DT
Drizzle Team

help

Does onConflictDoUpdate work with composite primary keys?

Nngregrichardson
View on Discord
5/8/2023
I have a model defined below: 
export const userDevices = pgTable(
  'user_devices',
  {
    id: text('id').notNull(),
    userId: uuid('user_id')
      .notNull()
      .references(() => users.id, {
        onDelete: 'cascade',
      }),
      ...
  },
  (table) => ({
    idUserIdPk: primaryKey(table.id, table.userId),
  }),
);
export const userDevices = pgTable(
  'user_devices',
  {
    id: text('id').notNull(),
    userId: uuid('user_id')
      .notNull()
      .references(() => users.id, {
        onDelete: 'cascade',
      }),
      ...
  },
  (table) => ({
    idUserIdPk: primaryKey(table.id, table.userId),
  }),
);
I want to upsert a row into this table but I'm not sure how to set target to the composite primary key. Is this possible? 
return this.drizzleService.db
      .insert(userDevices)
      .values(data)
      .onConflictDoUpdate({
        target: /* What to do here? */,
        set: data,
      });
return this.drizzleService.db
      .insert(userDevices)
      .values(data)
      .onConflictDoUpdate({
        target: /* What to do here? */,
        set: data,
      });
Ttmcw
View on Discord
5/8/2023
try something like this? 
target: [table.id, table.userId]
target: [table.id, table.userId]
Nngregrichardson
View on Discord
5/9/2023
Seems like that worked! I have yet to actually run it but the types don't disagree :)

Looking for more? Join the community!

DT
Drizzle Team

help

Join Server
Want results from more Discord servers?
Add your server
Recommended Posts
Support for multiple with statements?Is it possible to have multiple with statements? ``` const carriers = await tx .with(cahow to use placeholders for Prepared Insert statements?Is this possible?use constant in between operatorHello guys, Is there any way to use constant in between filter instead of column?Type error: Could not find a declaration file for module 'drizzle-kit'.Any idea how to fix this problem? I try to run this: npm i --save-dev @types/drizzle-kit: npm ERR! Typescript error that doesn't make a whole lot of sense when calling db.select or db.insertThis is my account model ``` export const accounts = mysqlTable("accounts", { id: nanoid("id", {Are default values not transferred over via drizzle-zod?It seems like when I use a `default([])` in my `schema` file that when I create a Zod object, I have