3 replies

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

store

that I want to update its joined table

shelf

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

await prisma.store
      .update({
        where: {
          id: store.id,
        },
        data: {
          shelf: {
            upsert: {
              create: {
                shelfName: data.shelfName,
              },
              update: {
                shelfName: data.shelfName,
              },
            },
          },
        },
      })

Drizzle Team•3y ago•

3 replies

imoby

Upsert create/update joined table similar to Prisma

store

store

that I want to update its joined table

shelf

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

await prisma.store
      .update({
        where: {
          id: store.id,
        },
        data: {
          shelf: {
            upsert: {
              create: {
                shelfName: data.shelfName,
              },
              update: {
                shelfName: data.shelfName,
              },
            },
          },
        },
      })

Upsert create/update joined table similar to Prisma

Similar Threads

Upsert create/update joined table similar to Prisma

Similar Threads

Similar Threads

Similar Threads