66 lines
2.3 KiB
Markdown
66 lines
2.3 KiB
Markdown
<div align='center'>
|
|
<h1>drizzle-zod <a href=''><img alt='npm' src='https://img.shields.io/npm/v/drizzle-zod?label='></a></h1>
|
|
<img alt='npm' src='https://img.shields.io/npm/dm/drizzle-zod'>
|
|
<img alt='npm bundle size' src='https://img.shields.io/bundlephobia/min/drizzle-zod'>
|
|
<a href='https://discord.gg/yfjTbVXMW4'><img alt='Discord' src='https://img.shields.io/discord/1043890932593987624'></a>
|
|
<img alt='License' src='https://img.shields.io/npm/l/drizzle-zod'>
|
|
<h6><i>If you know SQL, you know Drizzle ORM</i></h6>
|
|
<hr />
|
|
</div>
|
|
|
|
`drizzle-zod` is a plugin for [Drizzle ORM](https://github.com/drizzle-team/drizzle-orm) that allows you to generate [Zod](https://zod.dev/) schemas from Drizzle ORM schemas.
|
|
|
|
**Features**
|
|
|
|
- Create a select schema for tables, views and enums.
|
|
- Create insert and update schemas for tables.
|
|
- Supports all dialects: PostgreSQL, MySQL and SQLite.
|
|
|
|
# Usage
|
|
|
|
```ts
|
|
import { pgEnum, pgTable, serial, text, timestamp } from 'drizzle-orm/pg-core';
|
|
import { createInsertSchema, createSelectSchema } from 'drizzle-zod';
|
|
import { z } from 'zod';
|
|
|
|
const users = pgTable('users', {
|
|
id: serial('id').primaryKey(),
|
|
name: text('name').notNull(),
|
|
email: text('email').notNull(),
|
|
role: text('role', { enum: ['admin', 'user'] }).notNull(),
|
|
createdAt: timestamp('created_at').notNull().defaultNow(),
|
|
});
|
|
|
|
// Schema for inserting a user - can be used to validate API requests
|
|
const insertUserSchema = createInsertSchema(users);
|
|
|
|
// Schema for updating a user - can be used to validate API requests
|
|
const updateUserSchema = createUpdateSchema(users);
|
|
|
|
// Schema for selecting a user - can be used to validate API responses
|
|
const selectUserSchema = createSelectSchema(users);
|
|
|
|
// Overriding the fields
|
|
const insertUserSchema = createInsertSchema(users, {
|
|
role: z.string(),
|
|
});
|
|
|
|
// Refining the fields - useful if you want to change the fields before they become nullable/optional in the final schema
|
|
const insertUserSchema = createInsertSchema(users, {
|
|
id: (schema) => schema.positive(),
|
|
email: (schema) => schema.email(),
|
|
role: z.string(),
|
|
});
|
|
|
|
// Usage
|
|
|
|
const user = insertUserSchema.parse({
|
|
name: 'John Doe',
|
|
email: 'johndoe@test.com',
|
|
role: 'admin',
|
|
});
|
|
|
|
// Zod schema type is also inferred from the table schema, so you have full type safety
|
|
const requestSchema = insertUserSchema.pick({ name: true, email: true });
|
|
```
|