Theo's Typesafe Cult•5mo ago

switch function in drizzle

I'm following the "Add Clerk Authentication & Stripe Payments to your NextJS tRPC Application" tutorial. The tutorial uses T3 app + Prisma + Clerk. I've used drizzle for my T3 app and need help converting this switch function written in Prisma-speak to Drizzle-speak.

4 Replies

Neto•5mo ago

switch (eventType) {
  case "user.created": {
    // https://orm.drizzle.team/learn/guides/count-rows
    const [{count = 0}] = await db.select({count: count()}).from(accounts).where(eq(accounts.userId, id))
    
    if(!count){
      // https://orm.drizzle.team/docs/insert
      await db.insert(accounts).values({userId: id})
    }
  }
  
  ...
}

switch (eventType) {
  case "user.created": {
    // https://orm.drizzle.team/learn/guides/count-rows
    const [{count = 0}] = await db.select({count: count()}).from(accounts).where(eq(accounts.userId, id))
    
    if(!count){
      // https://orm.drizzle.team/docs/insert
      await db.insert(accounts).values({userId: id})
    }
  }
  
  ...
}

maybe there is an error or two around types and syntaxes, but should be easy to go from there

BickibirdOP•5mo ago

@nyx (Rustular DevRel) thank you for replying! Getting a few errors still:

Neto•5mo ago

idk the codebase to point to the specific errors but

import { count, eq } from 'drizzle-orm';

import { count, eq } from 'drizzle-orm';

BickibirdOP•5mo ago

Thanks so much

Gaming

Programming

switch function in drizzle