TranscationalExecutor class abstract interface

Methods

delete(Object table, {required Where where, Returning? returning}) → Future<QueryResult>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

dump(Type table) → Future<void>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

dumpTable(String table) → Future<void>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

execute(String sql, [AnyList? parameters]) → FutureOr<QueryResult>

inherited

insert(Object table, {required Iterable<ColumnValue<Object>> values, Returning? returning}) → Future<RowData?>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

insertAll(Object table, {required Iterable<List<ColumnValue<Object>>> rows, Returning? returning}) → Future<List<RowData>>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

insertAllMap(Object table, {required Iterable<Map<Object, dynamic>> rows, Returning? returning}) → Future<List<RowData>>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

insertAllValues(Object table, {required Iterable<Object> columns, required Iterable<AnyList> rows, Returning? returning}) → Future<List<RowData>>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

insertMap(Object table, {required Map<Object, dynamic> values, Returning? returning}) → Future<RowData?>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

insertValues(Object table, {required Iterable<Object> columns, required Iterable values, Returning? returning}) → Future<RowData?>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

multiQuery(String sql, Iterable<AnyList> parametersList) → FutureOr<List<QueryResult>>

inherited

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

query(List<Object> columns, {required Object from, Object? where, Object? groupBy, Object? having, Object? window, Object? orderBy, int? limit, int? offset, List? args}) → Future<QueryResult>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

query([], from:Person) query("*", from:Person) query(Person.values, from:Person)

register<T extends TableColumn>(List<T> fields, {OnMigrate? onMigrate}) → Future<bool>

Available on TranscationalExecutor, provided by the ConnectionExecutorTableExt extension

register(Person.values)

session<R>(FutureOr<R> callback(SessionExecutor)) → FutureOr<R>

streamQuery(String sql, [AnyList? parameters]) → FutureOr<StreamIterator<RowData>>

inherited

toString() → String

A string representation of this object.

inherited

transaction<R>(FutureOr<R> callback(SessionExecutor)) → FutureOr<R>

update(Object table, {required Iterable<ColumnValue<Object>> values, required Where where, Returning? returning}) → Future<QueryResult>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

updateMap(Object table, {required Map<Object, dynamic> values, required Where where, Returning? returning}) → Future<QueryResult>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

updateValues(Object table, {required Iterable<Object> columns, required Iterable values, required Where where, Returning? returning}) → Future<QueryResult>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

upsert(Object table, {required Iterable<ColumnValue<Object>> values, required Iterable<Object> constraints, Returning? returning}) → Future<RowData?>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

upsertAll(Object table, {required List<List<ColumnValue<Object>>> rows, required Iterable<Object> constraints, Returning? returning}) → Future<List<RowData>>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

upsertAllMap(Object table, {required List<Map<Object, dynamic>> rows, required Iterable<Object> constraints, Returning? returning}) → Future<List<RowData>>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

upsertAllValues(Object table, {required Iterable<Object> columns, required Iterable<Object> constraints, required List<List> rows, Returning? returning}) → Future<List<RowData>>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

upsertMap(Object table, {required Map<Object, dynamic> values, required Iterable<Object> constraints, Returning? returning}) → Future<RowData?>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension

upsertValues(Object table, {required Iterable<Object> columns, required Iterable<Object> constraints, required Iterable values, Returning? returning}) → Future<RowData?>

Available on SQLExecutor, provided by the LiteSqlInsertExt extension