Skip to content

jeffsenso/prestashop-skills / skills/prestashop-module-development/ps9-core-ai/Component/CQRS/skills/create-doctrine-repository

create-doctrine-repository

Verified

Create the repository in the Adapter layer. This is the ONLY class that touches the database — all handlers delegate to it. Covers multistore patterns with ShopConstraint when the entity requires it. Trigger: "create repository for {Domain}".

create-doctrine-repository

See CQRS/CONTEXT.md for conventions (stateless, no Context dependency, multistore tier model, typed exceptions).

1. Choose the base class

Create src/Adapter/{Domain}/{Domain}Repository.php. Choose the base class based on the multistore tier table in CONTEXT.md.

2. Core methods

Implement these methods (adapt naming to your domain):

  • get{Domain}({Domain}Id $id): {LegacyObjectModel} — loads the ObjectModel, throws {Domain}NotFoundException if not found
  • create(...): {Domain}Id — calls ObjectModel save() or add(), wraps in try/catch, returns new ID
  • update(...) — calls ObjectModel save() or update()
  • delete({Domain}Id $id) — deletes the entity, respects multistore if applicable

Reference: src/Adapter/Tax/CommandHandler/ uses a simple repository pattern, src/Adapter/Carrier/CommandHandler/ uses AbstractMultiShopObjectModelRepository

3. Multistore pattern (when using AbstractMultiShopObjectModelRepository)

  • Receive ShopConstraint as a method parameter — never read it from Context
  • Call $shopIds = $this->getShopIdsByConstraint($shopConstraint) at the start of every write
  • Iterate $shopIds and apply the write for each shop context
  • Modes: ShopConstraint::allShops(), ShopConstraint::shop($shopId), ShopConstraint::shopGroup($groupId)
  • Single-shop installs still go through this path (returns array with one ID)

4. Sub-resource methods (if applicable)

For entities with has-many sub-resources, two strategies:

Atomic replace (simpler)

  • set{SubResource}s({Domain}Id, array $items) — delete all existing rows, insert new set
  • Wrap in transaction — partial replace corrupts data

Incremental update (cleaner)

  • Compare existing rows with new collection, apply only changes
  • Preferred when sub-resources have their own identity

Rules

Conventions (stateless, no Context, typed exceptions) are in CQRS/CONTEXT.md. Skill-specific reminders:

  • Never use Db::getInstance() — use Doctrine DBAL or ObjectModel methods
  • Never hard-code Context::getContext()->shop->id — receive shop as parameter
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall