Esempi in PHP per Propel\Runtime\Query ModelCriteria::addJoin

Esempio n. 1

File: ModelCriteriaTest.php Progetto: rozwell/Propel2

 public function testAddJoin()
 {
     $c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
     $c->addJoin(BookPeer::AUTHOR_ID, AuthorPeer::ID);
     $c->addJoin(BookPeer::PUBLISHER_ID, PublisherPeer::ID);
     $sql = 'SELECT  FROM `book` INNER JOIN `author` ON (book.AUTHOR_ID=author.ID) INNER JOIN `publisher` ON (book.PUBLISHER_ID=publisher.ID)';
     $params = array();
     $this->assertCriteriaTranslation($c, $sql, $params, 'addJoin() works the same as in Criteria');
 }