FuelPHP Forums

I use MySQL and 90% of the time InnoDB where transactional or row level locking tables is required for mission critical apps. I noticed that Fuel does not have transactional support at this time, so I wanted to contribute the code (Database_Transactional). It is not complete yet, but it is functional. The source can be found at https://github.com/five07/Fuel-Addons. This class does require either my latest MySQLi driver (https://github.com/five07/Fuel-Addons/tree/master/Database_MySQLi) or you can adapt a the Fuel MySQL database driver to add the transactional requirements. It is fairly easy to do. Installation: I installed my version at the app level and make sure that if you do not add it to fuel/core/classes, you add it in your app/bootstrap.php

Fuel\Core\Autoloader::add_classes(array(
 // Add classes you want to override here
 'Fuel\\Core\\Database_Mysqli'     => APPPATH.'classes/core/database/mysqli.php',
 'Fuel\\Core\\Database_MySQLi_Result' => APPPATH.'classes/core/database/mysqli/result.php',
 'Fuel\\Core\\Database_Transaction'  => APPPATH.'classes/core/database/transaction.php',
));

Usage: This wraps all of your dependent queries in a transaction, and on complete(), it will either commit or rollback automatically. The status() method returns true if the queries were successful, false on errors.

$trans = Database_Transaction::instance();

$trans->start();
DB::insert('some_table')->set(array('column_name' => 'value'))->execute();
DB::insert('some_other_table')->set(array('column_name' => 'value'))->execute();
DB::insert('yet_another_table')->set(array('column_name' => 'value'))->execute();
$trans->complete();

if ($trans->status() !== true) {
 // Handle your errors...
 Debug::dump($trans->errors());
}

Fuel Team, once it is robust enough, feel free to add or adapt it into the core. I namespaced the class \Fuel\Core, so if it does get added, this will make upgrading easier for those already using it. If you would prefer that I do not use the Fuel namespace for addons that I wish to contribute to Fuel core functionality, please let me know. Michael