giuseppe-trisciuoglio/developer-kit / plugins/developer-kit-typescript/skills/nestjs-drizzle-crud-generator
nestjs-drizzle-crud-generator
VerifiedGenerates complete CRUD modules for NestJS applications with Drizzle ORM. Use when building server-side features in NestJS that require database operations, including creating new entities with full CRUD endpoints, services with Drizzle queries, Zod-validated DTOs, and unit tests. Triggered by requests like "generate a user module", "create a product CRUD", "add a new entity with endpoints", or when setting up database-backed features in NestJS.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 5.3 KB |
| assets/templates/controller-template.ts | script | 1.4 KB |
| assets/templates/dto-template.ts | script | 1003 B |
| assets/templates/module-template.ts | script | 1.2 KB |
| assets/templates/service-template.ts | script | 3.5 KB |
| assets/templates/table-template.ts | script | 709 B |
| assets/templates/test-template.ts | script | 5.1 KB |
| references/field-types.md | markdown | 1.3 KB |
| scripts/generate_crud.py | script | 12.0 KB |
assets/templates/test-template.ts
View on GitHubimport { Test, TestingModule } from '@nestjs/testing';
import { {{FeatureName}}Service } from './{{featureName}}.service';
import { DrizzleProvider } from './{{featureName}}.service';
import { {{FeatureName}}Table } from '../schema/{{featureName}}.table';
describe('{{FeatureName}}Service', () => {
let service: {{FeatureName}}Service;
let mockDb: {
select: jest.Mock;
insert: jest.Mock;
update: jest.Mock;
delete: jest.Mock;
};
const mock{{FeatureName}} = {
id: '123e4567-e89b-12d3-a456-426614174000',
{{MockFields}}
createdAt: new Date(),
updatedAt: new Date(),
deletedAt: null,
};
beforeEach(async () => {
mockDb = {
select: jest.fn().mockReturnValue({
from: jest.fn().mockReturnValue({
where: jest.fn().mockReturnValue({
returning: jest.fn().mockResolvedValue([]),
limit: jest.fn().mockReturnValue({
offset: jest.fn().mockReturnValue({
returning: jest.fn().mockResolvedValue([]),
}),
}),
}),
}),
}),
insert: jest.fn().mockReturnValue({
values: jest.fn().mockReturnValue({
returning: jest.fn().mockResolvedValue([mock{{FeatureName}}]),
}),
}),
update: jest.fn().mockReturnValue({
set: jest.fn().mockReturnValue({
where: jest.fn().mockReturnValue({
returning: jest.fn().mockResolvedValue([mock{{FeatureName}}]),
}),
}),
}),
delete: jest.fn().mockReturnValue({
where: jest.fn().mockReturnValue({
returning: jest.fn().mockResolvedValue([]),
}),
}),
};
const module: TestingModule = await Test.createTestingModule({
providers: [
{{FeatureName}}Service,
{
provide: DrizzleProvider,
useValue: mockDb,
},
],
}).compile();
service = module.get<{{FeatureName}}Service>({{FeatureName}}Service);
});
describe('create', () => {
it('should create a new {{featureName}}', async () => {
const dto = {{CreateDtoMock}};
const result = await service.create(dto as any);
expect(mockDb.insert).toHaveBeenCalled();
expect(result).toEqual(mock{{FeatureName}});
});
});
describe('findAll', () => {
it('should return paginated results', async () => {
const query = { page: 1, limit: 10 };
const result = await service.findAll(query as any);
expect(result.rows).toEqual([mock{{FeatureName}}]);
expect(result.total).toBeGreaterThanOrEqual(0);
});
it('should return empty array when no results', async () => {
mockDb.select.mockReturnValue({
from: jest.fn().mockReturnValue({
where: jest.fn().mockReturnValue({
returning: jest.fn().mockResolvedValue([]),
limit: jest.fn().mockReturnValue({
offset: jest.fn().mockReturnValue({
returning: jest.fn().mockResolvedValue([]),
}),
}),
}),
}),
});
const query = { page: 1, limit: 10 };
const result = await service.findAll(query as any);
expect(result.rows).toEqual([]);
expect(result.total).toBe(0);
});
});
describe('findOne', () => {
it('should return a {{featureName}} by id', async () => {
const result = await service.findOne(mock{{FeatureName}}.id);
expect(result).toEqual(mock{{FeatureName}});
});
it('should return null for non-existent id', async () => {
mockDb.select.mockReturnValue({
from: jest.fn().mockReturnValue({
where: jest.fn().mockReturnValue({
returning: jest.fn().mockResolvedValue([]),
}),
}),
});
const result = await service.findOne('non-existent-id');
expect(result).toBeNull();
});
});
describe('update', () => {
it('should update a {{featureName}}', async () => {
const dto = {{UpdateDtoMock}};
const result = await service.update(mock{{FeatureName}}.id, dto as any);
expect(mockDb.update).toHaveBeenCalled();
expect(result).toEqual(mock{{FeatureName}});
});
it('should throw NotFoundException for non-existent id', async () => {
mockDb.select.mockReturnValue({
from: jest.fn().mockReturnValue({
where: jest.fn().mockReturnValue({
returning: jest.fn().mockResolvedValue([]),
}),
}),
});
await expect(
service.update('non-existent-id', {} as any),
).rejects.toThrow('not found');
});
});
describe('remove', () => {
it('should soft delete a {{featureName}}', async () => {
await service.remove(mock{{FeatureName}}.id);
expect(mockDb.update).toHaveBeenCalled();
});
it('should throw NotFoundException for non-existent id', async () => {
mockDb.select.mockReturnValue({
from: jest.fn().mockReturnValue({
where: jest.fn().mockReturnValue({
returning: jest.fn().mockResolvedValue([]),
}),
}),
});
await expect(service.remove('non-existent-id')).rejects.toThrow(
'not found',
);
});
});
});
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the work | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixes | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation code | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |