DT
Drizzle Team•5mo ago
Need_Not

onConflict or upsert?

i have a table where email is a unique field. if im trying to insert into the table and the email is already being used i want to overwrite the other entry
3 Replies
Richard E
Richard E•5mo ago
https://orm.drizzle.team/docs/insert#upserts-and-conflicts
Drizzle ORM - Insert
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
Richard E
Richard E•5mo ago
Something like this I think: 
await db.insert(your_table)
  .values({ email: 'a@b.com', name: 'Dan' })
  .onConflictDoUpdate({ target: your_table.email, set: { name: 'John' } });
await db.insert(your_table)
  .values({ email: 'a@b.com', name: 'Dan' })
  .onConflictDoUpdate({ target: your_table.email, set: { name: 'John' } });
Need_Not
Need_Not•5mo ago
i swear i checked thanks
Want results from more Discord servers?
Add your server
More Posts
If we're using Drizzlekit push, do we need to ever generate migrations?Is there anywhere I can explain what the migration scripts are for? When I push a change, can't we jUsing Drizzle w/ PostgrestHi! I was wondering if there is a way to use drizzle w/ postgrest so I can use drizzle on edge. I cDrizzle.config tableFilter EXCLUDE option?Is it possible somehow to exlude tables (not inlcude filtering) database tables with drizzle.config?TypeErr: BatchItem<sqlite>[] not assignable to readonly [BatchItem<sqlite>, ...BatchItem<sqlite>[]]Hi, I'm trying to use drizzle/d1 (cloudflare worker) for batch. But I'm getting type error. ```typeDrizzle multi databse config (MySQL)Hey! I need to use drizzle on a new product, which also access a legacy database. I would like to uAdd a Exclusion Constraint for PostgresI want to add an exclusion constraint to a table where I want to make sure there is only one row witCan I generate migrations folder at runtime?I'm using Electron to build my app, and I'd like to generate the migrations folder at runtime so thaHow can I extend drizzle tables?I noticed that I write a lot of boilerplate code. When I had to update one of such types, I refactorHow to convert sql.raw`` to camelCase?I have queries I need to run with sql.raw but I'd like the result to come out neatly just how it comdrizzle-kit push:pg and sql commandsI have a schema that I can easily push to my PostgreSQL database. But whenever I have something I wa