sqliteTransaction.php

Go to the documentation of this file.

<?php

/**
 * SQLite transaction class
 *
 * @package objSQL
 * @version 2.1.0
 * @author MT Jordan <mtjo62@gmail.com>
 * @link http://objsql.sourceforge.net
 * @copyright 2004-2010 openSource Partners
 * @license LGPL
 * @revision $Id: sqliteTransaction.php,v 1.4 2008-01-17 20:55:23-05 mt_jordan Exp $
 */

class sqliteTransaction
{
    /**********************************************
     * Internal variables
     *********************************************/

    /**
     * Database connection object
     *
     * @access private
     * @var    mixed
     */
    private $objConnection;

    /**********************************************
     * Class methods
     *********************************************/
    /**
     * Constructor
     *
     * @access public
     * @param  mixed $connection
     */
    public function __construct( $connection )
    {
        $this->objConnection = $connection;

        //turn off autocommit
        sqlite_query( $this->objConnection, 'BEGIN' )
        or trigger_error( sqlite_error_string( sqlite_last_error( $this->objConnection ) ), E_USER_WARNING );
    }

    /**
     * Commit transaction
     *
     * @access public
     * @return mixed
     */
    public function commit()
    {
        return sqlite_query( $this->objConnection, 'COMMIT' )
        or trigger_error( sqlite_error_string( sqlite_last_error( $this->objConnection ) ), E_USER_WARNING );
    }

    /**
     * Rollback transaction
     *
     * @access public
     * @return mixed
     */
    public function rollback()
    {
        return sqlite_query( $this->objConnection, 'ROLLBACK' )
        or trigger_error( sqlite_error_string( sqlite_last_error( $this->objConnection ) ), E_USER_WARNING );
    }

    /**
     * Create rollback savepoint - dummy method - sqlite 2 does not support savepoints
     *
     * @access public
     */
    public function savepoint() {}
}

?>