Count how many records the database has?

[ReinaldoSergio]

I'm using moor_flutter and I don't know how to count how many records there are in the database, can someone tell me how to do this?

[simolus3]

You could use this method in a database:

Future<int> countAllRecords() async {
  var count = 0;

  for (final table in allTables) {
    final countTable = countAll();
    final row =  await (selectOnly(table)..addColumns([countTable])).getSingle();

    count += row.read(countTable);
  }
}