public function testDoInsert() { try { $c = new Criteria(); $c->setPrimaryTableName(BookTableMap::TABLE_NAME); $c->add(BookTableMap::AUTHOR_ID, 'lkhlkhj'); $c->doInsert(Propel::getServiceContainer()->getWriteConnection(BookTableMap::DATABASE_NAME)); $this->fail('Missing expected exception on BAD SQL'); } catch (PropelException $e) { $this->assertContains('[INSERT INTO `book` (`AUTHOR_ID`) VALUES (:p1)]', $e->getMessage(), 'SQL query is written in the exception message'); } }
public function testDoInsert() { $con = Propel::getServiceContainer()->getWriteConnection(BookTableMap::DATABASE_NAME); try { $c = new Criteria(); $c->setPrimaryTableName(BookTableMap::TABLE_NAME); $c->add(BookTableMap::AUTHOR_ID, 'lkhlkhj'); $db = Propel::getServiceContainer()->getAdapter($c->getDbName()); $c->doInsert($con); $this->fail('Missing expected exception on BAD SQL'); } catch (PropelException $e) { if ($db->isGetIdBeforeInsert()) { $this->assertContains($this->getSql('[INSERT INTO book (AUTHOR_ID,ID) VALUES (:p1,:p2)]'), $e->getMessage(), 'SQL query is written in the exception message'); } else { $this->assertContains($this->getSql('[INSERT INTO `book` (`AUTHOR_ID`) VALUES (:p1)]'), $e->getMessage(), 'SQL query is written in the exception message'); } } }