Row count of table?

[OOHehir]

Hello, I've taken a look at this & can't seem to find a decent answer.

Is there any suggested method to get the row count (i.e. length) of a table? I've tried using COUNT(*) without success & also something trivial like:

int row_count = 0;
sqlite3pp::query qry(this->db, "SELECT * FROM some_table");
auto i = qry.begin();
if (i != qry.end())
    row_count++;

Thanks

[iwongu]

You can use COUNT(*). Check https://github.com/iwongu/sqlite3pp/blob/master/test/testdb.cpp#L50

sqlite3pp::query qry(db, "SELECT COUNT(*) FROM contacts");
auto iter = qry.begin();
int count = (*iter).get<int>(0);
expect_eq(3, count);