Dao class

A class representing a Data Access Object (DAO) for executing SQL queries and operations.

Constructors

Dao({required String dataBaseProvider, required dynamic sqlFunction(string), String? quoteChar})
Constructs a new instance of the Dao class.

Properties

dataBaseProvider → String
final
hashCode → int
The hash code for this object.
no setterinherited
quoteChar ↔ String?
getter/setter pair
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
sqlFunction → dynamic Function(string)
final

Methods

executeDelete<T>({required String tableName, JsonRow where = const {}, bool nullAsBlank = false, T transform(dynamic)?}) → Future<SQLResponseOf<T>>
Executes an SQL DELETE query and returns the result as a SQLResponseOf object.
executeDeleteTop<T>({required String tableName, required int count, required String idColumn, required bool asc, JsonRow where = const {}, bool nullAsBlank = false}) → Future<SQLResponseOf<void>>
Executes an SQL DELETE TOP query and returns the result as a SQLResponseOf object.
executeInsert({required String tableName, required JsonRow values, bool nullAsBlank = false}) → Future<SQLResponseOf<void>>
Executes an SQL INSERT query and returns the result as a SQLResponseOf object.
executeSelect<T>({required String tableName, List<String> columns = const [], JsonRow where = const {}, bool nullAsBlank = false, bool and = true, T transform(dynamic)?}) → Future<SQLResponseOf<T>>
Executes an SQL SELECT query and returns the result as a SQLResponseOf object.
executeSQL<T>({required String sql, T transform(dynamic)?, dynamic dataSetType = 'set'}) → Future<SQLResponseOf<T>>
Executes an SQL query and returns the result as a SQLResponseOf object.
executeUpdate({required String tableName, required JsonRow values, required JsonRow where, bool nullAsBlank = false}) → Future<SQLResponseOf<void>>
Executes an SQL UPDATE query and returns the result as a SQLResponseOf object.
executeUpsert({required String tableName, required JsonRow values, JsonRow where = const {}, bool nullAsBlank = false}) → Future<SQLResponseOf<void>>
Executes an SQL UPSERT query and returns the result as a SQLResponseOf object.
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
toString() → String
A string representation of this object.
inherited

Operators

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