group method

Future<DbResponse> group({
  1. required List<String> groupBy,
  2. List<Column>? columns,
  3. List<Aggregate>? aggregates,
  4. Where? where,
  5. OrderBy? orderBy,
})

Implementation

Future<DbResponse> group(
    {required List<String> groupBy,
    List<Column>? columns,
    List<Aggregate>? aggregates,
    Where? where,
    OrderBy? orderBy}) async {
  String query =
      'SELECT ${columns == null ? "" : "${columns.map((val) => '"$val"').join(',')},"} ${aggregates == null ? "" : (aggregates.map((e) => e.query)).join(", ")} FROM "$tableName" ${getQuery(where: where, groupBy: groupBy, orderBy: orderBy)}';
  var dbRes = await db.query(query);

  return DbResponse(
      dbRes.columnDescriptions.map((e) => e.columnName).toList(),
      List<List>.from(dbRes.toList()));
}