README

Lightweight PHP repository pattern with built-in soft delete, eager loading, and rich criteria syntax.

Features

• Soft delete with restore/force delete
• Eager loading (BelongsTo, HasOne, HasMany, BelongsToMany)
• Rich criteria syntax: operators, BETWEEN, OR/AND groups, and correlated EXISTS via relation dot-notation
• Built-in aggregations (count, sum, avg, min, max)
• Translation via withLocale() — auto LEFT JOIN, propagates into relation EXISTS
• Transaction helpers with row locking (SELECT ... FOR UPDATE)
• Auto-detect custom IDs (UUID, prefixed)

Installation

composer require solophp/base-repository

Requirements: PHP 8.3+, Doctrine DBAL ^4.3

Quick Example

class UserRepository extends BaseRepository
{
    protected ?string $deletedAtColumn = 'deleted_at';

    public function __construct(Connection $connection)
    {
        parent::__construct($connection, User::class, 'users');
    }
}

// Usage
$users = $repo->findBy(['status' => 'active'], ['created_at' => 'DESC'], 20, 1);
$repo->delete($id);      // Soft delete
$repo->restore($id);     // Restore

Documentation

📖 Full Documentation

• Installation
• Quick Start
• Criteria Syntax
• Soft Delete
• Eager Loading
• Translations
• API Reference

License

MIT