Zend Framework
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.
Class for SQL table interface.
ADAPTER = 'db'
DEFINITION = 'definition'
DEFINITION_CONFIG_NAME = 'definitionConfigName'
SCHEMA = 'schema'
NAME = 'name'
PRIMARY = 'primary'
COLS = 'cols'
METADATA = 'metadata'
METADATA_CACHE = 'metadataCache'
METADATA_CACHE_IN_CLASS = 'metadataCacheInClass'
ROW_CLASS = 'rowClass'
ROWSET_CLASS = 'rowsetClass'
REFERENCE_MAP = 'referenceMap'
DEPENDENT_TABLES = 'dependentTables'
SEQUENCE = 'sequence'
COLUMNS = 'columns'
REF_TABLE_CLASS = 'refTableClass'
REF_COLUMNS = 'refColumns'
ON_DELETE = 'onDelete'
ON_UPDATE = 'onUpdate'
CASCADE = 'cascade'
RESTRICT = 'restrict'
SET_NULL = 'setNull'
DEFAULT_NONE = 'defaultNone'
DEFAULT_CLASS = 'defaultClass'
DEFAULT_DB = 'defaultDb'
SELECT_WITH_FROM_PART = 'true'
SELECT_WITHOUT_FROM_PART = 'false'
array $_cols = ''
The table column names derived from Zend_Db_Adapter_Abstract::describeTable().
Zend_Db_Adapter_Abstract $_db = ''
Zend_Db_Adapter_Abstract object.
Zend_Db_Adapter_Abstract $_defaultDb = ''
Default Zend_Db_Adapter_Abstract object.
Zend_Cache_Core $_defaultMetadataCache = 'null'
Default cache for information provided by the adapter's describeTable() method.
$_defaultSource = 'self'
$_defaultValues = 'array'
unknown_type $_definition = 'null'
Optional Zend_Db_Table_Definition object
string $_definitionConfigName = 'null'
Optional definition config name used in concrete implementation
array $_dependentTables = 'array'
Simple array of class names of tables that are "children" of the current table, in other words tables that contain a foreign key to this one.
Array elements are not table names; they are class names of classes that extend Zend_Db_Table_Abstract.
integer $_identity = '1'
If your primary key is a compound key, and one of the columns uses an auto-increment or sequence-generated value, set _identity to the ordinal index in the $_primary array for that column.
Note this index is the position of the column in the primary key, not the position of the column in the table. The primary key array is 1-based.
array $_metadata = 'array'
Information provided by the adapter's describeTable() method.
Zend_Cache_Core $_metadataCache = 'null'
Cache for information provided by the adapter's describeTable() method.
bool $_metadataCacheInClass = 'true'
Flag: whether or not to cache metadata in the class
string $_name = 'null'
The table name.
mixed $_primary = 'null'
The primary key column or columns.
A compound key should be declared as an array. You may declare a single-column primary key as a string.
array $_referenceMap = 'array'
Associative array map of declarative referential integrity rules.
This array has one entry per foreign key in the current table. Each key is a mnemonic name for one reference rule.
Each value is also an associative array, with the following keys: - columns = array of names of column(s) in the child table. - refTableClass = class name of the parent table. - refColumns = array of names of column(s) in the parent table, in the same order as those in the 'columns' entry. - onDelete = "cascade" means that a delete in the parent table also causes a delete of referencing rows in the child table. - onUpdate = "cascade" means that an update of primary key values in the parent table also causes an update of referencing rows in the child table.
string $_rowClass = 'Zend_Db_Table_Row'
Classname for row
string $_rowsetClass = 'Zend_Db_Table_Rowset'
Classname for rowset
array $_schema = 'null'
The schema name (default null means current schema)
mixed $_sequence = 'true'
Define the logic for new values in the primary key.
May be a string, boolean true, or boolean false.
__construct(
mixed $config
=
array
)
:
void
Constructor.
Supported params for $config are: - db = user-supplied instance of database connector, or key name of registry instance. - name = table name. - primary = string or array of primary key(s). - rowClass = row class name. - rowsetClass = rowset class name. - referenceMap = array structure to declare relationship to parent tables. - dependentTables = array of child tables. - metadataCache = cache for information from adapter describeTable().
_cascadeDelete(
string $parentTableClassname, array $primaryKey
)
:
int
Called by parent table's class during delete() method.
_cascadeUpdate(
string $parentTableClassname, array $oldPrimaryKey, array $newPrimaryKey
)
:
int
Called by a row object for the parent table's class during save() method.
_fetch(
Zend_Db_Table_Select $select
)
:
array
Support method for fetching rows.
_getCols(
)
:
array
Retrieve table columns
_getReferenceMapNormalized(
)
:
array
Returns a normalized version of the reference map
_order(
$select, string|array $order
)
:
Zend_Db_Table_Select
Generate ORDER clause from user-supplied string or array
_setAdapter(
mixed $db
)
:
Zend_Db_Table_Abstract
_setMetadataCache(
mixed $metadataCache
)
:
Zend_Db_Table_Abstract
Sets the metadata cache for information returned by Zend_Db_Adapter_Abstract::describeTable().
If $metadataCache is null, then no metadata cache is used. Since there is no opportunity to reload metadata after instantiation, this method need not be public, particularly because that it would have no effect results in unnecessary API complexity. To configure the metadata cache, use the metadataCache configuration option for the class constructor upon instantiation.
_setSequence(
mixed $sequence
)
:
Zend_Db_Table_Adapter_Abstract
Sets the sequence member, which defines the behavior for generating primary key values in new rows.
_setup(
)
:
void
Turnkey for initialization of a table object.
Calls other protected methods for individual tasks, to make it easier for a subclass to override part of the setup logic.
_setupAdapter(
mixed $db
)
:
Zend_Db_Adapter_Abstract
_setupDatabaseAdapter(
)
:
void
Initialize database adapter.
_setupMetadata(
)
:
boolean
Initializes metadata.
If metadata cannot be loaded from cache, adapter's describeTable() method is called to discover metadata information. Returns true if and only if the metadata are loaded from cache.
_setupMetadataCache(
mixed $metadataCache
)
:
Zend_Cache_Core
_setupPrimaryKey(
)
:
void
Initialize primary key from metadata.
If $_primary is not defined, discover primary keys from the information returned by describeTable().
_setupTableName(
)
:
void
Initialize table and schema names.
If the table name is not set in the class definition, use the class name itself as the table name.
A schema name provided with the table name (e.g., "schema.table") overrides any existing value for $this->_schema.
_where(
$select, string|array $where
)
:
Zend_Db_Table_Select
Generate WHERE clause from user-supplied string or array
addReference(
string $ruleKey, string|array $columns, string $refTableClass, string|array $refColumns, string $onDelete
=
null, string $onUpdate
=
null
)
:
Zend_Db_Table_Abstract
Add a reference to the reference map
createRow(
array $data
=
array, string $defaultSource
=
null
)
:
Zend_Db_Table_Row_Abstract
Fetches a new blank row (not from the database).
delete(
array|string $where
)
:
int
Deletes existing rows.
fetchAll(
string|array|Zend_Db_Table_Select $where
=
null, string|array $order
=
null, int $count
=
null, int $offset
=
null
)
:
Zend_Db_Table_Rowset_Abstract
Fetches all rows.
Honors the Zend_Db_Adapter fetch mode.
fetchNew(
)
:
Zend_Db_Table_Row_Abstract
Fetches a new blank row (not from the database).
fetchRow(
string|array|Zend_Db_Table_Select $where
=
null, string|array $order
=
null
)
:
Zend_Db_Table_Row_Abstract|null
Fetches one row in an object of type Zend_Db_Table_Row_Abstract, or returns null if no row matches the specified criteria.
find(
)
:
Zend_Db_Table_Rowset_Abstract
Fetches rows by primary key. The argument specifies one or more primary key value(s). To find multiple rows by primary key, the argument must be an array.
This method accepts a variable number of arguments. If the table has a multi-column primary key, the number of arguments must be the same as the number of columns in the primary key. To find multiple rows in a table with a multi-column primary key, each argument must be an array with the same number of elements.
The find() method always returns a Rowset object, even if only one row was found.
getAdapter(
)
:
Zend_Db_Adapter_Abstract
Gets the Zend_Db_Adapter_Abstract for this particular Zend_Db_Table object.
getDefaultAdapter(
)
:
Zend_Db_Adapter_Abstract
Gets the default Zend_Db_Adapter_Abstract for all Zend_Db_Table objects.
getDefaultMetadataCache(
)
:
Zend_Cache_Core
Gets the default metadata cache for information returned by Zend_Db_Adapter_Abstract::describeTable().
getDefaultSource(
)
:
unknown
returns the default source flag that determines where defaultSources come from
getDefaultValues(
)
:
getDefinition(
)
:
Zend_Db_Table_Definition|null
getDefinition()
getDefinitionConfigName(
)
:
string
getDefinitionConfigName()
getDependentTables(
)
:
array
getMetadataCache(
)
:
Zend_Cache_Core
Gets the metadata cache for information returned by Zend_Db_Adapter_Abstract::describeTable().
getReference(
string $tableClassname, string $ruleKey
=
null
)
:
array
getRowClass(
)
:
string
getRowsetClass(
)
:
string
info(
$key $key
=
null
)
:
mixed
Returns table information.
You can elect to return only a part of this information by supplying its key name, otherwise all information is returned as an array.
init(
)
:
void
Initialize object
Called from {@link __construct()} as final step of object instantiation.
insert(
array $data
)
:
mixed
Inserts a new row.
isIdentity(
string $column
)
:
boolean
Check if the provided column is an identity of the table
metadataCacheInClass(
)
:
bool
Retrieve flag indicating if metadata should be cached for duration of instance
select(
bool $withFromPart
=
self
)
:
Zend_Db_Table_Select
Returns an instance of a Zend_Db_Table_Select object.
setDefaultAdapter(
mixed $db
=
null
)
:
void
Sets the default Zend_Db_Adapter_Abstract for all Zend_Db_Table objects.
setDefaultMetadataCache(
mixed $metadataCache
=
null
)
:
void
Sets the default metadata cache for information returned by Zend_Db_Adapter_Abstract::describeTable().
If $defaultMetadataCache is null, then no metadata cache is used by default.
setDefaultSource(
string $defaultSource
=
self
)
:
Zend_Db_Table_Abstract
set the defaultSource property - this tells the table class where to find default values
setDefaultValues(
array $defaultValues
)
:
Zend_Db_Table_Abstract
set the default values for the table class
setDefinition(
Zend_Db_Table_Definition $definition
)
:
Zend_Db_Table_Abstract
setDefinition()
setDefinitionConfigName(
$definitionConfigName
)
:
Zend_Db_Table_Abstract
setDefinitionConfigName()
setDependentTables(
array $dependentTables
)
:
Zend_Db_Table_Abstract
setMetadataCacheInClass(
bool $flag
)
:
Zend_Db_Table_Abstract
Indicate whether metadata should be cached in the class for the duration of the instance
setOptions(
array $options
)
:
Zend_Db_Table_Abstract
setOptions()
setReferences(
array $referenceMap
)
:
Zend_Db_Table_Abstract
setRowClass(
string $classname
)
:
Zend_Db_Table_Abstract
setRowsetClass(
string $classname
)
:
Zend_Db_Table_Abstract
update(
array $data, array|string $where
)
:
int
Updates existing rows.