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.

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

(currently unsupported)

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

PostgreSQL (currently supported in an experimental state)

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

MariaDB (currently supported in an experimental state)

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

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.