Documentation / @zerotal/orm / index / MysqlDialect
Class: MysqlDialect
Defined in: packages/orm/src/db/dialects/MysqlDialect.ts:7
MySQL strategy — INFORMATION_SCHEMA introspection, DAY()/MONTH()/YEAR() date parts, GET_LOCK()/RELEASE_LOCK() named advisory locks.
Implements
Constructors
Constructor
new MysqlDialect():
MysqlDialect
Returns
MysqlDialect
Properties
name
readonlyname:"mysql"
Defined in: packages/orm/src/db/dialects/MysqlDialect.ts:8
Implementation of
supportsAdvisoryLocks
readonlysupportsAdvisoryLocks:true=true
Defined in: packages/orm/src/db/dialects/MysqlDialect.ts:9
Whether the engine supports application-level advisory locks.
Implementation of
SqlDialect.supportsAdvisoryLocks
Methods
hasTableSql()
hasTableSql(
table):DialectQuery
Defined in: packages/orm/src/db/dialects/MysqlDialect.ts:11
Introspection query returning at least one row when table exists.
Parameters
table
string
Returns
Implementation of
hasColumnSql()
hasColumnSql(
table,column):DialectQuery
Defined in: packages/orm/src/db/dialects/MysqlDialect.ts:20
Introspection query returning at least one row when column exists on table.
Parameters
table
string
column
string
Returns
Implementation of
dateExpr()
dateExpr(
part,column):string
Defined in: packages/orm/src/db/dialects/MysqlDialect.ts:29
SQL expression extracting a date part from column.
The caller must validate column as a safe identifier first — the
expression is interpolated verbatim.
Parameters
part
column
string
Returns
string
Implementation of
autoIncrementColumn()
autoIncrementColumn(
column):string
Defined in: packages/orm/src/db/dialects/MysqlDialect.ts:46
The column definition for an auto-incrementing integer primary key.
Every engine spells this differently and none of them accept SQLite's
INTEGER PRIMARY KEY AUTOINCREMENT: PostgreSQL wants a serial/identity type, MySQL
wants AUTO_INCREMENT. Hard-coding the SQLite form meant the first migrate against
PostgreSQL died on a syntax error and MySQL on error 1064 — before any of the
dialect-aware hasTable/ALTER handling downstream got a chance to matter.
Parameters
column
string
Already-validated column name.
Returns
string
The full column fragment, type and constraints included.
Implementation of
SqlDialect.autoIncrementColumn
advisoryLockSql()
advisoryLockSql(
key):DialectQuery
Defined in: packages/orm/src/db/dialects/MysqlDialect.ts:50
Statement acquiring an advisory lock (blocking), or null when unsupported.
Parameters
key
number
Returns
Implementation of
advisoryUnlockSql()
advisoryUnlockSql(
key):DialectQuery
Defined in: packages/orm/src/db/dialects/MysqlDialect.ts:54
Statement releasing an advisory lock, or null when unsupported.
Parameters
key
number