Ejemplos de TestableBookQuery en PHP

Ejemplo n.º 1

Archivo: SubQueryTest.php Proyecto: shelsonjava/datawrapper

 public function testSubQueryWithSelectColumns()
 {
     $subCriteria = new BookQuery();
     $c = new TestableBookQuery();
     $c->addSelectQuery($subCriteria, 'alias1', false);
     $c->select(array('alias1.Id'));
     $c->configureSelectColumns();
     $sql = "SELECT alias1.ID AS \"alias1.Id\" FROM (SELECT book.ID, book.TITLE, book.ISBN, book.PRICE, book.PUBLISHER_ID, book.AUTHOR_ID FROM `book`) AS alias1";
     $params = array();
     $this->assertCriteriaTranslation($c, $sql, $params, 'addSelectQuery() forges a unique alias and adds select columns by default');
 }

Ejemplo n.º 2

Archivo: SubQueryTest.php Proyecto: kalaspuffar/php-orm-benchmark

 public function testSubQueryWithSelectColumns()
 {
     $subCriteria = new BookQuery();
     $c = new TestableBookQuery();
     $c->addSelectQuery($subCriteria, 'alias1', false);
     $c->select(array('alias1.Id'));
     $c->configureSelectColumns();
     $sql = "SELECT alias1.id AS `alias1.Id` FROM (SELECT book.id, book.title, book.isbn, book.price, book.publisher_id, book.author_id FROM `book`) AS alias1";
     $params = array();
     $this->assertCriteriaTranslation($c, $sql, $params, 'addSelectQuery() forges a unique alias and adds select columns by default');
 }