kinsyu Comments - Answer Overflow

kinsyu

Explore posts from servers

TtRPC TTCTheo's Typesafe Cult DTDrizzle Team

•Created by kinsyu on 5/25/2024 in #help

onConflictDoUpdate excluded with a dynamic column

the idea is to be able to dynamically pass either minMembers, minMcap or maxTime through a parameter to the function, and update that field.

4 replies

DTDrizzle Team

•Created by kinsyu on 5/25/2024 in #help

onConflictDoUpdate excluded with a dynamic column

Here's the schema

export const groupAlertsConfigTable = pgTable(
  "groupAlertConfig",
  {
    id: serial("id").primaryKey(),
    groupId: integer("groupId").notNull(),
    userId: text("userId").notNull(),
    minMembers: integer("minMembers"),
    minMCap: integer("minMCap"),
    maxTime: integer("maxTime"),
  },
  (tbl) => ({
    userFk: foreignKey({
      columns: [tbl.userId],
      foreignColumns: [usersTable.id],
    }),
    groupFk: foreignKey({
      columns: [tbl.groupId],
      foreignColumns: [groupsTable.id],
    }),
    userGroupUniq: unique("unique_group_user").on(tbl.userId, tbl.grupId),
  }),
);

export const groupAlertsConfigTable = pgTable(
  "groupAlertConfig",
  {
    id: serial("id").primaryKey(),
    groupId: integer("groupId").notNull(),
    userId: text("userId").notNull(),
    minMembers: integer("minMembers"),
    minMCap: integer("minMCap"),
    maxTime: integer("maxTime"),
  },
  (tbl) => ({
    userFk: foreignKey({
      columns: [tbl.userId],
      foreignColumns: [usersTable.id],
    }),
    groupFk: foreignKey({
      columns: [tbl.groupId],
      foreignColumns: [groupsTable.id],
    }),
    userGroupUniq: unique("unique_group_user").on(tbl.userId, tbl.grupId),
  }),
);

4 replies

Gaming

Programming