- 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