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');
}
}
}
