Richard E Comments - Answer Overflow

Richard E

Explore posts from servers

•Created by Richard E on 3/28/2024 in #help

How can I convert a null value to integer in a select?

I just got it .. keep forgetting postgres does some things I'm not used to:

ranking: sql<number>`coalesce(${player.ranking},9999)

ranking: sql<number>`coalesce(${player.ranking},9999)

4 replies

DTDrizzle Team

•Created by Richard E on 3/28/2024 in #help

How can I convert a null value to integer in a select?

I have also tried the following:

ranking: player.ranking??9999

ranking: player.ranking??9999

4 replies

DTDrizzle Team

•Created by Tobias on 3/6/2024 in #help

drizzle-kit push:pg and sql commands

What I used to do was just tack it onto the end of the last schema change file generated. I don't think there is a way to create an empty migration file for yourself and have it added into the list of migration although that would be nice. I'm using supabase which has it's own migrations story so I've switched away from drizzle migrations totally now

2 replies

DTDrizzle Team

•Created by Need_Not on 3/7/2024 in #help

onConflict or upsert?

Something like this I think:

await db.insert(your_table)
  .values({ email: '[email protected]', name: 'Dan' })
  .onConflictDoUpdate({ target: your_table.email, set: { name: 'John' } });

await db.insert(your_table)
  .values({ email: '[email protected]', name: 'Dan' })
  .onConflictDoUpdate({ target: your_table.email, set: { name: 'John' } });

5 replies

DTDrizzle Team

•Created by Need_Not on 3/7/2024 in #help

onConflict or upsert?

https://orm.drizzle.team/docs/insert#upserts-and-conflicts

5 replies

DTDrizzle Team

•Created by Richard E on 1/10/2024 in #help

Is there a way to introspect with specific order?

Thanks. Would make my git commit much nicer .. such a jumble now

3 replies

Gaming

Programming