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:
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