Class: DBPostgres

Source Location: /adapter/DBPostgres.php

Class Overview

DBAdapter
   |
   --DBPostgres

This is used to connect to PostgresQL databases.

Author(s):

Hakan Tandogan <hakan42@gmx.de> (Torque)
Hans Lellelid <hans@xmpl.org> (Propel)

Version:

$Revision: 563 $

Methods

Inherited Constants

Class: DBAdapter

DBAdapter::ID_METHOD_AUTOINCREMENT
DBAdapter::ID_METHOD_NONE
DBAdapter::ID_METHOD_SEQUENCE

Inherited Methods

Class: DBAdapter

DBAdapter::applyLimit(): Modifies the passed-in SQL to add LIMIT and/or OFFSET.
DBAdapter::concatString(): Returns SQL which concatenates the second string to the first.
DBAdapter::factory(): Creates a new instance of the database adapter associated with the specified Creole driver.
DBAdapter::getDateFormatter(): Returns date formatter string for use in date() function.
DBAdapter::getId(): Gets the generated ID (either last ID for autoincrement or next sequence ID).
DBAdapter::getIdMethod(): Returns the native ID method for this RDBMS.
DBAdapter::getStringDelimiter(): Returns the character used to indicate the beginning and end of a piece of text used in a SQL statement (generally a single quote).
DBAdapter::getTimeFormatter(): Returns time formatter string for use in date() function.
DBAdapter::getTimestampFormatter(): Returns timestamp formatter string for use in date() function.
DBAdapter::ignoreCase(): This method is used to ignore case.
DBAdapter::ignoreCaseInOrderBy(): This method is used to ignore case in an ORDER BY clause.
DBAdapter::initConnection(): This method is called after a connection was created to run necessary post-initialization queries or code.
DBAdapter::isGetIdAfterInsert(): Whether this adapter uses an ID generation system that requires getting ID _before_ performing INSERT.
DBAdapter::isGetIdBeforeInsert(): Whether this adapter uses an ID generation system that requires getting ID _before_ performing INSERT.
DBAdapter::quoteIdentifier(): Quotes database objec identifiers (table names, col names, sequences, etc.).
DBAdapter::random()
DBAdapter::strLength(): Returns SQL which calculates the length (in chars) of a string.
DBAdapter::subString(): Returns SQL which extracts a substring.
DBAdapter::toUpperCase(): This method is used to ignore case.
DBAdapter::useQuoteIdentifier(): Should Column-Names get identifiers for inserts or updates.

Class Details

[line 33]
This is used to connect to PostgresQL databases.

<a href="http://www.pgsql.org">http://www.pgsql.org</a>

Tags:

author:	Hakan Tandogan <hakan42@gmx.de> (Torque)
author:	Hans Lellelid <hans@xmpl.org> (Propel)
version:	$Revision: 563 $

[ Top ]

Class Methods

method applyLimit [line 135]

void applyLimit(

&$sql, 
$offset, 
$limit)

Tags:

see:	DBAdapter::applyLimit()
access:	public

Overrides DBAdapter::applyLimit() (Modifies the passed-in SQL to add LIMIT and/or OFFSET.)

Parameters:

	&$sql
	$offset
	$limit

[ Top ]

method concatString [line 64]

string concatString(
string
$s1, string
$s2)

Returns SQL which concatenates the second string to the first.

Tags:

access:

public

Overrides DBAdapter::concatString() (Returns SQL which concatenates the second string to the first.)

Parameters:

string	$s1	String to concatenate.
string	$s2	String to append.

[ Top ]

method getId [line 104]

void getId(

$con, [
$name = null])

Gets ID for specified sequence name.

Tags:

access:

public

Overrides DBAdapter::getId() (Gets the generated ID (either last ID for autoincrement or next sequence ID).)

Parameters:

PDO	$con
	$name

[ Top ]

method getIdMethod [line 96]

void getIdMethod(
)

Tags:

see:	DBAdapter::getIdMethod()
access:	protected

Overrides DBAdapter::getIdMethod() (Returns the native ID method for this RDBMS.)

[ Top ]

method getTimeFormatter [line 127]

string getTimeFormatter(
)

Returns timestamp formatter string for use in date() function.

Tags:

access:

public

Overrides DBAdapter::getTimeFormatter() (Returns time formatter string for use in date() function.)

[ Top ]

method getTimestampFormatter [line 118]

string getTimestampFormatter(
)

Returns timestamp formatter string for use in date() function.

Tags:

access:

public

Overrides DBAdapter::getTimestampFormatter() (Returns timestamp formatter string for use in date() function.)

[ Top ]

method ignoreCase [line 52]

The ignoreCase(
in
$in)

This method is used to ignore case.

Tags:

return:	string in a case that can be ignored.
access:	public

Overrides DBAdapter::ignoreCase() (This method is used to ignore case.)

Parameters:

$in

The string whose case to ignore.

[ Top ]

method random [line 145]

void random(
[
$seed = NULL])

Tags:

access:

public

Overrides DBAdapter::random() (parent method not documented)

Parameters:

$seed

[ Top ]

method strLength [line 88]

string strLength(
string
$s)

Returns SQL which calculates the length (in chars) of a string.

Tags:

access:

public

Overrides DBAdapter::strLength() (Returns SQL which calculates the length (in chars) of a string.)

Parameters:

string

String to calculate length of.

[ Top ]

method subString [line 77]

string subString(
string
$s, int
$pos, int
$len)

Returns SQL which extracts a substring.

Tags:

access:

public

Overrides DBAdapter::subString() (Returns SQL which extracts a substring.)

Parameters:

string	$s	String to extract from.
int	$pos	Offset to start from.
int	$len	Number of characters to extract.

[ Top ]

method toUpperCase [line 41]

string toUpperCase(
string
$in)

This method is used to ignore case.

Tags:

return:	The upper case string.
access:	public

Overrides DBAdapter::toUpperCase() (This method is used to ignore case.)

Parameters:

string

$in

The string to transform to upper case.

[ Top ]

Documentation generated on Thu, 22 Nov 2007 03:33:42 +0000 by phpDocumentor 1.4.0