public function testFrom() { $q = PropelQuery::from('\\Propel\\Tests\\Bookstore\\Book'); $expected = new BookQuery(); $this->assertEquals($expected, $q, 'from() returns a Model query instance based on the model name'); $q = PropelQuery::from('\\Propel\\Tests\\Bookstore\\Book b'); $expected = new BookQuery(); $expected->setModelAlias('b'); $this->assertEquals($expected, $q, 'from() sets the model alias if found after the blank'); $q = PropelQuery::from('\\Propel\\Tests\\Runtime\\Query\\myBook'); $expected = new myBookQuery(); $this->assertEquals($expected, $q, 'from() can find custom query classes'); try { $q = PropelQuery::from('Foo'); $this->fail('PropelQuery::from() throws an exception when called on a non-existing query class'); } catch (PropelException $e) { $this->assertTrue(true, 'PropelQuery::from() throws an exception when called on a non-existing query class'); } }
public function testQuery() { BookstoreDataPopulator::depopulate(); BookstoreDataPopulator::populate(); $q = new BookQuery(); $book = $q->setModelAlias('b')->where('b.Title like ?', 'Don%')->orderBy('b.ISBN', 'desc')->findOne(); $this->assertTrue($book instanceof Book); $this->assertEquals('Don Juan', $book->getTitle()); }