select method

Future<DbResponse> select({
  1. Where? where,
  2. OrderBy? orderBy,
  3. List<Column> columns = const [],
  4. bool distinct = false,
  5. int? limit,
})

Implementation

Future<DbResponse> select({
  Where? where,
  OrderBy? orderBy,
  List<Column> columns = const [],
  bool distinct = false,
  int? limit,
}) async {
  // ignore: no_leading_underscores_for_local_identifiers
  String _fields = columns.isEmpty ? '*' : columns.join(',');
  String query =
      'SELECT ${distinct ? "DISTINCT " : ''}$_fields FROM "$tableName" ${getQuery(where: where, orderBy: orderBy, limit: limit)}';
  var dbRes = await db.query(query);

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