Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
adodb-access.inc.php	2.15 KB	-rw-r--r--	2023-01-22 09:53
adodb-ado.inc.php	16.24 KB	-rw-r--r--	2023-01-22 09:53
adodb-ado5.inc.php	17.33 KB	-rw-r--r--	2023-01-22 09:53
adodb-ado_access.inc.php	1.48 KB	-rw-r--r--	2023-01-22 09:53
adodb-ado_mssql.inc.php	4.02 KB	-rw-r--r--	2023-01-22 09:53
adodb-ads.inc.php	19.39 KB	-rw-r--r--	2023-01-22 09:53
adodb-borland_ibase.inc.php	2.43 KB	-rw-r--r--	2023-01-22 09:53
adodb-csv.inc.php	5.09 KB	-rw-r--r--	2023-01-22 09:53
adodb-db2.inc.php	44.36 KB	-rw-r--r--	2023-01-22 09:53
adodb-db2oci.inc.php	4.31 KB	-rw-r--r--	2023-01-22 09:53
adodb-db2ora.inc.php	2.23 KB	-rw-r--r--	2023-01-22 09:53
adodb-fbsql.inc.php	6.84 KB	-rw-r--r--	2023-01-22 09:53
adodb-firebird.inc.php	33.07 KB	-rw-r--r--	2023-01-22 09:53
adodb-ibase.inc.php	22.51 KB	-rw-r--r--	2023-01-22 09:53
adodb-informix.inc.php	1.21 KB	-rw-r--r--	2023-01-22 09:53
adodb-informix72.inc.php	14.9 KB	-rw-r--r--	2023-01-22 09:53
adodb-ldap.inc.php	10.93 KB	-rw-r--r--	2023-01-22 09:53
adodb-mssql.inc.php	30.66 KB	-rw-r--r--	2023-01-22 09:53
adodb-mssql_n.inc.php	7.75 KB	-rw-r--r--	2023-01-22 09:53
adodb-mssqlnative.inc.php	34.74 KB	-rw-r--r--	2023-01-22 09:53
adodb-mssqlpo.inc.php	1.41 KB	-rw-r--r--	2023-01-22 09:53
adodb-mysqli.inc.php	50.3 KB	-rw-r--r--	2023-01-22 09:53
adodb-netezza.inc.php	5.12 KB	-rw-r--r--	2023-01-22 09:53
adodb-oci8.inc.php	47.83 KB	-rw-r--r--	2023-01-22 09:53
adodb-oci805.inc.php	1.79 KB	-rw-r--r--	2023-01-22 09:53
adodb-oci8po.inc.php	7.12 KB	-rw-r--r--	2023-01-22 09:53
adodb-oci8quercus.inc.php	2.3 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbc.inc.php	18.56 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbc_db2.inc.php	6.87 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbc_mssql.inc.php	12.34 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbc_mssql2012.inc.php	1.08 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbc_oracle.inc.php	3.34 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbtp.inc.php	23.2 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbtp_unicode.inc.php	1.42 KB	-rw-r--r--	2023-01-22 09:53
adodb-oracle.inc.php	9.39 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo.inc.php	20.79 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_dblib.inc.php	5.8 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_firebird.inc.php	10.76 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_mssql.inc.php	1.84 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_mysql.inc.php	9.84 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_oci.inc.php	3.41 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_pgsql.inc.php	10.2 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_sqlite.inc.php	6.33 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_sqlsrv.inc.php	4.5 KB	-rw-r--r--	2023-01-22 09:53
adodb-postgres.inc.php	1008 B	-rw-r--r--	2023-01-22 09:53
adodb-postgres64.inc.php	32.3 KB	-rw-r--r--	2023-01-22 09:53
adodb-postgres7.inc.php	9.27 KB	-rw-r--r--	2023-01-22 09:53
adodb-postgres8.inc.php	2.1 KB	-rw-r--r--	2023-01-22 09:53
adodb-postgres9.inc.php	1.13 KB	-rw-r--r--	2023-01-22 09:53
adodb-proxy.inc.php	1.12 KB	-rw-r--r--	2023-01-22 09:53
adodb-sapdb.inc.php	5 KB	-rw-r--r--	2023-01-22 09:53
adodb-sqlanywhere.inc.php	3.43 KB	-rw-r--r--	2023-01-22 09:53
adodb-sqlite.inc.php	11.83 KB	-rw-r--r--	2023-01-22 09:53
adodb-sqlite3.inc.php	18.66 KB	-rw-r--r--	2023-01-22 09:53
adodb-sqlitepo.inc.php	2.05 KB	-rw-r--r--	2023-01-22 09:53
adodb-sybase.inc.php	12.27 KB	-rw-r--r--	2023-01-22 09:53
adodb-sybase_ase.inc.php	3.5 KB	-rw-r--r--	2023-01-22 09:53
adodb-text.inc.php	8.14 KB	-rw-r--r--	2023-01-22 09:53
adodb-vfp.inc.php	2.6 KB	-rw-r--r--	2023-01-22 09:53

Rename

<?php
/**
 * Netezza Driver
 *
 * @link https://www.ibm.com/products/netezza
 * Based on the previous postgres drivers. Major Additions/Changes:
 * - MetaDatabasesSQL, MetaTablesSQL, MetaColumnsSQL
 *   Note: You have to have admin privileges to access the system tables
 * - Removed non-working keys code (Netezza has no concept of keys)
 * - Fixed the way data types and lengths are returned in MetaColumns()
 *   as well as added the default lengths for certain types
 * - Updated public variables for Netezza
 * TODO: Still need to remove blob functions, as Netezza doesn't support blob
 *
 * This file is part of ADOdb, a Database Abstraction Layer library for PHP.
 *
 * @package ADOdb
 * @link https://adodb.org Project's web site and documentation
 * @link https://github.com/ADOdb/ADOdb Source code and issue tracker
 *
 * The ADOdb Library is dual-licensed, released under both the BSD 3-Clause
 * and the GNU Lesser General Public Licence (LGPL) v2.1 or, at your option,
 * any later version. This means you can use it in proprietary products.
 * See the LICENSE.md file distributed with this source code for details.
 * @license BSD-3-Clause
 * @license LGPL-2.1-or-later
 *
 * @copyright 2000-2013 John Lim
 * @copyright 2014 Damien Regad, Mark Newnham and the ADOdb community
 * @author Josh Eldridge <joshuae74@hotmail.com>
 */

// security - hide paths
if (!defined('ADODB_DIR')) die();

include_once(ADODB_DIR.'/drivers/adodb-postgres64.inc.php');

class ADODB_netezza extends ADODB_postgres64 {
    var $databaseType = 'netezza';
	var $dataProvider = 'netezza';
	var $hasInsertID = false;
	var $_resultid = false;
  	var $concat_operator='||';
  	var $random = 'random';
	var $metaDatabasesSQL = "select objname from _v_object_data where objtype='database' order by 1";
    var $metaTablesSQL = "select objname from _v_object_data where objtype='table' order by 1";
	var $isoDates = true; // accepts dates in ISO format
	var $sysDate = "CURRENT_DATE";
	var $sysTimeStamp = "CURRENT_TIMESTAMP";
	var $blobEncodeType = 'C';
	var $metaColumnsSQL = "SELECT attname, atttype FROM _v_relation_column_def WHERE name = '%s' AND attnum > 0 ORDER BY attnum";
	var $metaColumnsSQL1 = "SELECT attname, atttype FROM _v_relation_column_def WHERE name = '%s' AND attnum > 0 ORDER BY attnum";
	// netezza doesn't have keys. it does have distributions, so maybe this is
	// something that can be pulled from the system tables
	var $metaKeySQL = "";
	var $hasAffectedRows = true;
	var $hasLimit = true;
	var $true = 't';		// string that represents TRUE for a database
	var $false = 'f';		// string that represents FALSE for a database
	var $fmtDate = "'Y-m-d'";	// used by DBDate() as the default date format used by the database
	var $fmtTimeStamp = "'Y-m-d G:i:s'"; // used by DBTimeStamp as the default timestamp fmt.
	var $ansiOuter = true;
	var $autoRollback = true; // apparently pgsql does not autorollback properly before 4.3.4
							// http://bugs.php.net/bug.php?id=25404

function MetaColumns($table,$upper=true)
	{

// Changed this function to support Netezza which has no concept of keys
	// could posisbly work on other things from the system table later.

global $ADODB_FETCH_MODE;

$table = strtolower($table);

$save = $ADODB_FETCH_MODE;
		$ADODB_FETCH_MODE = ADODB_FETCH_NUM;
		if ($this->fetchMode !== false) $savem = $this->SetFetchMode(false);

$rs = $this->Execute(sprintf($this->metaColumnsSQL,$table,$table));
		if (isset($savem)) $this->SetFetchMode($savem);
		$ADODB_FETCH_MODE = $save;

if ($rs === false) return false;

$retarr = array();
		while (!$rs->EOF) {
			$fld = new ADOFieldObject();
			$fld->name = $rs->fields[0];

// since we're returning type and length as one string,
			// split them out here.

if ($first = strstr($rs->fields[1], "(")) {
			 $fld->max_length = trim($first, "()");
			} else {
			 $fld->max_length = -1;
			}

if ($first = strpos($rs->fields[1], "(")) {
			 $fld->type = substr($rs->fields[1], 0, $first);
			} else {
			 $fld->type = $rs->fields[1];
			}

switch ($fld->type) {
			 case "byteint":
			 case "boolean":
			 $fld->max_length = 1;
			 break;
			 case "smallint":
			 $fld->max_length = 2;
			 break;
			 case "integer":
			 case "numeric":
			 case "date":
			 $fld->max_length = 4;
			 break;
			 case "bigint":
			 case "time":
			 case "timestamp":
			 $fld->max_length = 8;
			 break;
			 case "timetz":
			 case "time with time zone":
			 $fld->max_length = 12;
			 break;
			}

if ($ADODB_FETCH_MODE == ADODB_FETCH_NUM) $retarr[] = $fld;
			else $retarr[($upper) ? strtoupper($fld->name) : $fld->name] = $fld;

$rs->MoveNext();
		}
		$rs->Close();
		return $retarr;

}

/*--------------------------------------------------------------------------------------
	 Class Name: Recordset
--------------------------------------------------------------------------------------*/

class ADORecordSet_netezza extends ADORecordSet_postgres64
{
	var $databaseType = "netezza";
	var $canSeek = true;

// _initrs modified to disable blob handling
	function _initrs()
	{
	global $ADODB_COUNTRECS;
		$this->_numOfRows = ($ADODB_COUNTRECS)? @pg_num_rows($this->_queryID):-1;
		$this->_numOfFields = @pg_num_fields($this->_queryID);
	}

}