PHP Magento\Component\QueryLanguage\Expression\Transformer Configuration::make Examples

Example #1

File: FilterTransformerTest.php Project: skolodyazhnyy/query-language

 protected function setUp()
 {
     $this->transformer = FilterTransformerBuilder::make()->build();
     $this->config = Configuration::make()->setNameResolver(new CallbackNameResolver(function ($name) {
         return "[{$name}]";
     }));
     $this->data = ['john' => ['name' => 'John', 'age' => 11, 'email' => null], 'jane' => ['name' => 'Jane', 'age' => 21, 'email' => '*****@*****.**'], 'joey' => ['name' => 'Joey', 'age' => 31, 'email' => '']];
 }

Example #2

File: SQLTransformerDoctrineTest.php Project: skolodyazhnyy/query-language

 public function find(Expression $expression)
 {
     $config = Configuration::make()->setNameResolver(new PrefixedNameResolver('person.'));
     $clause = $this->transformer->transform($expression, $config);
     $people = $this->manager->createQueryBuilder()->select('person')->from(Person::class, 'person')->where($clause->getWhere())->setParameters($clause->getParameters())->getQuery()->getResult();
     return array_map(function (Person $r) {
         return $r->getId();
     }, $people);
 }

Example #3

File: pdo-simple-query.php Project: skolodyazhnyy/query-language

<?php

require __DIR__ . '/../vendor/autoload.php';
use Magento\Component\QueryLanguage\Expression\Transformer\Configuration;
use Magento\Component\QueryLanguage\Expression\Transformer\SQLTransformerBuilder;
use Magento\Component\QueryLanguage\Expression\Where;
// Build or hydrate query
$query = Where::all([Where::field('name')->contains('Snow'), Where::field('age')->between(25, 30)]);
// Initiate database connection
$pdo = new \PDO('sqlite::memory:');
// Load sample data
array_map([$pdo, 'exec'], ['CREATE TABLE people (id INT, name VARCHAR(10), age INT);', 'INSERT INTO people VALUES(1, "John Snow", 30);', 'INSERT INTO people VALUES(2, "Ramsay Snow", 31);']);
// Create transformer
$transformer = SQLTransformerBuilder::make()->build();
// Transform query into SQL clause
$clause = $transformer->transform($query, Configuration::make());
// Execute query
$stmt = $pdo->prepare('SELECT * FROM people WHERE ' . $clause->getWhere());
$stmt->execute($clause->getParameters());
// Fetch results
$people = $stmt->fetchAll(PDO::FETCH_ASSOC);
var_dump($people);

Example #4

File: php-array-simple-query.php Project: skolodyazhnyy/query-language

<?php

require __DIR__ . '/../vendor/autoload.php';
use Magento\Component\QueryLanguage\Expression\Transformer\Configuration;
use Magento\Component\QueryLanguage\Expression\Transformer\Field\CallbackNameResolver;
use Magento\Component\QueryLanguage\Expression\Transformer\FilterTransformerBuilder;
use Magento\Component\QueryLanguage\Expression\Where;
// Build or hydrate query
$query = Where::all([Where::field('name')->contains('Snow'), Where::field('age')->between(25, 30)]);
// Sample data array
$data = [['id' => 1, 'name' => 'John Snow', 'age' => 30], ['id' => 2, 'name' => 'Ramsay Snow', 'age' => 31]];
// Setup transformer
$config = Configuration::make()->setNameResolver(new CallbackNameResolver(function ($name) {
    return '[' . $name . ']';
}));
// Create transformer
$transformer = FilterTransformerBuilder::make()->build();
// Transform query into filter callable
$filter = $transformer->transform($query, $config);
// Apply filter to initial set of data
$people = array_filter($data, $filter);
var_dump($people);

Example #5

File: doctrine-simple-query.php Project: skolodyazhnyy/query-language

<?php

require __DIR__ . '/../vendor/autoload.php';
use Doctrine\ORM\EntityManager;
use Doctrine\ORM\Tools\SchemaTool;
use Doctrine\ORM\Tools\Setup;
use Magento\Component\QueryLanguage\Expression\Transformer\Configuration;
use Magento\Component\QueryLanguage\Expression\Transformer\Field\MapNameResolver;
use Magento\Component\QueryLanguage\Expression\Transformer\SQLTransformerBuilder;
use Magento\Component\QueryLanguage\Expression\Where;
use Magento\Component\QueryLanguageTests\Entity\Person;
// Build or hydrate query
$query = Where::all([Where::field('name')->contains('Snow'), Where::field('age')->between(25, 30)]);
// Setup doctrine
$config = Setup::createAnnotationMetadataConfiguration([__DIR__ . '/../tests/Entity/'], true, null, null, false);
$manager = EntityManager::create(['driver' => 'pdo_sqlite', 'memory' => true], $config);
(new SchemaTool($manager))->createSchema($manager->getMetadataFactory()->getAllMetadata());
// Add sample data
$manager->persist(new Person(1, 'John Snow', 30));
$manager->persist(new Person(2, 'Ramsay Snow', 31));
$manager->flush();
$manager->clear();
// Setup transformer
$config = Configuration::make()->setNameResolver(new MapNameResolver(['name' => 'person.name', 'age' => 'person.age']));
// Create transformer
$clause = SQLTransformerBuilder::make()->build()->transform($query, $config);
// Build DQL query
$people = $manager->createQueryBuilder()->select('person')->from(Person::class, 'person')->where($clause->getWhere())->setParameters($clause->getParameters())->getQuery()->getResult();
var_dump($people);

Example #6

File: SQLTransformerTest.php Project: skolodyazhnyy/query-language

 protected function setUp()
 {
     $this->config = Configuration::make()->setNameResolver(new PrefixedNameResolver('phpunit.'))->setPlaceholderStyle(DefaultValueTransformer::STYLE_POSITION);
     $this->transformer = SQLTransformerBuilder::make()->build();
 }

Example #7

File: SQLTransformerPDOTest.php Project: skolodyazhnyy/query-language

 public function testUnsupportedExpressionException()
 {
     $this->expectException(\InvalidArgumentException::class);
     $this->transformer->transform($this->createMock(Expression::class), Configuration::make());
 }