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(); }