Docs For Class DBLPGSQLQuery

Description

Class implementing PostgreSQL interface.

This class adds Postgres specific code to the DBLSQLQuery class.

NOTE: sequenceName is set by default to <sourceDef>_id_seq, as this is the default name PgSQL uses when using the serial column type.

Located in /DBLPGSQLQuery.php (line 20)

DBLQuery
   |
   --DBLSQLQuery
      |
      --DBLPGSQLQuery

Variable Summary

int $c

int $lastRes

int $numRows

int $rowCnt

Method Summary

DBLPGSQLQuery DBLPGSQLQuery (mixed &$def, mixed $sourceDef)

void buildLimitStatement ()

void connect ()

void error (string $text)

void execSQL (mixed $sql, [mixed $calledInternally = false])

void getNumRows ()

void lastInsertID ()

void nextRecord ()

void nextUniqueID ()

void noDeletedRecords ()

void noModifiedRecords ()

Variables

int $c (line 25)

var: Connection link identifier.

int $lastRes (line 29)

var: Last result identifier.

int $numRows (line 37)

var: Number of rows in the result. Used to cap rowCnt

int $rowCnt (line 33)

var: Current row. We need to have counter to be able to specify PGSQL_ASSOC :-/

Inherited Variables

Inherited from DBLSQLQuery

DBLSQLQuery::$generateUniqueID
DBLSQLQuery::$groupBy
DBLSQLQuery::$having
DBLSQLQuery::$idFieldName
DBLSQLQuery::$nextSearchSQL
DBLSQLQuery::$sequenceName
DBLSQLQuery::$where

Inherited from DBLQuery

DBLQuery::$conditions
DBLQuery::$def
DBLQuery::$fields
DBLQuery::$offset
DBLQuery::$orderDef
DBLQuery::$orderReferse
DBLQuery::$records
DBLQuery::$srcDef
DBLQuery::$values

Methods

Constructor DBLPGSQLQuery (line 40)

DBLPGSQLQuery DBLPGSQLQuery (mixed &$def, mixed $sourceDef)

buildLimitStatement (line 51)

void buildLimitStatement ()

Redefinition of:

DBLSQLQuery::buildLimitStatement(): Internal function to build limit statement.

connect (line 74)

Internal - connect if connection was not yet established.

void connect ()

error (line 64)

Internal - display SQL error.

void error (string $text)

string $text: Error text.

execSQL (line 93)

void execSQL (mixed $sql, [mixed $calledInternally = false])

Redefinition of:

DBLSQLQuery::execSQL(): Executes given SQL query.

getNumRows (line 159)

void getNumRows ()

lastInsertID (line 142)

void lastInsertID ()

Redefinition of:

DBLSQLQuery::lastInsertID(): Returns auto increment ID of the last inserted record.

nextRecord (line 120)

void nextRecord ()

Redefinition of:

DBLQuery::nextRecord(): Gets next record from a result set.

nextUniqueID (line 137)

void nextUniqueID ()

Redefinition of:

DBLSQLQuery::nextUniqueID(): Returns next ID.

noDeletedRecords (line 176)

void noDeletedRecords ()

Redefinition of:

DBLSQLQuery::noDeletedRecords(): Returns number of deleted records.

noModifiedRecords (line 169)

void noModifiedRecords ()

Redefinition of:

DBLSQLQuery::noModifiedRecords(): Returns number of modified records.

Inherited Methods

Inherited From DBLSQLQuery

DBLSQLQuery::DBLSQLQuery()
DBLSQLQuery::addCondition()
DBLSQLQuery::addRecord()
DBLSQLQuery::addSQLCondition()
DBLSQLQuery::buildLimitStatement()
DBLSQLQuery::buildSQL()
DBLSQLQuery::deleteRecord()
DBLSQLQuery::execSQL()
DBLSQLQuery::formatDateTime()
DBLSQLQuery::getDefaultDateTime()
DBLSQLQuery::getNoRows()
DBLSQLQuery::isEmptyDateTime()
DBLSQLQuery::lastInsertID()
DBLSQLQuery::modifyRecord()
DBLSQLQuery::nextUniqueID()
DBLSQLQuery::noDeletedRecords()
DBLSQLQuery::noModifiedRecords()
DBLSQLQuery::parseDateTime()
DBLSQLQuery::reset()
DBLSQLQuery::search()
DBLSQLQuery::setGroupBy()
DBLSQLQuery::setNextSearchSQL()
DBLSQLQuery::setOrder()

Inherited From DBLQuery

DBLQuery::DBLQuery()
DBLQuery::addCondition()
DBLQuery::addRecord()
DBLQuery::addValue()
DBLQuery::clearConditions()
DBLQuery::clearValues()
DBLQuery::deleteRecord()
DBLQuery::formatDateTime()
DBLQuery::getDefaultDateTime()
DBLQuery::isEmptyDateTime()
DBLQuery::modifyRecord()
DBLQuery::nextRecord()
DBLQuery::parseDateTime()
DBLQuery::reset()
DBLQuery::search()
DBLQuery::setFields()
DBLQuery::setLimit()
DBLQuery::setOrder()
DBLQuery::setSource()