SqlBuilder class
SQL command builder.
- Available extensions
Constructors
-
SqlBuilder.delete(String table, {String? where, List<
Object?> ? whereArgs}) - Convenience method for deleting rows in the database.
-
SqlBuilder.insert(String table, Map<
String, Object?> values, {String? nullColumnHack, ConflictAlgorithm? conflictAlgorithm}) - Convenience method for inserting a row into the database. Parameters: @table the table to insert the row into @nullColumnHack optional; may be null. SQL doesn't allow inserting a completely empty row without naming at least one column name. If your provided values is empty, no column names are known and an empty row can't be inserted. If not set to null, the nullColumnHack parameter provides the name of nullable column name to explicitly insert a NULL into in the case where your values is empty. @values this map contains the initial column values for the row. The keys should be the column names and the values the column values
-
SqlBuilder.query(String table, {bool? distinct, List<
String> ? columns, String? where, List<Object?> ? whereArgs, String? groupBy, String? having, String? orderBy, int? limit, int? offset}) - Build an SQL query string from the given clauses.
-
SqlBuilder.update(String table, Map<
String, Object?> values, {String? where, List<Object?> ? whereArgs, ConflictAlgorithm? conflictAlgorithm}) - Convenience method for updating rows in the database.
Properties
-
arguments
↔ List<
Object?> ? -
The arguments list;
getter/setter pair
- hasEscape ↔ bool
-
Used during build if there was a name with an escaped keyword.
getter/setter pair
- hashCode → int
-
The hash code for this object.
no setterinherited
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
- sql ↔ String
-
The resulting SQL command.
getter/setter pair
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