count method

Future<int> count()

Implementation

Future<int> count() async {
  _count = true;

  String query = toSql();

  if (log) {
    Log.info('[QUERY BUILDER] Executing query...');
    Log.info(query);
  }

  List<Map<String, dynamic>> items = await Database.database.rawQuery(query);

  if (log) {
    Log.info('[QUERY BUILDER] Query result...');
    Log.info(jsonEncode(items));
  }

  if (items.isEmpty) {
    return 0;
  }

  return items.first['count'];
}