can onConflictDoUpdate coalesce?

[jiangok2006]

hi,

Suppose my table schema is (id: number (primary key), name: string, age: number). I have an existing record (1, "john", 20). Now I want to upsert (1, "john", null) where age=null:

let row = { id: 1, name: "john", age: null }
await drizzle(db).insert(users).values(row)
        .onConflictDoUpdate(
            {
                target: users.id,
                set: row
            }).returning();

I want to get the final record (1, "john", 20) instead of (1, "john", null). This needs drizzle to coalesce the provided null age with the existing 20. I can workaround by reading the existing record and manually create a coalesced row to upsert, but it is not efficient and bad DX.

Can Drizzle do this? Thanks!

[Angelelz]

Can you check if this would work?

let row = { id: 1, name: "john", age: null }
await drizzle(db).insert(users).values(row)
        .onConflictDoUpdate(
            {
                target: users.id,
                set: {
                    ...row,
                    age: sql`coalesce(${row.age}, excluded.age)`
                }
            }).returning();

[shawnmclean]

How'd this work if you're inserting multiple?