Home | Classes | Modules | Annotated | Hierarchy | Functions | Files

ConnectionCommon.php

Go to the documentation of this file.

<?php
/*
 *  $Id: ConnectionCommon.php,v 1.2 2004/03/20 04:16:49 hlellelid Exp $
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * This software consists of voluntary contributions made by many individuals
 * and is licensed under the LGPL. For more information please see
 * <http://creole.phpdb.org>.
 */

abstract class ConnectionCommon {

    // Constants that define transaction isolation levels.
    // [We don't have any code using these yet, so there's no need
    // to initialize these values at this point.]
    // const TRANSACTION_NONE = 0;
    // const TRANSACTION_READ_UNCOMMITTED = 1;
    // const TRANSACTION_READ_COMMITTED = 2;
    // const TRANSACTION_REPEATABLE_READ = 3;
    // const TRANSACTION_SERIALIZABLE = 4;
    
    protected $transactionOpcount = 0;
    
    protected $autocommit = true;
    
    protected $dblink;
    
    protected $dsn;

    protected $flags = 0;
        
    public function __sleep()
    {
        return array('dsn', 'flags');
    }
    
    public function __wakeup() 
    {
        $this->connect($this->dsn, $this->flags);
    }
    
    public function getResource()
    {
        return $this->dblink;
    }
    
    public function getDSN() {
        return $this->dsn;
    }
       
    public function getFlags()
    {
        return $this->flags;
    }    

    public function prepareCall($sql) 
    {
        throw new SQLException("Current driver does not support stored procedures using CallableStatement.");
    }    

    public function applyLimit(&$sql, $offset, $limit)
    {
        $sql .= " LIMIT ".$limit." OFFSET ".$offset;
    }
    
    public function getAutoCommit()
    {
        return $this->autocommit;
    }
    
    public function setAutoCommit($bit)
    {        
        $this->autocommit = (boolean) $bit;
        if ($this->transactionOpcount > 0) {
            trigger_error("Changing autocommit in mid-transaction; committing " . $this->transactionOpcount . " uncommitted statements.", E_USER_WARNING);
        }
        if ($bit && $this->transactionOpcount > 0) {
            $this->commit();
        }
    }

}

---

This file is part of the Creole[php5] library.