Drizzle TeamDT
Drizzle Team•3y ago
imoby

Upsert create/update joined table similar to Prisma

Hey all, trying to get another one of my queries to migrate away from prisma. This one is a bit more complex. Trying to see if I am able to take a joined table and either update it or create it. Prisma has this as a nested option but I couldnt figure out how to solve this with drizzle. In the example below, I have a 
store
 that I want to update its joined table shelf or create it if its not there

await prisma.store
      .update({
        where: {
          id: store.id,
        },
        data: {
          shelf: {
            upsert: {
              create: {
                shelfName: data.shelfName,
              },
              update: {
                shelfName: data.shelfName,
              },
            },
          },
        },
      })
Was this page helpful?