Path

ez components / documentation / api reference / 2008.1alpha1 / database


eZ Components 2008.1alpha1

Database: ezcQueryExpressionSqlite

[ Tutorial ] [ Oracle setup ] [ Class tree ] [ Element index ] [ ChangeLog ] [ Credits ]

Class: ezcQueryExpressionSqlite

The ezcQueryExpressionSqlite class is used to create SQL expression for SQLite. [source]
This class reimplements the methods that have a different syntax in SQLite (substr) and contains PHP implementations of functions that are registered with SQLite with it's PDO::sqliteRegisterFunction() method.

Parents

ezcQueryExpression
   |
   --ezcQueryExpressionSqlite

Member Variables

protected array(string=>string) $intervalMap = array(
'SECOND' => 'seconds',
'MINUTE' => 'minutes',
'HOUR' => 'hours',
'DAY' => 'days',
'MONTH' => 'months',
'YEAR' => 'years',
)

Contains an interval map from generic intervals to SQLite native intervals.

Inherited Member Variables

From ezcQueryExpression:
protected  ezcQueryExpression::$db
protected  ezcQueryExpression::$quoteValues

Method Summary

public string bitXor( $value1, $value2 )
Returns the SQL that performs the bitwise XOR on two values.
public string dateAdd( $column, $expr, $type )
Returns the SQL that adds an interval to a timestamp value.
public string dateExtract( $column, $type )
Returns the SQL that extracts parts from a timestamp value.
public string dateSub( $column, $expr, $type )
Returns the SQL that subtracts an interval from a timestamp value.
public string now( )
Returns the current system date and time.
public string subString( $value, $from, [$len = null] )
Returns part of a string.
public string unixTimestamp( $column )
Returns the SQL that converts a timestamp value to a unix timestamp.

Inherited Methods

From ezcQueryExpression :
public ezcQueryExpression ezcQueryExpression::__construct()
Constructs an empty ezcQueryExpression
public string ezcQueryExpression::add()
Returns the SQL to add values or expressions together.
public string ezcQueryExpression::avg()
Returns the average value of a column
public string ezcQueryExpression::between()
Returns SQL that checks if an expression evaluates to a value between two values.
public string ezcQueryExpression::bitAnd()
Returns the SQL that performs the bitwise AND on two values.
public string ezcQueryExpression::bitOr()
Returns the SQL that performs the bitwise OR on two values.
public string ezcQueryExpression::bitXor()
Returns the SQL that performs the bitwise XOR on two values.
public string ezcQueryExpression::ceil()
Returns the SQL to calculate the next highest integer value from the number.
public void ezcQueryExpression::concat()
Returns a series of strings concatinated
public string ezcQueryExpression::count()
Returns the number of rows (without a NULL value) of a column
public string ezcQueryExpression::dateAdd()
Returns the SQL that adds an interval to a timestamp value.
public string ezcQueryExpression::dateExtract()
Returns the SQL that extracts parts from a timestamp value.
public string ezcQueryExpression::dateSub()
Returns the SQL that subtracts an interval from a timestamp value.
public string ezcQueryExpression::div()
Returns the SQL to divide values or expressions by eachother.
public string ezcQueryExpression::eq()
Returns the SQL to check if two values are equal.
public string ezcQueryExpression::floor()
Returns the SQL to calculate the next lowest integer value from the number.
protected string ezcQueryExpression::getIdentifier()
Returns the correct identifier for the alias $alias.
protected array(string) ezcQueryExpression::getIdentifiers()
Returns the correct identifiers for the aliases found in $aliases.
public string ezcQueryExpression::gt()
Returns the SQL to check if one value is greater than another value.
public string ezcQueryExpression::gte()
Returns the SQL to check if one value is greater than or equal to another value.
public bool ezcQueryExpression::hasAliases()
Returns true if this object has aliases.
public string ezcQueryExpression::in()
Returns the SQL to check if a value is one in a set of given values..
public string ezcQueryExpression::isNull()
Returns SQL that checks if a expression is null.
public string ezcQueryExpression::lAnd()
Returns the SQL to bind logical expressions together using a logical and.
public string ezcQueryExpression::length()
Returns the length of text field $column
public void ezcQueryExpression::like()
Match a partial string in a column.
public string ezcQueryExpression::lOr()
Returns the SQL to bind logical expressions together using a logical or.
public string ezcQueryExpression::lower()
Returns the SQL to change all characters to lowercase
public string ezcQueryExpression::lt()
Returns the SQL to check if one value is less than another value.
public string ezcQueryExpression::lte()
Returns the SQL to check if one value is less than or equal to another value.
public string ezcQueryExpression::max()
Returns the highest value of a column
public string ezcQueryExpression::md5()
Returns the md5 sum of $column.
public string ezcQueryExpression::min()
Returns the lowest value of a column
public string ezcQueryExpression::mod()
Returns the remainder of the division operation $expression1 / $expression2.
public string ezcQueryExpression::mul()
Returns the SQL to multiply values or expressions by eachother.
public string ezcQueryExpression::neq()
Returns the SQL to check if two values are unequal.
public string ezcQueryExpression::not()
Returns the SQL for a logical not, negating the $expression.
public string ezcQueryExpression::now()
Returns the current system date and time.
public string ezcQueryExpression::position()
Returns the SQL to locate the position of the first occurrence of a substring
public string ezcQueryExpression::round()
Rounds a numeric field to the number of decimals specified.
public string ezcQueryExpression::searchedCase()
Returns a searched CASE statement.
public void ezcQueryExpression::setAliases()
Sets the aliases $aliases for this object.
public void ezcQueryExpression::setValuesQuoting()
Sets the mode of quoting for parameters passed to SQL functions and operators.
public string ezcQueryExpression::sub()
Returns the SQL to subtract values or expressions from eachother.
public string ezcQueryExpression::subString()
Returns part of a string.
public string ezcQueryExpression::sum()
Returns the total sum of a column
public string ezcQueryExpression::unixTimestamp()
Returns the SQL that converts a timestamp value to a unix timestamp.
public string ezcQueryExpression::upper()
Returns the SQL to change all characters to uppercase

Methods

bitXor

string bitXor( string $value1, string $value2 )
Returns the SQL that performs the bitwise XOR on two values.

Parameters

Name Type Description
$value1 string  
$value2 string  

Redefinition of

Method Description
ezcQueryExpression::bitXor() Returns the SQL that performs the bitwise XOR on two values.

dateAdd

string dateAdd( string $column, numeric $expr, string $type )
Returns the SQL that adds an interval to a timestamp value.

Parameters

Name Type Description
$column string  
$expr numeric  
$type string one of SECOND, MINUTE, HOUR, DAY, MONTH, or YEAR

Redefinition of

Method Description
ezcQueryExpression::dateAdd() Returns the SQL that adds an interval to a timestamp value.

dateExtract

string dateExtract( string $column, string $type )
Returns the SQL that extracts parts from a timestamp value.

Parameters

Name Type Description
$column string  
$type string one of SECOND, MINUTE, HOUR, DAY, MONTH, or YEAR

Redefinition of

Method Description
ezcQueryExpression::dateExtract() Returns the SQL that extracts parts from a timestamp value.

dateSub

string dateSub( string $column, numeric $expr, string $type )
Returns the SQL that subtracts an interval from a timestamp value.

Parameters

Name Type Description
$column string  
$expr numeric  
$type string one of SECOND, MINUTE, HOUR, DAY, MONTH, or YEAR

Redefinition of

Method Description
ezcQueryExpression::dateSub() Returns the SQL that subtracts an interval from a timestamp value.

now

string now( )
Returns the current system date and time.

Redefinition of

Method Description
ezcQueryExpression::now() Returns the current system date and time.

subString

string subString( string $value, int $from, [int $len = null] )
Returns part of a string.
Note: Not SQL92, but common functionality. SQLite only supports the 3 parameter variant of this function, so we are using 2^30-1 as artificial length in that case.

Parameters

Name Type Description
$value string the target $value the string or the string column.
$from int extract from this characeter.
$len int extract this amount of characters.

Redefinition of

Method Description
ezcQueryExpression::subString() Returns part of a string.

unixTimestamp

string unixTimestamp( string $column )
Returns the SQL that converts a timestamp value to a unix timestamp.

Parameters

Name Type Description
$column string  

Redefinition of

Method Description
ezcQueryExpression::unixTimestamp() Returns the SQL that converts a timestamp value to a unix timestamp.

Last updated: Mon, 05 May 2008