LiteSqlInsertExt extension

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

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

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)

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