Transactions with Doctrine

If you’re going to make multiple related updates to your database, you should use a transaction. Here’s how to do a transaction with Doctrine. This is essentially lifted from the official Doctrine documentation but it’s a little more to-the-point than theirs. Plus my version doesn’t fail silently.

<?php
$conn = Doctrine_Manager::connection();
 
try
{
  $conn->beginTransaction();
 
  $myObject->save();
  $myOtherObject->save();
 
  $conn->commit();
}
catch(Exception $e)
{
  $conn->rollback();
  throw new Exception($e->getMessage());
}

This entry was posted on Friday, September 3rd, 2010 at 10:28 am and is filed under Databases, Doctrine ORM, symfony. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

7 Responses to “Transactions with Doctrine”

  1. Christopher Shennan says:
    October 6, 2010 at 10:31 am

    Nice, quick, easy and no fuss. Just what I was looking for.

    I’ve written transactions in the past but forgotten where so this was extremely helpful.

    Many Thanks.

    Chris.

  2. jason says:
    October 7, 2010 at 2:28 pm

    Thanks, Chris. Glad you found it helpful.

  3. Chippie says:
    February 3, 2011 at 12:43 am

    You seem to be throwing an Exception and *then* trying to rollback. That’s never going to work ;)

  4. jason says:
    February 3, 2011 at 8:09 am

    I think you’re right, Chippie. I changed my example. Thanks for pointing that out.

  5. Rénald Casagraude says:
    May 9, 2011 at 2:54 pm

    Isn’t preferable to put the beginTransaction outside the try/catch ?

  6. jason says:
    May 9, 2011 at 2:57 pm

    Maybe. Why do you think it would be? To me it seems like it would probably be better to have absolutely everything inside of the try. That way, if any part fails, the whole thing fails.

  7. Rénald Casagraude says:
    May 10, 2011 at 9:17 am

    Well, you’re right. I had in mind a case where the transaction don’t start, and then, a rollback will throw something like “No transaction started”.