SqlClientTableHelper class

A helper class used by SqlClient for building statements/queries.

An example:

final tableHelper = sqlClient.table('Product');
Inheritance

Properties

hashCode int
The hash code for this object.
read-onlyinherited
runtimeType Type
A representation of the runtime type of the object.
read-onlyinherited

Methods

addColumn(String name, SqlType type, {Object defaultValue}) Future<void>
addForeignKeyConstraint({String constraintName, List<String> localColumnNames, String foreignTableName, List<String> foreignColumnNames, SqlReferenceDeleteAction onDelete, SqlReferenceUpdateAction onUpdate}) Future<void>
ascending(String name) SqlClientTableSelectionHelper
inherited
createIndex(String name, List<String> columnNames) Future<void>
deleteAll() Future<SqlStatementResult>
Deletes rows in the table.
inherited
descending(String name) SqlClientTableSelectionHelper
inherited
dropColumn(String name) Future<void>
dropConstraint(String name) Future<void>
dropIndex(String name) Future<void>
insert(Map<String, Object> map) Future<SqlStatementResult>
Inserts a row in the table.
insertAll(Iterable<Map<String, Object>> maps) Future<SqlStatementResult>
Inserts rows in the table.
limit(int value) SqlClientTableSelectionHelper
Sets maximum number of returned rows.
inherited
noSuchMethod(Invocation invocation) → dynamic
Invoked when a non-existent method or property is accessed.
inherited
offset(int value) SqlClientTableSelectionHelper
Sets offset for the first returned row.
inherited
renameColumn({String oldName, String newName}) Future<void>
Renames a column.
select({List<String> columnNames, List<SqlColumnEntry> columnEntries}) SqlClientTableQueryHelper
Selects rows in the table.
inherited
toString() String
A string representation of this object.
inherited
whereColumn(String name, {Object equals}) SqlClientTableSelectionHelper
inherited
whereColumns(Map<String, Object> properties) SqlClientTableSelectionHelper
inherited
whereSql(String sql, [List arguments]) SqlClientTableSelectionHelper
inherited

Operators

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