count method

@override Future<int> count()

Returns total count of matched rows.

Implementation

@override
Future<int> count() async {
  final sql = grammar.compileAggregate(_getQueryComponents(), {
    'function': 'COUNT',
    'column': '*',
  });
  final aggregateBindings = [
    ..._fromBindings,
    ..._joinBindings,
    ..._whereBindings,
    ..._havingBindings,
  ];
  final result = await connection.execute(sql, aggregateBindings);
  return result.data.first['aggregate'] as int;
}