eZPublish  3.9
eZPostgreSQLDB Class Reference

The eZPostgreSQLDB class provides PostgreSQL database functions. More...

+ Inheritance diagram for eZPostgreSQLDB:
+ Collaboration diagram for eZPostgreSQLDB:

Public Member Functions

 arrayQuery ($sql, $params=array(), $server=false)
 
 beginQuery ()
 
 bindingType ()
 
 bindVariable (&$value, $fieldDef=false)
 
 close ()
 
 commitQuery ()
 
 concatString ($strings=array())
 
 correctSequenceValues ()
 
 databaseName ()
 
 databaseServerVersion ()
 
 escapeString ($str)
 
 eZPostgreSQLDB ($parameters)
 
 eZTableList ($server=EZ_DB_SERVER_MASTER)
 
 isCharsetSupported ($charset)
 
 lastSerialID ($table, $column= 'id')
 
 lock ($table)
 
 md5 ($str)
 
 query ($sql, $server=false)
 
 relationCount ($relationType=EZ_DB_RELATION_TABLE)
 
 relationCounts ($relationMask)
 
 relationList ($relationType=EZ_DB_RELATION_TABLE)
 
 relationMatchRegexp ($relationType)
 
 removeRelation ($relationName, $relationType)
 
 rollbackQuery ()
 
 setError ()
 
 supportedRelationTypeMask ()
 
 supportedRelationTypes ()
 
 unlock ()
 
- Public Member Functions inherited from eZDBInterface
attribute ($name)
 
 attributes ()
 
 availableDatabases ()
 
 begin ()
 
 beginQuery ()
 
 bindVariable ($value, $fieldDef=false)
 
 bitAnd ($arg1, $arg2)
 
 bitOr ($arg1, $arg2)
 
 charset ()
 
 checkCharset ($charset, &$currentCharset)
 
 commit ()
 
 commitQuery ()
 
 connectRetryCount ()
 
 connectRetryWaitTime ()
 
 createDatabase ()
 
 createTempTable ($createTableQuery= '', $server=EZ_DB_SERVER_SLAVE)
 
 databaseClientVersion ()
 
 databaseServerVersion ()
 
 dropTempTable ($dropTableQuery= '', $server=EZ_DB_SERVER_SLAVE)
 
 dropTempTableList ($tableList, $server=EZ_DB_SERVER_SLAVE)
 
 errorMessage ()
 
 errorNumber ()
 
 eZDBInterface ($parameters)
 
 generateFailedTransactionStack ()
 
 generateUniqueTempTableName ($pattern, $randomizeIndex=false, $server=EZ_DB_SERVER_SLAVE)
 
 hasAttribute ($name)
 
 hasRequiredServerVersion ($minVersion, $name=false)
 
 implodeWithTypeCast ($glue, &$pieces, $type)
 
 insertFile ($path, $sqlFile, $usePathType=true)
 
 invalidateTransaction ()
 
 isCharsetSupported ($charset)
 
 isTransactionValid ()
 
 rollback ()
 
 rollbackQuery ()
 
 setIsSQLOutputEnabled ($enabled)
 
 socketPath ()
 
 transactionCounter ()
 
 usesBuiltinEncoding ()
 
 useShortNames ()
 
 version ()
 

Private Member Functions

 relationKind ($relationType)
 
 subString ($string, $from, $len=null)
 

Additional Inherited Members

- Protected Member Functions inherited from eZDBInterface
 isConnected ()
 
 relationName ($relationType)
 
 reportError ()
 
- Protected Attributes inherited from eZDBInterface
 $Charset
 The charset used for the current database. More...
 
 $ConnectRetries
 The number of times to retry a connection if it fails. More...
 
 $DB
 The current database name. More...
 
 $DBConnection
 The current connection, false if not connection has been made. More...
 
 $DBWriteConnection
 Contains the write database connection if used. More...
 
 $EndTime
 The end time of the tiemr. More...
 
 $ErrorMessage
 The database error message of the last executed function. More...
 
 $ErrorNumber = 0
 The database error message number of the last executed function. More...
 
 $InputTextCodec
 
 $IsConnected = false
 Contains true if we're connected to the database backend. More...
 
 $NumQueries = 0
 Contains number of queries sended to DB. More...
 
 $OutputSQL
 Setting if SQL queries should be sent to debug output. More...
 
 $OutputTextCodec
 Instance of a textcodec which handles text conversion, may not be set if no builtin encoding is used. More...
 
 $Password
 Stores the database connection password. More...
 
 $RecordError = true
 If true then ErrorMessage and ErrorNumber get filled. More...
 
 $Server
 Contains the current server. More...
 
 $SlaveDB
 The slave database name. More...
 
 $SlavePassword
 The slave database user password. More...
 
 $SlaveServer
 The slave server name. More...
 
 $SlaveUser
 The slave database user. More...
 
 $SocketPath
 The socket path, used by MySQL. More...
 
 $StartTime
 The start time of the timer. More...
 
 $TimeTaken
 The total number of milliseconds the timer took. More...
 
 $TransactionCounter
 The transaction counter, 0 means no transaction. More...
 
 $TransactionIsValid
 Flag which tells if a transaction is considered valid or not A transaction will be made invalid if SQL errors occur. More...
 
 $UseBuiltinEncoding
 True if a builtin encoder is to be used, this means that all input/output text is converted. More...
 
 $UsePersistentConnection = false
 If true then the database connection should be persistent. More...
 
 $User
 Stores the database connection user. More...
 
 $UserSlaveServer
 Contains true if slave servers are enabled. More...
 

Detailed Description

The eZPostgreSQLDB class provides PostgreSQL database functions.

eZPostgreSQLDB implementes PostgreSQLDB specific database code.

See Also
eZDB

Member Function Documentation

eZPostgreSQLDB::arrayQuery (   $sql,
  $params = array(),
  $server = false 
)
virtual
eZPostgreSQLDB::beginQuery ( )

The query to start the transaction.

eZPostgreSQLDB::bindingType ( )
virtual

Implements eZDBInterface.

eZPostgreSQLDB::bindVariable ( $value,
  $fieldDef = false 
)
eZPostgreSQLDB::close ( )
virtual

Implements eZDBInterface.

eZPostgreSQLDB::commitQuery ( )

The query to commit the transaction.

eZPostgreSQLDB::concatString (   $strings = array())
virtual
Returns
a sql-expression(string) to concatenate strings.

Implements eZDBInterface.

eZPostgreSQLDB::correctSequenceValues ( )

Sets PostgreSQL sequence values to the maximum values used in the corresponding columns.

eZPostgreSQLDB::databaseName ( )
virtual

Implements eZDBInterface.

eZPostgreSQLDB::databaseServerVersion ( )
eZPostgreSQLDB::escapeString (   $str)
virtual

Implements eZDBInterface.

eZPostgreSQLDB::eZPostgreSQLDB (   $parameters)

Creates a new eZPostgreSQLDB object and connects to the database.

eZPostgreSQLDB::eZTableList (   $server = EZ_DB_SERVER_MASTER)
virtual

Implements eZDBInterface.

eZPostgreSQLDB::isCharsetSupported (   $charset)
eZPostgreSQLDB::lastSerialID (   $table,
  $column = 'id' 
)
virtual

Implements eZDBInterface.

eZPostgreSQLDB::lock (   $table)
virtual

Implements eZDBInterface.

eZPostgreSQLDB::md5 (   $str)
virtual
Returns
a sql-expression(string) to generate a md5 sum of the string.

Implements eZDBInterface.

eZPostgreSQLDB::query (   $sql,
  $server = false 
)
virtual
eZPostgreSQLDB::relationCount (   $relationType = EZ_DB_RELATION_TABLE)
virtual

Implements eZDBInterface.

eZPostgreSQLDB::relationCounts (   $relationMask)
virtual

Implements eZDBInterface.

eZPostgreSQLDB::relationKind (   $relationType)
private
eZPostgreSQLDB::relationList (   $relationType = EZ_DB_RELATION_TABLE)
virtual

Implements eZDBInterface.

eZPostgreSQLDB::relationMatchRegexp (   $relationType)
virtual

Implements eZDBInterface.

eZPostgreSQLDB::removeRelation (   $relationName,
  $relationType 
)
virtual

Implements eZDBInterface.

eZPostgreSQLDB::rollbackQuery ( )

The query to cancel the transaction.

eZPostgreSQLDB::setError ( )
virtual

Implements eZDBInterface.

Referenced by query().

eZPostgreSQLDB::subString (   $string,
  $from,
  $len = null 
)
privatevirtual
Returns
a sql-expression(string) to get substring.

Implements eZDBInterface.

eZPostgreSQLDB::supportedRelationTypeMask ( )
virtual

Implements eZDBInterface.

eZPostgreSQLDB::supportedRelationTypes ( )
virtual

Implements eZDBInterface.

Referenced by relationCounts().

eZPostgreSQLDB::unlock ( )
virtual

Implements eZDBInterface.


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