DT
Drizzle Team•3mo ago
franek.stodulski

DrizzleZod - Can't use "createSelectSchema"

Hi! I have an issue with drizzle-orm & drizzle-zod from the beginning of my turborepo project. Packages: 
  
"dependencies": {
    "@paralleldrive/cuid2": "^2.2.2",
    "@t3-oss/env-core": "^0.11.1",
    "dotenv": "^16.4.5",
    "drizzle-orm": "^0.35.2",
    "drizzle-zod": "^0.5.1",
    "pg": "^8.13.0",
    "zod": "^3.23.8"
  },
  "devDependencies": {
    "@types/pg": "^8.11.10",
    "drizzle-kit": "^0.26.2",
    "tsx": "^4.19.1"
  }
  
"dependencies": {
    "@paralleldrive/cuid2": "^2.2.2",
    "@t3-oss/env-core": "^0.11.1",
    "dotenv": "^16.4.5",
    "drizzle-orm": "^0.35.2",
    "drizzle-zod": "^0.5.1",
    "pg": "^8.13.0",
    "zod": "^3.23.8"
  },
  "devDependencies": {
    "@types/pg": "^8.11.10",
    "drizzle-kit": "^0.26.2",
    "tsx": "^4.19.1"
  }
Simple Users table Definition: 
import { createId } from "@paralleldrive/cuid2";

import { pgTable, text, timestamp } from "drizzle-orm/pg-core";
import { timestampColumns } from "src/schema/_shared/time-stamp";

import { createSelectSchema } from "drizzle-zod";

export const TB_Users = pgTable("users", {
  id: text("id").primaryKey().$defaultFn(createId),

  email: text("email").unique().notNull(),
  passwordHash: text("password_hash").notNull(),
  emailVerified: timestamp("email_verified", { mode: "date" }).notNull(),

  ...timestampColumns,
});

export const userSchema = createSelectSchema(TB_Users);
import { createId } from "@paralleldrive/cuid2";

import { pgTable, text, timestamp } from "drizzle-orm/pg-core";
import { timestampColumns } from "src/schema/_shared/time-stamp";

import { createSelectSchema } from "drizzle-zod";

export const TB_Users = pgTable("users", {
  id: text("id").primaryKey().$defaultFn(createId),

  email: text("email").unique().notNull(),
  passwordHash: text("password_hash").notNull(),
  emailVerified: timestamp("email_verified", { mode: "date" }).notNull(),

  ...timestampColumns,
});

export const userSchema = createSelectSchema(TB_Users);
Getting Error for userSchema:
No description
1 Reply
franek.stodulski
franek.stodulskiOP•3mo ago
Also. For drizzle db instance. Following these steps "https://orm.drizzle.team/docs/get-started-postgresql#step-1---install-packages" 
import { drizzle } from "drizzle-orm/node-postgres";

import { DATABASE_URL } from "./env";

export const db = drizzle(DATABASE_URL);
import { drizzle } from "drizzle-orm/node-postgres";

import { DATABASE_URL } from "./env";

export const db = drizzle(DATABASE_URL);
Drizzle ORM - PostgreSQL
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
No description

Did you find this page helpful?