Documentation TYPO3 par Ameos

Disponible dans d'autres versions de TYPO3 -> 3.7.0 3.8.1 4.0.0 4.0.1 4.1.0 <- Available in other TYPO3 versions

ADODB_postgres64 Class Reference

Inheritance diagram for ADODB_postgres64:

[legend]Collaboration diagram for ADODB_postgres64:


Public Member Functions
	ADODB_postgres64 ()
	ServerInfo ()
	IfNull ($field, $ifNull)
	pg_insert_id ($tablename, $fieldname)
	_insertid ($table, $column)
	_affectedrows ()
	BeginTrans ()
	RowLock ($tables, $where, $flds='1 as ignore')
	CommitTrans ($ok=true)
	RollbackTrans ()
&	MetaTables ($ttype=false, $showSchema=false, $mask=false)
	qstr ($s, $magic_quotes=false)
	SQLDate ($fmt, $col=false)
	UpdateBlobFile ($table, $column, $path, $where, $blobtype='BLOB')
	BlobDelete ($blob)
	GuessOID ($oid)
	BlobDecode ($blob, $maxsize=false, $hastrans=true)
	BlobEncode ($blob)
	_connect ($str, $user='', $pwd='', $db='', $ctype=0)
	_nconnect ($argHostname, $argUsername, $argPassword, $argDatabaseName)
	_pconnect ($str, $user='', $pwd='', $db='')
	_query ($sql, $inputarr)
	_errconnect ()
	ErrorMsg ()
	ErrorNo ()
	_close ()
	CharMax ()
	TextMax ()
Public Attributes
	$databaseType = 'postgres64'
	$dataProvider = 'postgres'
	$hasInsertID = true
	$_resultid = false
	$concat_operator = '\|\|'
	maximum size of blobs or large text fields (262144 = 256K)-- some db's die otherwise like foxpro
	$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"
	cache for 1 hour
	$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 = 'TRUE'
	used by DBTimeStamp as the default timestamp fmt.
	$false = 'FALSE'
	string that represents TRUE for a database
	$fmtDate = "'Y-m-d'"
	uppercase function
	$fmtTimeStamp = "'Y-m-d H: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
	$autoRollback = true
	random function
	$_bindInputArray = false
	A boolean variable to state whether its a persistent connection or normal connection. */.
	$disableBlobs = false
	$ADODB_FETCH_MODE = ADODB_FETCH_NUM
	$rs = $this->Execute(sprintf($sql,$table,$table,$schema))
	$indexes = array()
return	$indexes

Detailed Description

Definition at line 57 of file adodb-postgres64.inc.php.

Member Function Documentation

ADODB_postgres64::BeginTrans ( )

Begin a Transaction. Must be followed by CommitTrans() or RollbackTrans().

Returns:
true if succeeded or false if database does not support transactions

Reimplemented from ADOConnection.
Definition at line 173 of file adodb-postgres64.inc.php.
Referenced by RowLock().

ADODB_postgres64::CommitTrans ( $ ok = true )

If database does not support transactions, always return true as data always commited

Parameters:

$ok set to false to rollback transaction, true to commit

Returns:
true/false.

Reimplemented from ADOConnection.
Definition at line 187 of file adodb-postgres64.inc.php.
References RollbackTrans().

ADODB_postgres64::ErrorMsg ( )

Returns:
the last error message

Reimplemented from ADOConnection.
Definition at line 788 of file adodb-postgres64.inc.php.

ADODB_postgres64::ErrorNo ( )

Returns:
the last error number. Normally 0 means no error.

Reimplemented from ADOConnection.
Definition at line 807 of file adodb-postgres64.inc.php.
References ADOConnection::MetaError().

& ADODB_postgres64::MetaTables ( $ ttype = false,

$ showSchema = false,

$ mask = false

)

Parameters:

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

Returns:
array of tables for current database.

Reimplemented from ADOConnection.
Definition at line 204 of file adodb-postgres64.inc.php.
References ADOConnection::MetaTables(), qstr(), and ServerInfo().

ADODB_postgres64::qstr ( $ s,

$ magic_quotes = false

)

Correctly quotes a string so that all strings are escaped. We prefix and append to the string single-quotes. An example is $db->qstr("Don't bother",magic_quotes_runtime());

Parameters:

s the string to quote

[magic_quotes] if $s is GET/POST var, set to get_magic_quotes_gpc(). This undoes the stupidity of magic quotes for GPC.

Returns:
quoted string to be sent back to database

Reimplemented from ADOConnection.
Definition at line 237 of file adodb-postgres64.inc.php.
Referenced by MetaTables().

ADODB_postgres64::RollbackTrans ( )

If database does not support transactions, rollbacks always fail, so return false

Returns:
true/false.

Reimplemented from ADOConnection.
Definition at line 197 of file adodb-postgres64.inc.php.
Referenced by CommitTrans().

ADODB_postgres64::ServerInfo ( )

Get server version info...

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

Reimplemented from ADOConnection.
Definition at line 124 of file adodb-postgres64.inc.php.
References ADOConnection::_findvers(), and ADOConnection::GetOne().
Referenced by MetaTables().

ADODB_postgres64::UpdateBlobFile ( $ table,

$ column,

$ path,

$ where,

$ blobtype = 'BLOB'

)

Usage: UpdateBlob('TABLE', 'COLUMN', '/path/to/file', 'ID=1');
$blobtype supports 'BLOB' and 'CLOB'
$conn->Execute('INSERT INTO blobtable (id, blobcol) VALUES (1, null)'); $conn->UpdateBlob('blobtable','blobcol',$blobpath,'id=1');
Reimplemented from ADOConnection.
Definition at line 344 of file adodb-postgres64.inc.php.
References ADOConnection::UpdateBlob().

Member Data Documentation

ADODB_postgres64::$metaColumnsSQL

Initial value:
"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"

Reimplemented in ADODB_netezza.
Definition at line 74 of file adodb-postgres64.inc.php.

ADODB_postgres64::$metaColumnsSQL1

Initial value:
"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"

Reimplemented in ADODB_netezza.
Definition at line 80 of file adodb-postgres64.inc.php.

ADODB_postgres64::$metaKeySQL

Initial value:
"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'"

Reimplemented in ADODB_netezza.
Definition at line 88 of file adodb-postgres64.inc.php.

ADODB_postgres64::$metaTablesSQL

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

Reimplemented from ADOConnection.
Reimplemented in ADODB_netezza.
Definition at line 64 of file adodb-postgres64.inc.php.

The documentation for this class was generated from the following file:

typo3_src-4.0/typo3/sysext/adodb/adodb/drivers/adodb-postgres64.inc.php

Généré par TYPO3 Ameos avec doxygen

1.4.6

Documentation TYPO3 par Ameos

ADODB_postgres64 Class Reference

Public Member Functions

Public Attributes

Detailed Description

Member Function Documentation

Member Data Documentation