\JDatabaseQuerySqlite

SQLite Query Building Class.

Synopsis

class JDatabaseQuerySqlite extends JDatabaseQueryPdo implements JDatabaseQueryPreparable,JDatabaseQueryLimitable {

// members
protected $offset;
protected $limit;
protected $bounded;

// Inherited members from JDatabaseQuery
protected JDatabaseDriver $db;
protected $sql;
protected $type;
protected JDatabaseQueryElement $element;
protected JDatabaseQueryElement $select;
protected JDatabaseQueryElement $delete;
protected JDatabaseQueryElement $update;
protected JDatabaseQueryElement $insert;
protected JDatabaseQueryElement $from;
protected JDatabaseQueryElement $join;
protected JDatabaseQueryElement $set;
protected JDatabaseQueryElement $where;
protected JDatabaseQueryElement $group;
protected JDatabaseQueryElement $having;
protected JDatabaseQueryElement $columns;
protected JDatabaseQueryElement $values;
protected JDatabaseQueryElement $order;
protected $autoIncrementField;
protected JDatabaseQueryElement $call;
protected JDatabaseQueryElement $exec;
protected JDatabaseQueryElement $union;
protected JDatabaseQueryElement $unionAll;

// methods
public JDatabaseQuerySqlite bind()
public mixed getBounded()
public string charLength()
public JDatabaseQuerySqlite clear()
public string concatenate()
public string processLimit()
public JDatabaseQuerySqlite setLimit()
public string dateAdd()

// Inherited methods from JDatabaseQuery
public string __call()
public void __construct()
public string __toString()
public mixed __get()
public JDatabaseQuery call()
public string castAsChar()
public string charLength()
public JDatabaseQuery clear()
public JDatabaseQuery columns()
public string concatenate()
public string currentTimestamp()
public string dateFormat()
public string dump()
public JDatabaseQuery delete()
public string escape()
public JDatabaseQuery exec()
public JDatabaseQuery from()
public string year()
public string month()
public string day()
public string hour()
public string minute()
public string second()
public JDatabaseQuery group()
public JDatabaseQuery having()
public JDatabaseQuery innerJoin()
public JDatabaseQuery insert()
public JDatabaseQuery join()
public JDatabaseQuery leftJoin()
public int length()
public string nullDate()
public JDatabaseQuery order()
public JDatabaseQuery outerJoin()
public string quote()
public mixed quoteName()
public JDatabaseQuery rightJoin()
public JDatabaseQuery select()
public JDatabaseQuery set()
public JDatabaseQuery setQuery()
public JDatabaseQuery update()
public JDatabaseQuery values()
public JDatabaseQuery where()
public void __clone()
public mixed union()
public mixed unionDistinct()
public string format()
public string dateAdd()
public mixed unionAll()

}

Hierarchy

Extends

JDatabaseQueryPdo

Implements

Members

protected

$autoIncrementField —

$bounded — array

$call — JDatabaseQueryElement
$columns — JDatabaseQueryElement
$db — JDatabaseDriver
$delete — JDatabaseQueryElement
$element — JDatabaseQueryElement
$exec — JDatabaseQueryElement
$from — JDatabaseQueryElement
$group — JDatabaseQueryElement
$having — JDatabaseQueryElement
$insert — JDatabaseQueryElement
$join — JDatabaseQueryElement
$limit — integer
$offset — integer
$order — JDatabaseQueryElement
$select — JDatabaseQueryElement
$set — JDatabaseQueryElement
$sql — string
$type — string
$union — JDatabaseQueryElement
$unionAll — JDatabaseQueryElement
$update — JDatabaseQueryElement
$values — JDatabaseQueryElement
$where — JDatabaseQueryElement

Methods

public

bind() — 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.
charLength() — Gets the number of characters in a string.
clear() — Clear data from the query or a specific clause of the query.
concatenate() — Concatenates an array of column names or values.
dateAdd() — Add to the current date and time.
getBounded() — Retrieves the bound parameters array when key is null and returns it by reference. If a key is provided then that item is returned.
processLimit() — 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.
setLimit() — Sets the offset and limit for the result set, if the database driver supports it.

Inherited from JDatabaseQuery

public

__call() — Magic method to provide method alias support for quote() and quoteName().
__clone() — Method to provide deep copy support to nested objects and arrays when cloning.
__get() — Magic function to get protected variable value
__toString() — Magic function to convert the query to a string.
call() — Add a single column, or array of columns to the CALL clause of the query.
castAsChar() — Casts a value to a char.
charLength() — Gets the number of characters in a string.
clear() — Clear data from the query or a specific clause of the query.
columns() — Adds a column, or array of column names that would be used for an INSERT INTO statement.
concatenate() — Concatenates an array of column names or values.
currentTimestamp() — Gets the current date and time.
dateAdd() — Add to the current date and time.
dateFormat() — Returns a PHP date() function compliant date format for the database driver.
day() — Used to get a string to extract day from date column.
delete() — Add a table name to the DELETE clause of the query.
dump() — Creates a formatted dump of the query for debugging purposes.
escape() — Method to escape a string for usage in an SQL statement.
exec() — Add a single column, or array of columns to the EXEC clause of the query.
format() — Find and replace sprintf-like tokens in a format string.
from() — Add a table to the FROM clause of the query.
group() — Add a grouping column to the GROUP clause of the query.
having() — A conditions to the HAVING clause of the query.
hour() — Used to get a string to extract hour from date column.
innerJoin() — Add an INNER JOIN clause to the query.
insert() — Add a table name to the INSERT clause of the query.
join() — Add a JOIN clause to the query.
leftJoin() — Add a LEFT JOIN clause to the query.
length() — Get the length of a string in bytes.
minute() — Used to get a string to extract minute from date column.
month() — Used to get a string to extract month from date column.
nullDate() — Get the null or zero representation of a timestamp for the database driver.
order() — Add a ordering column to the ORDER clause of the query.
outerJoin() — Add an OUTER JOIN clause to the query.
quote() — Method to quote and optionally escape a string to database requirements for insertion into the database.
quoteName() — Wrap an SQL statement identifier name such as column, table or database names in quotes to prevent injection risks and reserved word conflicts.
rightJoin() — Add a RIGHT JOIN clause to the query.
second() — Used to get a string to extract seconds from date column.
select() — Add a single column, or array of columns to the SELECT clause of the query.
set() — Add a single condition string, or an array of strings to the SET clause of the query.
setQuery() — Allows a direct query to be provided to the database driver's setQuery() method, but still allow queries to have bounded variables.
union() — Add a query to UNION with the current query.
unionAll() — Add a query to UNION ALL with the current query.
unionDistinct() — Add a query to UNION DISTINCT with the current query. Simply a proxy to Union with the Distinct clause.
update() — Add a table name to the UPDATE clause of the query.
values() — Adds a tuple, or array of tuples that would be used as values for an INSERT INTO statement.
where() — Add a single condition, or an array of conditions to the WHERE clause of the query.
year() — Used to get a string to extract year from date column.