MySQLDialect

Topics

Initializers

• init()
  Create a new MySQLDialect.

Instance Properties

• var alterTableSyntax: SQLAlterTableSyntax
  A description of the syntax the dialect supports for SQLAlterTable queries.
• var autoIncrementClause: any SQLExpression
  An expression inserted in a column definition when a .primaryKey(autoincrement: true) constraint is specified for the column.
• var enumSyntax: SQLEnumSyntax
  The syntax the dialect supports for strongly-typed enumerations.
• var exclusiveSelectLockExpression: (any SQLExpression)?
  A serialization for SQLLockingClause/update.
• var identifierQuote: any SQLExpression
  An expression (usually an SQLRaw) giving the character(s) used to quote SQL identifiers, such as table and column names.
• var literalStringQuote: any SQLExpression
  An expression (usually an SQLRaw) giving the character(s) used to quote literal string values which appear in a query, such as enumerator names.
• var name: String
  The name of the dialect.
• var sharedSelectLockExpression: (any SQLExpression)?
  A serialization for SQLLockingClause/share.
• var supportsAutoIncrement: Bool
  true if the dialect supports auto-increment for primary key values when inserting new rows, false if not.
• var triggerSyntax: SQLTriggerSyntax
  Various flags describing the dialect’s support for specific features of SQLCreateTrigger and SQLDropTrigger queries.
• var unionFeatures: SQLUnionFeatures
  A set of feature flags describing the dialect’s support for various forms of UNION with SELECT queries.
• var upsertSyntax: SQLUpsertSyntax
  The type of UPSERT syntax supported by the dialect.

Instance Methods

• func bindPlaceholder(at: Int) -> any SQLExpression
  A function which returns an expression to be used as the placeholder for the positionth bound parameter in a query.
• func customDataType(for: SQLDataType) -> (any SQLExpression)?
  A function which is consulted whenever an SQLDataType will be serialized into a query. The dialect may return an expression which will replace the default serialization of the given type. Returning nil causes the default to be used.
• func literalBoolean(Bool) -> any SQLExpression
  A function which returns an SQL expression (usually an SQLRaw) representing the given literal boolean value.
• func nestedSubpathExpression(in: any SQLExpression, for: [String]) -> (any SQLExpression)?
  Given a column name and a path consisting of one or more elements, return an expression appropriate for accessing a value at the given JSON path.
• func normalizeSQLConstraint(identifier: any SQLExpression) -> any SQLExpression
  A function which is consulted whenever a constraint name will be serialized into a query. The dialect must return an expression for an identifer which is unique to the input identifier and is a valid constraint name for the dialect.