AgentSkillsCN

api-data-repository

生成扩展自 BaseRepository 的仓储层，支持多租户、Testcontainers 以及事务模式。在构建数据访问层，或新增租户范围查询时，可使用此功能。

SKILL.md
--- frontmatter
name: api-data-repository
description: Generate repository extending BaseRepository with multi-tenancy support, Testcontainers, and transaction patterns. Use when creating data access layer or adding tenant-scoped queries.
allowed-tools:
  - Read
  - Write
  - Edit
  - Glob
  - Grep

Data Repository

Purpose

Generate a repository class that extends BaseRepository from @starter/foundation-repositories with multi-tenancy support, transaction patterns, and Testcontainers for integration testing.

When to Use

  • •Creating data access layer for new entities
  • •Adding complex query methods to repositories
  • •Implementing tenant-scoped data access
  • •Creating repositories with proper test coverage

What It Generates

Directory Structure

code
apps/api/src/modules/{feature}/repositories/
├── {entity}.repository.ts
└── index.ts

Patterns Enforced

BaseRepository Extension

Repositories must extend BaseRepository<T> from @starter/foundation-repositories:

  • •Inherits CRUD methods (findById, findAll, create, update, delete)
  • •All methods accept tenantId parameter
  • •Transaction support via db.transaction()

Multi-Tenancy

  • •All queries include WHERE organization_id = tenantId
  • •All methods validate tenant access
  • •Cross-tenant queries throw ForbiddenException

Transaction Support

  • •Multi-step writes use db.transaction(async (tx) => {...})
  • •All operations within transaction use tx instead of db
  • •Transactions rollback on error

Testcontainers Testing

  • •Integration tests use real PostgreSQL via Testcontainers
  • •Unique test data per test
  • •Cleanup after each test
  • •Tenant isolation tests

Usage Example

bash
/skill data-repository --name=User --table=users --methods='findByEmail,searchByName,findByIdWithProfile'

Related Files