[System.Data.DataGateway] element index

Package indexes

All elements
c d e f g i o q s t u _
_
top
__call
TTableGateway::__call() in TTableGateway.php
Dynamic find method using parts of method name as search criteria.
__construct
TTableGateway::__construct() in TTableGateway.php
Creates a new generic table gateway for a given table or view name and a database connection.
__construct
TDataGatewayCommand::__construct() in TDataGatewayCommand.php
__construct
TSqlCriteria::__construct() in TSqlCriteria.php
Creates a new criteria with given condition;
__construct
__construct
__toString
TSqlCriteria::__toString() in TSqlCriteria.php
c
top
count
TDataGatewayCommand::count() in TDataGatewayCommand.php
count
TTableGateway::count() in TTableGateway.php
Find the number of records.
createCriteriaFromString
d
top
delete
TDataGatewayCommand::delete() in TDataGatewayCommand.php
Executes a delete command.
deleteAll
TTableGateway::deleteAll() in TTableGateway.php
Delete records from the table with condition given by $where and binding values specified by $parameter argument.
deleteAllByPks
TTableGateway::deleteAllByPks() in TTableGateway.php
Alias for deleteByPk()
deleteByPk
TTableGateway::deleteByPk() in TTableGateway.php
Delete records by primary key. Usage:
deleteByPk
TDataGatewayCommand::deleteByPk() in TDataGatewayCommand.php
e
top
extractMatchingConditions
Calculates the AND/OR condition from dynamic method substrings using table meta data, allows for any AND-OR combinations.
f
top
find
TDataGatewayCommand::find() in TDataGatewayCommand.php
Find one record matching the critera.
find
TTableGateway::find() in TTableGateway.php
Find one single record that matches the criteria.
findAll
TDataGatewayCommand::findAll() in TDataGatewayCommand.php
Find one or more matching records.
findAll
TTableGateway::findAll() in TTableGateway.php
Accepts same parameters as find(), but returns TDbDataReader instead.
findAllByIndex
TDataGatewayCommand::findAllByIndex() in TDataGatewayCommand.php
findAllByPk
TDataGatewayCommand::findAllByPk() in TDataGatewayCommand.php
findAllByPks
TTableGateway::findAllByPks() in TTableGateway.php
Similar to findByPk(), but returns TDbDataReader instead.
findAllBySql
TDataGatewayCommand::findAllBySql() in TDataGatewayCommand.php
Find zero or more matching records for arbituary SQL.
findAllBySql
TTableGateway::findAllBySql() in TTableGateway.php
Execute arbituary sql command with binding parameters.
findByPk
TTableGateway::findByPk() in TTableGateway.php
Find one record using only the primary key or composite primary keys. Usage:
findByPk
TDataGatewayCommand::findByPk() in TDataGatewayCommand.php
findBySql
TTableGateway::findBySql() in TTableGateway.php
Execute arbituary sql command with binding parameters.
findBySql
TDataGatewayCommand::findBySql() in TDataGatewayCommand.php
Find one matching records for arbituary SQL.
g
top
getBuilder
TDataGatewayCommand::getBuilder() in TDataGatewayCommand.php
getCommand
TTableGateway::getCommand() in TTableGateway.php
getCommand
getCommand
TDataGatewayEventParameter::getCommand() in TDataGatewayCommand.php
The database command to be executed. Do not rebind the parameters or change the sql query string.
getCompositeKeyCondition
Construct a "pk IN ('key1', 'key2', ...)" criteria.
getCondition
TSqlCriteria::getCondition() in TSqlCriteria.php
getCriteria
getCriteria
TTableGateway::getCriteria() in TTableGateway.php
Create a new TSqlCriteria object from a string $criteria. The $args are additional parameters and are used in place of the $parameters if $parameters is not an array and $args is an arrary.
getDbConnection
TDataGatewayCommand::getDbConnection() in TDataGatewayCommand.php
getDbConnection
getFindCommand
TDataGatewayCommand::getFindCommand() in TDataGatewayCommand.php
Build the find command from the criteria. Limit, Offset and Ordering are applied if applicable.
getIndexKeyCondition
getIsNamedParameters
getLastInsertId
getLastInsertID
TDataGatewayCommand::getLastInsertID() in TDataGatewayCommand.php
Iterate through all the columns and returns the last insert id of the first column that has a sequence or serial.
getLimit
TSqlCriteria::getLimit() in TSqlCriteria.php
getOffset
TSqlCriteria::getOffset() in TSqlCriteria.php
getOrdersBy
TSqlCriteria::getOrdersBy() in TSqlCriteria.php
getParameters
TSqlCriteria::getParameters() in TSqlCriteria.php
getPrimaryKeyCondition
Create the condition and parameters for find by primary.
getResult
getSqlCommand
TDataGatewayCommand::getSqlCommand() in TDataGatewayCommand.php
Build sql command from the criteria. Limit, Offset and Ordering are applied if applicable.
getTableInfo
TDataGatewayCommand::getTableInfo() in TDataGatewayCommand.php
getTableInfo
TTableGateway::getTableInfo() in TTableGateway.php
getTableName
TTableGateway::getTableName() in TTableGateway.php
i
top
initCommandBuilder
insert
TTableGateway::insert() in TTableGateway.php
Inserts a new record into the table. Each array key must correspond to a column name in the table unless a null value is permitted.
insert
TDataGatewayCommand::insert() in TDataGatewayCommand.php
Inserts a new record into the table. Each array key must correspond to a column name in the table unless a null value is permitted.
o
top
onCreateCommand
Raised when a command is prepared and parameter binding is completed.
onCreateCommand
TDataGatewayCommand::onCreateCommand() in TDataGatewayCommand.php
Raised when a command is prepared and parameter binding is completed.
onExecuteCommand
Raised when a command is executed and the result from the database was returned.
onExecuteCommand
TDataGatewayCommand::onExecuteCommand() in TDataGatewayCommand.php
Raised when a command is executed and the result from the database was returned.
q
top
quoteTuple
TDataGatewayCommand::quoteTuple() in TDataGatewayCommand.php
s
top
setCondition
TSqlCriteria::setCondition() in TSqlCriteria.php
Sets the search conditions to be placed after the WHERE clause in the SQL.
setLimit
TSqlCriteria::setLimit() in TSqlCriteria.php
setOffset
TSqlCriteria::setOffset() in TSqlCriteria.php
setOrdersBy
TSqlCriteria::setOrdersBy() in TSqlCriteria.php
setParameters
TSqlCriteria::setParameters() in TSqlCriteria.php
setResult
setTableInfo
TTableGateway::setTableInfo() in TTableGateway.php
setTableName
TTableGateway::setTableName() in TTableGateway.php
Sets up the command builder for the given table.
t
top
TDataGatewayCommand.php
TDataGatewayCommand.php in TDataGatewayCommand.php
TSqlCriteria.php
TSqlCriteria.php in TSqlCriteria.php
TTableGateway.php
TTableGateway.php in TTableGateway.php
TDataGatewayCommand
TDataGatewayCommand in TDataGatewayCommand.php
TDataGatewayCommand is command builder and executor class for TTableGateway and TActiveRecordGateway.
TDataGatewayEventParameter
TDataGatewayEventParameter in TDataGatewayCommand.php
TDataGatewayEventParameter class contains the TDbCommand to be executed as well as the criteria object.
TDataGatewayResultEventParameter
TDataGatewayResultEventParameter in TDataGatewayCommand.php
TDataGatewayResultEventParameter contains the TDbCommand executed and the resulting data returned from the database. The data can be changed by changing the setResult property.
TSqlCriteria
TSqlCriteria in TSqlCriteria.php
Search criteria for TDbDataGateway.
TTableGateway
TTableGateway in TTableGateway.php
TTableGateway class provides several find methods to get data from the database and update, insert, and delete methods.
u
top
update
TDataGatewayCommand::update() in TDataGatewayCommand.php
Updates the table with new data.
update
TTableGateway::update() in TTableGateway.php
Updates the table with new name-value pair $data. Each array key must correspond to a column name in the table. The update condition is specified by the $where argument and additional binding values can be specified using the $parameter argument.
updateByPk
TDataGatewayCommand::updateByPk() in TDataGatewayCommand.php
c d e f g i o q s t u _