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

// 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/users/dto/create-user.dto.ts
export class CreateUserDto {
  @IsString() @IsNotEmpty() name: string;
  @IsEmail() email: string;
}

// src/users/user.repository.ts
@Injectable()
export class UserRepository {
  constructor(private db: DatabaseService) {}

  async findAll() {
    return this.db.database.select().from(users);
  }

  async create(data: typeof users.$inferInsert) {
    return this.db.database.insert(users).values(data).returning();
  }
}

// src/users/users.service.ts
@Injectable()
export class UsersService {
  constructor(private repo: UserRepository) {}

  async create(dto: CreateUserDto) {
    return this.repo.create(dto);
  }
}

// src/users/users.controller.ts
@Controller('users')
export class UsersController {
  constructor(private service: UsersService) {}

  @Post()
  create(@Body() dto: CreateUserDto) {
    return this.service.create(dto);
  }
}

// src/users/users.module.ts
@Module({
  controllers: [UsersController],
  providers: [UsersService, UserRepository, DatabaseService],
  exports: [UsersService],
})
export class UsersModule {}