Records in the table

[andim27]

Flutter drift 2.11 How to count records in the table?
Why I can't do :
int cnt = select(myTable).count();

[simolus3]

Flutter drift 2.11 How to count records in the table?

You need to add the aggregate expression explicitly:

final count = countAll();
final stmt = selectOnly(myTable)..addColumns([count]);
int cnt = await stmt.map((row) => row.read(count)!).getSingle();

Why I can't do: int cnt = select(myTable).count();

That's a fair question, I think we should have an API for this since it's fairly common. I'll add add extension allowing you to write myTable.count().getSingle() in the next version.

[bendangelo]

Has this been done?

[simolus3]

Yes, there's a count extension method on tables and views.