Référence de la classe JDatabaseQuerySqlite

Graphe d'héritage de JDatabaseQuerySqlite:

Fonctions membres publiques
	bind ($key=null, &$value=null, $dataType=PDO::PARAM_STR, $length=0, $driverOptions=array())
&	getBounded ($key=null)
	charLength ($field, $operator=null, $condition=null)
	clear ($clause=null)
	concatenate ($values, $separator=null)
	processLimit ($query, $limit, $offset=0)
	setLimit ($limit=0, $offset=0)
	dateAdd ($date, $interval, $datePart)
	currentTimestamp ()
	__toString ()
	selectRowNumber ($orderBy, $orderColumnAlias)
Fonctions membres publiques hérités de JDatabaseQueryPdo
	castAsChar ($value, $len=null)
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
	$offset
	$limit
	$bounded = array()
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

SQLite Query Building Class.

Depuis

3.0.0

Documentation des fonctions membres

__toString()

__toString

(

)

Magic function to convert the query to a string.

Renvoie

string The completed query.

Depuis

1.7.0

Références $fields, $key, $limit, $offset, $query, $value, et null.

bind()

bind	(		$key = null,
		&	$value = null,
			$dataType = PDO::PARAM_STR,
			$length = 0,
			$driverOptions = array()
	)

Method to add a variable to an internal array that will be bound to a prepared SQL statement before query execution. Also removes a variable that has been bounded from the internal bounded array when the passed in value is null.

Paramètres

string | integer	$key	The key that will be used in your SQL query to reference the value. Usually of the form ':key', but can also be an integer.
mixed	&$value	The value that will be bound. The value is passed by reference to support output parameters such as those possible with stored procedures.
integer	$dataType	Constant corresponding to a SQL datatype.
integer	$length	The length of the variable. Usually required for OUTPUT parameters.
array	$driverOptions	Optional driver options to be used.

Renvoie

JDatabaseQuerySqlite

Depuis

3.0.0

Implémente JDatabaseQueryPreparable.

Références $key, et $value.

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	$operator	Comparison operator between charLength integer value and $condition
string	$condition	Integer value to compare charLength with.

Renvoie

string The required char length call.

Depuis

3.2.0

Références $condition, et $field.

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

JDatabaseQuerySqlite Returns this object to allow chaining.

Depuis

3.0.0

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

Références $separator.

currentTimestamp()

currentTimestamp

(

)

Gets the current date and time.

Usage: $query->where('published_up < '.$query->currentTimestamp());

Renvoie

string

Depuis

3.4

dateAdd()

dateAdd	(		$date,
			$interval,
			$datePart
	)

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

Paramètres

datetime	$date	The date or datetime 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 http://www.sqlite.org/lang_datefunc.html

Références $date.

getBounded()

& getBounded

(

$key = null

)

Retrieves the bound parameters array when key is null and returns it by reference. If a key is provided then that item is returned.

Paramètres

mixed

$key

The bounded variable key to retrieve.

Renvoie

mixed

Depuis

3.0.0

Implémente JDatabaseQueryPreparable.

Références $key.

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. This method is used automatically by the __toString() method if it detects that the query implements the JDatabaseQueryLimitable interface.

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.

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

JDatabaseQuerySqlite Returns this object to allow chaining.

Depuis

3.0.0

Implémente JDatabaseQueryLimitable.

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

Documentation des champs

$bounded

$bounded = array()

protected

$limit

$limit

protected

$offset

$offset

protected

---

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

• joomla/database/query/sqlite.php