2 /*=====================================================================*\
3 || ###################################################################
4 || # Iris Studios Shared Object Framework [#]version[#]
5 || # Copyright ©2002-[#]year[#] Iris Studios, Inc.
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.
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
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 \*=====================================================================*/
23 * PostgreSQL Database Abstraction Layer
29 $this->load('db', null
);
32 * PostgreSQL Database Abstraction Layer
34 * This framework is a function wrapper for PostgresQL functions so we can have
35 * better error reporting and query reporting.
37 * @author Iris Studios, Inc.
38 * @copyright Copyright ©2002 - [#]year[#], Iris Studios, Inc.
43 class DB_PostgreSQL
extends DB_Abstract
46 * Command mapping list
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'
66 * Port number to connect to
72 // ###################################################################
76 function __construct(&$registry)
78 parent
::__construct($registry);
81 // ###################################################################
85 function DB_PostgreSQL(&$registry)
87 $this->__construct($registry);
90 // ###################################################################
96 * @param string Server name
97 * @param string User name
98 * @param string Password
99 * @param string Database
101 * @return integer DB-Link
103 function command_pg_connect($server, $user, $password, $database)
105 return pg_connect("host='$server' port={$this->port} user='$user' password='$password' dbname='$database'");
108 // ###################################################################
110 * Wrapper: pg_pconnect
114 * @param string Server name
115 * @param string User name
116 * @param string Password
117 * @param string Database
119 * @return integer DB-Link
121 function command_pg_pconnect($server, $user, $password, $database)
123 return pg_pconnect("host='$server' port={$this->port} user='$user' password='$password' dbname='$database'");
126 // ###################################################################
128 * Wrapper: pg_escape_string
132 * @param integer DB-Link (unused)
133 * @param string Raw string
135 * @return string Escaped string
137 function command_pg_escape_string($link, $string)
139 return pg_escape_string($string);
142 // ###################################################################
144 * Wrapper/no support: error string
148 * @param integer DB-Link
150 * @return string Error string
152 function command_error_str($link)
156 return pg_result_error($this->result
);
159 return pg_last_error($link);
162 // ###################################################################
164 * Not supported: error numbers
168 * @param integer DB-Link
170 * @return integer Returns -1 always
172 function command_error_num($link)
177 // ###################################################################
179 * Overload: insert_id
183 * @param integer Result
184 * @param string PostgreSQL sequence
186 * @return integer Insert ID
188 function insert_id($result, $sequence)
190 $temp = $this->query("SELECT currval($sequence) AS auto_inc");
191 //$temp = call_user_func($this->commands['query'], "SELECT currval($table_col)");
193 print_r($this->fetch_array($temp));
197 /*=====================================================================*\
198 || ###################################################################
201 || ###################################################################
202 \*=====================================================================*/