Counting rows in Drizzle ORM

Hi,

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

Solution

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__)

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__)

Jump to solution

Neto•7/5/23, 8:11 PM

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

Magical sql operator 🪄 – DrizzleORM

Drizzle ORM | %s

Solution

Neto•7/5/23, 8:12 PM

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__)

NNeto ```ts import { sql } from 'drizzle-orm' import { __YOUR_TABLE__ } from 'schema' ...

LiamOP•7/5/23, 8:23 PM

Thanks! That seems to be working.

Counting rows in Drizzle ORM

Similar Threads

Similar Threads

Similar Threads