Proyectos de Subversion Moodle

<?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);

	}

}