本文整理匯總了PHP中Propel\Runtime\ActiveQuery\ModelCriteria::useQuery方法的典型用法代碼示例。如果您正苦於以下問題：PHP ModelCriteria::useQuery方法的具體用法？PHP ModelCriteria::useQuery怎麽用？PHP ModelCriteria::useQuery使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Propel\Runtime\ActiveQuery\ModelCriteria的用法示例。
在下文中一共展示了ModelCriteria::useQuery方法的3個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: testSelectAllWithColumn
public function testSelectAllWithColumn()
{
BookstoreDataPopulator::depopulate($this->con);
BookstoreDataPopulator::populate($this->con);
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
$c->join('Propel\\Tests\\Bookstore\\Book.Author');
$c->useQuery('Author')->withColumn('Propel\\Tests\\Bookstore\\Author.LastName', 'authorLastName')->endUse();
$rows = $c->find($this->con);
$expectedSQL = $this->getSql('SELECT book.id, book.title, book.isbn, book.price, book.publisher_id, book.author_id, author.last_name AS authorLastName FROM book INNER JOIN author ON (book.author_id=author.id)');
$this->assertEquals($expectedSQL, $this->con->getLastExecutedQuery(), 'Rest of table after column added with withColumn() is not properly loaded');
}示例2: testUseQueryCustomRelationPhpNameAndAlias
public function testUseQueryCustomRelationPhpNameAndAlias()
{
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\BookstoreContest');
$c->leftJoin('Propel\\Tests\\Bookstore\\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('w' => 'book'), $c2->getAliases(), 'useQuery() sets the secondary Criteria alias correctly');
$c2->where('w.Title = ?', 'War And Peace');
$c = $c2->endUse();
$this->assertEquals('Propel\\Tests\\Bookstore\\BookstoreContest', $c->getModelName(), 'endUse() returns the Primary Criteria');
$con = Propel::getServiceContainer()->getConnection(BookTableMap::DATABASE_NAME);
$c->find($con);
$expectedSQL = $this->getSql("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');
}示例3: testUseQueryCustomRelationPhpNameAndAlias
public function testUseQueryCustomRelationPhpNameAndAlias()
{
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\BookstoreContest');
$c->leftJoin('Propel\\Tests\\Bookstore\\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('w' => 'book'), $c2->getAliases(), 'useQuery() sets the secondary Criteria alias correctly');
$c2->where('w.Title = ?', 'War And Peace');
$c = $c2->endUse();
$this->assertEquals('Propel\\Tests\\Bookstore\\BookstoreContest', $c->getModelName(), 'endUse() returns the Primary Criteria');
$con = Propel::getServiceContainer()->getConnection(BookTableMap::DATABASE_NAME);
$c->find($con);
if (in_array($this->getDriver(), array('mysql'))) {
$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'";
} else {
$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');
}