Class Zend_Db_Table_Select

Description

Class for SQL SELECT query manipulation for the Zend_Db_Table component.

  • copyright: Copyright (c) 2005-2008 Zend Technologies USA Inc. (http://www.zend.com)
  • license: New BSD License

Located in /Db/Table/Select.php (line 46)

Zend_Db_Select
   |
   --Zend_Db_Table_Select
Variable Summary
Method Summary
 Zend_Db_Table_Select __construct (Zend_Db_Table_Abstract $table, Zend_Db_Table_Abstract $adapter)
 string assemble ()
 Zend_Db_Table_Select from (array|string|Zend_Db_Expr|Zend_Db_Table_Abstract $name, [array|string|Zend_Db_Expr $cols = self::SQL_WILDCARD], [string $schema = null])
 boolean isReadOnly ()
Variables
array $_info (line 53)

Table schema for parent Zend_Db_Table.

  • access: protected
array $_integrityCheck = true (line 60)

Table integrity override.

  • access: protected
Zend_Db_Table_Abstract $_table (line 67)

Table instance that created this select object

  • access: protected

Inherited Variables

Inherited from Zend_Db_Select

Zend_Db_Select::$_adapter
Zend_Db_Select::$_joinTypes
Zend_Db_Select::$_parts
Zend_Db_Select::$_partsInit
Zend_Db_Select::$_tableCols
Zend_Db_Select::$_unionTypes
Methods
Constructor __construct (line 74)

Class constructor

  • access: public
Zend_Db_Table_Select __construct (Zend_Db_Table_Abstract $table, Zend_Db_Table_Abstract $adapter)

Redefinition of:
Zend_Db_Select::__construct()
Class constructor
assemble (line 189)

Performs a validation on the select query before passing back to the parent class.

Ensures that only columns from the primary Zend_Db_Table are returned in the result.

  • return: This object as a SELECT string.
  • access: public
string assemble ()

Redefinition of:
Zend_Db_Select::assemble()
Converts this object to an SQL SELECT string.
from (line 170)

Adds a FROM table and optional columns to the query.

The table name can be expressed

  • return: This Zend_Db_Table_Select object.
  • access: public
Zend_Db_Table_Select from (array|string|Zend_Db_Expr|Zend_Db_Table_Abstract $name, [array|string|Zend_Db_Expr $cols = self::SQL_WILDCARD], [string $schema = null])

Redefinition of:
Zend_Db_Select::from()
Adds a FROM table and optional columns to the query.
getTable (line 85)

Return the table that created this select object

  • access: public
isReadOnly (line 125)

Tests query to determine if expressions or aliases columns exist.

  • access: public
boolean isReadOnly ()
setIntegrityCheck (line 114)

Sets the integrity check flag.

Setting this flag to false skips the checks for table joins, allowing 'hybrid' table rows to be created.

  • return: This Zend_Db_Select object.
  • access: public
Zend_Db_Select setIntegrityCheck ([ $flag = true], Zend_Db_Table_Abstract $adapter)
setTable (line 96)

Sets the primary table name and retrieves the table schema.

  • return: This Zend_Db_Select object.
  • access: public

Inherited Methods

Inherited From Zend_Db_Select

 Zend_Db_Select::__construct()
 Zend_Db_Select::assemble()
 Zend_Db_Select::columns()
 Zend_Db_Select::distinct()
 Zend_Db_Select::forUpdate()
 Zend_Db_Select::from()
 Zend_Db_Select::getAdapter()
 Zend_Db_Select::getPart()
 Zend_Db_Select::group()
 Zend_Db_Select::having()
 Zend_Db_Select::join()
 Zend_Db_Select::joinCross()
 Zend_Db_Select::joinFull()
 Zend_Db_Select::joinInner()
 Zend_Db_Select::joinLeft()
 Zend_Db_Select::joinNatural()
 Zend_Db_Select::joinRight()
 Zend_Db_Select::limit()
 Zend_Db_Select::limitPage()
 Zend_Db_Select::order()
 Zend_Db_Select::orHaving()
 Zend_Db_Select::orWhere()
 Zend_Db_Select::query()
 Zend_Db_Select::reset()
 Zend_Db_Select::union()
 Zend_Db_Select::where()
 Zend_Db_Select::_getDummyTable()
 Zend_Db_Select::_getQuotedSchema()
 Zend_Db_Select::_getQuotedTable()
 Zend_Db_Select::_join()
 Zend_Db_Select::_joinUsing()
 Zend_Db_Select::_renderColumns()
 Zend_Db_Select::_renderDistinct()
 Zend_Db_Select::_renderForupdate()
 Zend_Db_Select::_renderFrom()
 Zend_Db_Select::_renderGroup()
 Zend_Db_Select::_renderHaving()
 Zend_Db_Select::_renderLimitoffset()
 Zend_Db_Select::_renderOrder()
 Zend_Db_Select::_renderUnion()
 Zend_Db_Select::_renderWhere()
 Zend_Db_Select::_tableCols()
 Zend_Db_Select::_where()
 Zend_Db_Select::__call()
 Zend_Db_Select::__toString()
Class Constants

Documentation generated on Fri, 08 Jan 2010 17:30:00 -0500 by phpDocumentor 1.4.3