How to achieve the same in drizzle ORM ?
SELECT 'TOTAL_COURSES' AS name , COUNT(id) FROM course WHERE deleted_at IS NULL
UNION ALL
SELECT 'PUBLISHED_COURSES' AS name, COUNT(id) FROM course WHERE is_published = true AND deleted_at IS NULL
UNION ALL
SELECT 'COURSE_LEAD' AS name, COUNT(id) FROM lead WHERE type = 'COURSE' AND deleted_at IS NULL
UNION ALL
SELECT 'COURSE_LEAD_PENDING' AS name, COUNT(id) FROM lead WHERE type = 'COURSE' AND deleted_at IS NULL
UNION ALL
SELECT 'TOTAL_JOBS' AS name, count(id) FROM job WHERE deleted_at IS NULL
UNION ALL
SELECT 'PUBLISHED_JOBS' as name, count(id) FROM job WHERE is_published = true AND deleted_at IS NULL
UNION ALL
SELECT 'JOB_LEAD' AS name, COUNT(id) FROM lead WHERE type = 'JOB' AND deleted_at IS NULL
UNION ALL
SELECT 'JOB_LEAD_PENDING' AS name, COUNT(id) FROM lead WHERE type = 'JOB' AND deleted_at IS NULLSELECT 'TOTAL_COURSES' AS name , COUNT(id) FROM course WHERE deleted_at IS NULL
UNION ALL
SELECT 'PUBLISHED_COURSES' AS name, COUNT(id) FROM course WHERE is_published = true AND deleted_at IS NULL
UNION ALL
SELECT 'COURSE_LEAD' AS name, COUNT(id) FROM lead WHERE type = 'COURSE' AND deleted_at IS NULL
UNION ALL
SELECT 'COURSE_LEAD_PENDING' AS name, COUNT(id) FROM lead WHERE type = 'COURSE' AND deleted_at IS NULL
UNION ALL
SELECT 'TOTAL_JOBS' AS name, count(id) FROM job WHERE deleted_at IS NULL
UNION ALL
SELECT 'PUBLISHED_JOBS' as name, count(id) FROM job WHERE is_published = true AND deleted_at IS NULL
UNION ALL
SELECT 'JOB_LEAD' AS name, COUNT(id) FROM lead WHERE type = 'JOB' AND deleted_at IS NULL
UNION ALL
SELECT 'JOB_LEAD_PENDING' AS name, COUNT(id) FROM lead WHERE type = 'JOB' AND deleted_at IS NULLcan someone tell me how i can achieve such,
UNION ALLUNION ALLThe official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources
Similar Threads
Was this page helpful?
