count method

Future<int> count({
  1. ExecutionOptions options = const ExecutionOptions(),
})

Counts the query's result rows, including its limit, offset and grouping.

Implementation

Future<int> count({
  ExecutionOptions options = const ExecutionOptions(),
}) async {
  final inner = compile();
  final result = await database.execute(
    SqlCommand(
      'SELECT COUNT(*) FROM (${inner.sql}) AS ${SqlWriter(database.dialect, {}).quote('orm_count')}',
      inner.parameters,
    ),
    options: options,
  );
  return Codecs.integer.decode(result.rows.single.single);
}