join method

Future<List<DbRow>> join({
  1. required String table,
  2. required String? joinTable,
  3. required String? joinOn,
  4. String columns = "*",
  5. int? offset,
  6. int? limit,
  7. String? orderBy,
  8. String? where,
  9. String? groupBy,
  10. bool verbose = false,
})

A select query with a join

Implementation

Future<List<DbRow>> join(
    {required String table,
    required String? joinTable,
    required String? joinOn,
    String columns = "*",
    int? offset,
    int? limit,
    String? orderBy,
    String? where,
    String? groupBy,
    bool verbose = false}) async {
  List<Map<String, dynamic>>? data;
  try {
    data = await _db.join(
        table: table,
        joinTable: joinTable,
        joinOn: joinOn,
        columns: columns,
        offset: offset,
        limit: limit,
        orderBy: orderBy,
        where: where,
        groupBy: groupBy,
        verbose: verbose);
  } catch (e) {
    rethrow;
  }
  return _rowsFromRawData(table, data!);
}