SqliteDb class

The Sqlite database used for project and datasets as mbtiles.

Inheritance

• Object
• ADb
• SqliteDb

Constructors

SqliteDb(String? _dbPath)

SqliteDb.memory()

Properties

hashCode → int

The hash code for this object.

no setter, inherited

path → String?

Get the database path.

no setter

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

checkOpen() → void

close() → void

Close the database.

override

createFunction({required String functionName, required ScalarFunction function, required int argumentCount, bool deterministic = false, bool directOnly = true}) → void

Creater a custom callback function.

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.

override

getInternalDb() → Database?

This should only be used when a custom function is necessary, which forces to use the method from the moor database.

getPrimaryKey(TableName tableName) → String?

Get the primary key from a non spatial db.

override

getQueryObjectsList<T>(QueryObjectBuilder<T> queryObj, {String? whereString}) → List<T>

Get a list of items defined by the queryObj.

inherited

getSchemas({bool doOrder = false}) → List<String>

Get the list of user created schemas, if necessary doOrder.

override

getTableColumns(TableName tableName) → List<List>

Get the tableName columns as array of:

override

getTables({bool doOrder = false}) → List<TableName>

Get the list of table names, if necessary doOrder.

override

hasTable(TableName tableName) → bool

Check is a given tableName exists.

override

insertMap(TableName table, Map<String, dynamic> values) → int?

Insert a new record using a map values into a given table.

inherited

isAsync() → bool

isOpen() → bool

Checks if the database is open.

override

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.

override

select(String sql, [List? arguments]) → QueryResult

The standard query method.

override

toString() → String

A string representation of this object.

inherited

transaction(Function transactionOperations) → dynamic

Run a set of operations inside a transaction.

inherited

updateMap(TableName table, Map<String, dynamic> values, String where) → int?

Update a new record using a map and a where condition.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited