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

Documentation generated on Mon, 26 Oct 2015 21:58:03 +0100 by phpDocumentor 1.4.3