Graphe d'héritage de SqliteQuery:

Fonctions membres publiques
	__toString ()

	charLength ($field, $operator=null, $condition=null)

	concatenate ($values, $separator=null)

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

	selectRowNumber ($orderBy, $orderColumnAlias)

	union ($query, $distinct=true)

	groupConcat ($expression, $separator=',')

Fonctions membres publiques hérités de PdoQuery
	castAsChar ($value, $len=null)

Fonctions membres publiques hérités de DatabaseQuery
	__construct (DatabaseInterface $db=null)

	__toString ()

	__get ($name)

	call ($columns)

	castAs (string $type, string $value, ?string $length=null)

	castAsChar ($value)

	charLength ($field, $operator=null, $condition=null)

	clear ($clause=null)

	columns ($columns)

	concatenate ($values, $separator=null)

	currentTimestamp ()

	dateAdd ($date, $interval, $datePart)

	dateFormat ()

	dump ()

	delete ($table=null)

	e ($text, $extra=false)

	escape ($text, $extra=false)

	exec ($columns)

	findInSet ($value, $set)

	from ($table)

	alias ($alias)

	year ($date)

	month ($date)

	day ($date)

	hour ($date)

	minute ($date)

	second ($date)

	group ($columns)

	having ($conditions, $glue='AND')

	insert ($table, $incrementField=false)

	join ($type, $table, $condition=null)

	innerJoin ($table, $condition=null)

	outerJoin ($table, $condition=null)

	leftJoin ($table, $condition=null)

	rightJoin ($table, $condition=null)

	length ($value)

	nullDate ($quoted=true)

	isNullDatetime ($column)

	order ($columns)

	q ($text, $escape=true)

	quote ($text, $escape=true)

	qn ($name, $as=null)

	quoteName ($name, $as=null)

	rand ()

	regexp ($value)

	select ($columns)

	set ($conditions, $glue=',')

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

	setQuery ($sql)

	update ($table)

	values ($values)

	where ($conditions, $glue='AND')

	whereIn (string $keyName, array $keyValues, $dataType=ParameterType::INTEGER)

	whereNotIn (string $keyName, array $keyValues, $dataType=ParameterType::INTEGER)

	extendWhere ($outerGlue, $conditions, $innerGlue='AND')

	orWhere ($conditions, $glue='AND')

	andWhere ($conditions, $glue='OR')

	bind ($key, &$value, $dataType=ParameterType::STRING, $length=0, $driverOptions=[])

	unbind ($key)

	bindArray (array $values, $dataType=ParameterType::INTEGER)

	__clone ()

&	getBounded ($key=null)

	union ($query, $distinct=true)

	unionAll ($query)

	querySet ($query)

	toQuerySet ()

	format ($format)

	selectRowNumber ($orderBy, $orderColumnAlias)

Membres hérités additionnels
Fonctions membres protégées hérités de DatabaseQuery
	merge ($name, $query)

	validateRowNumber ($orderBy, $orderColumnAlias)

Attributs protégés hérités de PdoQuery
	$nullDatetimeList = ['0000-00-00 00:00:00']

Attributs protégés hérités de DatabaseQuery
	$bounded = []

	$parameterMapping

	$db

	$sql

	$type = ''

	$alias = null

	$element

	$select

	$delete

	$update

	$insert

	$from

	$join

	$set

	$where

	$group

	$having

	$columns

	$values

	$order

	$autoIncrementField = false

	$call

	$exec

	$merge

	$querySet

	$selectRowNumber

	$nullDatetimeList = []

	$offset

	$limit

	$preparedIndex = 0

Description détaillée

SQLite Query Building Class.

Depuis: 1.0

Documentation des fonctions membres

◆ __toString()

__toString ( )

Magic function to convert the query to a string.

Renvoie: string The completed query.

Depuis: 2.0.0

Implémente QueryInterface.

Références DatabaseQuery\$db, DatabaseQuery\$element, $fields, DatabaseQuery\$join, $key, DatabaseQuery\$limit, DatabaseQuery\$offset, DatabaseQuery\$order, $query, DatabaseQuery\$querySet, DatabaseQuery\$select, $value, DatabaseQuery\$where, Joomla\Database\Query\__toString(), DatabaseQuery\columns(), DatabaseQuery\from(), DatabaseQuery\join(), Joomla\Database\Query\limit(), DatabaseQuery\merge(), null, Joomla\Database\Query\offset(), DatabaseQuery\order(), SqliteQuery\processLimit(), DatabaseQuery\select(), SqliteQuery\selectRowNumber(), et DatabaseQuery\update().

◆ charLength()

charLength	(	$field,
		$operator = `null`,
		$condition = `null`
	)

Gets the number of characters in a string.

Note, use 'length' to find the number of bytes in a string.

Usage: $query->select($query->charLength('a'));

Paramètres

string	$field	A value.
string \| null	$operator	Comparison operator between charLength integer value and $condition
string \| null	$condition	Integer value to compare charLength with.

Renvoie: string The required char length call.

Depuis: 1.1.0

Implémente QueryInterface.

Références $field, et null.

◆ concatenate()

concatenate	(	$values,
		$separator = `null`
	)

Concatenates an array of column names or values.

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

Paramètres

	string[]	$values An array of values to concatenate.
string \| null	$separator	As separator to place between each value.

Renvoie: string The concatenated values.

Depuis: 1.1.0

Implémente QueryInterface.

Références $separator, DatabaseQuery\$values, null, et DatabaseQuery\quote().

◆ groupConcat()

groupConcat	(	$expression,
		$separator = `','`
	)

Aggregate function to get input values concatenated into a string, separated by delimiter

Usage: $query->groupConcat('id', ',');

Paramètres

string	$expression	The expression to apply concatenation to, this may be a column name or complex SQL statement.
string	$separator	The delimiter of each concatenated value

Renvoie: string Input values concatenated into a string, separated by delimiter

Depuis: 2.0.0

Implémente QueryInterface.

Références $separator, et DatabaseQuery\quote().

◆ 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: 1.0

Implémente LimitableInterface.

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

Référencé par SqliteQuery\__toString().

◆ selectRowNumber()

selectRowNumber	(	$orderBy,
		$orderColumnAlias
	)

Return the number of the current row.

Usage: $query->select('id'); $query->selectRowNumber('ordering,publish_up DESC', 'new_ordering'); $query->from('#__content');

Paramètres

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

Renvoie: $this

Depuis: 2.0.0

Exceptions

Implémente QueryInterface.

Références $this, et DatabaseQuery\validateRowNumber().

Référencé par SqliteQuery\__toString().

◆ union()

union	(	$query,
		$distinct = `true`
	)

Add a query to UNION with the current query.

Usage: $query->union('SELECT name FROM #__foo') $query->union('SELECT name FROM #__foo', true)

Paramètres

DatabaseQuery \| string	$query	The DatabaseQuery object or string to union.
boolean	$distinct	True to only return distinct rows from the union.

Renvoie: $this

Depuis: 1.0

Implémente QueryInterface.

Références $query, et DatabaseQuery\merge().

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

SqliteQuery.php

Fonctions membres publiques

Membres hérités additionnels

Description détaillée

Documentation des fonctions membres

◆ __toString()

◆ charLength()

◆ concatenate()

◆ groupConcat()

◆ processLimit()

◆ selectRowNumber()

◆ union()