Class: ADODB_pdo_pgsql

Source Location: /includes/classes/adodb/drivers/adodb-pdo_pgsql.inc.php

Class Overview

ADOConnection
   |
   --ADODB_pdo
      |
      --ADODB_pdo_pgsql

Connection object. For connecting to databases, and executing queries.

Variables

Methods

Inherited Variables

Class: ADODB_pdo

ADODB_pdo::$databaseType
ADODB_pdo::$dataProvider
ADODB_pdo::$dsnType
ADODB_pdo::$replaceQuote
ADODB_pdo::$stmt
ADODB_pdo::$_autocommit
ADODB_pdo::$_bindInputArray
ADODB_pdo::$_errormsg
ADODB_pdo::$_errorno
ADODB_pdo::$_haserrorfunctions
ADODB_pdo::$_lastAffectedRows

Class: ADOConnection

ADOConnection::$ansiOuter
ADOConnection::$arrayClass
ADOConnection::$autoCommit
ADOConnection::$autoRollback
ADOConnection::$cacheSecs
ADOConnection::$charSet
ADOConnection::$database
ADOConnection::$debug
ADOConnection::$emptyDate
ADOConnection::$emptyTimeStamp
ADOConnection::$fetchMode
ADOConnection::$fnCacheExecute
ADOConnection::$fnExecute
ADOConnection::$genID
ADOConnection::$hasInsertID
ADOConnection::$hasTop
ADOConnection::$hasTransactions
ADOConnection::$host
ADOConnection::$lastInsID
ADOConnection::$leftOuter
ADOConnection::$length
ADOConnection::$maxblobsize
ADOConnection::$memCache
ADOConnection::$memCacheCompress
ADOConnection::$memCacheHost
ADOConnection::$memCachePort
ADOConnection::$nameQuote
ADOConnection::$noNullStrings
ADOConnection::$null2null
ADOConnection::$numCacheHits
ADOConnection::$numCacheMisses
ADOConnection::$pageExecuteCountRows
ADOConnection::$password
ADOConnection::$poorAffectedRows
ADOConnection::$raiseErrorFn
ADOConnection::$readOnly
ADOConnection::$rightOuter
ADOConnection::$rsPrefix
ADOConnection::$substr
ADOConnection::$transCnt
ADOConnection::$transOff
ADOConnection::$uniqueOrderBy
ADOConnection::$uniqueSort
ADOConnection::$upperCase
ADOConnection::$user
ADOConnection::$_affected
ADOConnection::$_connectionID
ADOConnection::$_errorCode
ADOConnection::$_errorMsg
ADOConnection::$_evalAll
ADOConnection::$_isPersistentConnection
ADOConnection::$_logsql
ADOConnection::$_oldRaiseFn
ADOConnection::$_queryID
ADOConnection::$_transmode
ADOConnection::$_transOK

Inherited Methods

Class: ADODB_pdo

ADODB_pdo::ADODB_pdo()
ADODB_pdo::BeginTrans()
ADODB_pdo::CommitTrans()
ADODB_pdo::ErrorMsg()
ADODB_pdo::ErrorNo()
ADODB_pdo::InParameter()
ADODB_pdo::MetaColumns()
ADODB_pdo::MetaTables()
ADODB_pdo::Prepare()
ADODB_pdo::PrepareStmt()
ADODB_pdo::RollbackTrans()
ADODB_pdo::SelectLimit()
ADODB_pdo::ServerInfo()
ADODB_pdo::Time()
ADODB_pdo::_affectedrows()
ADODB_pdo::_close()
ADODB_pdo::_connect()
ADODB_pdo::_insertid()
ADODB_pdo::_pconnect()
ADODB_pdo::_query()
ADODB_pdo::_UpdatePDO()

Class: ADOConnection

ADOConnection::ADOConnection(): Constructor
ADOConnection::addq(): Quotes a string, without prefixing nor appending quotes.
ADOConnection::Affected_Rows()
ADOConnection::AutoExecute()
ADOConnection::BeginTrans(): Begin a Transaction. Must be followed by CommitTrans() or RollbackTrans().
ADOConnection::BindDate()
ADOConnection::BindTimeStamp()
ADOConnection::BlobDecode()
ADOConnection::BlobEncode()
ADOConnection::CacheExecute(): Execute SQL, caching recordsets.
ADOConnection::CacheFlush(): Flush cached recordsets that match a particular $sql statement.
ADOConnection::CacheGetAll()
ADOConnection::CacheGetArray()
ADOConnection::CacheGetAssoc()
ADOConnection::CacheGetCol()
ADOConnection::CacheGetOne()
ADOConnection::CacheGetRow()
ADOConnection::CachePageExecute(): Will select the supplied $page number from a recordset, given that it is paginated in pages of $nrows rows per page. It also saves two boolean values saying if the given page is the first and/or last one of the recordset. Added by Iv�n Oliva to provide recordset pagination.
ADOConnection::CacheSelectLimit(): Will select, getting rows from $offset (1-based), for $nrows.
ADOConnection::Close(): Close Connection
ADOConnection::CommitLock()
ADOConnection::CommitTrans(): If database does not support transactions, always return true as data always commited
ADOConnection::CompleteTrans()
ADOConnection::Concat(): Different SQL databases used different methods to combine strings together.
ADOConnection::Connect(): Connect to database
ADOConnection::CreateSequence()
ADOConnection::DBDate(): Converts a date "d" to a string that the database can understand.
ADOConnection::DBTimeStamp(): Converts a timestamp "ts" to a string that the database can understand.
ADOConnection::Disconnect(): PEAR DB Compat - do not use internally
ADOConnection::DropSequence()
ADOConnection::ErrorMsg()
ADOConnection::ErrorNative(): PEAR DB Compat - do not use internally.
ADOConnection::ErrorNo()
ADOConnection::escape()
ADOConnection::Execute(): Execute SQL
ADOConnection::FailTrans()
ADOConnection::GenID(): Generates a sequence id and stores it in $this->genID; GenID is only available if $this->hasGenID = true;
ADOConnection::GetActiveRecords()
ADOConnection::GetActiveRecordsClass()
ADOConnection::GetAll()
ADOConnection::GetArray()
ADOConnection::GetAssoc()
ADOConnection::GetCharSet()
ADOConnection::GetCol()
ADOConnection::GetInsertSQL(): Generates an Insert Query based on an existing recordset.
ADOConnection::GetOne(): Return first element of first row of sql statement. Recordset is disposed for you.
ADOConnection::GetRandRow()
ADOConnection::GetRow(): Return one row of sql statement. Recordset is disposed for you.
ADOConnection::GetUpdateSQL(): Generates an Update Query based on an existing recordset.
ADOConnection::HasFailedTrans()
ADOConnection::IfNull()
ADOConnection::IgnoreErrors()
ADOConnection::InParameter()
ADOConnection::Insert_ID()
ADOConnection::IsConnected()
ADOConnection::LimitQuery(): PEAR DB Compat - do not use internally
ADOConnection::LogSQL()
ADOConnection::MetaColumnNames(): List columns names in a table as an array.
ADOConnection::MetaColumns(): List columns in a database as an array of ADOFieldObjects.
ADOConnection::MetaDatabases(): return the databases that the driver can connect to.
ADOConnection::MetaError()
ADOConnection::MetaErrorMsg()
ADOConnection::MetaForeignKeys()
ADOConnection::MetaIndexes(): List indexes on a table as an array.
ADOConnection::MetaPrimaryKeys()
ADOConnection::MetaTables()
ADOConnection::MetaTransaction()
ADOConnection::MetaType()
ADOConnection::NConnect(): Always force a new connection to database - currently only works with oracle
ADOConnection::nextId(): PEAR DB Compat - do not use internally.
ADOConnection::OffsetDate()
ADOConnection::outp(): All error messages go through this bottleneck function.
ADOConnection::OutParameter()
ADOConnection::PageExecute(): Will select the supplied $page number from a recordset, given that it is paginated in pages of $nrows rows per page. It also saves two boolean values saying if the given page is the first and/or last one of the recordset. Added by Iv�n Oliva to provide recordset pagination.
ADOConnection::Param()
ADOConnection::Parameter()
ADOConnection::PConnect(): Establish persistent connect to database
ADOConnection::PO_Insert_ID(): Portable Insert ID. Pablo Roca <pabloroca#mvps.org>
ADOConnection::Prepare(): Should prepare the sql statement and return the stmt resource.
ADOConnection::PrepareSP(): Some databases, eg. mssql require a different function for preparing stored procedures. So we cannot use Prepare().
ADOConnection::q()
ADOConnection::QMagic()
ADOConnection::qstr(): Correctly quotes a string so that all strings are escaped. We prefix and append to the string single-quotes.
ADOConnection::Query(): PEAR DB Compat - do not use internally.
ADOConnection::Quote(): PEAR DB Compat
ADOConnection::Replace(): Insert or replace a single record. Note: this is not the same as MySQL's replace.
ADOConnection::RollbackLock()
ADOConnection::RollbackTrans(): If database does not support transactions, rollbacks always fail, so return false
ADOConnection::RowLock(): Lock a row, will escalate and lock the table if row locking not supported will normally free the lock at the end of the transaction
ADOConnection::SelectDB(): Choose a database to connect to. Many databases do not support this.
ADOConnection::SelectLimit(): Will select, getting rows from $offset (1-based), for $nrows.
ADOConnection::SerializableRS(): Create serializable recordset. Breaks rs link to connection.
ADOConnection::ServerInfo()
ADOConnection::SetCharSet()
ADOConnection::SetDateLocale(): Change the SQL connection locale to a specified locale.
ADOConnection::SetFetchMode(): PEAR DB Compat - do not use internally.
ADOConnection::SetTransactionMode()
ADOConnection::SQLDate()
ADOConnection::StartTrans()
ADOConnection::Time()
ADOConnection::Transpose()
ADOConnection::UnixDate(): Also in ADORecordSet.
ADOConnection::UnixTimeStamp(): Also in ADORecordSet.
ADOConnection::UpdateBlob(): Update a blob column, given a where clause. There are more sophisticated blob handling functions that we could have implemented, but all require a very complex API. Instead we have chosen something that is extremely simple to understand and use.
ADOConnection::UpdateBlobFile(): Usage: UpdateBlob('TABLE', 'COLUMN', '/path/to/file', 'ID=1');
ADOConnection::UpdateClob(): Usage: UpdateClob('TABLE', 'COLUMN', $var, 'ID=1', 'CLOB');
ADOConnection::UserDate(): Also in ADORecordSet.
ADOConnection::UserTimeStamp()
ADOConnection::Version()
ADOConnection::xCacheFlush()
ADOConnection::_dirFlush(): Private function to erase all of the files and subdirectories in a directory.
ADOConnection::_Execute()
ADOConnection::_findschema()
ADOConnection::_findvers()
ADOConnection::_gencachename(): Private function to generate filename for caching.
ADOConnection::_nconnect()
ADOConnection::_rs2rs(): Convert database recordset to an array recordset input recordset's cursor should be at beginning, and old $rs will be closed.

Class Details

[line 12]
Connection object. For connecting to databases, and executing queries.

[ Top ]

Class Variables

$blobEncodeType = 'C'

[line 23]

Type:	mixed
Overrides:	Array

[ Top ]

$concat_operator = '||'

[line 55]

Type:	mixed
Overrides:	Array

[ Top ]

$false = 'f'

[line 45]

Type:	mixed
Overrides:	Array

[ Top ]

$fmtDate = "'Y-m-d'"

[line 46]

Type:	mixed
Overrides:	Array

[ Top ]

$fmtTimeStamp = "'Y-m-d G:i:s'"

[line 47]

Type:	mixed
Overrides:	Array

[ Top ]

$hasAffectedRows = true

[line 41]

Type:	mixed
Overrides:	Array

[ Top ]

$hasGenID = true

[line 49]

Type:	mixed
Overrides:	Array

[ Top ]

$hasLimit = false

[line 42]

Type:	mixed
Overrides:	Array

[ Top ]

$hasMoveFirst = true

[line 48]

Type:	mixed
Overrides:	Array

[ Top ]

$isoDates = true

[line 20]

Type:	mixed
Overrides:	Array

[ Top ]

$metaColumnsSQL = "SELECT a.attname,t.typname,a.attlen,a.atttypmod,a.attnotnull,a.atthasdef,a.attnum
FROM pg_class c, pg_attribute a,pg_type t
WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s')) and a.attname not like '....%%'
AND a.attnum > 0 AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum"

[line 24]

Type:

mixed

[ Top ]

$metaColumnsSQL1 = "SELECT a.attname, t.typname, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, a.attnum
FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n
WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s'))
and c.relnamespace=n.oid and n.nspname='%s'
and a.attname not like '....%%' AND a.attnum > 0
AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum"

[line 30]

Type:

mixed

[ Top ]

$metaDatabasesSQL = "select datname from pg_database where datname not in ('template0','template1') order by 1"

[line 13]

Type:	mixed
Overrides:	Array

[ Top ]

$metaDefaultsSQL = "SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='%s' order by d.adnum"

[line 53]

Type:

mixed

[ Top ]

$metaKeySQL = "SELECT ic.relname AS index_name, a.attname AS column_name,i.indisunique AS unique_key, i.indisprimary AS primary_key
FROM pg_class bc, pg_class ic, pg_index i, pg_attribute a WHERE bc.oid = i.indrelid AND ic.oid = i.indexrelid AND (i.indkey[0] = a.attnum OR i.indkey[1] = a.attnum OR i.indkey[2] = a.attnum OR i.indkey[3] = a.attnum OR i.indkey[4] = a.attnum OR i.indkey[5] = a.attnum OR i.indkey[6] = a.attnum OR i.indkey[7] = a.attnum) AND a.attrelid = bc.oid AND bc.relname = '%s'"

[line 38]

Type:

mixed

[ Top ]

$metaTablesSQL = "select tablename,'T' from pg_tables where tablename not like 'pg\_%'
   and tablename not in ('sql_features', 'sql_implementation_info', 'sql_languages',
    'sql_packages', 'sql_sizing', 'sql_sizing_profiles')
   union
        select viewname,'V' from pg_views where viewname not like 'pg\_%'"

[line 14]

Type:	mixed
Overrides:	Array

[ Top ]

$random = 'random()'

[line 54]

Type:	mixed
Overrides:	Array

[ Top ]

$sysDate = "CURRENT_DATE"

[line 21]

Type:	mixed
Overrides:	Array

[ Top ]

$sysTimeStamp = "CURRENT_TIMESTAMP"

[line 22]

Type:	mixed
Overrides:	Array

[ Top ]

$true = 't'

[line 44]

Type:	mixed
Overrides:	Array

[ Top ]

$_dropSeqSQL = "DROP SEQUENCE %s"

[line 52]

Type:

mixed

[ Top ]

$_genIDSQL = "SELECT NEXTVAL('%s')"

[line 50]

Type:

mixed

[ Top ]

$_genSeqSQL = "CREATE SEQUENCE %s START %s"

[line 51]

Type:	mixed
Overrides:	Array

[ Top ]

Class Methods

method MetaColumns [line 115]

void &MetaColumns(

$table, [
$normalize = true])

Overrides ADODB_pdo::MetaColumns() (parent method not documented)

Parameters:

	$table
	$normalize

[ Top ]

method MetaTables [line 84]

void &MetaTables(
[
$ttype = false], [
$showSchema = false], [
$mask = false])

Overrides ADODB_pdo::MetaTables() (parent method not documented)

Parameters:

	$ttype
	$showSchema
	$mask

[ Top ]

method SelectLimit [line 72]

void &SelectLimit(

$sql, [
$nrows = -1], [
$offset = -1], [
$inputarr = false], [
$secs2cache = 0])

Overrides ADODB_pdo::SelectLimit() (parent method not documented)

Parameters:

	$sql
	$nrows
	$offset
	$inputarr
	$secs2cache

[ Top ]

method ServerInfo [line 65]

void ServerInfo(
)

Overrides ADODB_pdo::ServerInfo() (parent method not documented)

[ Top ]

method _init [line 57]

void _init(

$parentDriver)

Parameters:

$parentDriver

[ Top ]

Documentation generated on Fri, 18 Jul 2008 21:41:21 +0200 by phpDocumentor 1.4.1

Class: ADODB_pdo_pgsql

Class Overview

Variables

Methods

Inherited Variables

Class: ADODB_pdo

Class: ADOConnection

Inherited Methods

Class: ADODB_pdo

Class: ADOConnection

Class Details

Class Variables

$blobEncodeType = 'C'

$concat_operator = '||'

$false = 'f'

$fmtDate = "'Y-m-d'"

$fmtTimeStamp = "'Y-m-d G:i:s'"

$hasAffectedRows = true

$hasGenID = true

$hasLimit = false

$hasMoveFirst = true

$isoDates = true

$metaDatabasesSQL = "select datname from pg_database where datname not in ('template0','template1') order by 1"

$metaDefaultsSQL = "SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='%s' order by d.adnum"

$metaTablesSQL = "select tablename,'T' from pg_tables where tablename not like 'pg\_%' and tablename not in ('sql_features', 'sql_implementation_info', 'sql_languages', 'sql_packages', 'sql_sizing', 'sql_sizing_profiles') union select viewname,'V' from pg_views where viewname not like 'pg\_%'"

$random = 'random()'

$sysDate = "CURRENT_DATE"

$sysTimeStamp = "CURRENT_TIMESTAMP"

$true = 't'

$_dropSeqSQL = "DROP SEQUENCE %s"

$_genIDSQL = "SELECT NEXTVAL('%s')"

$_genSeqSQL = "CREATE SEQUENCE %s START %s"

Class Methods

method MetaColumns [line 115]

Parameters:

method MetaTables [line 84]

Parameters:

method SelectLimit [line 72]

Parameters:

method ServerInfo [line 65]

method _init [line 57]

Parameters:

$metaTablesSQL = "select tablename,'T' from pg_tables where tablename not like 'pg\_%'
and tablename not in ('sql_features', 'sql_implementation_info', 'sql_languages',
'sql_packages', 'sql_sizing', 'sql_sizing_profiles')
union
select viewname,'V' from pg_views where viewname not like 'pg\_%'"