PHP Classes

File: tests/eMapper/MySQL/QueryTest.php

Recommend this page to a friend!
  Classes of Emmanuel Antico   eMapper   tests/eMapper/MySQL/QueryTest.php   Download  
File: tests/eMapper/MySQL/QueryTest.php
Role: Unit test script
Content type: text/plain
Description: Unit test script
Class: eMapper
Database abstraction layer that maps data types
Author: By
Last change:
Date: 10 years ago
Size: 2,474 bytes
 

Contents

Class file image Download
<?php
namespace eMapper\MySQL;

use
eMapper\AbstractQueryTest;
use
eMapper\Reflection\Profiler;
use
eMapper\MySQL\MySQLTest;
use
eMapper\Engine\MySQL\MySQLDriver;
use
eMapper\Query\Builder\SelectQueryBuilder;
use
eMapper\Query\Attr;

/**
 * MySQL query builder tests
 * @author emaphp
 * @group mysql
 * @group query
 */
class QueryTest extends AbstractQueryTest {
    public function
build() {
       
$config = MySQLTest::$config;
       
$this->driver = new MySQLDriver($config['database'], $config['host'], $config['user'], $config['password']);
       
$this->profile = Profiler::getClassProfile('Acme\Entity\Product');
    }
   
   
//SELECT regex
   
public function testRegex() {
       
$query = new SelectQueryBuilder($this->profile);
       
$query->setCondition(Attr::code()->matches('^(An?|The) +'));
        list(
$query, $args) = $query->build($this->driver, []);
       
$this->assertRegExpMatch("/SELECT \* FROM @@products WHERE product_code REGEXP BINARY #\{([\w]+)\}/", $query, $matches);
       
$index = $matches[1];
       
$this->assertArrayHasKey($index, $args);
       
$this->assertEquals('^(An?|The) +', $args[$index]);
    }
   
    public function
testNotRegex() {
       
$query = new SelectQueryBuilder($this->profile);
       
$query->setCondition(Attr::code()->matches('^(An?|The) +', false));
        list(
$query, $args) = $query->build($this->driver, []);
       
$this->assertRegExpMatch("/SELECT \* FROM @@products WHERE product_code NOT REGEXP BINARY #\{([\w]+)\}/", $query, $matches);
       
$index = $matches[1];
       
$this->assertArrayHasKey($index, $args);
       
$this->assertEquals('^(An?|The) +', $args[$index]);
    }
   
   
//SELECT iregex
   
public function testIRegex() {
       
$query = new SelectQueryBuilder($this->profile);
       
$query->setCondition(Attr::code()->imatches('^(an?|the) +'));
        list(
$query, $args) = $query->build($this->driver, []);
       
$this->assertRegExpMatch("/SELECT \* FROM @@products WHERE product_code REGEXP #\{([\w]+)\}/", $query, $matches);
       
$index = $matches[1];
       
$this->assertArrayHasKey($index, $args);
       
$this->assertEquals('^(an?|the) +', $args[$index]);
    }
   
    public function
testNotIRegex() {
       
$query = new SelectQueryBuilder($this->profile);
       
$query->setCondition(Attr::code()->imatches('^(an?|the) +', false));
        list(
$query, $args) = $query->build($this->driver, []);
       
$this->assertRegExpMatch("/SELECT \* FROM @@products WHERE product_code NOT REGEXP #\{([\w]+)\}/", $query, $matches);
       
$index = $matches[1];
       
$this->assertArrayHasKey($index, $args);
       
$this->assertEquals('^(an?|the) +', $args[$index]);
    }
}
?>