- Home
- About
- Testimonials
- Demos
- Download
- Documentation
- Blogs
- Forum
- Support

Packages:
System.IO
default
System.Web.UI
System.Web.UI.ActiveControls
System.Web.UI.WebControls
System.Web.UI.WebControls.assets
System.Web
System.Web.Services
System.Xml
System.Data.Common.Pgsql
System.Data.Common.Mssql
System.Data.Common
System.Data.Common.Mysql
System.Data.Commom.Sqlite
System.Data.Common.Oracle
System.Data.Common.Sqlite
System.Data
System.Data.ActiveRecord
System.Data.ActiveRecord.Relations
System.Data.ActiveReecord.Scaffold.InputBuilder
System.Data.ActiveRecord.Scaffold
System.Data.DataGateway
System.Data.SqlMap
System.Data.SqlMap.Statements
System.Data.SqlMap.Configuration
System.I18N
System.Util
System
System.Collections
System.Caching
System.Security
System.Exceptions
Classes:
TDataGatewayCommand
TDataGatewayEventParameter
TDataGatewayResultEventParameter
TSqlCriteria
TTableGateway

Keyword

# Element index for package System.Data.DataGateway

[ c ] [ d ] [ e ] [ f ] [ g ] [ i ] [ o ] [ q ] [ s ] [ t ] [ u ] [ _ ]

## _

__call
  in file TTableGateway.php, method TTableGateway::__call()
  Dynamic find method using parts of method name as search criteria.
__construct
  in file TTableGateway.php, method TTableGateway::__construct()
  Creates a new generic table gateway for a given table or view name and a database connection.
__construct
  in file TDataGatewayCommand.php, method TDataGatewayCommand::__construct()
__construct
  in file TSqlCriteria.php, method TSqlCriteria::__construct()
  Creates a new criteria with given condition;
__construct
  in file TDataGatewayCommand.php, method TDataGatewayEventParameter::__construct()
__construct
  in file TDataGatewayCommand.php, method TDataGatewayResultEventParameter::__construct()
__toString
  in file TSqlCriteria.php, method TSqlCriteria::__toString()

top

## c

count
  in file TDataGatewayCommand.php, method TDataGatewayCommand::count()
count
  in file TTableGateway.php, method TTableGateway::count()
  Find the number of records.
createCriteriaFromString
  in file TDataGatewayCommand.php, method TDataGatewayCommand::createCriteriaFromString()

top

## d

delete
  in file TDataGatewayCommand.php, method TDataGatewayCommand::delete()
  Executes a delete command.
deleteAll
  in file TTableGateway.php, method TTableGateway::deleteAll()
  Delete records from the table with condition given by $where and binding values specified by $parameter argument.
deleteAllByPks
  in file TTableGateway.php, method TTableGateway::deleteAllByPks()
  Alias for deleteByPk()
deleteByPk
  in file TTableGateway.php, method TTableGateway::deleteByPk()
  Delete records by primary key. Usage:
deleteByPk
  in file TDataGatewayCommand.php, method TDataGatewayCommand::deleteByPk()

top

## e

extractMatchingConditions
  in file TDataGatewayCommand.php, method TDataGatewayCommand::extractMatchingConditions()
  Calculates the AND/OR condition from dynamic method substrings using table meta data, allows for any AND-OR combinations.

top

## f

find
  in file TDataGatewayCommand.php, method TDataGatewayCommand::find()
  Find one record matching the critera.
find
  in file TTableGateway.php, method TTableGateway::find()
  Find one single record that matches the criteria.
findAll
  in file TDataGatewayCommand.php, method TDataGatewayCommand::findAll()
  Find one or more matching records.
findAll
  in file TTableGateway.php, method TTableGateway::findAll()
  Accepts same parameters as find(), but returns TDbDataReader instead.
findAllByIndex
  in file TDataGatewayCommand.php, method TDataGatewayCommand::findAllByIndex()
findAllByPk
  in file TDataGatewayCommand.php, method TDataGatewayCommand::findAllByPk()
findAllByPks
  in file TTableGateway.php, method TTableGateway::findAllByPks()
  Similar to findByPk(), but returns TDbDataReader instead.
findAllBySql
  in file TDataGatewayCommand.php, method TDataGatewayCommand::findAllBySql()
  Find zero or more matching records for arbituary SQL.
findAllBySql
  in file TTableGateway.php, method TTableGateway::findAllBySql()
  Execute arbituary sql command with binding parameters.
findByPk
  in file TTableGateway.php, method TTableGateway::findByPk()
  Find one record using only the primary key or composite primary keys. Usage:
findByPk
  in file TDataGatewayCommand.php, method TDataGatewayCommand::findByPk()
findBySql
  in file TTableGateway.php, method TTableGateway::findBySql()
  Execute arbituary sql command with binding parameters.
findBySql
  in file TDataGatewayCommand.php, method TDataGatewayCommand::findBySql()
  Find one matching records for arbituary SQL.

top

## g

getBuilder
  in file TDataGatewayCommand.php, method TDataGatewayCommand::getBuilder()
getCommand
  in file TTableGateway.php, method TTableGateway::getCommand()
getCommand
  in file TDataGatewayCommand.php, method TDataGatewayResultEventParameter::getCommand()
getCommand
  in file TDataGatewayCommand.php, method TDataGatewayEventParameter::getCommand()
  The database command to be executed. Do not rebind the parameters or change the sql query string.
getCompositeKeyCondition
  in file TDataGatewayCommand.php, method TDataGatewayCommand::getCompositeKeyCondition()
  Construct a "pk IN ('key1', 'key2', ...)" criteria.
getCondition
  in file TSqlCriteria.php, method TSqlCriteria::getCondition()
getCriteria
  in file TDataGatewayCommand.php, method TDataGatewayEventParameter::getCriteria()
getCriteria
  in file TTableGateway.php, method TTableGateway::getCriteria()
  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
  in file TDataGatewayCommand.php, method TDataGatewayCommand::getDbConnection()
getDbConnection
  in file TTableGateway.php, method TTableGateway::getDbConnection()
getFindCommand
  in file TDataGatewayCommand.php, method TDataGatewayCommand::getFindCommand()
  Build the find command from the criteria. Limit, Offset and Ordering are applied if applicable.
getIndexKeyCondition
  in file TDataGatewayCommand.php, method TDataGatewayCommand::getIndexKeyCondition()
getIsNamedParameters
  in file TSqlCriteria.php, method TSqlCriteria::getIsNamedParameters()
getLastInsertId
  in file TTableGateway.php, method TTableGateway::getLastInsertId()
getLastInsertID
  in file TDataGatewayCommand.php, method TDataGatewayCommand::getLastInsertID()
  Iterate through all the columns and returns the last insert id of the first column that has a sequence or serial.
getLimit
  in file TSqlCriteria.php, method TSqlCriteria::getLimit()
getOffset
  in file TSqlCriteria.php, method TSqlCriteria::getOffset()
getOrdersBy
  in file TSqlCriteria.php, method TSqlCriteria::getOrdersBy()
getParameters
  in file TSqlCriteria.php, method TSqlCriteria::getParameters()
getPrimaryKeyCondition
  in file TDataGatewayCommand.php, method TDataGatewayCommand::getPrimaryKeyCondition()
  Create the condition and parameters for find by primary.
getResult
  in file TDataGatewayCommand.php, method TDataGatewayResultEventParameter::getResult()
getSqlCommand
  in file TDataGatewayCommand.php, method TDataGatewayCommand::getSqlCommand()
  Build sql command from the criteria. Limit, Offset and Ordering are applied if applicable.
getTableInfo
  in file TDataGatewayCommand.php, method TDataGatewayCommand::getTableInfo()
getTableInfo
  in file TTableGateway.php, method TTableGateway::getTableInfo()
getTableName
  in file TTableGateway.php, method TTableGateway::getTableName()

top

## i

initCommandBuilder
  in file TTableGateway.php, method TTableGateway::initCommandBuilder()
insert
  in file TTableGateway.php, method TTableGateway::insert()
  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
  in file TDataGatewayCommand.php, method TDataGatewayCommand::insert()
  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.

top

## o

onCreateCommand
  in file TTableGateway.php, method TTableGateway::onCreateCommand()
  Raised when a command is prepared and parameter binding is completed.
onCreateCommand
  in file TDataGatewayCommand.php, method TDataGatewayCommand::onCreateCommand()
  Raised when a command is prepared and parameter binding is completed.
onExecuteCommand
  in file TTableGateway.php, method TTableGateway::onExecuteCommand()
  Raised when a command is executed and the result from the database was returned.
onExecuteCommand
  in file TDataGatewayCommand.php, method TDataGatewayCommand::onExecuteCommand()
  Raised when a command is executed and the result from the database was returned.

top

## q

quoteTuple
  in file TDataGatewayCommand.php, method TDataGatewayCommand::quoteTuple()

top

## s

setCondition
  in file TSqlCriteria.php, method TSqlCriteria::setCondition()
  Sets the search conditions to be placed after the WHERE clause in the SQL.
setLimit
  in file TSqlCriteria.php, method TSqlCriteria::setLimit()
setOffset
  in file TSqlCriteria.php, method TSqlCriteria::setOffset()
setOrdersBy
  in file TSqlCriteria.php, method TSqlCriteria::setOrdersBy()
setParameters
  in file TSqlCriteria.php, method TSqlCriteria::setParameters()
setResult
  in file TDataGatewayCommand.php, method TDataGatewayResultEventParameter::setResult()
setTableInfo
  in file TTableGateway.php, method TTableGateway::setTableInfo()
setTableName
  in file TTableGateway.php, method TTableGateway::setTableName()
  Sets up the command builder for the given table.

top

## t

TDataGatewayCommand.php
  procedural page TDataGatewayCommand.php
TSqlCriteria.php
  procedural page TSqlCriteria.php
TTableGateway.php
  procedural page TTableGateway.php
TDataGatewayCommand
  in file TDataGatewayCommand.php, class TDataGatewayCommand
  TDataGatewayCommand is command builder and executor class for TTableGateway and TActiveRecordGateway.
TDataGatewayEventParameter
  in file TDataGatewayCommand.php, class TDataGatewayEventParameter
  TDataGatewayEventParameter class contains the TDbCommand to be executed as well as the criteria object.
TDataGatewayResultEventParameter
  in file TDataGatewayCommand.php, class TDataGatewayResultEventParameter
  TDataGatewayResultEventParameter contains the TDbCommand executed and the resulting data returned from the database. The data can be changed by changing the setResult property.
TSqlCriteria
  in file TSqlCriteria.php, class TSqlCriteria
  Search criteria for TDbDataGateway.
TTableGateway
  in file TTableGateway.php, class TTableGateway
  TTableGateway class provides several find methods to get data from the database and update, insert, and delete methods.

top

## u

update
  in file TDataGatewayCommand.php, method TDataGatewayCommand::update()
  Updates the table with new data.
update
  in file TTableGateway.php, method TTableGateway::update()
  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
  in file TDataGatewayCommand.php, method TDataGatewayCommand::updateByPk()

top