[BUG]: pgEnum enumValues does not return as literal value anymore

[Gerbuuun]

What version of drizzle-orm are you using?

0.23.4

Describe the Bug

import { z } from "zod";
import { pgEnum } from "drizzle-orm/pg-core";

export const sexEnum = pgEnum("sex", ["female", "male", "other"]);

const enumSchema = z.enum(sexEnum.enumValues);

The z.enum() requires a literal value and pgEnum.enumValues used to return as type ["female", "male", "other"].
Now the type is just a string[].
Is this intentional and do I need to change the way I do it?

[dankochetov]

Yes, this was intentional, but seems like it was implemented incorrectly. As a quick workaround, you can extract your values tuple into a variable and pass it both to pgEnum and z.enum.

[dankochetov]

Also, you can use drizzle-zod to create a Zod schema from a table.

[Gerbuuun]

Yes I have looked into that. The problem I have with that is that I still need to refine the validation and then add a transformation for sanitization etc. so I still have to do the same kind of work.

Example without drizzle-zod:

// Only the fields that can be changed after insertion
const memberInput = z.object({
  userId: z.string().cuid2(),
  firstName: z.string().max(255),
  middleName: z.string().max(255).nullable(),
  insertion: z.string().max(255).nullable(),
  lastName: z.string().max(255),
  sex: z.enum(["female", "male", "other"]),
  dateOfBirth: z.date().max(new Date()),
});

export const createMemberSchema = memberInput.transform((member) => ({
  id: createId(),
  userId: member.userId,
  firstName: member.firstName.trim(),
  middleName: member.middleName?.trim() || null,
  insertion: member.insertion?.trim() || null,
  lastName: member.lastName.trim(),
  sex: member.sex,
  dateOfBirth: member.dateOfBirth,
  createdAt: new Date(),
  updatedAt: new Date(),
}));

export const updateMemberSchema = memberInput.partial().transform((member) => ({
  userId: member.userId,
  firstName: member.firstName?.trim(),
  middleName: member.middleName?.trim(),
  insertion: member.insertion?.trim(),
  lastName: member.lastName?.trim(),
  sex: member.sex,
  dateOfBirth: member.dateOfBirth,
  updatedAt: new Date(),
}));

Example with drizzle-zod:

const memberInsertSchema = createInsertSchema(members, {
  userId: z.string().cuid2(),
}).transform((member) => ({
  id: createId(),
  userId: member.userId,
  firstName: member.firstName.trim(),
  middleName: member.middleName?.trim() || null,
  insertion: member.insertion?.trim() || null,
  lastName: member.lastName.trim(),
  sex: member.sex,
  dateOfBirth: member.dateOfBirth,
  createdAt: new Date(),
  updatedAt: new Date(),
}));

const memberUpdateSchema = createInsertSchema(members, {
  userId: z.string().cuid2(),
})
  .omit({
    id: true,
    createdAt: true,
    updatedAt: true,
  })
  .partial()
  .transform((member) => ({
    userId: member.userId,
    firstName: member.firstName?.trim(),
    middleName: member.middleName?.trim(),
    insertion: member.insertion?.trim(),
    lastName: member.lastName?.trim(),
    sex: member.sex,
    dateOfBirth: member.dateOfBirth,
    updatedAt: new Date(),
  }));

Of course with drizzle-zod there is a connection between my database table and zod schema. However I lose that anyways when I transform the data.

What would be amazing is to be able to create database tables from a zod schema.

If you think this is possible and something for this project, I might be able to take a look at it but I've never really contributed to projects like this. If you can point me to where this can be implemented, I might try something.

[dankochetov]

Fixed in 0.23.6

[lontrr]

Hello, I'm on 0.38.3 and this isn't fixed. Fields that have pgEnum type return a typescript string, why do they not return the enum values?