protected function setUp()
{
$config = Setup::createAnnotationMetadataConfiguration([__DIR__ . '/../Entity/'], true, null, null, false);
$this->manager = EntityManager::create(['driver' => 'pdo_sqlite', 'memory' => true], $config);
(new SchemaTool($this->manager))->createSchema($this->manager->getMetadataFactory()->getAllMetadata());
$this->manager->persist(new Person('john', 'John', 11, null));
$this->manager->persist(new Person('jane', 'Jane', 21, '*****@*****.**'));
$this->manager->persist(new Person('joey', 'Joey', 31, ''));
$this->manager->flush();
$this->manager->clear();
$this->transformer = SQLTransformerBuilder::make()->build();
}
<?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);
<?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);
protected function setUp()
{
$this->config = Configuration::make()->setNameResolver(new PrefixedNameResolver('phpunit.'))->setPlaceholderStyle(DefaultValueTransformer::STYLE_POSITION);
$this->transformer = SQLTransformerBuilder::make()->build();
}
protected function setUp()
{
$this->pdo = new \PDO('sqlite::memory:');
array_map([$this->pdo, 'exec'], ['CREATE TABLE people (id VARCHAR(10), name VARCHAR(10), age INT, email VARCHAR(20));', 'INSERT INTO people VALUES("john", "John", 11, NULL);', 'INSERT INTO people VALUES("jane", "Jane", 21, "*****@*****.**");', 'INSERT INTO people VALUES("joey", "Joey", 31, "");']);
$this->transformer = SQLTransformerBuilder::make()->build();
}
