Theo's Typesafe Cult•2y ago

Counting rows in Drizzle ORM

Hi, I was wondering what the best way to count rows in drizzle is. Thanks for the help!

Solution:

```ts import { sql } from 'drizzle-orm' import { YOUR_TABLE } from 'schema' const { count } = await db.select({...

Jump to solution

3 Replies

Neto•2y ago

https://orm.drizzle.team/docs/sql#sql-select

Magical sql operator 🪄 – DrizzleORM

Drizzle ORM | %s

Solution

Neto•2y ago

import { sql } from 'drizzle-orm'
import { __YOUR_TABLE__ } from 'schema'
 
const { count } = await db.select({
    count: sql<number>`count(*)`.mapWith(Number) 
}).from(__YOUR_TABLE__)

import { sql } from 'drizzle-orm'
import { __YOUR_TABLE__ } from 'schema'
 
const { count } = await db.select({
    count: sql<number>`count(*)`.mapWith(Number) 
}).from(__YOUR_TABLE__)

LiamOP•2y ago

Thanks! That seems to be working.

Gaming

Programming

Counting rows in Drizzle ORM