Solo Repository

🧩
Explicit mapping
Map an existing table to ordinary PHP objects. Values are converted before your hydrator runs; partial reads return typed rows.
🔎
Reusable queries
Branch independent ReadQuery settings for locale, visibility, and includes. Group criteria with Filter, select related owners with EXISTS, search with LIKE patterns that escape the same way on every database, and read pages that keep tied rows in place and count only when they must.
✍️
Explicit writes
CRUD returns affected rows or a requested ID. Atomic bulk inserts and pivot writes join the application's transactions.
🌐
Consistent translations
Per-field fallback uses the same value in SELECT, WHERE, and ORDER BY. Translation editing has a separate PATCH upsert API.
🔗
Batch relations
Load four relation types and nested paths in batches. Assign related objects to mutable or immutable models without lazy proxies.
🛠️
SQL when you need it
Use the application's Connection for aggregates, custom SQL, and locks; take transaction boundaries through TransactionManager or DBAL. Schema and migrations remain explicit.

Map, write, and read

The application owns its schema and supplies $db, a DBAL Connection. For an existing products table with a generated integer id, sku, and decimal price:

php

use Doctrine\DBAL\Types\Types;
use Solo\Repository\Mapping;
use Solo\Repository\PageRequest;
use Solo\Repository\Repository;

/** @var Repository<stdClass> $products */
$products = new Repository($db, new Mapping(
    table: 'products',
    columns: ['id' => Types::INTEGER, 'sku' => Types::STRING, 'price' => Types::DECIMAL],
    hydrate: static fn(array $row): stdClass => (object) $row,
));

$id = $products->insertGetId(['sku' => 'CHAIR', 'price' => '49.90']);
$products->update($id, ['price' => '59.90']);
$product = $products->read()->find($id);

$page = $products->read()->page(
    new PageRequest(page: 1, perPage: 20, orderBy: ['price' => 'ASC']),
    criteria: ['price >=' => '50.00'],
);

Replace the object cast with your model constructor. Writes do not reread a model automatically; rows() supports projections without hydration. Read the getting-started guide and API reference for translations, relations, visibility, and transaction contracts.

Solo RepositoryYour models. Explicit queries.

Explicit mapping

Reusable queries

Explicit writes

Consistent translations

Batch relations

SQL when you need it

Map, write, and read

Installation

Solo RepositoryYour models. Explicit queries.

Explicit mapping

Reusable queries

Explicit writes

Consistent translations

Batch relations

SQL when you need it

Map, write, and read ​

Installation ​

Map, write, and read

Installation