PHP Class Zend_Db_Table_Select

Inheritance: extends Zend_Db_Select
Show file Open project: dbpatch/dbpatch Class Usage Examples

Protected Properties

Property Type Description
$_info array Table schema for parent Zend_Db_Table.
$_integrityCheck array Table integrity override.
$_table Zend_Db_Table_Abstract Table instance that created this select object

Public Methods

Method Description
__construct ( Zend_Db_Table_Abstract $table ) Class constructor
assemble ( ) : string | null Performs a validation on the select query before passing back to the parent class.
from ( array | string | Zend_Db_Expr | Zend_Db_Table_Abstract $name, array | string | Zend_Db_Expr $cols = self::SQL_WILDCARD, string $schema = null ) : Zend_Db_Table_Select Adds a FROM table and optional columns to the query.
getTable ( ) : Zend_Db_Table_Abstract Return the table that created this select object
isReadOnly ( ) : boolean Tests query to determine if expressions or aliases columns exist.
setIntegrityCheck ( $flag = true ) : Zend_Db_Select Sets the integrity check flag.
setTable ( Zend_Db_Table_Abstract $table ) : Zend_Db_Select Sets the primary table name and retrieves the table schema.

Method Details

__construct() public method

Class constructor
public __construct ( Zend_Db_Table_Abstract $table )
$table Zend_Db_Table_Abstract

assemble() public method

Ensures that only columns from the primary Zend_Db_Table are returned in the result.
public assemble ( ) : string | null
return string | null This object as a SELECT string (or null if a string cannot be produced)

from() public method

The table name can be expressed
public from ( array | string | Zend_Db_Expr | Zend_Db_Table_Abstract $name, array | string | Zend_Db_Expr $cols = self::SQL_WILDCARD, string $schema = null ) : Zend_Db_Table_Select
$name array | string | Zend_Db_Expr | Zend_Db_Table_Abstract The table name or an associative array relating table name to correlation name.
$cols array | string | Zend_Db_Expr The columns to select from this table.
$schema string The schema name to specify, if any.
return Zend_Db_Table_Select This Zend_Db_Table_Select object.

getTable() public method

Return the table that created this select object
public getTable ( ) : Zend_Db_Table_Abstract
return Zend_Db_Table_Abstract

isReadOnly() public method

Tests query to determine if expressions or aliases columns exist.
public isReadOnly ( ) : boolean
return boolean

setIntegrityCheck() public method

Setting this flag to false skips the checks for table joins, allowing 'hybrid' table rows to be created.
public setIntegrityCheck ( $flag = true ) : Zend_Db_Select
return Zend_Db_Select This Zend_Db_Select object.

setTable() public method

Sets the primary table name and retrieves the table schema.
public setTable ( Zend_Db_Table_Abstract $table ) : Zend_Db_Select
$table Zend_Db_Table_Abstract
return Zend_Db_Select This Zend_Db_Select object.

Property Details

$_info protected property

Table schema for parent Zend_Db_Table.
protected array $_info
return array

$_integrityCheck protected property

Table integrity override.
protected array $_integrityCheck
return array

$_table protected property

Table instance that created this select object
protected Zend_Db_Table_Abstract $_table
return Zend_Db_Table_Abstract