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.

Neto•8/14/24, 9:58 PM

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})
    }
  }
  
  ...
}

Neto•8/14/24, 9:59 PM

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

BickibirdOP•8/14/24, 10:47 PM

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

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

Neto•8/14/24, 10:50 PM

idk the codebase to point to the specific errors

Neto•8/14/24, 10:50 PM

but

Neto•8/14/24, 10:51 PM

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

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

BickibirdOP•8/14/24, 11:00 PM

Thanks so much

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 function in drizzle

Similar Threads

Similar Threads

Similar Threads