net.php.pear/DB/odbc.php

<?php
//
// +----------------------------------------------------------------------+
// | PHP Version 4                                                        |
// +----------------------------------------------------------------------+
// | Copyright (c) 1997-2002 The PHP Group                                |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.02 of the PHP license,      |
// | that is bundled with this package in the file LICENSE, and is        |
// | available at through the world-wide-web at                           |
// | http://www.php.net/license/2_02.txt.                                 |
// | If you did not receive a copy of the PHP license and are unable to   |
// | obtain it through the world-wide-web, please send a note to          |
// | license@php.net so we can mail you a copy immediately.               |
// +----------------------------------------------------------------------+
// | Author: Stig Bakken <ssb@fast.no>                                    |
// +----------------------------------------------------------------------+
//
// $Id: odbc.php,v 1.54 2002/02/28 08:27:11 sebastian Exp $
//
// Database independent query interface definition for PHP's ODBC
// extension.
//

//
// XXX legend:
//  More info on ODBC errors could be found here:
//  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_err_odbc_5stz.asp
//
// XXX ERRORMSG: The error message from the odbc function should
//                 be registered here.
//

require_once 'DB/common.php';

class DB_odbc extends DB_common
{
    // {{{ properties

    var $connection;
    var $phptype, $dbsyntax;
    var $row = array();

    // }}}
    // {{{ constructor

    function DB_odbc()
    {
        $this->DB_common();
        $this->phptype = 'odbc';
        $this->dbsyntax = 'sql92';
        $this->features = array(
            'prepare' => true,
            'pconnect' => true,
            'transactions' => false,
            'limit' => 'emulate'
        );
        $this->errorcode_map = array(
            '01004' => DB_ERROR_TRUNCATED,
            '07001' => DB_ERROR_MISMATCH,
            '21S01' => DB_ERROR_MISMATCH,
            '21S02' => DB_ERROR_MISMATCH,
            '22003' => DB_ERROR_INVALID_NUMBER,
            '22008' => DB_ERROR_INVALID_DATE,
            '22012' => DB_ERROR_DIVZERO,
            '23000' => DB_ERROR_CONSTRAINT,
            '24000' => DB_ERROR_INVALID,
            '34000' => DB_ERROR_INVALID,
            '37000' => DB_ERROR_SYNTAX,
            '42000' => DB_ERROR_SYNTAX,
            'IM001' => DB_ERROR_UNSUPPORTED,
            'S0000' => DB_ERROR_NOSUCHTABLE,
            'S0001' => DB_ERROR_NOT_FOUND,
            'S0002' => DB_ERROR_NOT_FOUND,
            'S0011' => DB_ERROR_ALREADY_EXISTS,
            'S0012' => DB_ERROR_NOT_FOUND,
            'S0021' => DB_ERROR_ALREADY_EXISTS,
            'S0022' => DB_ERROR_NOT_FOUND,
            'S1009' => DB_ERROR_INVALID,
            'S1090' => DB_ERROR_INVALID,
            'S1C00' => DB_ERROR_NOT_CAPABLE
        );
    }

    // }}}
    // {{{ connect()

    /**
     * Connect to a database and log in as the specified user.
     *
     * @param $dsn the data source name (see DB::parseDSN for syntax)
     * @param $persistent (optional) whether the connection should
     *        be persistent
     *
     * @return int DB_OK on success, a DB error code on failure
     */
    function connect($dsninfo, $persistent = false)
    {
        if (!DB::assertExtension('odbc'))
            return $this->raiseError(DB_ERROR_EXTENSION_NOT_FOUND);

        $this->dsn = $dsninfo;
        if (!empty($dsninfo['dbsyntax'])) {
            $this->dbsyntax = $dsninfo['dbsyntax'];
        }
        switch ($this->dbsyntax) {
            case 'solid':
                $this->features = array(
                    'prepare' => true,
                    'pconnect' => true,
                    'transactions' => true
                );
                $default_dsn = 'localhost';
                break;
            case 'navision':
                // the Navision driver doesn't support fetch row by number
                $this->features['limit'] = false;
                break;
            default:
                break;
        }
        $dbhost = $dsninfo['hostspec'] ? $dsninfo['hostspec'] : 'localhost';
        $user = $dsninfo['username'];
        $pw = $dsninfo['password'];
        if ($this->provides('pconnect')) {
            $connect_function = $persistent ? 'odbc_pconnect' : 'odbc_connect';
        } else {
            $connect_function = 'odbc_connect';
        }
        $conn = @$connect_function($dbhost, $user, $pw);
        if (!is_resource($conn)) {
            return $this->raiseError(DB_ERROR_CONNECT_FAILED, null, null,
                                         null, $this->errorNative());
        }
        $this->connection = $conn;
        return DB_OK;
    }

    // }}}
    // {{{ disconnect()

    function disconnect()
    {
        $err = @odbc_close($this->connection);
        $this->connection = null;
        return $err;
    }

    // }}}
    // {{{ simpleQuery()

    /**
     * Send a query to ODBC and return the results as a ODBC resource
     * identifier.
     *
     * @param $query the SQL query
     *
     * @return int returns a valid ODBC result for successful SELECT
     * queries, DB_OK for other successful queries.  A DB error code
     * is returned on failure.
     */
    function simpleQuery($query)
    {
        $this->last_query = $query;
        $query = $this->modifyQuery($query);
        $result = @odbc_exec($this->connection, $query);
        if (!$result) {
            return $this->odbcRaiseError(); // XXX ERRORMSG
        }
        // Determine which queries that should return data, and which
        // should return an error code only.
        if (DB::isManip($query)) {
            $this->manip_result = $result; // For affectedRows()
            return DB_OK;
        }
        $this->row[$result] = 0;
        $this->manip_result = 0;
        return $result;
    }

    // }}}
    // {{{ nextResult()

    /**
     * Move the internal odbc result pointer to the next available result
     *
     * @param a valid fbsql result resource
     *
     * @access public
     *
     * @return true if a result is available otherwise return false
     */
    function nextResult($result)
    {
        return odbc_next_result($result);
    }

    // }}}
    // {{{ fetchRow()

    function fetchRow($result, $fetchmode = DB_FETCHMODE_DEFAULT, $rownum=null)
    {
        if ($fetchmode == DB_FETCHMODE_DEFAULT) {
            $fetchmode = $this->fetchmode;
        }
        $res = $this->fetchInto ($result, $arr, $fetchmode, $rownum);
        if ($res !== DB_OK) {
            return $res;
        }
        return $arr;
    }

    // }}}
    // {{{ fetchInto()

    function fetchInto($result, &$row, $fetchmode, $rownum=null)
    {
        $row = array();
        if ($rownum !== null) {
            $rownum++; // ODBC first row is 1
            if (!function_exists('version_compare') || version_compare(phpversion(), "4.0.5", "lt")) {
                $cols = odbc_fetch_into($result, $rownum, &$row);
            } else {
                $cols = odbc_fetch_into($result, $rownum, $row);
            }
        } else {
            if (!function_exists('version_compare') || version_compare(phpversion(), "4.0.5", "lt")) {
                $cols = odbc_fetch_into($result, &$row);
            } else {
                $cols = odbc_fetch_into($result, $row);
            }
        }

        if (!$cols) {
            /* XXX FIXME: doesn't work with unixODBC and easysoft
                          (get corrupted $errno values)
            if ($errno = odbc_error($this->connection)) {
                return $this->RaiseError($errno);
            }*/
            return null;
        }
        if ($fetchmode !== DB_FETCHMODE_ORDERED) {
            for ($i = 0; $i < count($row); $i++) {
                $colName = odbc_field_name($result, $i+1);
                $a[$colName] = $row[$i];
            }
            $row = $a;
        }
        return DB_OK;
    }

    // }}}
    // {{{ freeResult()

    function freeResult($result)
    {
        if (is_resource($result)) {
            // Always return true
            return odbc_free_result($result);
        }
        if (!isset($this->prepare_tokens[(int)$result])) {
            return false;
        }
        unset($this->prepare_tokens[(int)$result]);
        unset($this->prepare_types[(int)$result]);
        return true;
    }

    // }}}
    // {{{ numCols()

    function numCols($result)
    {
        $cols = @odbc_num_fields($result);
        if (!$cols) {
            return $this->odbcRaiseError();
        }
        return $cols;
    }

    // }}}
    // {{{ affectedRows()

    /**
    * Returns the number of rows affected by a manipulative query
    * (INSERT, DELETE, UPDATE)
    * @return mixed int affected rows, 0 when non manip queries or
    *               DB error on error
    */
    function affectedRows()
    {
        if (empty($this->manip_result)) {  // In case of SELECT stms
            return 0;
        }
        $nrows = odbc_num_rows($this->manip_result);
        if ($nrows == -1) {
            return $this->odbcRaiseError();
        }
        return $nrows;
    }

    // }}}
    // {{{ numRows()

    /**
     * ODBC may or may not support counting rows in the result set of
     * SELECTs.
     *
     * @param $result the odbc result resource
     * @return the number of rows, or 0
     */
    function numRows($result)
    {
        $nrows = odbc_num_rows($result);
        if ($nrows == -1) {
            return $this->odbcRaiseError(DB_ERROR_UNSUPPORTED);
        }
        return $nrows;
    }

    // }}}
    // {{{ errorNative()

    /**
     * Get the native error code of the last error (if any) that
     * occured on the current connection.
     *
     * @access public
     *
     * @return int ODBC error code
     */

    function errorNative()
    {
        if (!isset($this->connection) || !is_resource($this->connection)) {
            return odbc_error() . ' ' . odbc_errormsg();
        }
        return odbc_error($this->connection) . ' ' . odbc_errormsg($this->connection);
    }

    // }}}
    // {{{ nextId()

    /**
     * Get the next value in a sequence.  We emulate sequences
     * for odbc. Will create the sequence if it does not exist.
     *
     * @access public
     *
     * @param $seq_name the name of the sequence
     *
     * @param $ondemand whether to create the sequence table on demand
     * (default is true)
     *
     * @return a sequence integer, or a DB error
     */
    function nextId($seq_name, $ondemand = true)
    {
        $seqname = $this->getSequenceName($seq_name);
        $repeat = 0;
        do {
            $result = $this->query("update ${seqname} set id = id + 1");
            if ($ondemand && DB::isError($result) &&
                $result->getCode() == DB_ERROR_NOT_FOUND) {
                $repeat = 1;
                $result = $this->createSequence($seq_name);
                if (DB::isError($result)) {
                    return $result;
                }
                $result = $this->query("insert into ${seqname} (id) values(0)");
            } else {
                $repeat = 0;
            }
        } while ($repeat);

        if (DB::isError($result)) {
            return $result;
        }

        $result = $this->query("select id from ${seqname}");
        if (DB::isError($result)) {
            return $result;
        }

        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
        if (DB::isError($row || !$row)) {
            return $row;
        }

        return $row['id'];
    }

    // }}}
    // {{{ createSequence()

    function createSequence($seq_name)
    {
        $seqname = $this->getSequenceName($seq_name);
        return $this->query("CREATE TABLE ${seqname} ".
                            '(id bigint NOT NULL,'.
                            ' PRIMARY KEY(id))');
    }

    // }}}
    // {{{ dropSequence()

    function dropSequence($seq_name)
    {
        $seqname = $this->getSequenceName($seq_name);
        return $this->query("DROP TABLE ${seqname}");
    }

    // }}}
    // {{{ autoCommit()

    function autoCommit($onoff = false)
    {
        if (!@odbc_autocommit($this->connection, $onoff)) {
            return $this->odbcRaiseError();
        }
        return DB_OK;
    }

    // }}}
    // {{{ commit()

    function commit()
    {
        if (!@odbc_commit($this->connection)) {
            return $this->odbcRaiseError();
        }
        return DB_OK;
    }

    // }}}
    // {{{ rollback()

    function rollback()
    {
        if (!@odbc_rollback($this->connection)) {
            return $this->odbcRaiseError();
        }
        return DB_OK;
    }

    // }}}
    // {{{ odbcRaiseError()

    function odbcRaiseError($errno = null)
    {
        if ($errno === null) {
            $errno = $this->errorCode(odbc_error($this->connection));
        }
        return $this->raiseError($errno, null, null, null,
                        $this->errorNative());
    }

    // }}}
    // {{{ getSpecialQuery()

    /**
    * Returns the query needed to get some backend info
    * @param string $type What kind of info you want to retrieve
    * @return string The SQL query string
    */
    function getSpecialQuery($type)
    {
        switch ($type) {
            case 'tables':
            default:
                return null;
        }
        return $sql;
    }

    // }}}

}

// Local variables:
// tab-width: 4
// c-basic-offset: 4
// End:
?>
1	cvsjoko	1.1	<?php
2			//
3			// +----------------------------------------------------------------------+
4			// \| PHP Version 4 \|
5			// +----------------------------------------------------------------------+
6			// \| Copyright (c) 1997-2002 The PHP Group \|
7			// +----------------------------------------------------------------------+
8			// \| This source file is subject to version 2.02 of the PHP license, \|
9			// \| that is bundled with this package in the file LICENSE, and is \|
10			// \| available at through the world-wide-web at \|
11			// \| http://www.php.net/license/2_02.txt. \|
12			// \| If you did not receive a copy of the PHP license and are unable to \|
13			// \| obtain it through the world-wide-web, please send a note to \|
14			// \| license@php.net so we can mail you a copy immediately. \|
15			// +----------------------------------------------------------------------+
16			// \| Author: Stig Bakken <ssb@fast.no> \|
17			// +----------------------------------------------------------------------+
18			//
19			// $Id: odbc.php,v 1.54 2002/02/28 08:27:11 sebastian Exp $
20			//
21			// Database independent query interface definition for PHP's ODBC
22			// extension.
23			//
24
25			//
26			// XXX legend:
27			// More info on ODBC errors could be found here:
28			// http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_err_odbc_5stz.asp
29			//
30			// XXX ERRORMSG: The error message from the odbc function should
31			// be registered here.
32			//
33
34			require_once 'DB/common.php';
35
36			class DB_odbc extends DB_common
37			{
38			// {{{ properties
39
40			var $connection;
41			var $phptype, $dbsyntax;
42			var $row = array();
43
44			// }}}
45			// {{{ constructor
46
47			function DB_odbc()
48			{
49			$this->DB_common();
50			$this->phptype = 'odbc';
51			$this->dbsyntax = 'sql92';
52			$this->features = array(
53			'prepare' => true,
54			'pconnect' => true,
55			'transactions' => false,
56			'limit' => 'emulate'
57			);
58			$this->errorcode_map = array(
59			'01004' => DB_ERROR_TRUNCATED,
60			'07001' => DB_ERROR_MISMATCH,
61			'21S01' => DB_ERROR_MISMATCH,
62			'21S02' => DB_ERROR_MISMATCH,
63			'22003' => DB_ERROR_INVALID_NUMBER,
64			'22008' => DB_ERROR_INVALID_DATE,
65			'22012' => DB_ERROR_DIVZERO,
66			'23000' => DB_ERROR_CONSTRAINT,
67			'24000' => DB_ERROR_INVALID,
68			'34000' => DB_ERROR_INVALID,
69			'37000' => DB_ERROR_SYNTAX,
70			'42000' => DB_ERROR_SYNTAX,
71			'IM001' => DB_ERROR_UNSUPPORTED,
72			'S0000' => DB_ERROR_NOSUCHTABLE,
73			'S0001' => DB_ERROR_NOT_FOUND,
74			'S0002' => DB_ERROR_NOT_FOUND,
75			'S0011' => DB_ERROR_ALREADY_EXISTS,
76			'S0012' => DB_ERROR_NOT_FOUND,
77			'S0021' => DB_ERROR_ALREADY_EXISTS,
78			'S0022' => DB_ERROR_NOT_FOUND,
79			'S1009' => DB_ERROR_INVALID,
80			'S1090' => DB_ERROR_INVALID,
81			'S1C00' => DB_ERROR_NOT_CAPABLE
82			);
83			}
84
85			// }}}
86			// {{{ connect()
87
88			/**
89			* Connect to a database and log in as the specified user.
90			*
91			* @param $dsn the data source name (see DB::parseDSN for syntax)
92			* @param $persistent (optional) whether the connection should
93			* be persistent
94			*
95			* @return int DB_OK on success, a DB error code on failure
96			*/
97			function connect($dsninfo, $persistent = false)
98			{
99			if (!DB::assertExtension('odbc'))
100			return $this->raiseError(DB_ERROR_EXTENSION_NOT_FOUND);
101
102			$this->dsn = $dsninfo;
103			if (!empty($dsninfo['dbsyntax'])) {
104			$this->dbsyntax = $dsninfo['dbsyntax'];
105			}
106			switch ($this->dbsyntax) {
107			case 'solid':
108			$this->features = array(
109			'prepare' => true,
110			'pconnect' => true,
111			'transactions' => true
112			);
113			$default_dsn = 'localhost';
114			break;
115			case 'navision':
116			// the Navision driver doesn't support fetch row by number
117			$this->features['limit'] = false;
118			break;
119			default:
120			break;
121			}
122			$dbhost = $dsninfo['hostspec'] ? $dsninfo['hostspec'] : 'localhost';
123			$user = $dsninfo['username'];
124			$pw = $dsninfo['password'];
125			if ($this->provides('pconnect')) {
126			$connect_function = $persistent ? 'odbc_pconnect' : 'odbc_connect';
127			} else {
128			$connect_function = 'odbc_connect';
129			}
130			$conn = @$connect_function($dbhost, $user, $pw);
131			if (!is_resource($conn)) {
132			return $this->raiseError(DB_ERROR_CONNECT_FAILED, null, null,
133			null, $this->errorNative());
134			}
135			$this->connection = $conn;
136			return DB_OK;
137			}
138
139			// }}}
140			// {{{ disconnect()
141
142			function disconnect()
143			{
144			$err = @odbc_close($this->connection);
145			$this->connection = null;
146			return $err;
147			}
148
149			// }}}
150			// {{{ simpleQuery()
151
152			/**
153			* Send a query to ODBC and return the results as a ODBC resource
154			* identifier.
155			*
156			* @param $query the SQL query
157			*
158			* @return int returns a valid ODBC result for successful SELECT
159			* queries, DB_OK for other successful queries. A DB error code
160			* is returned on failure.
161			*/
162			function simpleQuery($query)
163			{
164			$this->last_query = $query;
165			$query = $this->modifyQuery($query);
166			$result = @odbc_exec($this->connection, $query);
167			if (!$result) {
168			return $this->odbcRaiseError(); // XXX ERRORMSG
169			}
170			// Determine which queries that should return data, and which
171			// should return an error code only.
172			if (DB::isManip($query)) {
173			$this->manip_result = $result; // For affectedRows()
174			return DB_OK;
175			}
176			$this->row[$result] = 0;
177			$this->manip_result = 0;
178			return $result;
179			}
180
181			// }}}
182			// {{{ nextResult()
183
184			/**
185			* Move the internal odbc result pointer to the next available result
186			*
187			* @param a valid fbsql result resource
188			*
189			* @access public
190			*
191			* @return true if a result is available otherwise return false
192			*/
193			function nextResult($result)
194			{
195			return odbc_next_result($result);
196			}
197
198			// }}}
199			// {{{ fetchRow()
200
201			function fetchRow($result, $fetchmode = DB_FETCHMODE_DEFAULT, $rownum=null)
202			{
203			if ($fetchmode == DB_FETCHMODE_DEFAULT) {
204			$fetchmode = $this->fetchmode;
205			}
206			$res = $this->fetchInto ($result, $arr, $fetchmode, $rownum);
207			if ($res !== DB_OK) {
208			return $res;
209			}
210			return $arr;
211			}
212
213			// }}}
214			// {{{ fetchInto()
215
216			function fetchInto($result, &$row, $fetchmode, $rownum=null)
217			{
218			$row = array();
219			if ($rownum !== null) {
220			$rownum++; // ODBC first row is 1
221			if (!function_exists('version_compare') \|\| version_compare(phpversion(), "4.0.5", "lt")) {
222			$cols = odbc_fetch_into($result, $rownum, &$row);
223			} else {
224			$cols = odbc_fetch_into($result, $rownum, $row);
225			}
226			} else {
227			if (!function_exists('version_compare') \|\| version_compare(phpversion(), "4.0.5", "lt")) {
228			$cols = odbc_fetch_into($result, &$row);
229			} else {
230			$cols = odbc_fetch_into($result, $row);
231			}
232			}
233
234			if (!$cols) {
235			/* XXX FIXME: doesn't work with unixODBC and easysoft
236			(get corrupted $errno values)
237			if ($errno = odbc_error($this->connection)) {
238			return $this->RaiseError($errno);
239			}*/
240			return null;
241			}
242			if ($fetchmode !== DB_FETCHMODE_ORDERED) {
243			for ($i = 0; $i < count($row); $i++) {
244			$colName = odbc_field_name($result, $i+1);
245			$a[$colName] = $row[$i];
246			}
247			$row = $a;
248			}
249			return DB_OK;
250			}
251
252			// }}}
253			// {{{ freeResult()
254
255			function freeResult($result)
256			{
257			if (is_resource($result)) {
258			// Always return true
259			return odbc_free_result($result);
260			}
261			if (!isset($this->prepare_tokens[(int)$result])) {
262			return false;
263			}
264			unset($this->prepare_tokens[(int)$result]);
265			unset($this->prepare_types[(int)$result]);
266			return true;
267			}
268
269			// }}}
270			// {{{ numCols()
271
272			function numCols($result)
273			{
274			$cols = @odbc_num_fields($result);
275			if (!$cols) {
276			return $this->odbcRaiseError();
277			}
278			return $cols;
279			}
280
281			// }}}
282			// {{{ affectedRows()
283
284			/**
285			* Returns the number of rows affected by a manipulative query
286			* (INSERT, DELETE, UPDATE)
287			* @return mixed int affected rows, 0 when non manip queries or
288			* DB error on error
289			*/
290			function affectedRows()
291			{
292			if (empty($this->manip_result)) { // In case of SELECT stms
293			return 0;
294			}
295			$nrows = odbc_num_rows($this->manip_result);
296			if ($nrows == -1) {
297			return $this->odbcRaiseError();
298			}
299			return $nrows;
300			}
301
302			// }}}
303			// {{{ numRows()
304
305			/**
306			* ODBC may or may not support counting rows in the result set of
307			* SELECTs.
308			*
309			* @param $result the odbc result resource
310			* @return the number of rows, or 0
311			*/
312			function numRows($result)
313			{
314			$nrows = odbc_num_rows($result);
315			if ($nrows == -1) {
316			return $this->odbcRaiseError(DB_ERROR_UNSUPPORTED);
317			}
318			return $nrows;
319			}
320
321			// }}}
322			// {{{ errorNative()
323
324			/**
325			* Get the native error code of the last error (if any) that
326			* occured on the current connection.
327			*
328			* @access public
329			*
330			* @return int ODBC error code
331			*/
332
333			function errorNative()
334			{
335			if (!isset($this->connection) \|\| !is_resource($this->connection)) {
336			return odbc_error() . ' ' . odbc_errormsg();
337			}
338			return odbc_error($this->connection) . ' ' . odbc_errormsg($this->connection);
339			}
340
341			// }}}
342			// {{{ nextId()
343
344			/**
345			* Get the next value in a sequence. We emulate sequences
346			* for odbc. Will create the sequence if it does not exist.
347			*
348			* @access public
349			*
350			* @param $seq_name the name of the sequence
351			*
352			* @param $ondemand whether to create the sequence table on demand
353			* (default is true)
354			*
355			* @return a sequence integer, or a DB error
356			*/
357			function nextId($seq_name, $ondemand = true)
358			{
359			$seqname = $this->getSequenceName($seq_name);
360			$repeat = 0;
361			do {
362			$result = $this->query("update ${seqname} set id = id + 1");
363			if ($ondemand && DB::isError($result) &&
364			$result->getCode() == DB_ERROR_NOT_FOUND) {
365			$repeat = 1;
366			$result = $this->createSequence($seq_name);
367			if (DB::isError($result)) {
368			return $result;
369			}
370			$result = $this->query("insert into ${seqname} (id) values(0)");
371			} else {
372			$repeat = 0;
373			}
374			} while ($repeat);
375
376			if (DB::isError($result)) {
377			return $result;
378			}
379
380			$result = $this->query("select id from ${seqname}");
381			if (DB::isError($result)) {
382			return $result;
383			}
384
385			$row = $result->fetchRow(DB_FETCHMODE_ASSOC);
386			if (DB::isError($row \|\| !$row)) {
387			return $row;
388			}
389
390			return $row['id'];
391			}
392
393			// }}}
394			// {{{ createSequence()
395
396			function createSequence($seq_name)
397			{
398			$seqname = $this->getSequenceName($seq_name);
399			return $this->query("CREATE TABLE ${seqname} ".
400			'(id bigint NOT NULL,'.
401			' PRIMARY KEY(id))');
402			}
403
404			// }}}
405			// {{{ dropSequence()
406
407			function dropSequence($seq_name)
408			{
409			$seqname = $this->getSequenceName($seq_name);
410			return $this->query("DROP TABLE ${seqname}");
411			}
412
413			// }}}
414			// {{{ autoCommit()
415
416			function autoCommit($onoff = false)
417			{
418			if (!@odbc_autocommit($this->connection, $onoff)) {
419			return $this->odbcRaiseError();
420			}
421			return DB_OK;
422			}
423
424			// }}}
425			// {{{ commit()
426
427			function commit()
428			{
429			if (!@odbc_commit($this->connection)) {
430			return $this->odbcRaiseError();
431			}
432			return DB_OK;
433			}
434
435			// }}}
436			// {{{ rollback()
437
438			function rollback()
439			{
440			if (!@odbc_rollback($this->connection)) {
441			return $this->odbcRaiseError();
442			}
443			return DB_OK;
444			}
445
446			// }}}
447			// {{{ odbcRaiseError()
448
449			function odbcRaiseError($errno = null)
450			{
451			if ($errno === null) {
452			$errno = $this->errorCode(odbc_error($this->connection));
453			}
454			return $this->raiseError($errno, null, null, null,
455			$this->errorNative());
456			}
457
458			// }}}
459			// {{{ getSpecialQuery()
460
461			/**
462			* Returns the query needed to get some backend info
463			* @param string $type What kind of info you want to retrieve
464			* @return string The SQL query string
465			*/
466			function getSpecialQuery($type)
467			{
468			switch ($type) {
469			case 'tables':
470			default:
471			return null;
472			}
473			return $sql;
474			}
475
476			// }}}
477
478			}
479
480			// Local variables:
481			// tab-width: 4
482			// c-basic-offset: 4
483			// End:
484			?>
MailToCvsAdmin">MailToCvsAdmin	ViewVC Help
Powered by ViewVC 1.1.26