SqliteBuilder class

Inheritance

Constructors

SqliteBuilder()
const

Properties

autoincrementPkType String
The autoincrementing integer primary key type for the current SQL dialect.
no setteroverride
blobType String
The type to use for BLOB for the current SQL dialect.
no setteroverride
defaultNamespace String
no setteroverride
deferOrDisableFKsForTx String
Depending on the dialect, defers or disables foreign key checks for the duration of the transaction.
no setteroverride
dialect Dialect
no setteroverride
getVersion String
Queries the version of SQLite/Postgres we are using.
no setteroverride
hashCode int
The hash code for this object.
no setterinherited
metaTables List<String>
no setter
paramSign String
no setteroverride
runtimeType Type
A representation of the runtime type of the object.
no setterinherited

Methods

batchedInsertOrReplace(QualifiedTablename table, List<String> columns, List<Map<String, Object?>> records, List<String> conflictCols, List<String> updateCols, int maxSqlParameters) List<Statement>
Inserts a batch of rows into a table, replacing them if they already exist.
override
countTablesIn(List<String> tableNames) Statement
Counts tables whose name is included in tableNames.
override
createFkCompensationTrigger(String opType, QualifiedTablename table, String childKey, QualifiedTablename fkTable, String joinedFkPKs, ForeignKey foreignKey) List<String>
Creates a trigger that logs compensations for operations into the oplog.
override
createIndex(String indexName, QualifiedTablename onTable, List<String> columns) String
Create an index on a table.
override
createJsonObject(String rows) String
createNoFkUpdateTrigger(QualifiedTablename table, List<String> pk) List<String>
Create a trigger that prevents updates to the primary key.
override
createOplogTrigger(SqlOpType opType, QualifiedTablename table, String newPKs, String newRows, String oldRows) List<String>
Create a trigger that logs operations into the oplog.
override
createOrReplaceDeleteTrigger(QualifiedTablename table, String newPKs, String newRows, String oldRows) List<String>
Creates or replaces a trigger that logs deletions into the oplog.
inherited
createOrReplaceFkCompensationTrigger(String opType, QualifiedTablename table, String childKey, QualifiedTablename fkTable, String joinedFkPKs, ForeignKey foreignKey) List<String>
inherited
createOrReplaceInsertCompensationTrigger(QualifiedTablename table, String childKey, QualifiedTablename fkTable, String joinedFkPKs, ForeignKey foreignKey) List<String>
Creates a trigger that logs compensations for insertions into the oplog.
inherited
createOrReplaceInsertTrigger(QualifiedTablename table, String newPKs, String newRows, String oldRows) List<String>
Creates or replaces a trigger that logs insertions into the oplog.
inherited
createOrReplaceNoFkUpdateTrigger(QualifiedTablename table, List<String> pk) List<String>
Creates or replaces a trigger that prevents updates to the primary key.
inherited
createOrReplaceOplogTrigger(SqlOpType opType, QualifiedTablename table, String newPKs, String newRows, String oldRows) List<String>
inherited
createOrReplaceUpdateCompensationTrigger(QualifiedTablename table, String childKey, QualifiedTablename fkTable, String joinedFkPKs, ForeignKey foreignKey) List<String>
Creates a trigger that logs compensations for updates into the oplog.
inherited
createOrReplaceUpdateTrigger(QualifiedTablename table, String newPKs, String newRows, String oldRows) List<String>
Creates or replaces a trigger that logs updates into the oplog.
inherited
createPKJsonObject(String rows) String
dropTriggerIfExists(String triggerName, QualifiedTablename table) String
Drop a trigger if it exists.
override
getLocalTableNames([List<String> notIn = const []]) Statement
Fetches the names of all tables that are not in notIn.
override
getTableInfo(QualifiedTablename table) Statement
Fetches information about the columns of a table. The information includes all column names, their type, whether or not they are nullable, and whether they are part of the PK.
override
hexValue(String hexString) String
Converts a hexidecimal string to a hex value.
override
insertOrIgnore(QualifiedTablename table, List<String> columns, List<Object?> values) Statement
Insert a row into a table, ignoring it if it already exists.
override
insertOrReplace(QualifiedTablename table, List<String> columns, List<Object?> values, List<String> conflictCols, List<String> updateCols) Statement
Insert a row into a table, replacing it if it already exists.
override
insertOrReplaceWith(QualifiedTablename table, List<String> columns, List<Object?> values, List<String> conflictCols, List<String> updateCols, List<Object?> updateVals) Statement
Insert a row into a table. If it already exists we update the provided columns updateCols with the provided values updateVals
override
makePositionalParam(int i) String
Makes the i-th positional parameter, e.g. '$3' For Postgres when i is 3 and always '?' for SQLite
override
makeQT(String tablename) QualifiedTablename
inherited
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
pgOnly(String query) String
Returns the given query if the current SQL dialect is PostgreSQL.
override
prepareDeleteBatchedStatements(String baseSql, List<String> columns, List<Map<String, Object?>> records, int maxParameters, {String suffixSql = ''}) List<Statement>
Prepare multiple batched DELETE statements for an array of records.
inherited
prepareInsertBatchedStatements(String baseSql, List<String> columns, List<Map<String, Object?>> records, int maxParameters, [String suffixSql = '']) List<Statement>
Prepare multiple batched insert statements for an array of records.
inherited
removeDeletedShadowRows(QualifiedTablename oplog, QualifiedTablename shadow) String
Deletes any shadow rows where the last oplog operation was a DELETE
override
removeSpaceAndNullValuesFromJson(String json) String
setTagsForShadowRows(QualifiedTablename oplog, QualifiedTablename shadow) String
For each affected shadow row, set new tag array, unless the last oplog operation was a DELETE
override
setTriggerSetting(QualifiedTablename table, int value) String
Modifies the trigger setting for the table identified by its tablename and namespace.
override
sqliteOnly(String query) String
Returns the given query if the current SQL dialect is SQLite.
override
tableExists(QualifiedTablename table) Statement
Checks if the given table exists.
override
toHex(String column) String
Converts a column value to a hexidecimal string.
override
toString() String
A string representation of this object.
inherited

Operators

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