PHP Propel\Runtime\ActiveQuery ModelCriteria::groupByClass示例

示例#1

文件： ModelCriteriaTest.php 项目： dracony/forked-php-orm-benchmark

 public function testGroupByClassJoinedModelWithAlias()
 {
     $c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Author');
     $c->join('Propel\\Tests\\Bookstore\\Author.Book b');
     $c->groupByClass('b');
     $sql = $this->getSql('SELECT  FROM author INNER JOIN book b ON (author.id=b.author_id) GROUP BY b.id,b.title,b.isbn,b.price,b.publisher_id,b.author_id');
     $params = array();
     $this->assertCriteriaTranslation($c, $sql, $params, 'groupByClass() accepts the alias of a joined model');
 }

示例#2

文件： ModelCriteriaTest.php 项目： kalaspuffar/php-orm-benchmark

 public function testGroupByClassJoinedModelWithAlias()
 {
     $c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Author');
     $c->join('Propel\\Tests\\Bookstore\\Author.Book b');
     $c->groupByClass('b');
     $sql = $this->getSql('SELECT  FROM `author` INNER JOIN `book` `b` ON (author.ID=b.AUTHOR_ID) GROUP BY b.ID,b.TITLE,b.ISBN,b.PRICE,b.PUBLISHER_ID,b.AUTHOR_ID');
     $params = array();
     $this->assertCriteriaTranslation($c, $sql, $params, 'groupByClass() accepts the alias of a joined model');
 }