KWeb  6.4
Public Member Functions | Protected Attributes
SqlQueryExpr Class Reference

SqlQueryBuilder is based on Zend_Db_Select (23775) from Zend Framework (1.10.11) It's not compatible with the Zend_Db_Select and it's not dependent on Zend. More...

Public Member Functions

 __construct ($expression)
 Instantiate an expression, which is just a string stored as an instance member variable.
 __toString ()

Protected Attributes

 $_expression

Detailed Description

SqlQueryBuilder is based on Zend_Db_Select (23775) from Zend Framework (1.10.11) It's not compatible with the Zend_Db_Select and it's not dependent on Zend.

It contains parts from Zend_Db_Adapter_Abstract for quoting.

Several additional features has been added:

  • ability to build insert, update, delete and replace statements

LICENSE

This source file is subject to the new BSD license that is bundled with this package in the file LICENSE.txt. It is also available through the world-wide-web at this URL: http://framework.zend.com/license/new-bsd If you did not receive a copy of the license and are unable to obtain it through the world-wide-web, please send an email to license@zend.com so we can send you a copy immediately.

Copyright:
Copyright (c) 2005-2011 Zend Technologies USA Inc. (http://www.zend.com), Copyright (c) 2011 STAMINA Rafał Lindemann http://framework.zend.com/license/new-bsd New BSD License
Version:
1.0 Class for SQL SELECT fragments.

This class simply holds a string, so that fragments of SQL statements can be distinguished from identifiers and values that should be implicitly quoted when interpolated into SQL statements.

For example, when specifying a primary key value when inserting into a new row, some RDBMS brands may require you to use an expression to generate the new value of a sequence. If this expression is treated as an identifier, it will be quoted and the expression will not be evaluated. Another example is that you can use SqlQueryExpr in the SqlQueryBuilder::order() method to order by an expression instead of simply a column name.

The way this works is that in each context in which a column name can be specified to methods of Zend_Db classes, if the value is an instance of SqlQueryExpr instead of a plain string, then the expression is not quoted. If it is a plain string, it is assumed to be a plain column name.

Constructor & Destructor Documentation

SqlQueryExpr::__construct ( $  expression)

Instantiate an expression, which is just a string stored as an instance member variable.

Parameters:
string$expressionThe string containing a SQL expression.

Member Function Documentation

SqlQueryExpr::__toString ( )
Returns:
string The string of the SQL expression stored in this object.

Field Documentation

SqlQueryExpr::$_expression [protected]
The documentation for this class was generated from the following file: