BabaYaga Posts - Answer Overflow

BabaYaga

Explore posts from servers

•Created by BabaYaga on 8/24/2023 in #help

drizzle-zod doesn't work with Array in pg

I'm using drizzle-orm, drizzle-kit & drizzle-zod in my application. One of my schema looks like following:

export const committee = pgTable("committee", {
  id: text("id").primaryKey().notNull(),
  safety_health: text("safety_health"),
  safety_health_sources: text(
    "safety_health_sources"
  ).array(),
  // other properties

export const committee = pgTable("committee", {
  id: text("id").primaryKey().notNull(),
  safety_health: text("safety_health"),
  safety_health_sources: text(
    "safety_health_sources"
  ).array(),
  // other properties

The schema works fine when I push, safety_health_sources is created as an array (No issues till this point) I create zod schema as well, like following:

export const committeeSchema = createSelectSchema(committee);

export const committeeSchema = createSelectSchema(committee);

and when I do:

type Committee = Partial<
  z.infer<typeof committeeSchema>
>;
// the type become something like following
type Committee = {
    id?: string | undefined;
    safety_health?: string | null | undefined;
    safety_health_sources?: string | null | undefined; // <--- The problem is here, it should be an Array<string>
    // other properties
}

type Committee = Partial<
  z.infer<typeof committeeSchema>
>;
// the type become something like following
type Committee = {
    id?: string | undefined;
    safety_health?: string | null | undefined;
    safety_health_sources?: string | null | undefined; // <--- The problem is here, it should be an Array<string>
    // other properties
}

6 replies

DTDrizzle Team

•Created by BabaYaga on 7/15/2023 in #help

[Solved] Transforming const to the configured target environment ("es5") is not supported yet

So I had a old project, and I copied the DATABASE_URL and on created a basic drizzle project and drizzle.config.ts I got a schema created. Now, I copied the schema.ts file and pasted it into my new (second/another) project. I ran npx drizzle-kit generate:pg but I got the error Transforming const to the configured target environment ("es5") is not supported yet 55 times (55 is the number of tables that I have) 🥹 PLS HELP

2 replies

Gaming

Programming