Doctrine DBAL compilation target for RulerZ
Doctrine DBAL compilation target for RulerZ.
Doctrine DBAL is one of the targets supported by RulerZ.
This cookbook will show you how to retrieve records using Doctrine DBAL and RulerZ.
Here is a summary of what you will have to do:
This subject won't be directly treated here. You can either follow the official documentation or use a bundle/module/whatever the framework you're using promotes.
Once Doctrine DBAL is installed and configured we can the RulerZ engine:
$rulerz = new RulerZ( $compiler, [ new \RulerZ\DoctrineDBAL\Target\DoctrineDBAL(), // this line is Doctrine DBAL-specific // other compilation targets... ] );
The only Doctrine DBAL-related configuration is the
DoctrineDBAL target being added to the list
of the known compilation targets.
Now that both the DBAL and RulerZ are ready, you can use them to retrieve data.
DoctrineDBAL instance that we previously injected into the RulerZ engine
only knows how to use
Doctrine\DBAL\Query\QueryBuilder so the first step
is to create one and configure it:
$connection = DriverManager::getConnection([/** connection parameters */]); $queryBuilder = $connection->createQueryBuilder(); $queryBuilder ->select('pseudo', 'gender', 'points') ->from('players');
And as usual, we call RulerZ with our target (the
QueryBuilder object) and our rule.
RulerZ will build the right executor for the given target and use it to filter
the data, or in our case to retrieve data from a database.
$rule = 'gender = :gender and points > :points'; $parameters = [ 'points' => 30, 'gender' => 'M', ]; var_dump( iterator_to_array($rulerz->filter($queryBuilder, $rule, $parameters)) );
This library is under the MIT license.