Drizzle Team•7mo ago

Type Hinting $inferSelect

Hi Drizzle Team, I have the following tables set up with Postgres and Drizzle. There is a reviews table with an enum status field. When the status is assigned, the userId field is non-null, otherwise it's null. Is there a way to typehint reviews.$inferSelect such that it adheres to the type logic above?

export const status = pgEnum("status", ["unassigned", "assigned"]);
export const reviews = createTable("review", {
  id: uuid("id").defaultRandom().primaryKey(),
  status: status("status").notNull(),
  userId: uuid("user_id"), // set if the review status is 'assigned'
});

export const status = pgEnum("status", ["unassigned", "assigned"]);
export const reviews = createTable("review", {
  id: uuid("id").defaultRandom().primaryKey(),
  status: status("status").notNull(),
  userId: uuid("user_id"), // set if the review status is 'assigned'
});

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Type Hinting $inferSelect