How to onConflictDoUpdate with variable? or onConflictReplace?

[ThibaultJanBeyer]

Dear team,

I am looking at a code that goes like:

    const members = userList.members.flatMap((member) => {
        if (member.is_bot || member.name === "slackbot") return [];
        return [
          {
            slackId: member.id || "",
            slackName: member.name || "",
            workspaceId: team.id,
          },
        ];
      });

    await db
        .insert(Users)
        .values(members)
        .onConflictDoUpdate({
          target: Users.slackId,
          set: {
            // slackName:  => how would I set the slack name here? Which is different for each user?
            workspaceId: team.id
          },
        })
        .execute();

Can I somehow force update the user?
Or can I somehow add the specific slackName to the conflicting user?

Thank you!

[ThibaultJanBeyer]

ah! I got it. From the EXCLUDED table like so:

slackName: sql`EXCLUDED.slack_name\`,

Total:

 await db
     .insert(Users)
     .values(members)
     .onConflictDoUpdate({
       target: Users.slackId,
       set: {
         slackName: sql`EXCLUDED.slack_name`,
         workspaceId: team.id
       },
     })
     .execute();

Thanks Github Copilot :D

[aulneau]

thank you! this is helpful. I wish set would return a function like this:

set: (excluded) => ({...});