3 replies

upsert with excluded using column name

I'm trying to do a an upsert like so

await db.insert(user).values(values).onConflictDoUpdate({
  target: user.id,
  set: {
    // Defined in schema as full_name
    fullName: sql`EXCLUDED.${user.fullName.name}`
}
})

await db.insert(user).values(values).onConflictDoUpdate({
  target: user.id,
  set: {
    // Defined in schema as full_name
    fullName: sql`EXCLUDED.${user.fullName.name}`
}
})

When I try to do this, I'm getting error

PostgresError: syntax error at or near "$265"

PostgresError: syntax error at or near "$265"

. If I do

fullName: sql`EXCLUDED.full_name`

fullName: sql`EXCLUDED.full_name`

, it works. But I would like to do so using the

.name

.name

property as it will be easier to catch if there's an issue. How do I do it?

Solution

Hello @vr7bd. You can follow this guide to do upsert
https://orm.drizzle.team/learn/guides/upsert

In your case should be

await db.insert(user).values(values).onConflictDoUpdate({
  target: user.id,
  set: {
    // Defined in schema as full_name
    fullName: sql.raw(`excluded.${user.fullName.name}`)
}
})

await db.insert(user).values(values).onConflictDoUpdate({
  target: user.id,
  set: {
    // Defined in schema as full_name
    fullName: sql.raw(`excluded.${user.fullName.name}`)
}
})

Drizzle ORM - Upsert Query

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

Jump to solution

Drizzle Team•2y ago•

3 replies

vr7bd

upsert with excluded using column name

I'm trying to do a an upsert like so

await db.insert(user).values(values).onConflictDoUpdate({
  target: user.id,
  set: {
    // Defined in schema as full_name
    fullName: sql`EXCLUDED.${user.fullName.name}`
}
})

await db.insert(user).values(values).onConflictDoUpdate({
  target: user.id,
  set: {
    // Defined in schema as full_name
    fullName: sql`EXCLUDED.${user.fullName.name}`
}
})

When I try to do this, I'm getting error

PostgresError: syntax error at or near "$265"

PostgresError: syntax error at or near "$265"

. If I do

fullName: sql`EXCLUDED.full_name`

fullName: sql`EXCLUDED.full_name`

, it works. But I would like to do so using the

.name

.name

property as it will be easier to catch if there's an issue. How do I do it?

Solution

Hello @vr7bd. You can follow this guide to do upsert
https://orm.drizzle.team/learn/guides/upsert

In your case should be

await db.insert(user).values(values).onConflictDoUpdate({
  target: user.id,
  set: {
    // Defined in schema as full_name
    fullName: sql.raw(`excluded.${user.fullName.name}`)
}
})

await db.insert(user).values(values).onConflictDoUpdate({
  target: user.id,
  set: {
    // Defined in schema as full_name
    fullName: sql.raw(`excluded.${user.fullName.name}`)
}
})

Drizzle ORM - Upsert Query

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

Jump to solution

upsert with excluded using column name

upsert with excluded using column name

Similar Threads

Similar Threads

Similar Threads