Home | Classes | Modules | Annotated | Functions | Files

ConnectionCommon.php

Go to the documentation of this file.

<?php
/*
 *  $Id: ConnectionCommon.php,v 1.2 2004/03/29 18:46:46 micha 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>.
 */

//
// STATUS:
// - ported:   y
// - exceptions: y
// - compiled: y
// - tested:   n
//

require_once 'creole/Connection.php';

class ConnectionCommon extends Connection
{

  // 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;

    var $transactionOpcount = 0;

    var $autocommit = true;

  var $dblink;

  var $dsn;

  var $flags = 0;

  function __sleep()
  {
    return array('dsn', 'flags');
  }

  function __wakeup()
  {
    $this->connect($this->dsn, $this->flags);
  }

  function getResource()
  {
    return $this->dblink;
  }

  function getDSN()
  {
    return $this->dsn;
  }

  function getFlags()
  {
    return $this->flags;
  }

  function prepareCall(&$sql)
  {
    return new SQLException(CREOLE_ERROR_UNSUPPORTED, "Current driver does not support stored procedures using CallableStatement.");
  }

  function applyLimit(&$sql, $offset, $limit)
  {
    $sql .= " LIMIT ".$limit." OFFSET ".$offset;
  }

  function getAutoCommit()
  {
    return $this->autocommit;
  }

  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
      );
      return false;
    }

    if ($bit && $this->transactionOpcount > 0) {
      return $this->commit();
    }

    return true;
  }

}

---

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