eZ Components latest

Getting Started

Components

Archive (1.4)
Authentication (1.3.1)
AuthenticationDatabaseTiein (1.1)
Base (1.8)
Cache (1.5)
Configuration (1.3.5)
ConsoleTools (1.6)
Database (1.4.6)
DatabaseSchema (1.4.3)
Debug (1.2.1)
Document (1.3)
EventLog (1.4)
EventLogDatabaseTiein (1.0.2)
Execution (1.1.1)
Feed (1.3)
File (1.2)
Graph (1.5)
GraphDatabaseTiein (1.0.1)
ImageAnalysis (1.1.3)
ImageConversion (1.3.7)
Mail (1.7)
MvcTools (1.1.2)
MvcAuthenticationTiein (1.0)
MvcFeedTiein (1.0)
MvcMailTiein (1.0.1)
MvcTemplateTiein (1.0)
PersistentObject (1.7)
PersistentObjectDatabaseSchemaTiein (1.3)
PhpGenerator (1.0.5)
Search (1.0.8)
SignalSlot (1.1.1)
SystemInformation (1.0.8)
Template (1.4.2)
TemplateTranslationTiein (1.1)
Translation (1.3.2)
TranslationCacheTiein (1.1.2)
Tree (1.1.3)
TreeDatabaseTiein (1.1.1)
TreePersistentObjectTiein (1.0)
Url (1.2.2)
UserInput (1.4)
Webdav (1.1.3)
Workflow (1.4)
WorkflowDatabaseTiein (1.4)
WorkflowEventLogTiein (1.1)
WorkflowSignalSlotTiein (1.0)

Database: ezcQueryExpressionMssql

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

Class: ezcQueryExpressionMssql

The ezcQueryExpressionMssql class is used to create SQL expression for SQL Server. [source]

This class reimplements the methods that have a different syntax in SQL Server.

Parents

ezcQueryExpression
   |
   --ezcQueryExpressionMssql

Member Variables

protected array(string=>string)

$intervalMap
         = array(
        'SECOND' => 'second',
        'MINUTE' => 'minute',
        'HOUR' => 'Hour',
        'DAY' => 'Day',
        'MONTH' => 'Month',
        'YEAR' => 'Year',
    )

Contains an interval map from generic intervals to MS SQL native intervals.

Inherited Member Variables

From ezcQueryExpression:

protected	`ezcQueryExpression::$db`
protected	`ezcQueryExpression::$quoteValues`

Method Summary

public string	`ceil( $number )` Returns the SQL to calculate the next highest integer value from the number.
public void	`concat( $... )` Returns a series of strings concatinated
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 from a column.
public string	`dateSub( $column, $expr, $type )` Returns the SQL that subtracts an interval from a timestamp value.
public string	`length( $column )` Returns the length of a text field.
public string	`md5( $column )` Returns the md5 sum of a field.
public string	`mod( $expression1, $expression2 )` Returns the remainder of the division operation $expression1 / $expression2.
public string	`now( )` Returns the current system date and time in the database internal format.
public string	`position( $substr, $value )` Returns the SQL to locate the position of the first occurrence of a substring
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 number of seconds since 1970-01-01 00:00:00-00.

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

ceil

string ceil( string $number )

Returns the SQL to calculate the next highest integer value from the number.

Parameters

Name	Type	Description
`$number`	string

Redefinition of

Method	Description
`ezcQueryExpression::ceil()`	Returns the SQL to calculate the next highest integer value from the number.

concat

void concat( string|array(string) $... )

Returns a series of strings concatinated

concat() accepts an arbitrary number of parameters. Each parameter must contain an expression or an array with expressions.

Parameters

Name	Type	Description
`$...`	string\|array(string)	strings that will be concatinated.

Redefinition of

Method	Description
`ezcQueryExpression::concat()`	Returns a series of strings concatinated

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 from a column.

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.

length

string length( string $column )

Returns the length of a text field.

Parameters

Name	Type	Description
`$column`	string

Redefinition of

Method	Description
`ezcQueryExpression::length()`	Returns the length of text field $column

md5

string md5( string $column )

Returns the md5 sum of a field.

There are two variants of implementation for this feature. Both not ideal though. First don't require additional setup of MS SQL Server and uses undocumented function master.dbo.fn_varbintohexstr() to convert result of Transact-SQL HashBytes() function to string.

Second one requires the stored procedure from http://www.thecodeproject.com/database/xp_md5.asp to be installed and wrapped by the user defined function fn_md5.

Parameters

Name	Type	Description
`$column`	string

Redefinition of

Method	Description
`ezcQueryExpression::md5()`	Returns the md5 sum of $column.

mod

string mod( string $expression1, string $expression2 )

Returns the remainder of the division operation $expression1 / $expression2.

Parameters

Name	Type	Description
`$expression1`	string
`$expression2`	string

Redefinition of

Method	Description
`ezcQueryExpression::mod()`	Returns the remainder of the division operation $expression1 / $expression2.

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.

position

string position( string $substr, string $value )

Returns the SQL to locate the position of the first occurrence of a substring

Parameters

Name	Type	Description
`$substr`	string
`$value`	string

Redefinition of

Method	Description
`ezcQueryExpression::position()`	Returns the SQL to locate the position of the first occurrence of a substring

subString

string subString( string $value, int $from, [int $len = null] )

Returns part of a string.

Note: Not SQL92, but common functionality.

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. If $len is not provided it's assumed to be the number of characters to get the whole remainder of the string.

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 number of seconds since 1970-01-01 00:00:00-00.

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, 21 Dec 2009

eZ Components

User menu

Path

eZ Components latest

Getting Started

Components

Database: ezcQueryExpressionMssql

Class: ezcQueryExpressionMssql

Parents

Member Variables

Inherited Member Variables

Method Summary

Inherited Methods

Methods

ceil

Parameters

Redefinition of

concat

Parameters

Redefinition of

dateAdd

Parameters

Redefinition of

dateExtract

Parameters

Redefinition of

dateSub

Parameters

Redefinition of

length

Parameters

Redefinition of

md5

Parameters

Redefinition of

mod

Parameters

Redefinition of

now

Redefinition of

position

Parameters

Redefinition of

subString

Parameters

Redefinition of

unixTimestamp

Parameters

Redefinition of