Type Hinting $inferSelect

Hi Drizzle Team,

I have the following tables set up with Postgres and Drizzle. There is a

reviews

reviews

table with an enum

status

status

field. When the

status

status

assigned

assigned

, the

userId

userId

field is non-null, otherwise it's null.

Is there a way to typehint

reviews.$inferSelect

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'
});

Drizzle Team•2y ago

Patrick

Type Hinting $inferSelect

Hi Drizzle Team,

I have the following tables set up with Postgres and Drizzle. There is a

reviews

reviews

table with an enum

status

status

field. When the

status

status

assigned

assigned

, the

userId

userId

field is non-null, otherwise it's null.

Is there a way to typehint

reviews.$inferSelect

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'
});

Type Hinting $inferSelect

Similar Threads

Type Hinting $inferSelect

Similar Threads

Similar Threads

Similar Threads