MainelyDesign.com Blog

Transactional Support in CakePHP

Posted on 04/17/2009 at 11:50 am by Kevin Wentworth
Viewed 14,769 times | 0 comments

I just found out that CakePHP has transactional support built-in.  It should have been obvious, seeing how the saveAll() function has transaction support built-in too.  My first attempt at using it didn't work.  In my contoller/model I was doing the following:

Based on the API and my limited knowledge of inheritance, I figured this would work.  It didn't.  I was a little stumped and was about to write methods in my model that I wanted to use, but decided to make use of app_model.php (great place for anything you will use over your entire application).  After peeking at the source for saveAll, I saw that they were instantiating a $db object and then using it to call the begin(), commit(), and rollback() functions.  It turns out it isn't available at the model level (as of 1.2 final) but you can add it to all your models very easily:

In app_model.php:

That's it.  Now in any model, you can use my code above, that didn't work at first.

Cheers,

-Kevin Wentworth