public function testDoCount() { try { $c = new Criteria(); $c->add(BookPeer::ID, 12, ' BAD SQL'); BookPeer::addSelectColumns($c); BasePeer::doCount($c); } catch (RuntimeException $e) { $this->assertContains('[SELECT COUNT(*) FROM `book` WHERE book.ID BAD SQL:p1]', $e->getMessage(), 'SQL query is written in the exception message'); } }
public function testDoCountDuplicateColumnName() { $con = Propel::getServiceContainer()->getReadConnection(BookPeer::DATABASE_NAME); $c = new Criteria(); $c->addSelectColumn(BookPeer::ID); $c->addJoin(BookPeer::AUTHOR_ID, AuthorPeer::ID); $c->addSelectColumn(AuthorPeer::ID); $c->setLimit(3); try { $count = BasePeer::doCount($c, $con); } catch (Exception $e) { $this->fail('doCount() cannot deal with a criteria selecting duplicate column names '); } }