Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
adodb-access.inc.php	2.13 KB	-rw-rw-rw-
adodb-ado.inc.php	15.98 KB	-rw-rw-rw-
adodb-ado5.inc.php	17.08 KB	-rw-rw-rw-
adodb-ado_access.inc.php	1.39 KB	-rw-rw-rw-
adodb-ado_mssql.inc.php	4.35 KB	-rw-rw-rw-
adodb-ads.inc.php	23.41 KB	-rw-rw-rw-
adodb-borland_ibase.inc.php	2.19 KB	-rw-rw-rw-
adodb-csv.inc.php	4.75 KB	-rw-rw-rw-
adodb-db2.inc.php	21.59 KB	-rw-rw-rw-
adodb-db2oci.inc.php	4.58 KB	-rw-rw-rw-
adodb-db2ora.inc.php	1.62 KB	-rw-rw-rw-
adodb-fbsql.inc.php	6.37 KB	-rw-rw-rw-
adodb-firebird.inc.php	1.88 KB	-rw-rw-rw-
adodb-ibase.inc.php	24.76 KB	-rw-rw-rw-
adodb-informix.inc.php	980 B	-rw-rw-rw-
adodb-informix72.inc.php	14.44 KB	-rw-rw-rw-
adodb-ldap.inc.php	12.11 KB	-rw-rw-rw-
adodb-mssql.inc.php	33.8 KB	-rw-rw-rw-
adodb-mssql_n.inc.php	7.14 KB	-rw-rw-rw-
adodb-mssqlnative.inc.php	30.08 KB	-rw-rw-rw-
adodb-mssqlpo.inc.php	1.49 KB	-rw-rw-rw-
adodb-mysql.inc.php	22.8 KB	-rw-rw-rw-
adodb-mysqli.inc.php	32.66 KB	-rw-rw-rw-
adodb-mysqlpo.inc.php	3.14 KB	-rw-rw-rw-
adodb-mysqlt.inc.php	3.72 KB	-rw-rw-rw-
adodb-netezza.inc.php	5.03 KB	-rw-rw-rw-
adodb-oci8.inc.php	46.43 KB	-rw-rw-rw-
adodb-oci805.inc.php	1.54 KB	-rw-rw-rw-
adodb-oci8po.inc.php	5.53 KB	-rw-rw-rw-
adodb-odbc.inc.php	19.33 KB	-rw-rw-rw-
adodb-odbc_db2.inc.php	9.13 KB	-rw-rw-rw-
adodb-odbc_mssql.inc.php	10.52 KB	-rw-rw-rw-
adodb-odbc_oracle.inc.php	3.12 KB	-rw-rw-rw-
adodb-odbtp.inc.php	23.29 KB	-rw-rw-rw-
adodb-odbtp_unicode.inc.php	1.1 KB	-rw-rw-rw-
adodb-oracle.inc.php	9.2 KB	-rw-rw-rw-
adodb-pdo.inc.php	14.73 KB	-rw-rw-rw-
adodb-pdo_mssql.inc.php	1.41 KB	-rw-rw-rw-
adodb-pdo_mysql.inc.php	5 KB	-rw-rw-rw-
adodb-pdo_oci.inc.php	2.6 KB	-rw-rw-rw-
adodb-pdo_pgsql.inc.php	8.26 KB	-rw-rw-rw-
adodb-pdo_sqlite.inc.php	5.78 KB	-rw-rw-rw-
adodb-postgres.inc.php	515 B	-rw-rw-rw-
adodb-postgres64.inc.php	31.51 KB	-rw-rw-rw-
adodb-postgres7.inc.php	11 KB	-rw-rw-rw-
adodb-postgres8.inc.php	348 B	-rw-rw-rw-
adodb-postgres9.inc.php	1.59 KB	-rw-rw-rw-
adodb-proxy.inc.php	805 B	-rw-rw-rw-
adodb-sapdb.inc.php	4.98 KB	-rw-rw-rw-
adodb-sqlanywhere.inc.php	4.13 KB	-rw-rw-rw-
adodb-sqlite.inc.php	10.27 KB	-rw-rw-rw-
adodb-sqlite3.inc.php	12 KB	-rw-rw-rw-
adodb-sqlitepo.inc.php	1.82 KB	-rw-rw-rw-
adodb-sybase.inc.php	12.71 KB	-rw-rw-rw-
adodb-sybase_ase.inc.php	3.18 KB	-rw-rw-rw-
adodb-vfp.inc.php	2.42 KB	-rw-rw-rw-

Code Editor : adodb-netezza.inc.php

<?php
/*
  V5.18 3 Sep 2012  (c) 2000-2012 John Lim (jlim#natsoft.com). All rights reserved.
 
  First cut at the Netezza Driver by Josh Eldridge joshuae74#hotmail.com
 Based on the previous postgres drivers.
 http://www.netezza.com/
 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
    Still need to remove blob functions, as Netezza doesn't suppport blob
*/
// 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 ADODB_netezza() 
	{
	
	}
	
	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;
	
	function ADORecordSet_netezza($queryID,$mode=false) 
	{
		if ($mode === false) { 
			global $ADODB_FETCH_MODE;
			$mode = $ADODB_FETCH_MODE;
		}
		switch ($mode)
		{
		case ADODB_FETCH_NUM: $this->fetchMode = PGSQL_NUM; break;
		case ADODB_FETCH_ASSOC:$this->fetchMode = PGSQL_ASSOC; break;
		
		case ADODB_FETCH_DEFAULT:
		case ADODB_FETCH_BOTH:
		default: $this->fetchMode = PGSQL_BOTH; break;
		}
		$this->adodbFetchMode = $mode;
		$this->ADORecordSet($queryID);
	}
	
	// _initrs modified to disable blob handling
	function _initrs()
	{
	global $ADODB_COUNTRECS;
		$this->_numOfRows = ($ADODB_COUNTRECS)? @pg_numrows($this->_queryID):-1;
		$this->_numOfFields = @pg_numfields($this->_queryID);
	}

}
?>

${this.title}

Code Editor : adodb-netezza.inc.php