CI_DB_driver::trans_complete PHP Method

trans_complete() public method

Complete Transaction
public trans_complete ( ) : boolean
return boolean
    public function trans_complete()
    {
        if (!$this->trans_enabled) {
            return FALSE;
        }
        // The query() function will set this flag to FALSE in the event that a query failed
        if ($this->_trans_status === FALSE or $this->_trans_failure === TRUE) {
            $this->trans_rollback();
            // If we are NOT running in strict mode, we will reset
            // the _trans_status flag so that subsequent groups of
            // transactions will be permitted.
            if ($this->trans_strict === FALSE) {
                $this->_trans_status = TRUE;
            }
            log_message('debug', 'DB Transaction Failure');
            return FALSE;
        }
        return $this->trans_commit();
    }

Usage Example

Example #1
0
 public static function closures(\CI_DB_driver $db)
 {
     $_ = array();
     $lastquery = '';
     $_['__tostring'] = function () use($db, &$lastquery) {
         $errmsg = $db->_error_message();
         $error = $errmsg ? $db->_error_number() . ': ' . $errmsg : '';
         $res = '(Gaia\\DB\\CI object - ' . "\n" . '  [driver] => ' . $db->dbdriver . "\n" . '  [connection] => ' . $db->hostname . "\n" . '  [error] => ' . $error . "\n" . '  [lastquery] => ' . $lastquery . "\n" . ')';
         return $res;
     };
     $_['prep_args'] = $format_args = function ($query, array $args) use($db, &$lastquery) {
         if (!$args || count($args) < 1) {
             return $query;
         }
         return \Gaia\DB\Query::prepare($query, $args, function ($v) use($db) {
             return "'" . $db->escape_str($v) . "'";
         });
     };
     $_['execute'] = function ($query) use($db, &$lastquery) {
         $lastquery = $query;
         if (strlen($lastquery) > 500) {
             $lastquery = substr($lastquery, 0, 485) . ' ...[trucated]';
         }
         try {
             $res = $db->query($query);
             if (!$res) {
                 return FALSE;
             }
             $_ = array();
             if (is_object($res)) {
                 $_['fetch'] = function () use($res) {
                     return $res->_fetch_assoc();
                 };
                 $_['free'] = function () use($res) {
                     $res->free_result();
                 };
             }
             $_['affected'] = $db->affected_rows();
             if (preg_match('#^insert#i', $query)) {
                 $_['insertid'] = $db->insert_id();
             }
             return new Result($_);
         } catch (Exception $e) {
             return FALSE;
         }
     };
     $_['start'] = function ($auth = NULL) use($db) {
         if ($db instanceof Iface) {
             return $db->start($auth);
         }
         $db->trans_start();
         return TRUE;
     };
     $_['commit'] = function ($auth = NULL) use($db) {
         if ($db instanceof Iface) {
             return $db->commit($auth);
         }
         $db->trans_complete();
         return TRUE;
     };
     $_['rollback'] = function ($auth = NULL) use($db) {
         if ($db instanceof Iface) {
             return $db->rollback($auth);
         }
         $db->trans_rollback($auth);
         return TRUE;
     };
     $_['error'] = function () use($db) {
         return $db->_error_message();
     };
     $_['errorcode'] = function () use($db) {
         return $db->_error_number();
     };
     $_['isa'] = function ($name) use($db) {
         if ($db instanceof $name) {
             return TRUE;
         }
         if ($db->dbdriver == $name) {
             return TRUE;
         }
         return FALSE;
     };
     $_['hash'] = function () use($db) {
         if ($db instanceof Iface) {
             return $db->hash();
         }
         return spl_object_hash($db);
     };
     return $_;
 }