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()
→ void
-
Close the database.
-
execute(String sqlToExecute, {List arguments, bool getLastInsertId = false, String? primaryKey})
→ int?
-
Execute an insert, update or delete using
sqlToExecute
in normal
or prepared mode using arguments
.
-
getPrimaryKey(TableName tableName)
→ String?
-
Get the primary key from a non spatial db.
-
getQueryObjectsList<T>(QueryObjectBuilder<T> queryObj, {String? whereString})
→ List<T>
-
Get a list of items defined by the
queryObj
.
-
getSchemas({bool doOrder = false})
→ List<String>
-
Get the list of user created schemas, if necessary
doOrder
.
-
getTableColumns(TableName tableName)
→ List<List>
-
Get the
tableName
columns as array of:
-
getTables({bool doOrder = false})
→ List<TableName>
-
Get the list of table names, if necessary
doOrder
.
-
hasTable(TableName tableName)
→ bool
-
Check is a given
tableName
exists.
-
insertMap(TableName table, Map<String, dynamic> values)
→ 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})
→ void
-
Open the database or create a new one.
-
select(String sql, [List arguments])
→ QueryResult
-
The standard query method.
-
toString()
→ String
-
A string representation of this object.
inherited
-
transaction(Function transactionOperations)
→ dynamic
-
Run a set of operations inside a transaction.
-
updateMap(TableName table, Map<String, dynamic> values, String where)
→ int?
-
Update a new record using a map and a where condition.