## [System.Data.DataGateway] element index

### Package indexes

- System.Caching
- default
- System.Collections
- System.Data.ActiveRecord
- System.Data.ActiveRecord.Relations
- System.Data.ActiveReecord.Scaffold.InputBuilder
- System.Data.ActiveRecord.Scaffold
- System.Data.Common
- System.Data.Common.Pgsql
- System.Data.Common.Mssql
- System.Data.Common.Mysql
- System.Data.Commom.Sqlite
- System.Data.Common.Oracle
- System.Data.Common.Sqlite
- System.Data.SqlMap.Configuration
- System.Data.SqlMap.Statements
- System.Data.SqlMap
- System.Data
- System.Exceptions
- System.I18N
- System
- System.IO
- System.Security
- System.Util
- System.Web.Services
- System.Web
- System.Web.UI.ActiveControls
- System.Web.UI
- System.Web.UI.WebControls.assets
- System.Web.UI.WebControls
- System.Xml

All elements
_
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
  TDataGatewayEventParameter::__construct() in TDataGatewayCommand.php
__construct
  TDataGatewayResultEventParameter::__construct() in TDataGatewayCommand.php
__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
  TDataGatewayCommand::createCriteriaFromString() in TDataGatewayCommand.php

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
  TDataGatewayCommand::extractMatchingConditions() in TDataGatewayCommand.php
  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
  TDataGatewayResultEventParameter::getCommand() in TDataGatewayCommand.php
getCommand
  TDataGatewayEventParameter::getCommand() in TDataGatewayCommand.php
  The database command to be executed. Do not rebind the parameters or change the sql query string.
getCompositeKeyCondition
  TDataGatewayCommand::getCompositeKeyCondition() in TDataGatewayCommand.php
  Construct a "pk IN ('key1', 'key2', ...)" criteria.
getCondition
  TSqlCriteria::getCondition() in TSqlCriteria.php
getCriteria
  TDataGatewayEventParameter::getCriteria() in TDataGatewayCommand.php
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
  TTableGateway::getDbConnection() in TTableGateway.php
getFindCommand
  TDataGatewayCommand::getFindCommand() in TDataGatewayCommand.php
  Build the find command from the criteria. Limit, Offset and Ordering are applied if applicable.
getIndexKeyCondition
  TDataGatewayCommand::getIndexKeyCondition() in TDataGatewayCommand.php
getIsNamedParameters
  TSqlCriteria::getIsNamedParameters() in TSqlCriteria.php
getLastInsertId
  TTableGateway::getLastInsertId() in TTableGateway.php
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
  TDataGatewayCommand::getPrimaryKeyCondition() in TDataGatewayCommand.php
  Create the condition and parameters for find by primary.
getResult
  TDataGatewayResultEventParameter::getResult() in TDataGatewayCommand.php
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
  TTableGateway::initCommandBuilder() in TTableGateway.php
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
  TTableGateway::onCreateCommand() in TTableGateway.php
  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
  TTableGateway::onExecuteCommand() in TTableGateway.php
  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
  TDataGatewayResultEventParameter::setResult() in TDataGatewayCommand.php
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