fawwaz Comments - Answer Overflow

fawwaz

Posts Comments

DTDrizzle Team

•Created by peterstnsz on 6/1/2024 in #help

Supabase + Drizzle + Nuxt 3 + Node - SSL 'SELF_SIGNED_CERT_IN_CHAIN' and drizzle-kit studio issues

I'm in the same boat looking for answers. is it possible that there is no way to do this with drizzle?

5 replies

DTDrizzle Team

•Created by sevenwestonroads on 4/23/2023 in #help

UPSERT many ?

I might be wrong as I'm not an sql expert but @Jan Vorwerk shouldn't you catch all the keys instead of just the keys of the first element in the array, something like this?

const saveAll = async (usersData: Array<NewUser | UpdateUser>) => {
  await db
    .insert(users)
    .values(usersData)
    .onConflictDoUpdate({
      target: users.id,
      set: Object.assign(
        {},
        [...new Set(usersData.map((user) => Object.keys(user)).flat())].filter((k) => k !== "id").map((k) => ({ [k]: sql`excluded.${k}` }))
      ) as Partial<UpdateUser>,
    });
};

const saveAll = async (usersData: Array<NewUser | UpdateUser>) => {
  await db
    .insert(users)
    .values(usersData)
    .onConflictDoUpdate({
      target: users.id,
      set: Object.assign(
        {},
        [...new Set(usersData.map((user) => Object.keys(user)).flat())].filter((k) => k !== "id").map((k) => ({ [k]: sql`excluded.${k}` }))
      ) as Partial<UpdateUser>,
    });
};

14 replies

CCConvex Community

•Created by fawwaz on 11/3/2023 in #support-community

ways to debug and fix slow updates

3 replies

CCConvex Community

•Created by fawwaz on 10/24/2023 in #support-community

Trying to implement 404 but getting validator error

what! 😳 really ?, so if say a userId was passed to the bellow line, we are not always going to get null? const campaign = await ctx.db.get(args.id as Id<"campaigns">).catch(() => null);

15 replies

CCConvex Community

•Created by fawwaz on 10/24/2023 in #support-community

Trying to implement 404 but getting validator error

15 replies

CCConvex Community

•Created by erquhart on 7/1/2023 in #support-community

Updating the UI for relational batch deletions

would cascading delete be a possible feature that can come to Convex?

11 replies

CCConvex Community

•Created by fawwaz on 10/15/2023 in #support-community

an object with fixed shape but random keys in the table schema

that's not a bad idea, thanks @Michal Srb

3 replies

CCConvex Community

•Created by iZeus on 10/13/2023 in #support-community

I have to use VPN.

I think this is also connected to this https://discord.com/channels/1019350475847499849/1133322692032995388/1150060033950879776

8 replies

CCConvex Community

•Created by fawwaz on 10/11/2023 in #support-community