SqlDialect enum

An enumeration of database systems supported by drift. Only SqlDialect.sqlite is officially supported, all others are in an experimental state at the moment.

Inheritance

Constructors

SqlDialect({required String booleanType, required String textType, required String integerType, required String realType, required String blobType, String escapeChar = '"', bool supportsIndexedParameters = true})
const

Values

sqlite → const SqlDialect

Use sqlite's sql dialect. This is the default option and the only officially supported dialect at the moment.

const SqlDialect(booleanType: 'INTEGER', textType: 'TEXT', integerType: 'INTEGER', realType: 'REAL', blobType: 'BLOB')
mysql → const SqlDialect

(currently unsupported)

const SqlDialect(booleanType: '', textType: '', integerType: '', blobType: '', realType: '')
postgres → const SqlDialect

PostgreSQL (currently supported in an experimental state)

const SqlDialect(booleanType: 'boolean', textType: 'text', integerType: 'bigint', blobType: 'bytea', realType: 'float8')
mariadb → const SqlDialect

MariaDB (currently supported in an experimental state)

const SqlDialect(booleanType: 'BOOLEAN', textType: 'TEXT', integerType: 'BIGINT', blobType: 'BLOB', realType: 'DOUBLE', escapeChar: '`', supportsIndexed…

Properties

blobType → String
The type to use in CASTs and column definitions to store blobs (as a Uint8List in Dart).
final
booleanType → String
The type to use in CASTs and column definitions to store booleans.
final
escapeChar → String
The character used to wrap identifiers to distinguish them from keywords.
final
hashCode → int
The hash code for this object.
no setterinherited
index → int
A numeric identifier for the enumerated value.
no setterinherited
integerType → String
The type to use in CASTs and column definitions to store 64-bit integers.
final
realType → String
The type to use in CASTs and column definitions to store doubles.
final
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
supportsIndexedParameters → bool
Whether this dialect supports indexed parameters.
final
textType → String
The type to use in CASTs and column definitions to store strings.
final

Methods

desugarDuplicateVariables(List<Variable<Object>> original, List<int> syntacticOccurences) → List<Variable<Object>>
For dialects that don't support named or explicitly-indexed variables, translates a variable assignment to avoid using that feature.
escape(String identifier) → String
Escapes identifier by wrapping it in escapeChar.
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
toString() → String
A string representation of this object.
inherited

Operators

operator ==(Object other) → bool
The equality operator.
inherited

Constants

values → const List<SqlDialect>
A constant List of the values in this enum, in order of their declaration.