Joomla Platform  13.1
Documentation des API du framework Joomla Platform
 Tout Classes Espaces de nommage Fichiers Fonctions Variables Pages
Fonctions membres publiques | Attributs protégés
Référence de la classe JDatabaseQuerySqlite
+ Graphe d'héritage de JDatabaseQuerySqlite:
+ Graphe de collaboration de JDatabaseQuerySqlite:

Liste de tous les membres

Fonctions membres publiques

 bind ($key=null, &$value=null, $dataType=PDO::PARAM_STR, $length=0, $driverOptions=array())
& getBounded ($key=null)
 clear ($clause=null)
 processLimit ($query, $limit, $offset=0)
 setLimit ($limit=0, $offset=0)
 dateAdd ($date, $interval, $datePart)

Attributs protégés

 $offset
 $limit
 $bounded = array()

Description détaillée

Définition à la ligne 19 du fichier sqlite.php.

Documentation des fonctions membres

JDatabaseQuerySqlite::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$keyThe 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&$valueThe value that will be bound. The value is passed by reference to support output parameters such as those possible with stored procedures.
integer$dataTypeConstant corresponding to a SQL datatype.
integer$lengthThe length of the variable. Usually required for OUTPUT parameters.
array$driverOptionsOptional driver options to be used.
Renvoie:
JDatabaseQuerySqlite
Depuis:
12.1

Implémente JDatabaseQueryPreparable.

Définition à la ligne 55 du fichier sqlite.php.

{
// Case 1: Empty Key (reset $bounded array)
if (empty($key))
{
$this->bounded = array();
return $this;
}
// Case 2: Key Provided, null value (unset key from $bounded array)
if (is_null($value))
{
if (isset($this->bounded[$key]))
{
unset($this->bounded[$key]);
}
return $this;
}
$obj = new stdClass;
$obj->value = &$value;
$obj->dataType = $dataType;
$obj->length = $length;
$obj->driverOptions = $driverOptions;
// Case 3: Simply add the Key/Value into the bounded array
$this->bounded[$key] = $obj;
return $this;
}
JDatabaseQuerySqlite::clear (   $clause = null)

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

Paramètres:
string$clauseOptionally, the name of the clause to clear, or nothing to clear the whole query.
Renvoie:
JDatabaseQuerySqlite Returns this object to allow chaining.
Depuis:
12.1

Réimplémentée à partir de JDatabaseQuery.

Définition à la ligne 123 du fichier sqlite.php.

{
switch ($clause)
{
case null:
$this->bounded = array();
break;
}
parent::clear($clause);
return $this;
}
JDatabaseQuerySqlite::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$dateThe date or datetime to add to
string$intervalThe string representation of the appropriate number of units
string$datePartThe part of the date to perform the addition on
Renvoie:
string The string with the appropriate sql for addition of dates
Depuis:
13.1 http://www.sqlite.org/lang_datefunc.html

Réimplémentée à partir de JDatabaseQuery.

Définition à la ligne 199 du fichier sqlite.php.

{
// SQLite does not support microseconds as a separate unit. Convert the interval to seconds
if (strcasecmp($datePart, 'microseconds') == 0)
{
$interval = .001 * $interval;
$datePart = 'seconds';
}
if (substr($interval, 0, 1) != '-')
{
return "datetime('" . $date . "', '+" . $interval . " " . $datePart . "')";
}
else
{
return "datetime('" . $date . "', '" . $interval . " " . $datePart . "')";
}
}
& JDatabaseQuerySqlite::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$keyThe bounded variable key to retrieve.
Renvoie:
mixed
Depuis:
12.1

Implémente JDatabaseQueryPreparable.

Définition à la ligne 99 du fichier sqlite.php.

{
if (empty($key))
{
return $this->bounded;
}
else
{
if (isset($this->bounded[$key]))
{
return $this->bounded[$key];
}
}
}
JDatabaseQuerySqlite::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$queryThe query in string format
integer$limitThe limit for the result set
integer$offsetThe offset for the result set
Renvoie:
string
Depuis:
12.1

Implémente JDatabaseQueryLimitable.

Définition à la ligne 152 du fichier sqlite.php.

{
if ($limit > 0 || $offset > 0)
{
$query .= ' LIMIT ' . $offset . ', ' . $limit;
}
return $query;
}
JDatabaseQuerySqlite::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$limitThe limit for the result set
integer$offsetThe offset for the result set
Renvoie:
JDatabaseQuerySqlite Returns this object to allow chaining.
Depuis:
12.1

Implémente JDatabaseQueryLimitable.

Définition à la ligne 176 du fichier sqlite.php.

{
$this->limit = (int) $limit;
$this->offset = (int) $offset;
return $this;
}

Documentation des données membres

JDatabaseQuerySqlite::$bounded = array()
protected

Définition à la ligne 37 du fichier sqlite.php.

JDatabaseQuerySqlite::$limit
protected

Définition à la ligne 31 du fichier sqlite.php.

JDatabaseQuerySqlite::$offset
protected

Définition à la ligne 25 du fichier sqlite.php.

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