本文整理汇总了PHP中ModelCriteria::useQuery方法的典型用法代码示例。如果您正苦于以下问题:PHP ModelCriteria::useQuery方法的具体用法?PHP ModelCriteria::useQuery怎么用?PHP ModelCriteria::useQuery使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类ModelCriteria
的用法示例。
在下文中一共展示了ModelCriteria::useQuery方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: testUseQueryCustomRelationPhpNameAndAlias
public function testUseQueryCustomRelationPhpNameAndAlias()
{
$c = new ModelCriteria('bookstore', 'BookstoreContest');
$c->leftJoin('BookstoreContest.Work w');
$c2 = $c->useQuery('w');
$this->assertTrue($c2 instanceof BookQuery, 'useQuery() returns a secondary Criteria');
$this->assertEquals($c, $c2->getPrimaryCriteria(), 'useQuery() sets the primary Criteria os the secondary Criteria');
//$this->assertEquals(array('a' => 'author'), $c2->getAliases(), 'useQuery() sets the secondary Criteria alias correctly');
$c2->where('w.Title = ?', 'War And Peace');
$c = $c2->endUse();
$this->assertEquals('BookstoreContest', $c->getModelName(), 'endUse() returns the Primary Criteria');
$con = Propel::getConnection(BookPeer::DATABASE_NAME);
$c->find($con);
$expectedSQL = "SELECT bookstore_contest.BOOKSTORE_ID, bookstore_contest.CONTEST_ID, bookstore_contest.PRIZE_BOOK_ID FROM `bookstore_contest` LEFT JOIN `book` `w` ON (bookstore_contest.PRIZE_BOOK_ID=w.ID) WHERE w.TITLE = 'War And Peace'";
$this->assertEquals($expectedSQL, $con->getLastExecutedQuery(), 'useQuery() and endUse() allow to merge a secondary criteria');
}
示例2: sortI18nColumn
public function sortI18nColumn(\ModelCriteria $query, $colName, $order)
{
$column = $this->columns[$colName]['phpName'];
$i18nTableName = $this->getI18nTableName($this->query->getTableMap());
$query->useQuery($i18nTableName, $i18nTableName . "Query")->{'orderBy' . $column}($order)->endUse();
}