Aryan Posts - Answer Overflow

Aryan

Explore posts from servers

•Created by Aryan on 11/15/2024 in #help

Insert row, on conflict do nothing, and "return the conflicted row if it exists" - in 1 query?

Is it possible to do this query in one single Drizzle ORM query? Cus currently .onConflictDoNothing() is always returning an empty array for me (which I'm guessing is by design unless there's something else I could do) My best solution is probably using multiple ORM calls in a transaction for now, but was wondering if there was a way of doing this efficiently that I don't know about My query:

const data = await db
  .insert(wishlist)
  .values({
    userId: userId,
  })
  .returning() // this returns succesfully if no conflicts
  .onConflictDoNothing(); // can we somehow return the "conflicted" row?

const data = await db
  .insert(wishlist)
  .values({
    userId: userId,
  })
  .returning() // this returns succesfully if no conflicts
  .onConflictDoNothing(); // can we somehow return the "conflicted" row?

1 replies

TTCTheo's Typesafe Cult

•Created by Aryan on 2/25/2024 in #questions

[Turborepo] How to exclude a folder?

I have a Turborepo app that uses pnpm and pnpm workspaces. Everything's good. Q: Now let's say I wanted to add a ElysiaJS (uses Bun) or any other language for that matter (Go backend for example). I want to store them in my monorepo so I have everything in one place, but I want Turborepo to not look at this folder for any building/dev/caching etc. Is this possible? Worst case I just put the other lang backends in a different repo but I'd like to have them all in my monorepo.

5 replies

TTCTheo's Typesafe Cult

•Created by Aryan on 4/19/2023 in #questions

How to let 2 types of users to login to my app - customers and businesses

I'm using Clerk rn but I'm down to switch to NextAuth if it works better for this. I just want to let customers and businesses sign up to this website - and they see different stuff when they login. I ask businneses more questions on signup and store that in a table (customer data on another table) How would I even manage this? Do I let states manage this? (don't think this is correct)

7 replies

Gaming

Programming