count method

Future<int> count()

Count the number of matching rows.

final count = await DB.table('users').where('is_active', true).count();

Implementation

Future<int> count() async {
  final sql = _buildCountSql();
  final params = _buildWhereParams();
  final result = _db.connection.select(sql, params);
  return result.first['count'] as int;
}