Zeta Components - high quality PHP components

Zeta Components Manual :: Docs For Class ezcQueryExpressionSqlite

Database::ezcQueryExpressionSqlite

Class ezcQueryExpressionSqlite

The ezcQueryExpressionSqlite class is used to create SQL expression for SQLite.

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.

Source for this file: /Database/src/sqlabstraction/implementations/expression_sqlite.php

ezcQueryExpression
   |
   --ezcQueryExpressionSqlite

Version:

//autogentag//

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 in the database internal format.
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 in the database internal format.
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 in the database internal format.

Redefinition of:

Method	Description
`ezcQueryExpression::now()`	Returns the current system date and time in the database internal format.

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.

Documentation generated by phpDocumentor 1.4.3