nestjs_specialist

Create a DatabaseService that initializes drizzle with a node-postgres Pool and your schema, then inject it into repository classes. Repositories use db.select, insert, update, and delete with eq filters, keeping Drizzle code out of services.

Implement a JwtAuthGuard as a CanActivate that extracts the Bearer token from the authorization header and verifies it with JwtService. Attach the decoded payload to request.user, then combine with a RolesGuard using Reflector for role-based access control.

Drizzle ORM offers a lightweight, SQL-like query API with strong TypeScript inference and schema defined in code via pgTable. TypeORM uses decorator-based entities and active record patterns. This skill covers Drizzle with migrations via drizzle-kit.

Generate migration files with npx drizzle-kit generate, then run them programmatically using the migrate function from drizzle-orm/node-postgres/migrator inside a MigrationService. Migrations can also run during E2E test setup before app initialization.

Create a TestingModule importing AppModule, run Drizzle migrations against a test database, and clean tables in beforeEach. Use supertest against app.getHttpServer to assert HTTP responses while seeding data directly through the DatabaseService.