How to SELECT COUNT(*) with drizzle?

[jschwindt]

I'm just starting with drizzle-orm and I can't figure out how to do a simple "SELECT COUNT(*) FROM someTable".

[jschwindt]

Never mind, I figured it out:

const dbUsers = await db.select({ totalUsers: sql`COUNT(*)` }).from(users)

[Senbonzakura1234]

@jschwindt if i do limit and skip for pagination and i want to get the count before limit and skip to get the total record, does this work for my problem?

[jschwindt]

@jschwindt if i do limit and skip for pagination and i want to get the count before limit and skip to get the total record, does this work for my problem?

Yes, SELECT COUNT(*) from someTable returns the total amount of records from someTable.

[Senbonzakura1234]

@jschwindt if i do limit and skip for pagination and i want to get the count before limit and skip to get the total record, does this work for my problem?

Yes, SELECT COUNT(*) from someTable returns the total amount of records from someTable.

Can it be done in a single query? Get both the paginated data and total count?