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
-
close()
→ Future<void>
-
Close the database.
-
execute(String sqlToExecute, {List arguments, bool getLastInsertId = false, String? primaryKey})
→ Future<int?>
-
Execute an insert, update or delete using
sqlToExecute in normal
or prepared mode using arguments.
-
getPrimaryKey(TableName tableName)
→ Future<String?>
-
Get the primary key for a given table.
-
getQueryObjectsList<T>(QueryObjectBuilder<T> queryObj, {dynamic whereString = ""})
→ Future<List<T>>
-
Get a list of items defined by the
queryObj.
-
getSchemas({bool doOrder = false})
→ Future<List<SqlName>>
-
Get the list of user created schemas, if necessary
doOrder.
-
getTableColumns(TableName tableName)
→ Future<List<List>>
-
Get the
tableName columns as array of:
-
getTables({bool doOrder = false})
→ Future<List<TableName>>
-
Get the list of table names, if necessary
doOrder.
-
hasTable(TableName tableName)
→ Future<bool>
-
Check is a given
tableName exists.
-
insertMap(TableName table, Map<String, dynamic> values)
→ Future<int?>
-
Insert a new record using a map
values into a given table.
-
isOpen()
→ bool
-
Checks if the database is open.
-
noSuchMethod(Invocation invocation)
→ dynamic
-
Invoked when a nonexistent method or property is accessed.
inherited
-
open({Function populateFunction})
→ Future<bool>
-
Open the database and returns true upon success.
-
select(String sql, [List arguments])
→ Future<QueryResult?>
-
The standard query method.
-
toString()
→ String
-
A string representation of this object.
inherited
-
transaction(Function transactionOperations)
→ Future?
-
Run a set of operations inside a transaction.
-
updateMap(TableName table, Map<String, dynamic> values, String where)
→ Future<int?>
-
Update a new record using a map and a where condition.
