Docs For Class pgsqlDbConnection

Description

Located in /plugins/db/pgsql/pgsql.dbconnection.php (line 27)

jDbConnection
   |
   --pgsqlDbConnection

Variable Summary

mixed $_charsets

Method Summary

pgsqlDbConnection __construct ( $profile)

void __destruct ()

void beginTransaction ()

void commit ()

string encloseName (string $fieldName)

void errorCode ()

void errorInfo ()

string getAttribute (integer $id)

void lastInsertId ([ $seqname = ''])

void prepare ( $query)

void rollback ()

void setAttribute (integer $id, string $value)

void _autoCommitNotify ( $state)

void _connect ()

void _disconnect ()

void _doExec ( $query)

void _doLimitQuery ( $queryString, $offset, $number)

void _doQuery ( $queryString)

void _quote ( $text, $binary)

Variables

mixed $_charsets = array( 'UTF-8'=>'UNICODE', 'ISO-8859-1'=>'LATIN1') (line 28)

access: protected

Inherited Variables

Inherited from jDbConnection

jDbConnection::$dbms
jDbConnection::$driverName
jDbConnection::$lastQuery
jDbConnection::$msgError
jDbConnection::$profile
jDbConnection::$_connection
jDbConnection::$_schema
jDbConnection::$_tools

Methods

Constructor __construct (line 30)

pgsqlDbConnection __construct ( $profile)

$profile

Redefinition of:

jDbConnection::__construct(): do a connection to the database, using properties of the given profile

Destructor __destruct (line 55)

void __destruct ()

Redefinition of:

jDbConnection::__destruct()

beginTransaction (line 62)

access: public

void beginTransaction ()

Redefinition of:

jDbConnection::beginTransaction(): begin a transaction. Call it before query, limitQuery, exec

commit (line 66)

access: public

void commit ()

Redefinition of:

jDbConnection::commit(): validate all queries and close a transaction

encloseName (line 51)

enclose the field name

return: the enclosed field name
since: 1.1.1
access: public

string encloseName (string $fieldName)

string $fieldName: the field name

Redefinition of:

jDbConnection::encloseName(): enclose the field name

errorCode (line 89)

access: public

void errorCode ()

Redefinition of:

jDbConnection::errorCode()

errorInfo (line 85)

access: public

void errorInfo ()

Redefinition of:

jDbConnection::errorInfo()

getAttribute (line 213)

return: the attribute value
see: PDO::getAttribute()
access: public

string getAttribute (integer $id)

integer $id: the attribut id

Redefinition of:

jDbConnection::getAttribute()

lastInsertId (line 175)

access: public

void lastInsertId ([ $seqname = ''])

$seqname

Redefinition of:

jDbConnection::lastInsertId(): return the id value of the last inserted row.

prepare (line 74)

access: public

void prepare ( $query)

$query

Redefinition of:

jDbConnection::prepare(): prepare a query

rollback (line 70)

access: public

void rollback ()

Redefinition of:

jDbConnection::rollback(): cancel all queries of a transaction and close the transaction

setAttribute (line 231)

see: PDO::setAttribute()
access: public

void setAttribute (integer $id, string $value)

integer $id: the attribut id
string $value: the attribute value

Redefinition of:

jDbConnection::setAttribute()

_autoCommitNotify (line 194)

access: protected

void _autoCommitNotify ( $state)

$state

Redefinition of:

jDbConnection::_autoCommitNotify(): Notify the changes on autocommit

_connect (line 93)

access: protected

void _connect ()

Redefinition of:

jDbConnection::_connect(): return a connection identifier or false/null if there is an error

_disconnect (line 144)

access: protected

void _disconnect ()

Redefinition of:

jDbConnection::_disconnect(): do a disconnection

_doExec (line 159)

access: protected

void _doExec ( $query)

$query

Redefinition of:

jDbConnection::_doExec(): do a query which return nothing

_doLimitQuery (line 166)

access: protected

void _doLimitQuery ( $queryString, $offset, $number)

$queryString
$offset
$number

Redefinition of:

jDbConnection::_doLimitQuery(): do a query which return a limited number of results

_doQuery (line 148)

access: protected

void _doQuery ( $queryString)

$queryString

Redefinition of:

jDbConnection::_doQuery(): do a query which return results

_quote (line 199)

access: protected

void _quote ( $text, $binary)

$text
$binary

Redefinition of:

jDbConnection::_quote(): do the escaping of a string.

Inherited Methods

Inherited From jDbConnection

jDbConnection::__construct()
jDbConnection::beginTransaction()
jDbConnection::commit()
jDbConnection::encloseFieldName()
jDbConnection::encloseName()
jDbConnection::errorCode()
jDbConnection::errorInfo()
jDbConnection::exec()
jDbConnection::getAttribute()
jDbConnection::hasTablePrefix()
jDbConnection::lastIdInTable()
jDbConnection::lastInsertId()
jDbConnection::limitQuery()
jDbConnection::prefixTable()
jDbConnection::prepare()
jDbConnection::query()
jDbConnection::quote()
jDbConnection::quote2()
jDbConnection::rollback()
jDbConnection::schema()
jDbConnection::setAttribute()
jDbConnection::setAutoCommit()
jDbConnection::tools()
jDbConnection::_autoCommitNotify()
jDbConnection::_connect()
jDbConnection::_disconnect()
jDbConnection::_doExec()
jDbConnection::_doLimitQuery()
jDbConnection::_doQuery()
jDbConnection::_quote()
jDbConnection::__destruct()

Class Constants

Inherited Constants

Inherited from jDbConnection

jDbConnection::ATTR_AUTOCOMMIT
jDbConnection::ATTR_CASE
jDbConnection::ATTR_CLIENT_VERSION
jDbConnection::ATTR_CONNECTION_STATUS
jDbConnection::ATTR_CURSOR
jDbConnection::ATTR_DRIVER_NAME
jDbConnection::ATTR_ERRMODE
jDbConnection::ATTR_ORACLE_NULLS
jDbConnection::ATTR_PERSISTENT
jDbConnection::ATTR_PREFETCH
jDbConnection::ATTR_SERVER_INFO
jDbConnection::ATTR_SERVER_VERSION
jDbConnection::ATTR_TIMEOUT
jDbConnection::CURSOR_FWDONLY
jDbConnection::CURSOR_SCROLL
jDbConnection::FETCH_CLASS
jDbConnection::FETCH_INTO
jDbConnection::FETCH_OBJ