Matching across aggregates

You can match aggregates of some kind based on conditions from another aggregate kind.

For example if you have 2 aggregates User and Movie and you want:

All movies where the director's last name is Blomkamp.

You can write the following code:

use Innmind\Specification\{
    Comparator\Property,
    Sign,
};

$orm
    ->repository(Movie::class)
    ->matching(Property::of(
        'director',
        Sign::in,
        $orm
            ->repository(User::class)
            ->matching(Property::of(
                'lastName',
                Sign::equality,
                'Blomkamp',
            )),
    ))
    ->foreach(static fn($movie) => doSomething($movie));

For this to work the director property must be typed Formal\ORM\Id<User>.

If your storage adapter supports it this is even optimised at the storage level.

Warning

Only SQL is able to optimize this at the storage level.

It still works with Elasticsearch and Filesystem but Formal will fetch the matching ids in memory and use them as input value.