Référence de la classe JDatabaseQueryPostgresql

Graphe d'héritage de JDatabaseQueryPostgresql:

Fonctions membres publiques
	__toString ()
	clear ($clause=null)
	castAsChar ($value, $len=null)
	concatenate ($values, $separator=null)
	currentTimestamp ()
	forUpdate ($tableName, $glue=',')
	forShare ($tableName, $glue=',')
	year ($date)
	month ($date)
	day ($date)
	hour ($date)
	minute ($date)
	second ($date)
	noWait ()
	limit ($limit=0)
	offset ($offset=0)
	returning ($pkCol)
	setLimit ($limit=0, $offset=0)
	processLimit ($query, $limit, $offset=0)
	dateAdd ($date, $interval, $datePart)
	regexp ($value)
	Rand ()
	selectRowNumber ($orderBy, $orderColumnAlias)
Fonctions membres publiques hérités de JDatabaseQuery
	__call ($method, $args)
	__construct (JDatabaseDriver $db=null)
	__toString ()
	__get ($name)
	call ($columns)
	castAsChar ($value)
	charLength ($field, $operator=null, $condition=null)
	clear ($clause=null)
	columns ($columns)
	concatenate ($values, $separator=null)
	currentTimestamp ()
	dateFormat ()
	dump ()
	delete ($table=null)
	escape ($text, $extra=false)
	exec ($columns)
	from ($tables, $subQueryAlias=null)
	year ($date)
	month ($date)
	day ($date)
	hour ($date)
	minute ($date)
	second ($date)
	group ($columns)
	having ($conditions, $glue='AND')
	innerJoin ($condition)
	insert ($table, $incrementField=false)
	join ($type, $conditions)
	leftJoin ($condition)
	length ($value)
	nullDate ($quoted=true)
	order ($columns)
	outerJoin ($condition)
	quote ($text, $escape=true)
	quoteName ($name, $as=null)
	rightJoin ($condition)
	select ($columns)
	set ($conditions, $glue=',')
	setQuery ($sql)
	update ($table)
	values ($values)
	where ($conditions, $glue='AND')
	extendWhere ($outerGlue, $conditions, $innerGlue='AND')
	orWhere ($conditions, $glue='AND')
	andWhere ($conditions, $glue='OR')
	__clone ()
	union ($query, $distinct=false, $glue='')
	unionDistinct ($query, $glue='')
	format ($format)
	dateAdd ($date, $interval, $datePart)
	unionAll ($query, $distinct=false, $glue='')
	selectRowNumber ($orderBy, $orderColumnAlias)

Attributs protégés
	$forUpdate = null
	$forShare = null
	$noWait = null
	$limit = null
	$offset = null
	$returning = null
Attributs protégés hérités de JDatabaseQuery
	$db = null
	$sql = null
	$type = ''
	$element = null
	$select = null
	$delete = null
	$update = null
	$insert = null
	$from = null
	$join = null
	$set = null
	$where = null
	$group = null
	$having = null
	$columns = null
	$values = null
	$order = null
	$autoIncrementField = null
	$call = null
	$exec = null
	$union = null
	$unionAll = null
	$selectRowNumber = null

Membres hérités additionnels
Fonctions membres protégées hérités de JDatabaseQuery
	validateRowNumber ($orderBy, $orderColumnAlias)

Description détaillée

Query Building Class.

Depuis

1.7.3

Obsolète:

4.0 Use PDO PostgreSQL instead

Documentation des fonctions membres

__toString()

__toString

(

)

Magic function to convert the query to a string, only for postgresql specific query

Renvoie

string The completed query.

Depuis

1.7.3

Références $columns, $condition, $limit, $offset, $query, elseif, et null.

castAsChar()

castAsChar	(		$value,
			$len = null
	)

Casts a value to a char.

Ensure that the value is properly quoted before passing to the method.

Usage: $query->select($query->castAsChar('a')); $query->select($query->castAsChar('a', 40));

Paramètres

string	$value	The value to cast as a char.
string	$len	The length of the char.

Renvoie

string Returns the cast value.

Depuis

1.7.3

Références $value.

clear()

clear

(

$clause = null

)

Clear data from the query or a specific clause of the query.

Paramètres

string

$clause

Optionally, the name of the clause to clear, or nothing to clear the whole query.

Renvoie

JDatabaseQueryPostgresql Returns this object to allow chaining.

Depuis

1.7.3

Références null.

concatenate()

concatenate	(		$values,
			$separator = null
	)

Concatenates an array of column names or values.

Usage: $query->select($query->concatenate(array('a', 'b')));

Paramètres

array	$values	An array of values to concatenate.
string	$separator	As separator to place between each value.

Renvoie

string The concatenated values.

Depuis

1.7.3

Références $separator.

currentTimestamp()

currentTimestamp

(

)

Gets the current date and time.

Renvoie

string Return string used in query to obtain

Depuis

1.7.3

dateAdd()

dateAdd	(		$date,
			$interval,
			$datePart
	)

Add to the current date and time in Postgresql. Usage: $query->select($query->dateAdd()); Prefixing the interval with a - (negative sign) will cause subtraction to be used.

Paramètres

string	$date	The db quoted string representation of the date to add to
string	$interval	The string representation of the appropriate number of units
string	$datePart	The part of the date to perform the addition on

Renvoie

string The string with the appropriate sql for addition of dates

Depuis

3.2.0

Note

Not all drivers support all units. Check appropriate references http://www.postgresql.org/docs/9.0/static/functions-datetime.html.

Références $date.

day()

day

(

$date

)

Used to get a string to extract day from date column.

Usage: $query->select($query->day($query->quoteName('dateColumn')));

Paramètres

string

$date

Date column containing day to be extracted.

Renvoie

string Returns string to extract day from a date.

Depuis

3.0.0

Références $date.

forShare()

forShare	(		$tableName,
			$glue = ','
	)

Sets the FOR SHARE lock on select's output row

Paramètres

string	$tableName	The table to lock
string	$glue	The glue by which to join the conditions. Defaults to ',' .

Renvoie

JDatabaseQueryPostgresql FOR SHARE query element

Depuis

1.7.3

forUpdate()

forUpdate	(		$tableName,
			$glue = ','
	)

Sets the FOR UPDATE lock on select's output row

Paramètres

string	$tableName	The table to lock
string	$glue	The glue by which to join the conditions. Defaults to ',' .

Renvoie

JDatabaseQueryPostgresql FOR UPDATE query element

Depuis

1.7.3

hour()

hour

(

$date

)

Used to get a string to extract hour from date column.

Usage: $query->select($query->hour($query->quoteName('dateColumn')));

Paramètres

string

$date

Date column containing hour to be extracted.

Renvoie

string Returns string to extract hour from a date.

Depuis

3.0.0

Références $date.

limit()

limit

(

$limit = 0

)

Set the LIMIT clause to the query

Paramètres

integer

$limit

An int of how many row will be returned

Renvoie

JDatabaseQueryPostgresql Returns this object to allow chaining.

Depuis

1.7.3

Références $limit.

minute()

minute

(

$date

)

Used to get a string to extract minute from date column.

Usage: $query->select($query->minute($query->quoteName('dateColumn')));

Paramètres

string

$date

Date column containing minute to be extracted.

Renvoie

string Returns string to extract minute from a date.

Depuis

3.0.0

Références $date.

month()

month

(

$date

)

Used to get a string to extract month from date column.

Usage: $query->select($query->month($query->quoteName('dateColumn')));

Paramètres

string

$date

Date column containing month to be extracted.

Renvoie

string Returns string to extract month from a date.

Depuis

3.0.0

Références $date.

noWait()

noWait

(

)

Sets the NOWAIT lock on select's output row

Renvoie

JDatabaseQueryPostgresql NO WAIT query element

Depuis

1.7.3

Références null.

offset()

offset

(

$offset = 0

)

Set the OFFSET clause to the query

Paramètres

integer

$offset

An int for skipping row

Renvoie

JDatabaseQueryPostgresql Returns this object to allow chaining.

Depuis

1.7.3

Références $offset.

processLimit()

processLimit	(		$query,
			$limit,
			$offset = 0
	)

Method to modify a query already in string format with the needed additions to make the query limited to a particular number of results, or start at a particular offset.

Paramètres

string	$query	The query in string format
integer	$limit	The limit for the result set
integer	$offset	The offset for the result set

Renvoie

string

Depuis

3.0.0

Implémente JDatabaseQueryLimitable.

Références $limit, $offset, et $query.

Rand()

Rand

(

)

Return correct rand() function for Postgresql.

Ensure that the rand() function is Postgresql compatible.

Usage: $query->Rand();

Renvoie

string The correct rand function.

Depuis

3.5

regexp()

regexp

(

$value

)

Return correct regexp operator for Postgresql.

Ensure that the regexp operator is Postgresql compatible.

Usage: $query->where('field ' . $query->regexp($search));

Paramètres

string

$value

The regex pattern.

Renvoie

string Returns the regex operator.

Depuis

1.7.3

Références $value.

returning()

returning

(

$pkCol

)

Add the RETURNING element to INSERT INTO statement.

Paramètres

mixed

$pkCol

The name of the primary key column.

Renvoie

JDatabaseQueryPostgresql Returns this object to allow chaining.

Depuis

1.7.3

second()

second

(

$date

)

Used to get a string to extract seconds from date column.

Usage: $query->select($query->second($query->quoteName('dateColumn')));

Paramètres

string

$date

Date column containing second to be extracted.

Renvoie

string Returns string to extract second from a date.

Depuis

3.0.0

Références $date.

selectRowNumber()

selectRowNumber	(		$orderBy,
			$orderColumnAlias
	)

Return the number of the current row.

Paramètres

string	$orderBy	An expression of ordering for window function.
string	$orderColumnAlias	An alias for new ordering column.

Renvoie

JDatabaseQuery Returns this object to allow chaining.

Depuis

3.7.0

Exceptions

RuntimeException

setLimit()

setLimit	(		$limit = 0,
			$offset = 0
	)

Sets the offset and limit for the result set, if the database driver supports it.

Usage: $query->setLimit(100, 0); (retrieve 100 rows, starting at first record) $query->setLimit(50, 50); (retrieve 50 rows, starting at 50th record)

Paramètres

integer	$limit	The limit for the result set
integer	$offset	The offset for the result set

Renvoie

JDatabaseQueryPostgresql Returns this object to allow chaining.

Depuis

3.0.0

Implémente JDatabaseQueryLimitable.

Références $limit, et $offset.

year()

year

(

$date

)

Used to get a string to extract year from date column.

Usage: $query->select($query->year($query->quoteName('dateColumn')));

Paramètres

string

$date

Date column containing year to be extracted.

Renvoie

string Returns string to extract year from a date.

Depuis

3.0.0

Références $date.

Documentation des champs

$forShare

$forShare = null

protected

$forUpdate

$forUpdate = null

protected

$limit

$limit = null

protected

$noWait

$noWait = null

protected

$offset

$offset = null

protected

$returning

$returning = null

protected

---

La documentation de cette classe a été générée à partir du fichier suivant :

• libraries/joomla/database/query/postgresql.php