SqliteQueryGrammar class final

SQLite grammar: ? placeholders, INSERT OR IGNORE, ON CONFLICT.

Inheritance

Constructors

SqliteQueryGrammar()
The SQLite grammar.
const

Properties

dialect → SqlDialect
The dialect it writes for.
no setteroverride
hashCode → int
The hash code for this object.
no setterinherited
quoteClose → String
The character that closes a quoted identifier.
no setterinherited
quoteOpen → String
Opening/closing identifier quotes.
no setterinherited
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
supportsReturning → bool
Whether INSERT ... RETURNING is supported.
no setterinherited
supportsSavepoints → bool
Whether savepoints are supported, for nested transactions.
no setterinherited

Methods

compileDelete(QueryAst query) → CompiledQuery
The DELETE of query's rows.
inherited
compileExists(QueryAst query) → CompiledQuery
The query returning whether query has a row.
inherited
compileInsert(String table, List<Map<String, Object?>> rows, {bool ignore = false}) → CompiledQuery
The INSERT of rows into table; ignore skips rows a unique constraint refuses.
inherited
compileInsertGetId(String table, Map<String, Object?> row, String idColumn) → CompiledQuery
Insert returning the generated id (RETURNING when supported).
inherited
compileLimitOffset(int? limit, int? offset, Compilation c) → String
LIMIT/OFFSET fragment (MySQL needs a limit when offset is given).
inherited
compileSelect(QueryAst query) → CompiledQuery
The SELECT statement of query.
inherited
compileTruncate(String table) → CompiledQuery
The statement emptying table.
inherited
compileUpdate(QueryAst query, Map<String, Object?> values) → CompiledQuery
The UPDATE of query's rows with values.
inherited
compileUpsert(String table, List<Map<String, Object?>> rows, List<String> uniqueBy, List<String> update) → CompiledQuery
The insert-or-update of rows on conflict of the unique columns.
override
datePart(String part, String column) → String
Expression extracting part from a column (date, year...).
override
excludedValue(String column) → String
Dialect name for value in upserts (excluded.col / VALUES(col)).
inherited
insertKeyword(bool ignore) → String
The insert keyword: INSERT, or the dialect's ignoring form.
inherited
jsonOperand(Object? value) → Object?
value as the text a jsonSelector gives, where the dialect compares strictly.
inherited
jsonSelector(String column, List<String> path) → String
Reads a JSON path as text.
override
jsonUpdate(String column, List<(List<String>, Object?)> values, Compilation c) → String
column with values, path to value, written into it.
override
jsonWhere(String column, String kind, String operator, Object? value, bool not, Compilation c) → String
JSON where fragment (contains / length).
override
lockClause(LockMode mode) → String
The row lock clause for mode.
override
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
parameter(int index) → String
Placeholder for the index-th (1-based) binding.
override
toString() → String
A string representation of this object.
inherited
wrap(Object identifier) → String
Quotes table.column, column as alias, table.* or *. Invalid characters throw instead of being interpolated (never trust input).
inherited
wrapUnion(String sql) → String
Wraps one side of a UNION (SQLite cannot parenthesize selects).
override

Operators

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