WebSVN – Applications.gtt – Diff – /trunk/bibliotheque/pear/DB/sybase.php

 /**
  * The PEAR DB driver for PHP's sybase extension
  * for interacting with Sybase databases
  *
- * PHP versions 4 and 5
+ * PHP version 5
+ *
  * LICENSE: This source file is subject to version 3.0 of the PHP license
  * that is available through the world-wide-web at the following URI:
  * http://www.php.net/license/3_0.txt.  If you did not receive a copy of
  * @category   Database
  * @package    DB
  * @author     Sterling Hughes <sterling@php.net>
  * @author     Antônio Carlos Venâncio Júnior <floripa@php.net>
  * @author     Daniel Convissor <danielc@php.net>
- * @copyright  1997-2005 The PHP Group
+ * @copyright  1997-2007 The PHP Group
  * @license    http://www.php.net/license/3_0.txt  PHP License 3.0
- * @version    CVS: $Id: sybase.php,v 1.78 2005/02/20 00:44:48 danielc Exp $
+ * @version    CVS: $Id$
  * @link       http://pear.php.net/package/DB
  */
 /**
  * @category   Database
  * @package    DB
  * @author     Sterling Hughes <sterling@php.net>
  * @author     Antônio Carlos Venâncio Júnior <floripa@php.net>
  * @author     Daniel Convissor <danielc@php.net>
- * @copyright  1997-2005 The PHP Group
+ * @copyright  1997-2007 The PHP Group
  * @license    http://www.php.net/license/3_0.txt  PHP License 3.0
- * @version    Release: 1.7.6
+ * @version    Release: 1.9.2
  * @link       http://pear.php.net/package/DB
  */
 class DB_sybase extends DB_common
+{
     // {{{ properties
     // }}}
     // {{{ constructor
     /**
-     * This constructor calls <kbd>$this->DB_common()</kbd>
+     * This constructor calls <kbd>parent::__construct()</kbd>
+     *
      * @return void
      */
-    function DB_sybase()
+    function __construct()
+    {
-        $this->DB_common();
+        parent::__construct();
+    }
      *                + the DB_OK constant for other successful queries
      *                + a DB_Error object on failure
      */
     function simpleQuery($query)
+    {
-        $ismanip = DB::isManip($query);
+        $ismanip = $this->_checkManip($query);
         $this->last_query = $query;
-        if (!@sybase_select_db($this->_db, $this->connection)) {
+        if ($this->_db && !@sybase_select_db($this->_db, $this->connection)) {
             return $this->sybaseRaiseError(DB_ERROR_NODBSELECTED);
+        }
         $query = $this->modifyQuery($query);
         if (!$this->autocommit && $ismanip) {
             if ($this->transaction_opcount == 0) {
+     *
      * @see DB_result::free()
      */
     function freeResult($result)
+    {
-        return @sybase_free_result($result);
+        return is_resource($result) ? sybase_free_result($result) : false;
+    }
     // }}}
+     *
      * @return int  the number of rows.  A DB_Error object on failure.
      */
     function affectedRows()
+    {
-        if (DB::isManip($this->last_query)) {
+        if ($this->_last_query_manip) {
             $result = @sybase_affected_rows($this->connection);
         } else {
             $result = 0;
+        }
         return $result;
      *      DB_sybase::createSequence(), DB_sybase::dropSequence()
      */
     function nextId($seq_name, $ondemand = true)
+    {
         $seqname = $this->getSequenceName($seq_name);
-        if (!@sybase_select_db($this->_db, $this->connection)) {
+        if ($this->_db && !@sybase_select_db($this->_db, $this->connection)) {
             return $this->sybaseRaiseError(DB_ERROR_NODBSELECTED);
+        }
         $repeat = 0;
         do {
             $this->pushErrorHandling(PEAR_ERROR_RETURN);
                 $result = $this->createSequence($seq_name);
                 if (DB::isError($result)) {
                     return $this->raiseError($result);
+                }
             } elseif (!DB::isError($result)) {
-                $result =& $this->query("SELECT @@IDENTITY FROM $seqname");
+                $result = $this->query("SELECT @@IDENTITY FROM $seqname");
                 $repeat = 0;
             } else {
                 $repeat = false;
+            }
         } while ($repeat);
+    {
         return $this->query('DROP TABLE ' . $this->getSequenceName($seq_name));
+    }
+    // }}}
+    // {{{ quoteFloat()
+    /**
+     * Formats a float value for use within a query in a locale-independent
+     * manner.
+     *
+     * @param float the float value to be quoted.
+     * @return string the quoted string.
+     * @see DB_common::quoteSmart()
+     * @since Method available since release 1.7.8.
+     */
+    function quoteFloat($float) {
+        return $this->escapeSimple(str_replace(',', '.', strval(floatval($float))));
+    }
     // }}}
     // {{{ autoCommit()
     /**
      * @return int  DB_OK on success.  A DB_Error object on failure.
      */
     function commit()
+    {
         if ($this->transaction_opcount > 0) {
-            if (!@sybase_select_db($this->_db, $this->connection)) {
+            if ($this->_db && !@sybase_select_db($this->_db, $this->connection)) {
                 return $this->sybaseRaiseError(DB_ERROR_NODBSELECTED);
+            }
             $result = @sybase_query('COMMIT', $this->connection);
             $this->transaction_opcount = 0;
             if (!$result) {
      * @return int  DB_OK on success.  A DB_Error object on failure.
      */
     function rollback()
+    {
         if ($this->transaction_opcount > 0) {
-            if (!@sybase_select_db($this->_db, $this->connection)) {
+            if ($this->_db && !@sybase_select_db($this->_db, $this->connection)) {
                 return $this->sybaseRaiseError(DB_ERROR_NODBSELECTED);
+            }
             $result = @sybase_query('ROLLBACK', $this->connection);
             $this->transaction_opcount = 0;
             if (!$result) {
      * @return integer  an error number from a DB error constant
      */
     function errorCode($errormsg)
+    {
         static $error_regexps;
+        // PHP 5.2+ prepends the function name to $php_errormsg, so we need
+        // this hack to work around it, per bug #9599.
+        $errormsg = preg_replace('/^sybase[a-z_]+\(\): /', '', $errormsg);
         if (!isset($error_regexps)) {
             $error_regexps = array(
                 '/Incorrect syntax near/'
                     => DB_ERROR_SYNTAX,
                 '/^Unclosed quote before the character string [\"\'].*[\"\']\./'
                     => DB_ERROR_NOT_FOUND,
                 '/^There is already an index/i'
                     => DB_ERROR_ALREADY_EXISTS,
                 '/^There are fewer columns in the INSERT statement than values specified/i'
                     => DB_ERROR_VALUE_COUNT_ON_ROW,
+                '/Divide by zero/i'
+                    => DB_ERROR_DIVZERO,
             );
+        }
         foreach ($error_regexps as $regexp => $code) {
         if (is_string($result)) {
             /*
              * Probably received a table name.
              * Create a result resource identifier.
              */
-            if (!@sybase_select_db($this->_db, $this->connection)) {
+            if ($this->_db && !@sybase_select_db($this->_db, $this->connection)) {
                 return $this->sybaseRaiseError(DB_ERROR_NODBSELECTED);
+            }
             $id = @sybase_query("SELECT * FROM $result WHERE 1=0",
                                 $this->connection);
             $got_string = true;
         if ($table != $tableName) {
             $flags = array();
+            $tableName = $table;
+            /* We're running sp_helpindex directly because it doesn't exist in
-            $tableName = $table;
+             * older versions of ASE -- unfortunately, we can't just use
+             * DB::isError() because the user may be using callback error
-            // get unique/primary keys
+             * handling. */
+            $res = @sybase_query("sp_helpindex $table", $this->connection);
             $res = $this->getAll("sp_helpindex $table", DB_FETCHMODE_ASSOC);
             if ($res === false || $res === true) {
+                // Fake a valid response for BC reasons.
+                return '';
+            }
-            if (!isset($res[0]['index_description'])) {
+            while (($val = sybase_fetch_assoc($res)) !== false) {
+                if (!isset($val['index_keys'])) {
+                    /* No useful information returned. Break and be done with
-                return '';
+                     * it, which preserves the pre-1.7.9 behaviour. */
                     break;
+                }
             foreach ($res as $val) {
                         $this->_add_flag($flags[$key], 'unique_key');
+                    }
+                }
+            }
+            sybase_free_result($res);
+        }
         if (array_key_exists($column, $flags)) {

Subversion Repositories Applications.gtt

(root)/trunk/bibliotheque/pear/DB/sybase.php – Rev 94 → 187