Can I use this for complex SQL joins?

Absolutely. It includes patterns for implementing leftJoin and addSelect to optimize data fetching for related entities.

Does this skill handle soft deletes automatically?

Yes, the skill includes 'isDeleted = 0' filters by default in its QueryBuilder templates to ensure deleted records are excluded from standard queries.

What base class do the generated repositories use?

All generated repositories extend the standard Symfony ServiceEntityRepository for full compatibility with Doctrine Bundle features.

Where are the repository files located?

The skill manages files specifically within the 'api/src/Repository/' directory of your Symfony project.

Symfony Doctrine Repository Assistant

Name: Symfony Doctrine Repository Assistant
Author: Swoking

bySwoking

データベース管理

Generates and manages Doctrine repositories with optimized QueryBuilder patterns and soft-delete support.

概要

The symfony-sk:api-repository skill automates the creation and modification of Doctrine repositories within Symfony projects. It provides standardized templates for ServiceEntityRepository, ensuring consistent implementation of custom database queries. By incorporating best practices like mandatory soft-delete filtering (isDeleted = 0), type-hinted PHPDoc, and efficient QueryBuilder patterns for joins and counts, this skill helps developers maintain a clean and performant data access layer while reducing boilerplate code.

主な機能

Standardized ServiceEntityRepository boilerplate generation
Automatic soft-delete filtering (isDeleted = 0) integration
Support for complex relational joins and aggregate functions
Type-hinted PHPDoc generation for enhanced IDE support
Pre-configured QueryBuilder patterns for common fetch operations
0 GitHub stars

ユースケース

Creating custom database queries for specific business domain logic
Adding soft-delete aware search and filter methods to existing entities
Optimizing data retrieval through custom joins and relational mapping

概要

主な機能

Standardized ServiceEntityRepository boilerplate generation
Automatic soft-delete filtering (isDeleted = 0) integration
Support for complex relational joins and aggregate functions
Type-hinted PHPDoc generation for enhanced IDE support
Pre-configured QueryBuilder patterns for common fetch operations
0 GitHub stars

ユースケース

Creating custom database queries for specific business domain logic
Adding soft-delete aware search and filter methods to existing entities
Optimizing data retrieval through custom joins and relational mapping