nestjs

# NestJS Framework with Drizzle ORM ## Overview Provides NestJS patterns with Drizzle ORM for building production-ready server-side applications. Covers CRUD modules, JWT authentication, database operations, migrations, testing, microservices, and GraphQL integration. ## When to Use - Building REST APIs or GraphQL servers with NestJS - Setting up authentication and authorization with JWT - Implementing database operations with Drizzle ORM - Creating microservices with TCP/Redis transport - Writing unit and integration tests - Running database migrations with drizzle-kit ## Instructions 1. **Install dependencies**: `npm i drizzle-orm pg && npm i -D drizzle-kit tsx` 2. **Define schema**: Create `src/db/schema.ts` with Drizzle table definitions 3. **Create DatabaseService**: Inject Drizzle client as a NestJS provider 4. **Build CRUD module**: Controller → Service → Repository pattern 5. **Add validation**: Use class-validator DTOs with ValidationPipe 6. **Implement guards**: Create JWT/Roles guards for route protection 7. **Write tests**: Use `@nestjs/testing` with mocked repositories 8. **Run migrations**: `npx drizzle-kit generate` → **Verify SQL** → `npx drizzle-kit migrate` ## Examples ### Complete CRUD Module with Drizzle ```typescript // src/db/schema.ts export const users = pgTable('users', { id: serial('id').primaryKey(), name: text('name').notNull(), email: text('email').notNull().unique(), createdAt: timestamp('created_at').defaultNow(), }); // src/us...