How to start database transaction in Opencart?

I wanted to start a transaction in opencart for a long db operation. Is there any default functions or any extension to do this easily something like below?

// First of all, let's begin a transaction
$db->beginTransaction();
// A set of queries;
$db->query('first query');
$db->query('second query');

//Checking Status
if($db->tarns_status=='true'){
$db->commit();
}else{
$db->rollback();
}

I've never seen it, so you might be better off adding it.

paulfeakins wrote: ↑

Thu Nov 09, 2017 7:04 pm

I've never seen it, so you might be better off adding it.

I have found that MySql Engine for all OC tables is MyISAM. So DB transaction will not work. Is there any problem if I am changing Engine to InnoDB for all tables in OC?