本文整理匯總了PHP中Propel\Runtime\ActiveQuery\ModelCriteria::leftJoinWith方法的典型用法代碼示例。如果您正苦於以下問題：PHP ModelCriteria::leftJoinWith方法的具體用法？PHP ModelCriteria::leftJoinWith怎麽用？PHP ModelCriteria::leftJoinWith使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Propel\Runtime\ActiveQuery\ModelCriteria的用法示例。
在下文中一共展示了ModelCriteria::leftJoinWith方法的4個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: testFindWithLeftJoinWithManyToOneAndNullObject
public function testFindWithLeftJoinWithManyToOneAndNullObject()
{
if (!$this->runningOnSQLite()) {
$this->markTestSkipped('This test is designed for SQLite as it saves an empty object.');
}
BookTableMap::clearInstancePool();
AuthorTableMap::clearInstancePool();
ReviewTableMap::clearInstancePool();
$review = new Review();
$review->setReviewedBy('Peter');
$review->setRecommended(true);
$review->save($this->con);
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Review');
$c->setFormatter(ModelCriteria::FORMAT_ON_DEMAND);
$c->leftJoinWith('Propel\\Tests\\Bookstore\\Review.Book');
$c->leftJoinWith('Book.Author');
// should not raise a notice
$reviews = $c->find($this->con);
$this->assertTrue(true);
}示例2: testFindOneWithOneToManyThenManyToOneUsingAlias
public function testFindOneWithOneToManyThenManyToOneUsingAlias()
{
BookstoreDataPopulator::populate();
BookTableMap::clearInstancePool();
AuthorTableMap::clearInstancePool();
ReviewTableMap::clearInstancePool();
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Author');
$c->add(AuthorTableMap::COL_LAST_NAME, 'Rowling');
$c->leftJoinWith('Propel\\Tests\\Bookstore\\Author.Book b');
$c->leftJoinWith('b.Review r');
$con = Propel::getServiceContainer()->getConnection(BookTableMap::DATABASE_NAME);
$authors = $c->find($con);
$this->assertEquals(1, count($authors), 'with() does not duplicate the main object');
$rowling = $authors[0];
$count = $con->getQueryCount();
$this->assertEquals($rowling->getFirstName(), 'J.K.', 'Main object is correctly hydrated');
$books = $rowling->getBooks();
$this->assertEquals($count, $con->getQueryCount(), 'with() hydrates the related objects to save a query ');
$this->assertEquals(1, count($books), 'Related objects are correctly hydrated');
$book = $books[0];
$this->assertEquals($book->getTitle(), 'Harry Potter and the Order of the Phoenix', 'Related object is correctly hydrated');
$reviews = $book->getReviews();
$this->assertEquals($count, $con->getQueryCount(), 'with() hydrates the related objects to save a query ');
$this->assertEquals(2, count($reviews), 'Related objects are correctly hydrated');
}示例3: testMergeWithWiths
public function testMergeWithWiths()
{
$c1 = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book', 'b');
$c1->leftJoinWith('b.Author a');
$c2 = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Author');
$c1->mergeWith($c2);
$with = $c1->getWith();
$this->assertEquals(1, count($with), 'mergeWith() does not remove an existing join');
$this->assertEquals('modelName: Propel\\Tests\\Bookstore\\Author, relationName: Author, relationMethod: setAuthor, leftPhpName: , rightPhpName: a', $with['a']->__toString(), 'mergeWith() does not remove an existing join');
$c1 = new ModelCriteria('bookstore', '\\Propel\\Tests\\Bookstore\\Book', 'b');
$c1->leftJoinWith('b.Author a');
$c2 = new ModelCriteria('bookstore', '\\Propel\\Tests\\Bookstore\\Author');
$c1->mergeWith($c2);
$with = $c1->getWith();
$this->assertEquals(1, count($with), 'mergeWith() does not remove an existing join');
$this->assertEquals('modelName: Propel\\Tests\\Bookstore\\Author, relationName: Author, relationMethod: setAuthor, leftPhpName: , rightPhpName: a', $with['a']->__toString(), 'mergeWith() does not remove an existing join');
$c1 = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book', 'b');
$c2 = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book', 'b');
$c2->leftJoinWith('b.Author a');
$c1->mergeWith($c2);
$with = $c1->getWith();
$this->assertEquals(1, count($with), 'mergeWith() merge joins to an empty join');
$this->assertEquals('modelName: Propel\\Tests\\Bookstore\\Author, relationName: Author, relationMethod: setAuthor, leftPhpName: , rightPhpName: a', $with['a']->__toString(), 'mergeWith() merge joins to an empty join');
$c1 = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book', 'b');
$c1->leftJoinWith('b.Author a');
$c2 = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book', 'b');
$c2->innerJoinWith('b.Publisher p');
$c1->mergeWith($c2);
$with = $c1->getWith();
$this->assertEquals(2, count($with), 'mergeWith() merge joins to an existing join');
$this->assertEquals('modelName: Propel\\Tests\\Bookstore\\Author, relationName: Author, relationMethod: setAuthor, leftPhpName: , rightPhpName: a', $with['a']->__toString(), 'mergeWith() merge joins to an empty join');
$this->assertEquals('modelName: Propel\\Tests\\Bookstore\\Publisher, relationName: Publisher, relationMethod: setPublisher, leftPhpName: , rightPhpName: p', $with['p']->__toString(), 'mergeWith() merge joins to an empty join');
}示例4: testFindWithLeftJoinWithManyToOneAndNullObject
public function testFindWithLeftJoinWithManyToOneAndNullObject()
{
if ('sqlite' !== $this->con->getAttribute(\PDO::ATTR_DRIVER_NAME)) {
$this->markTestSkipped('This test is designed for SQLite as it saves an empty object.');
}
BookTableMap::clearInstancePool();
AuthorTableMap::clearInstancePool();
ReviewTableMap::clearInstancePool();
$review = new Review();
$review->save($this->con);
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Review');
$c->setFormatter(ModelCriteria::FORMAT_ARRAY);
$c->leftJoinWith('Propel\\Tests\\Bookstore\\Review.Book');
$c->leftJoinWith('Book.Author');
// should not raise a notice
$reviews = $c->find($this->con);
$this->assertTrue(true);
}