DbLayer class

Constructors

DbLayer(DBConnectionInfo connectionInfo, {List<Map<Type, Function>>? factories})

Properties

connectionInfo ↔ DBConnectionInfo
getter/setter pair
currentQuery ↔ QueryBuilder
getter/setter pair
executor ↔ QueryExecutor
getter/setter pair
factories → List<Map<Type, Function>>?
final
hashCode → int
The hash code for this object.
no setterinherited
options → QueryBuilderOptions
no setter
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited

Methods

close() → Future
commit() → Future<DbLayer>
connect([DBConnectionInfo? connInfo]) → Future<DbLayer>
delete() → QueryBuilder
Starts the DELETE-query with the provided options. @return QueryBuilder
exec() → Future<List<List>>
this method to execute current query and get results as List
execute(String query, {Map<String, dynamic>? substitutionValues}) → Future<int>
execute command on database
expression() → Expression
Starts a new expression with the provided options. @param options Options to use for expression generation. @return Expression
first() → Future<List?>
firstAsMap() → Future<Map<String, dynamic>?>
firstAsMapWithMeta() → Future<Map<String, Map<String, dynamic>>?>
formatSubititutioValue(String value) → String
for input table.field return @field for pgsql and ? for mysql
formatValue(Object? value) → String
format value for no SQL Injection, is not garatid securyty
get() → Future<List<List>>
getAsMap() → Future<List<Map<String, dynamic>>>
getAsMapWithMeta() → Future<List<Map<String, Map<String, dynamic>>>>
getRelationFromMaps(List<Map<String, dynamic>> data, String tableName, String localKey, String foreignKey, {String? relationName, dynamic defaultNull = DEFAULT_NULL, dynamic callback_fields(Map<String?, dynamic>)?, dynamic callback_query(QueryBuilder)?, dynamic isSingle = false}) → Future<List<Map<String, dynamic>>>
@param data @param tableName nome da tabela relacionada @param localKey key id da tabela relacionada @param foreignKey id contido nos dados passados pelo parametro data para comparar com o key id da tabela relacionada @param relationName nome da chave no map que estara com o resultado @param defaultNull valor padrão para a chave no map caso não tenha resultado List | null
insert() → QueryBuilder
Starts the INSERT-query with the provided options. @return QueryBuilder
insertGetAll({List<String>? returningFields}) → QueryBuilder
Starts the INSERT-query with the provided options and return * or returningFields @return QueryBuilder
insertGetId({String? defaultIdColName = 'id'}) → QueryBuilder
Starts the INSERT-query with the provided options and return id @return QueryBuilder
isConnect() → Future<bool>
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
putInQuotes(String value) → String
add " for pgsql or ` for mysql
putSingle<T>(T entity) → Future
putSingleGetId<T>(T entity) → Future
raw(String rawQueryString, {Map<String, dynamic>? substitutionValues}) → QueryBuilder
function to execute query from raw SQL String
reconnectIfNecessary() → Future
rollback() → Future<DbLayer>
select() → QueryBuilder
Starts the SELECT-query chain with the provided options @param options Options to use for query generation. @return QueryBuilder
startTransaction() → Future<DbLayer>
toString() → String
A string representation of this object.
inherited
transaction<T>(FutureOr<T> f(DbLayer)) → Future<T?>
transaction2(Future queryBlock(DbLayer), {int? commitTimeoutInSeconds}) → Future
update() → QueryBuilder
Starts the UPDATE-query. @return QueryBuilder

Operators

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

Constants

DEFAULT_NULL → const dynamic