public function testFindWithLeftJoinWithOneToManyAndNullObject()
{
BookPeer::clearInstancePool();
AuthorPeer::clearInstancePool();
ReviewPeer::clearInstancePool();
$freud = new Author();
$freud->setFirstName("Sigmund");
$freud->setLastName("Freud");
$freud->save($this->con);
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Author');
$c->setFormatter(ModelCriteria::FORMAT_ARRAY);
$c->add(AuthorPeer::LAST_NAME, 'Freud');
$c->leftJoinWith('Propel\\Tests\\Bookstore\\Author.Book');
$c->leftJoinWith('Book.Review');
// should not raise a notice
$authors = $c->find($this->con);
$this->assertTrue(true);
}
public function testAddUsingAliasTrueAliasTwice()
{
$c1 = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
$c1->setModelAlias('b', true);
$c1->addUsingAlias(BookPeer::TITLE, 'foo');
$c1->addUsingAlias(BookPeer::TITLE, 'bar');
$c2 = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
$c2->setModelAlias('b', true);
$c2->add('b.TITLE', 'foo');
$c2->addAnd('b.TITLE', 'bar');
$this->assertEquals($c2, $c1, 'addUsingalias() translates to addAnd() when the table already has a condition on the column');
}
public function testFindOneWithOneToManyThenManyToOneUsingAlias()
{
BookstoreDataPopulator::populate();
BookPeer::clearInstancePool();
AuthorPeer::clearInstancePool();
ReviewPeer::clearInstancePool();
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Author');
$c->add(AuthorPeer::LAST_NAME, 'Rowling');
$c->leftJoinWith('Propel\\Tests\\Bookstore\\Author.Book b');
$c->leftJoinWith('b.Review r');
$con = Propel::getServiceContainer()->getConnection(BookPeer::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');
}
/**
* @expectedException \Propel\Runtime\Exception\PropelException
*/
public function testFindOneWithOneToMany()
{
BookstoreDataPopulator::populate();
BookPeer::clearInstancePool();
AuthorPeer::clearInstancePool();
ReviewPeer::clearInstancePool();
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
$c->setFormatter(ModelCriteria::FORMAT_ON_DEMAND);
$c->add(BookPeer::ISBN, '043935806X');
$c->leftJoin('Propel\\Tests\\Bookstore\\Book.Review');
$c->with('Review');
$books = $c->find();
}
