Solutions Open Source

Référence de la classe ADODB_pdo_pgsql

Graphe d'héritage de ADODB_pdo_pgsql:

[légende]

Graphe de collaboration de ADODB_pdo_pgsql:

[légende]

Liste de tous les membres

Fonctions membres publiques

_init ($parentDriver)

ServerInfo ()

& SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)

& MetaTables ($ttype=false, $showSchema=false, $mask=false)

& MetaColumns ($table, $normalize=true)

Attributs publics

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

character set to use - only for interbase, postgres and oci8

$metaTablesSQL

$isoDates = true

error function to call

$sysDate = "CURRENT_DATE"

Use 'true' to store the item compressed (uses zlib).

$sysTimeStamp = "CURRENT_TIMESTAMP"

name of function that returns the current date

$blobEncodeType = 'C'

$metaColumnsSQL

$metaColumnsSQL1

$metaKeySQL

$hasAffectedRows = true

supports autoincrement ID?

$hasLimit = false

support mssql/access SELECT TOP 10 * FROM TABLE

$true = 't'

used by DBTimeStamp as the default timestamp fmt.

$false = 'f'

string that represents TRUE for a database

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

uppercase function

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

used by DBDate() as the default date format used by the database

$hasMoveFirst = true

this is a readonly database - used by phpLens

$hasGenID = true

has ability to run MoveFirst(), scrolling backwards

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

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

$_dropSeqSQL = "DROP SEQUENCE %s"

$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"

$random = 'random()'

string length ofperator

$concat_operator = '||'

random function

Documentation des fonctions membres

ADODB_pdo_pgsql::_init ( $ parentDriver )

ADODB_pdo_pgsql::ServerInfo ( )

Get server version info...

Renvoie:: An array with 2 elements: $arr['string'] is the description string, and $arr[version] is the version (also a string).

Réimplémentée à partir de ADODB_pdo.

& ADODB_pdo_pgsql::SelectLimit	(	$	sql,
		$	nrows = `-1`,
		$	offset = `-1`,
		$	inputarr = `false`,
		$	secs2cache = `0`
	)

Will select, getting rows from $offset (1-based), for $nrows. This simulates the MySQL "select * from table limit $offset,$nrows" , and the PostgreSQL "select * from table limit $nrows offset $offset". Note that MySQL and PostgreSQL parameter ordering is the opposite of the other. eg. SelectLimit('select * from table',3); will return rows 1 to 3 (1-based) SelectLimit('select * from table',3,2); will return rows 3 to 5 (1-based)

Uses SELECT TOP for Microsoft databases (when $this->hasTop is set) BUG: Currently SelectLimit fails with $sql with LIMIT or TOP clause already set

Paramètres:

	sql
	[offset]	is the row to start calculations from (1-based)
	[nrows]	is the number of rows to get
	[inputarr]	array of bind variables
	[secs2cache]	is a private parameter only used by jlim

Renvoie:: the recordset ($rs->databaseType == 'array')

Réimplémentée à partir de ADODB_pdo.

& ADODB_pdo_pgsql::MetaTables	(	$	ttype = `false`,
		$	showSchema = `false`,
		$	mask = `false`
	)

Paramètres:

	ttype	can either be 'VIEW' or 'TABLE' or false. If false, both views and tables are returned. "VIEW" returns only views "TABLE" returns only tables
	showSchema	returns the schema/user with the table name, eg. USER.TABLE
	mask	is the input mask - only supported by oci8 and postgresql

Renvoie:: array of tables for current database.

Réimplémentée à partir de ADODB_pdo.

& ADODB_pdo_pgsql::MetaColumns	(	$	table,
		$	normalize = `true`
	)

List columns in a database as an array of ADOFieldObjects. See top of file for definition of object.

Paramètres:

	$table	table name to query
	$normalize	makes table name case-insensitive (required by some databases) is optional database schema to use - not supported by all databases.

Renvoie:: array of ADOFieldObjects for current table.

Réimplémentée à partir de ADODB_pdo.

Documentation des données membres

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

character set to use - only for interbase, postgres and oci8

Réimplémentée à partir de ADOConnection.

ADODB_pdo_pgsql::$metaTablesSQL

Valeur initiale :

 "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\_%'"

Réimplémentée à partir de ADOConnection.

ADODB_pdo_pgsql::$isoDates = true

error function to call

Réimplémentée à partir de ADOConnection.

ADODB_pdo_pgsql::$sysDate = "CURRENT_DATE"

Use 'true' to store the item compressed (uses zlib).

Réimplémentée à partir de ADOConnection.

ADODB_pdo_pgsql::$sysTimeStamp = "CURRENT_TIMESTAMP"

name of function that returns the current date

Réimplémentée à partir de ADOConnection.

ADODB_pdo_pgsql::$blobEncodeType = 'C'

Réimplémentée à partir de ADOConnection.

ADODB_pdo_pgsql::$metaColumnsSQL

Valeur initiale :

 "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"

ADODB_pdo_pgsql::$metaColumnsSQL1

Valeur initiale :

 "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"

ADODB_pdo_pgsql::$metaKeySQL

Valeur initiale :

 "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'"

ADODB_pdo_pgsql::$hasAffectedRows = true

supports autoincrement ID?

Réimplémentée à partir de ADODB_pdo.

ADODB_pdo_pgsql::$hasLimit = false

support mssql/access SELECT TOP 10 * FROM TABLE

Réimplémentée à partir de ADOConnection.

ADODB_pdo_pgsql::$true = 't'

used by DBTimeStamp as the default timestamp fmt.

Réimplémentée à partir de ADOConnection.

ADODB_pdo_pgsql::$false = 'f'

string that represents TRUE for a database

Réimplémentée à partir de ADOConnection.

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

uppercase function

Réimplémentée à partir de ADODB_pdo.

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

used by DBDate() as the default date format used by the database

Réimplémentée à partir de ADODB_pdo.

ADODB_pdo_pgsql::$hasMoveFirst = true

this is a readonly database - used by phpLens

Réimplémentée à partir de ADOConnection.

ADODB_pdo_pgsql::$hasGenID = true

has ability to run MoveFirst(), scrolling backwards

Réimplémentée à partir de ADOConnection.

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

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

Réimplémentée à partir de ADODB_pdo.

ADODB_pdo_pgsql::$_dropSeqSQL = "DROP SEQUENCE %s"

ADODB_pdo_pgsql::$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"

ADODB_pdo_pgsql::$random = 'random()'

string length ofperator

Réimplémentée à partir de ADOConnection.

ADODB_pdo_pgsql::$concat_operator = '||'

random function

Réimplémentée à partir de ADOConnection.

La documentation de cette classe a été générée à partir du fichier suivant :

Z:/doxygen/typo3_src-4.1.2/typo3/sysext/adodb/adodb/drivers/adodb-pdo_pgsql.inc.php

Généré le Fri Aug 31 11:40:02 2007 pour OBLADY - Typo3 API v4.1.2 par

1.5.3


Fonctions membres publiques
	_init ($parentDriver)
	ServerInfo ()
&	SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
&	MetaTables ($ttype=false, $showSchema=false, $mask=false)
&	MetaColumns ($table, $normalize=true)
Attributs publics
	$metaDatabasesSQL = "select datname from pg_database where datname not in ('template0','template1') order by 1"
	character set to use - only for interbase, postgres and oci8
	$metaTablesSQL
	$isoDates = true
	error function to call
	$sysDate = "CURRENT_DATE"
	Use 'true' to store the item compressed (uses zlib).
	$sysTimeStamp = "CURRENT_TIMESTAMP"
	name of function that returns the current date
	$blobEncodeType = 'C'
	$metaColumnsSQL
	$metaColumnsSQL1
	$metaKeySQL
	$hasAffectedRows = true
	supports autoincrement ID?
	$hasLimit = false
	support mssql/access SELECT TOP 10 * FROM TABLE
	$true = 't'
	used by DBTimeStamp as the default timestamp fmt.
	$false = 'f'
	string that represents TRUE for a database
	$fmtDate = "'Y-m-d'"
	uppercase function
	$fmtTimeStamp = "'Y-m-d G:i:s'"
	used by DBDate() as the default date format used by the database
	$hasMoveFirst = true
	this is a readonly database - used by phpLens
	$hasGenID = true
	has ability to run MoveFirst(), scrolling backwards
	$_genIDSQL = "SELECT NEXTVAL('%s')"
	$_genSeqSQL = "CREATE SEQUENCE %s START %s"
	$_dropSeqSQL = "DROP SEQUENCE %s"
	$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"
	$random = 'random()'
	string length ofperator
	$concat_operator = '\|\|'
	random function