ClientManagerSqlUtils class
Utility class for generating SQLite SQL strings from TetherModels and applying transformations.
Constructors
Properties
- hashCode → int
-
The hash code for this object.
no setterinherited
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
Methods
-
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
Static Methods
-
applyLimit(
SqlStatement statement, int count) → SqlStatement - Adds a LIMIT clause to a SqlStatement. Replaces existing LIMIT.
-
applyOrder(
SqlStatement statement, TetherColumn column, {bool ascending = true, bool nullsFirst = false}) → SqlStatement - Adds an ORDER BY clause to a SqlStatement. Replaces existing ORDER BY.
-
applyRange(
SqlStatement statement, int from, int to) → SqlStatement - Adds LIMIT and OFFSET clauses (for range) to a SqlStatement. Replaces existing.
-
applySingle(
SqlStatement statement) → SqlStatement -
applyWhere(
SqlStatement statement, String clause, [List< Object?> ? arguments]) → SqlStatement - Adds a WHERE clause to a SqlStatement.
-
buildDeleteSql(
String tableName, dynamic idValue, {String idColumnName = 'id'}) → SqlStatement - Generates a structured DELETE statement based on an ID.
-
buildDeleteSqlByPks(
String localTableName, Map< String, dynamic> primaryKeyValues) → SqlStatement -
buildDeleteSqlFromModel<
T> (TetherModel< T> model, String tableName, {String idColumnName = 'id'}) → SqlStatement - Generates a structured DELETE statement based on a TetherModel's ID.
-
buildInsertSql(
List< TetherModelInputBase> models, String tableName) → SqlStatement - Generates a structured INSERT statement for a list of input models.
-
buildInsertSqlFromModel<
TModel extends TetherModel< (TModel> >List< TModel> models, String tableName) → SqlStatement - Generates a structured INSERT statement for a list of models.
-
buildRealtimeUpsertSql(
List< TetherModel> models, String originalSupabaseTableName, Map<String, SupabaseTableInfo> tableSchemas) → SqlStatement - Builds an UPSERT SqlStatement using SupabaseTableInfo for schema details.
-
buildUpdateSql(
TetherModelInputBase model, String tableName, {String idColumnName = 'id'}) → SqlStatement - Generates a structured UPDATE statement for a given input model, based on its ID.
-
buildUpsertSql<
T> (List< TetherModel< models, String originalSupabaseTableName, {required Map<T> >String, SupabaseTableInfo> tableSchemas}) → SqlStatement - Generates a structured UPSERT statement for a list of models.