SimpleDatabase class

Constructors

SimpleDatabase({String tableName = ""})

Properties

fields ↔ Map<String, dynamic>

getter/setter pair

hashCode → int

The hash code for this object.

no setter, inherited

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

table ↔ String

getter/setter pair

Methods

checkStackStatus(int stack, String name) → bool

deleteRecord({String condition = ""}) → Future<Map<String, dynamic>>

fetchDistinctRecords({String condition = "", String distinctField = "", String fetchMode = "LIST", String limitCondition = ""}) → Future<Map<String, dynamic>>

fetchQueryRecords({String fetchMode = "LIST", String query = "", Map<String, List<String>> formatColumns = const {}}) → Future<Map<String, dynamic>>

fetchRecords({String condition = "", String fetchMode = "LIST", String limitCondition = ""}) → Future<Map<String, dynamic>>

formatValues() → dynamic

getField({String name = "", List attributes = const []}) → Map<String, dynamic>

getFieldFormats() → Map<String, List<String>>

getFieldSQLValue(String fieldName) → String

getFieldValue(String name) → dynamic

getSelectQuery() → String

getTableViewName() → String

getUserDefinedFunction(String name) → Map<String, dynamic>

getViewQuery() → String

insertRecord(Map<String, dynamic> data) → Future<Map<String, dynamic>>

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

saveRecord(Map<String, dynamic> data) → Future<Map<String, dynamic>>

toString() → String

A string representation of this object.

inherited

updateRecord(Map<String, dynamic> data) → Future<Map<String, dynamic>>

updateUserDefinedFunction(Map userDefinedFunctions, String name) → Map

validateValues() → String

Operators

operator ==(Object other) → bool

The equality operator.

inherited

Static Properties

databaseTables ↔ Map<String, dynamic>

getter/setter pair

dbHandler ↔ DBHandler

getter/setter pair

Static Methods

createDatabaseMySql(String db, String host, Map<String, Map<String, dynamic>> tables) → Future

createDatabaseSqlite({required Map<String, Map<String, dynamic>> tables, required String path, int version = 1}) → Future

generateUniqueRecordId() → Future<String>

getCreateTableQueries(Map<String, Map<String, dynamic>> table) → List<String>

getCreateTableStatement(Map<String, dynamic> tableDefinition) → String

getFieldAttributes(Map fieldDetails) → List<String>

getFieldType(Map fieldDetails) → String

getSQLValueString(Object value, String type) → String

initTables({required Map<String, Map<String, dynamic>> tables}) → Future

on(String event, Function callback) → String

registerListener(String tableName, SimpleTableEvent eventListener) → String

setDatabaseSqlite(String path) → dynamic

Constants

attributeAutoIncrement → const String

attributeCheckModify → const String

attributeCheckUnique → const String

attributeCheckUpdate → const String

attributePrimaryKey → const String

attributeTimestamp → const String

attributeUniqueKey → const String

attributeUpdateTimestamp → const String

createdOn → const String

deletedOn → const String

fieldAttributes → const String

fieldFormats → const String

fieldName → const String

fieldSize → const String

fieldStacks → const String

fieldType → const String

fieldUserFunction → const String

fieldValue → const String

formatEncrypt → const String

formatJson → const String

formatLowercase → const String

formatUppercase → const String

functionName → const String

functionParameters → const String

functionValueTableField → const String

id → const String

modifiedOn → const String

resultPrimaryKeyField → const String

resultPrimaryKeyValue → const String

stackUpdateAll → const int

stackUpdateSkipMain → const int

tableFields → const String

tableName → const String

typeBlob → const String

typeDate → const String

typeDateTime → const String

typeDouble → const String

typeInt → const String

typeJson → const String

typeString → const String

typeUserDefinedFunction → const String

typeVarchar → const String