public function testNestedTransactionForceRollBack()
{
$con = Propel::getConnection(BookPeer::DATABASE_NAME);
$driver = $con->getAttribute(PDO::ATTR_DRIVER_NAME);
// main transaction
$con->beginTransaction();
$a = new Author();
$a->setFirstName('Test');
$a->setLastName('User');
$a->save($con);
$authorId = $a->getId();
// nested transaction
$con->beginTransaction();
$a2 = new Author();
$a2->setFirstName('Test2');
$a2->setLastName('User2');
$a2->save($con);
$authorId2 = $a2->getId();
// force rollback
$con->forceRollback();
$this->assertEquals(0, $con->getNestedTransactionCount(), 'nested transaction is null after nested transaction forced rollback');
$this->assertFalse($con->isInTransaction(), 'PropelPDO is not in transaction after nested transaction force rollback');
AuthorPeer::clearInstancePool();
$at = AuthorPeer::retrieveByPK($authorId);
$this->assertNull($at, "Rolled back transaction is not persisted in database");
$at2 = AuthorPeer::retrieveByPK($authorId2);
$this->assertNull($at2, "Forced Rolled back nested transaction is not persisted in database");
}
public function testObjectInstances()
{
$sample = BookPeer::doSelectOne(new Criteria());
$samplePk = $sample->getPrimaryKey();
// 1) make sure consecutive calls to retrieveByPK() return the same object.
$b1 = BookPeer::retrieveByPK($samplePk);
$b2 = BookPeer::retrieveByPK($samplePk);
$sampleval = md5(microtime());
$this->assertTrue($b1 === $b2, "Expected object instances to match for calls with same retrieveByPK() method signature.");
// 2) make sure that calls to doSelect also return references to the same objects.
$allbooks = BookPeer::doSelect(new Criteria());
foreach ($allbooks as $testb) {
if ($testb->getPrimaryKey() == $b1->getPrimaryKey()) {
$this->assertTrue($testb === $b1, "Expected same object instance from doSelect() as from retrieveByPK()");
}
}
// 3) test fetching related objects
$book = BookPeer::retrieveByPK($samplePk);
$bookauthor = $book->getAuthor();
$author = AuthorPeer::retrieveByPK($bookauthor->getId());
$this->assertTrue($bookauthor === $author, "Expected same object instance when calling fk object accessor as retrieveByPK()");
// 4) test a doSelectJoin()
$morebooks = BookPeer::doSelectJoinAuthor(new Criteria());
for ($i = 0, $j = 0; $j < count($morebooks); $i++, $j++) {
$testb1 = $allbooks[$i];
$testb2 = $allbooks[$j];
$this->assertTrue($testb1 === $testb2, "Expected the same objects from consecutive doSelect() calls.");
// we could probably also test this by just verifying that $book & $testb are the same
if ($testb1->getPrimaryKey() === $book) {
$this->assertTrue($book->getAuthor() === $testb1->getAuthor(), "Expected same author object in calls to pkey-matching books.");
}
}
// 5) test creating a new object, saving it, and then retrieving that object (should all be same instance)
$b = new BookstoreEmployee();
$b->setName("Testing");
$b->setJobTitle("Testing");
$b->save();
$empId = $b->getId();
$this->assertSame($b, BookstoreEmployeePeer::retrieveByPK($empId), "Expected newly saved object to be same instance as pooled.");
}
public function getAuthor($con = null)
{
include_once 'lib/model/om/BaseAuthorPeer.php';
if ($this->aAuthor === null && $this->author_id !== null) {
$this->aAuthor = AuthorPeer::retrieveByPK($this->author_id, $con);
}
return $this->aAuthor;
}
public function testSavingParentSavesRelatedObjectsIncludingNew()
{
$author = AuthorPeer::retrieveByPK($this->author->getId());
// add new object before fetching old books
$b3 = new Book();
$author->addBook($b3);
$c = new Criteria();
$c->add(BookPeer::ID, $this->books[0]->getId());
$books = $author->getBooks($c);
$books[0]->setTitle('Update to a book');
$author->save();
$this->assertEquals(3, $author->countBooks());
$this->assertFalse($b3->isModified());
$this->assertFalse($books[0]->isModified());
}
/**
* @link http://propel.phpdb.org/trac/ticket/699
*/
public function testRollBack_NestedSwallow()
{
$con = Propel::getConnection(BookPeer::DATABASE_NAME);
$driver = $con->getAttribute(PDO::ATTR_DRIVER_NAME);
if ($driver == "mysql") {
$this->markTestSkipped();
}
$con->beginTransaction();
try {
$a = new Author();
$a->setFirstName('Test');
$a->setLastName('User');
$a->save($con);
$authorId = $a->getId();
$this->assertTrue($authorId !== null, "Expected valid new author ID");
$con->beginTransaction();
try {
$con->exec('INVALID SQL');
$this->fail("Expected exception on invalid SQL");
} catch (Exception $x) {
$con->rollBack();
// NO RETHROW
}
$a2 = new Author();
$a2->setFirstName('Test2');
$a2->setLastName('User2');
$authorId2 = $a2->save($con);
$con->commit();
// this should not do anything!
} catch (Exception $x) {
$this->fail("No outside rollback expected.");
}
AuthorPeer::clearInstancePool();
$at = AuthorPeer::retrieveByPK($authorId);
$this->assertNull($at, "Expected no author result for rolled-back save.");
$at2 = AuthorPeer::retrieveByPK($authorId2);
$this->assertNull($at2, "Expected no author2 result for rolled-back save.");
}
public function getAuthor($con = null)
{
if ($this->aAuthor === null && $this->author_id !== null) {
$this->aAuthor = AuthorPeer::retrieveByPK($this->author_id, $con);
}
return $this->aAuthor;
}
