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