Ting - rules system to build query

Still in progress. You SHOULD NOT use this package until release 1.0.

Build a rule

Basic rule

<?php

namespace AppBundle\Domain\Feed\Rules;

use Aura\SqlQuery\Common\Select;
use Blackprism\TingRules\AbstractRule;
use CCMBenchmark\Ting\Repository\Metadata;

class IsEnabled extends AbstractRule
{
    public function getRule()
    {
        return "feed.enabled = '1'";
    }

    public function getParameters()
    {
        return [];
    }

    public function applyQueryRule(
        Select $queryBuilder,
        Metadata $metadata,
        $rule,
        array $parameters = []
    ) {
        return $queryBuilder
            ->where($rule)
            ->bindValues($parameters);
    }
}

Use your rule

<?php
$rulesApplier = new RulesApplier($feedRepository);
$rulesApplier->rule(new IsEnabled());
$feeds = $rulesApplier->apply();

Advanced rule

<?php

namespace AppBundle\Domain\Feed\Rules;

use Aura\SqlQuery\Common\Select;
use CCMBenchmark\Ting\Repository\HydratorAggregator;
use CCMBenchmark\Ting\Repository\HydratorInterface;
use Blackprism\TingRules\AbstractRule;
use CCMBenchmark\Ting\Repository\Metadata;

class WithArticle extends AbstractRule
{
    public function getRule()
    {
        return '';
    }

    public function getParameters()
    {
        return [];
    }

    public function applyQueryRule(
        Select $queryBuilder,
        Metadata $metadata,
        $rule,
        array $parameters = []
    ) {
        return $queryBuilder
            ->cols(['*'])
            ->leftJoin('article', 'feed.id = article.feed_id');
    }

    public function applyHydratorRule(HydratorInterface $hydrator)
    {
        if ($hydrator instanceof HydratorAggregator === false) {
            throw new \RuntimeException(
                "Can't apply " . self::class . " rule because Hydrator is not instance of HydratorAggregator"
            );
        }

        /** @var HydratorAggregator $hydrator */
        $hydrator->callableIdIs(function ($result) {
            return $result['feed']->getId();
        });

        $hydrator->callableDataIs(function ($result) {
            return $result['article'];
        });

        $hydrator->callableFinalizeAggregate(function ($result, $articles) {
            $result['feed']->setArticles($articles);
            return $result['feed'];
        });

        return $hydrator;
    }
}

Even with advanced rule it's still easy to use

<?php
$rulesApplier = new RulesApplier($feedRepository);
$rulesApplier->rule(new WithArticle());
$feeds = $rulesApplier->apply();