db_postgresql.php

   1 <?php
   2 /*=====================================================================*\
   3 || ###################################################################
   4 || # Iris Studios Shared Object Framework [#]version[#]
   5 || # Copyright ©2002-[#]year[#] Iris Studios, Inc.
   6 || #
   7 || # This program is free software; you can redistribute it and/or modify
   8 || # it under the terms of the GNU General Public License as published by
   9 || # the Free Software Foundation; version [#]gpl[#] of the License.
  10 || #
  11 || # This program is distributed in the hope that it will be useful, but
  12 || # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
  13 || # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
  14 || # more details.
  15 || #
  16 || # You should have received a copy of the GNU General Public License along
  17 || # with this program; if not, write to the Free Software Foundation, Inc.,
  18 || # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
  19 || ###################################################################
  20 \*=====================================================================*/
  21
  22 /**
  23 * PostgreSQL Database Abstraction Layer
  24 * db_postgresql.php
  25 *
  26 * @package      ISSO
  27 */
  28
  29 $this->load('db', null);
  30
  31 /**
  32 * PostgreSQL Database Abstraction Layer
  33 *
  34 * This framework is a function wrapper for PostgresQL functions so we can have
  35 * better error reporting and query reporting.
  36 *
  37 * @author               Iris Studios, Inc.
  38 * @copyright    Copyright ©2002 - [#]year[#], Iris Studios, Inc.
  39 * @version              $Revision$
  40 * @package              ISSO
  41 *
  42 */
  43 class DB_PostgreSQL extends DB_Abstract
  44 {
  45         /**
  46         * Command mapping list
  47         * @var  array
  48         * @access       private
  49         */
  50         var $commands = array(
  51                 'pconnect'              => '$this->command_pg_pconnect',
  52                 'connect'               => '$this->command_pg_connect',
  53                 'query'                 => 'pg_query',
  54                 'error_num'             => '$this->command_error_num',
  55                 'error_str'             => '$this->command_error_str',
  56                 'escape_string' => '$this->command_pg_escape_string',
  57                 'fetch_assoc'   => 'pg_fetch_assoc',
  58                 'fetch_object'  => 'pg_fetch_object',
  59                 'free_result'   => 'pg_free_result',
  60                 'insert_id'             => '%link', // how do we support this...?
  61                 'num_rows'              => 'pg_num_rows',
  62                 'affected_rows' => 'pg_affected_rows'
  63         );
  64
  65         /**
  66         * Port number to connect to
  67         * @var  integer
  68         * @access       private
  69         */
  70         var $port = 5432;
  71
  72         /**
  73         * Fields array that is used in this module
  74         * @var  array
  75         * @access       private
  76         */
  77         var $fields = array(
  78                 'port'          => array(REQ_NO,        null,   true)
  79         );
  80
  81         // ###################################################################
  82         /**
  83         * Constructor
  84         */
  85         function __construct(&$registry)
  86         {
  87                 parent::__construct($registry);
  88         }
  89
  90         // ###################################################################
  91         /**
  92         * (PHP 4) Constructor
  93         */
  94         function DB_PostgreSQL(&$registry)
  95         {
  96                 $this->__construct($registry);
  97         }
  98
  99         // ###################################################################
 100         /**
 101         * Sets an ISSO field
 102         *
 103         * @access       public
 104         *
 105         * @param        string  Field name
 106         * @param        mixed   Value of the field
 107         */
 108         function set($name, $value)
 109         {
 110                 $this->registry->do_set($name, $value, 'db_postgresql');
 111         }
 112
 113         // ###################################################################
 114         /**
 115         * Wrapper: pg_connect
 116         *
 117         * @access       protected
 118         *
 119         * @param        string  Server name
 120         * @param        string  User name
 121         * @param        string  Password
 122         * @param        string  Database
 123         *
 124         * @return       integer DB-Link
 125         */
 126         function command_pg_connect($server, $user, $password, $database)
 127         {
 128                 return pg_connect("host='$server' port={$this->port} user='$user' password='$password' dbname='$database'");
 129         }
 130
 131         // ###################################################################
 132         /**
 133         * Wrapper: pg_pconnect
 134         *
 135         * @access       protected
 136         *
 137         * @param        string  Server name
 138         * @param        string  User name
 139         * @param        string  Password
 140         * @param        string  Database
 141         *
 142         * @return       integer DB-Link
 143         */
 144         function command_pg_pconnect($server, $user, $password, $database)
 145         {
 146                 return pg_pconnect("host='$server' port={$this->port} user='$user' password='$password' dbname='$database'");
 147         }
 148
 149         // ###################################################################
 150         /**
 151         * Wrapper: pg_escape_string
 152         *
 153         * @access       protected
 154         *
 155         * @param        integer DB-Link (unused)
 156         * @param        string  Raw string
 157         *
 158         * @return       string  Escaped string
 159         */
 160         function command_pg_escape_string($link, $string)
 161         {
 162                 return pg_escape_string($string);
 163         }
 164
 165         // ###################################################################
 166         /**
 167         * Wrapper/no support: error string
 168         *
 169         * @access       protected
 170         *
 171         * @param        integer DB-Link
 172         *
 173         * @return       string  Error string
 174         */
 175         function command_error_str($link)
 176         {
 177                 if ($this->result)
 178                 {
 179                         return pg_result_error($this->result);
 180                 }
 181
 182                 return pg_last_error($link);
 183         }
 184
 185         // ###################################################################
 186         /**
 187         * Not supported: error numbers
 188         *
 189         * @access       protected
 190         *
 191         * @param        integer DB-Link
 192         *
 193         * @return       integer Returns -1 always
 194         */
 195         function command_error_num($link)
 196         {
 197                 return -1;
 198         }
 199
 200         // ###################################################################
 201         /**
 202         * Overload: insert_id
 203         *
 204         * @access       public
 205         *
 206         * @param        integer Result
 207         * @param        string  PostgreSQL sequence
 208         *
 209         * @return       integer Insert ID
 210         */
 211         function insert_id($result, $sequence)
 212         {
 213                 $temp = $this->query("SELECT currval($sequence) AS auto_inc");
 214                 //$temp = call_user_func($this->commands['query'], "SELECT currval($table_col)");
 215                 var_dump( $temp);
 216                 print_r($this->fetch_array($temp));
 217         }
 218 }
 219
 220 /*=====================================================================*\
 221 || ###################################################################
 222 || # $HeadURL$
 223 || # $Id$
 224 || ###################################################################
 225 \*=====================================================================*/
 226 ?>