Drizzle Teamrykuno

PGEnum -> Typescript Enum

Hey there. Is there any convenient way people have found to conveniently turn a pgEnum into a typescript enum such as below? Currently I'm creating DTO's but i figured coupling them would be much easier :). I figure ZOD might come into play but we are utilizing NestJS w/ class-validator atm.

const typeEnum = pgEnum('type', [
  'short_text',
  'long_text',
  'single_choice',
  'multiple_choice',
]);

export enum SurveyQuestionType {
  SHORT_TEXT = 'short_text',
  LONG_TEXT = 'long_text',
  SINGLE_CHOICE = 'single_choice',
  MULTIPLE_CHOICE = 'multiple_choice',
}

const typeEnum = pgEnum('type', [
  'short_text',
  'long_text',
  'single_choice',
  'multiple_choice',
]);

export enum SurveyQuestionType {
  SHORT_TEXT = 'short_text',
  LONG_TEXT = 'long_text',
  SINGLE_CHOICE = 'single_choice',
  MULTIPLE_CHOICE = 'multiple_choice',
}

Waldo•301d ago

Hello! Did you ever find a solution for this?

Vanerac•300d ago

const valueMap = [
  'short_text',
  'long_text',
  'single_choice',
  'multiple_choice',
] as const

const typeEnum = pgEnum('type', valueMap);

export type SurveyQuestionType = typeof typeEnum[number]

const valueMap = [
  'short_text',
  'long_text',
  'single_choice',
  'multiple_choice',
] as const

const typeEnum = pgEnum('type', valueMap);

export type SurveyQuestionType = typeof typeEnum[number]

I'd try something like this

RaikuGg 🧑💻•176d ago

Found any solution for this? Currently I am doing -

export const teamMemberStatusEnum = pgEnum('team_member_status', [
  'Active',
  'Inactive',
  'Invited',
]);
export const TeamMemberStatus = z.enum(teamMemberStatusEnum.enumValues).Enum;

export const teamMemberStatusEnum = pgEnum('team_member_status', [
  'Active',
  'Inactive',
  'Invited',
]);
export const TeamMemberStatus = z.enum(teamMemberStatusEnum.enumValues).Enum;

균어•176d ago

im doing like this too

Drizzle Team Join

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

7.4KMembers

View on Discord

Want results from more Discord servers?

Add your server

Is Drizzle Kit/Drizzle Studio possible with RDS Data API?I'm able to create the RDSDataClient for querying my DB using Drizzle ORM, but I don't see a way to How to apply migrations on postgres in a serverless enviroment?Hello, I want to apply postgres migrations to my vercel DB. I see that the push command does not wo Error when trying to generate a migration schemaanyone any ideas to what the problem is? It was working fine yesterday and now it throws an error wh Modelling self relationsI have a table `categories` with a parent fields: ``` { id: text("id").notNull().primaryKey(), .Issue running migrations to DBI am having an issue running migrations to Neon. I checked that everything is exporting const variab It is possible to have prepared statements inside transactions?Is there a way to insert prepared queries inside a transaction ?type config findMany or findFirstHi, I've one question i don't find the way to type correctly findMany() Like: export async function Any idea on how to pass a pool from postgres-pool to drizzle?Passing a single client works, but for better connection management it would help to be able to pass How to get another linked tables count?I am new to Drizzle ORM and I wanted to get another tables data in my api. This is my api ```ts imp I created a next auth adapter for postgres-jsThe open PR was not working for me so I created a new adapter. I added it to a starter project so pe

Gaming

Programming

PGEnum -> Typescript Enum