/** * @expectedException \Propel\Runtime\Exception\PropelException */ public function testMergeWithAliasesThrowsException() { $c1 = new Criteria(); $c1->addAlias('b', BookPeer::TABLE_NAME); $c2 = new Criteria(); $c2->addAlias('b', AuthorPeer::TABLE_NAME); $c1->mergeWith($c2); }
public function testDoDeleteTableAlias() { $con = Propel::getServiceContainer()->getWriteConnection(BookPeer::DATABASE_NAME); $c = new Criteria(BookPeer::DATABASE_NAME); $c->addAlias('b', BookPeer::TABLE_NAME); $c->add('b.TITLE', 'War And Peace'); BasePeer::doDelete($c, $con); $expectedSQL = "DELETE b FROM `book` AS b WHERE b.TITLE='War And Peace'"; $this->assertEquals($expectedSQL, $con->getLastExecutedQuery(), 'doDelete() accepts a Criteria with a table alias'); }