Table definition to TS type

Is it possible to get a TS type from a Drizzle Schema Table definition? Something like this:

export const users = pgTable('user', {
    id: text('id')
        .primaryKey()
        .$default(() => `${Math.random()}`),
    name: text('name'),
    email: text('email').notNull(),
    emailVerified: timestamp('emailVerified', { mode: 'date' }),
    image: text('image')
})

export const users = pgTable('user', {
    id: text('id')
        .primaryKey()
        .$default(() => `${Math.random()}`),
    name: text('name'),
    email: text('email').notNull(),
    emailVerified: timestamp('emailVerified', { mode: 'date' }),
    image: text('image')
})

👆 would convert to 👇

type User = {
  id: string
  name: string
  email: string
  emailVerified: string
  image: string
}

type User = {
  id: string
  name: string
  email: string
  emailVerified: string
  image: string
}

2 Replies

cenuijza•6mo ago

https://orm.drizzle.team/learn/latest-releases/drizzle-orm-v0283#-added-tableinferselect--table_inferselect-and-tableinferinsert--table_inferinsert-for-more-convenient-table-model-type-inference

Drizzle ORM - DrizzleORM v0.28.3 release

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

Slaven•6mo ago

Thank you!

Gaming

Programming

Table definition to TS type