Issue with 'insert on conflict do update where'
I am using
db.insert(lastHeaterMetricsTable)
.values(heaterEntityWithMaxTime)
.onConflictDoUpdate({
target: lastHeaterMetricsTable.deviceId,
set: heaterEntityWithMaxTime,
where: lt(
lastHeaterMetricsTable.receivedAt,
heaterEntityWithMaxTime.receivedAt,
),
})
.execute()
But as the query result I get the following:
db.insert(lastHeaterMetricsTable)
.values(heaterEntityWithMaxTime)
.onConflictDoUpdate({
target: lastHeaterMetricsTable.deviceId,
set: heaterEntityWithMaxTime,
where: lt(
lastHeaterMetricsTable.receivedAt,
heaterEntityWithMaxTime.receivedAt,
),
})
.execute()
But as the query result I get the following:
wheredo update
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,959Members
Resources
Similar Threads
Was this page helpful?
