fetchAll method

Future<List<Map<String, dynamic>>> fetchAll()

Implementation

Future<List<Map<String, dynamic>>> fetchAll() async {
  List<Map<String, dynamic>> results = [];

  if (dbType == DbType.sqlite) {
    final rows = sqliteDb!.select(
        "SELECT ${_selectQueryMaker.toString()} FROM $tableName ${_queryMaker.toString()}");

    for (final row in rows) {
      Map<String, dynamic> result = {};

      for (final rowMap in row.entries) {
        result[rowMap.key] = rowMap.value;
      }

      results.add(result);
    }
  } else if (dbType == DbType.postgresql) {
    final rows = await postgresqlDb!
        .query(
            "SELECT ${_selectQueryMaker.toString()} FROM $tableName ${_queryMaker.toString()}")
        .toList();

    for (final row in rows) {
      results.add(row.toMap());
    }
  }

  return results;
}