Angel Posts - Answer Overflow

Angel

•Created by Angel on 12/8/2023 in #help

Count with Limit

How can i recreate this select in Drizzle?

select count(*) as total from (select 1 from post WHERE ... limit 1000);

select count(*) as total from (select 1 from post WHERE ... limit 1000);

I want to reuse a query builder to get the total number of results limited to 1000.

2 replies

•Created by Angel on 11/30/2023 in #help

Type for select with relations?

Is it possible to infer select with relations? Currently im using:

export let user: typeof user.$inferSelect & { profile?: typeof profile.$inferSelect };

export let user: typeof user.$inferSelect & { profile?: typeof profile.$inferSelect };

7 replies