kohana transaction with orm

Question

is it possible (how) to use mysql transactions and rollbacks using kohana ORM ?

JV- · Answer 1 · 2011-10-07T17:12:22.967

8

SQL Transactions in Kohana 3.x are not done the same way as in 2.x. In 3.x, the database class comes with transaction methods:

$db->begin();
$db->commit();
$db->rollback();

This also works if you are using ORM stuff. Just initiate the transaction before ORM saves, updates, a or deletes.

In 2.x, transactions had to be done manually:

$this->db->query("START TRANSACTION")

edited Oct 07 '11 at 17:12

answered Oct 07 '11 at 16:47

JV-

DB::instance()->begin(), DB::instance()->commit(), DB::instance()->rollback() – Moe Aug 08 '14 at 08:27

score 7 · Answer 2 · answered Oct 10 '09 at 13:28

7

Check out the official forums. It shows an example on how to use transactions with Ko3:

$db->query(NULL, 'TRANSACTION START');  
// Do stuff  
$db->query(NULL, 'COMMIT');

How to do it with version 2, I don't know. I'm still new to kohana myself, and learning Ko3 rather than 2. But I'm guessing it's quite similar.

answered Oct 10 '09 at 13:28

SpadXIII

score 3 · Answer 3 · answered Apr 08 '12 at 16:15

I've created a Kohana module that makes using transactions a lot easier:

It does, however, require at least Kohana 3.1. But then you just add

public $_transactional = true;

to the controller, and all actions are automatically executed inside a transaction, which is rolled back when the action fails with an exception.

3 Answers3