- 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: IMappedStatement TCachingStatement TDeleteMappedStatement TInsertMappedStatement TMappedStatement TPostSelectBinding TPreparedCommand TPreparedStatement TPreparedStatementFactory TResultSetListItemParameter TResultSetMapItemParameter TSelectMappedStatement TSimpleDynamicSql TSqlMapObjectCollectionTree TSqlMapSelect TStaticSql TUpdateMappedStatement |
Keyword
# Element index for package System.Data.SqlMap.Statements [ a ] [ b ] [ c ] [ e ] [ f ] [ g ] [ h ] [ i ] [ o ] [ p ] [ r ] [ s ] [ t ] [ u ] [ _ ] ## _ __construct in file TPreparedStatementFactory.php, method TPreparedStatementFactory::__construct() __construct in file TSimpleDynamicSql.php, method TSimpleDynamicSql::__construct() __construct in file TPreparedStatement.php, method TPreparedStatement::__construct() __construct in file TMappedStatement.php, method TResultSetMapItemParameter::__construct() __construct in file TMappedStatement.php, method TMappedStatement::__construct() Creates a new mapped statement. __construct in file TMappedStatement.php, method TResultSetListItemParameter::__construct() __construct in file TCachingStatement.php, method TCachingStatement::__construct() top ## a add in file TMappedStatement.php, method TSqlMapObjectCollectionTree::add() Add a new node to the object tree graph. addNode in file TMappedStatement.php, method TSqlMapObjectCollectionTree::addNode() Find the parent node and add the new node as its child. addResultMapGroupBy in file TMappedStatement.php, method TMappedStatement::addResultMapGroupBy() ResultMap with GroupBy property. Save object collection graph in a tree and collect the result later. applyParameterMap in file TPreparedCommand.php, method TPreparedCommand::applyParameterMap() applyResultMap in file TMappedStatement.php, method TMappedStatement::applyResultMap() Apply result mapping. top ## b buildPreparedStatement in file TStaticSql.php, method TStaticSql::buildPreparedStatement() top ## c collect in file TMappedStatement.php, method TSqlMapObjectCollectionTree::collect() collectChildren in file TMappedStatement.php, method TSqlMapObjectCollectionTree::collectChildren() Visit all the child nodes and collect them by removing. create in file TPreparedCommand.php, method TPreparedCommand::create() createCommand in file TCachingStatement.php, method TCachingStatement::createCommand() createParametersForTextCommand in file TPreparedStatementFactory.php, method TPreparedStatementFactory::createParametersForTextCommand() top ## e enquequePostSelect in file TMappedStatement.php, method TMappedStatement::enquequePostSelect() Add nested result property to post select queue. executeInsert in file TSelectMappedStatement.php, method TSelectMappedStatement::executeInsert() executeInsert in file TUpdateMappedStatement.php, method TUpdateMappedStatement::executeInsert() executeInsert in file TCachingStatement.php, method TCachingStatement::executeInsert() executeInsert in file TMappedStatement.php, method TMappedStatement::executeInsert() Execute an insert statement. Fill the parameter object with the ouput parameters if any, also could return the insert generated key. executePostSelect in file TMappedStatement.php, method TMappedStatement::executePostSelect() Process 'select' result properties executeQueryForList in file TCachingStatement.php, method TCachingStatement::executeQueryForList() executeQueryForList in file TUpdateMappedStatement.php, method TUpdateMappedStatement::executeQueryForList() executeQueryForList in file IMappedStatement.php, method IMappedStatement::executeQueryForList() Executes the SQL and retuns a subset of the rows selected. executeQueryForList in file TMappedStatement.php, method TMappedStatement::executeQueryForList() Executes the SQL and retuns a List of result objects. executeQueryForList in file TInsertMappedStatement.php, method TInsertMappedStatement::executeQueryForList() executeQueryForMap in file TMappedStatement.php, method TMappedStatement::executeQueryForMap() Executes the SQL and retuns all rows selected in a map that is keyed on the property named in the keyProperty parameter. The value at each key will be the value of the property specified in the valueProperty parameter. executeQueryForMap in file TCachingStatement.php, method TCachingStatement::executeQueryForMap() executeQueryForMap in file IMappedStatement.php, method IMappedStatement::executeQueryForMap() Executes the SQL and retuns all rows selected in a map that is keyed on executeQueryForMap in file TUpdateMappedStatement.php, method TUpdateMappedStatement::executeQueryForMap() executeQueryForMap in file TInsertMappedStatement.php, method TInsertMappedStatement::executeQueryForMap() executeQueryForObject in file TUpdateMappedStatement.php, method TUpdateMappedStatement::executeQueryForObject() executeQueryForObject in file IMappedStatement.php, method IMappedStatement::executeQueryForObject() Executes an SQL statement that returns a single row as an object of the type of the <tt>$result</tt> passed in as a parameter. executeQueryForObject in file TMappedStatement.php, method TMappedStatement::executeQueryForObject() Executes an SQL statement that returns a single row as an object of the type of the <tt>$result</tt> passed in as a parameter. executeQueryForObject in file TCachingStatement.php, method TCachingStatement::executeQueryForObject() executeQueryForObject in file TInsertMappedStatement.php, method TInsertMappedStatement::executeQueryForObject() executeSelectKey in file TMappedStatement.php, method TMappedStatement::executeSelectKey() Execute the select key statement, used to obtain last insert ID. executeSQLQueryLimit in file TMappedStatement.php, method TMappedStatement::executeSQLQueryLimit() Execute SQL Query with limits. executeUpdate in file TInsertMappedStatement.php, method TInsertMappedStatement::executeUpdate() executeUpdate in file TCachingStatement.php, method TCachingStatement::executeUpdate() executeUpdate in file TSelectMappedStatement.php, method TSelectMappedStatement::executeUpdate() executeUpdate in file TMappedStatement.php, method TMappedStatement::executeUpdate() Execute an update statement. Also used for delete statement. executeUpdate in file IMappedStatement.php, method IMappedStatement::executeUpdate() Execute an update statement. Also used for delete statement. Return the number of row effected. top ## f fillArrayResultMap in file TMappedStatement.php, method TMappedStatement::fillArrayResultMap() Retrieve the result map as an array. fillDefaultResultMap in file TMappedStatement.php, method TMappedStatement::fillDefaultResultMap() Fill the result map using default settings. If <tt>$resultMap</tt> is null the result object returned will be guessed from <tt>$resultObject</tt>. fillPropertyWithResultMap in file TMappedStatement.php, method TMappedStatement::fillPropertyWithResultMap() Fills the property with result mapping results. fillResultArrayList in file TMappedStatement.php, method TMappedStatement::fillResultArrayList() Apply the result to a TList or an array. fillResultClass in file TMappedStatement.php, method TMappedStatement::fillResultClass() Fill the result using ResultClass, will creates new result object if required. fillResultMap in file TMappedStatement.php, method TMappedStatement::fillResultMap() Fills the result object according to result mappings. fillResultObjectProperty in file TMappedStatement.php, method TMappedStatement::fillResultObjectProperty() Apply the result to an object. top ## g getCacheKey in file TCachingStatement.php, method TCachingStatement::getCacheKey() getCollection in file TMappedStatement.php, method TSqlMapObjectCollectionTree::getCollection() getCommand in file TMappedStatement.php, method TMappedStatement::getCommand() getGenerate in file TSqlMapStatement.php, method TSqlMapSelect::getGenerate() getID in file IMappedStatement.php, method IMappedStatement::getID() getID in file TCachingStatement.php, method TCachingStatement::getID() getID in file TMappedStatement.php, method TMappedStatement::getID() getKey in file TMappedStatement.php, method TResultSetMapItemParameter::getKey() getKeys in file TMappedStatement.php, method TPostSelectBinding::getKeys() getList in file TMappedStatement.php, method TResultSetListItemParameter::getList() getManager in file TCachingStatement.php, method TCachingStatement::getManager() getManager in file TMappedStatement.php, method TMappedStatement::getManager() getManager in file IMappedStatement.php, method IMappedStatement::getManager() getMap in file TMappedStatement.php, method TResultSetMapItemParameter::getMap() getMethod in file TMappedStatement.php, method TPostSelectBinding::getMethod() getParameter in file TMappedStatement.php, method TResultSetListItemParameter::getParameter() getParameter in file TMappedStatement.php, method TResultSetMapItemParameter::getParameter() getParameterNames in file TPreparedStatement.php, method TPreparedStatement::getParameterNames() getParameterValues in file TPreparedStatement.php, method TPreparedStatement::getParameterValues() getPostGeneratedSelectKey in file TMappedStatement.php, method TMappedStatement::getPostGeneratedSelectKey() Gets the inserted row ID after executing an insert statement. getPostSelectKeys in file TMappedStatement.php, method TMappedStatement::getPostSelectKeys() Finds in the post select property the SQL statement primary selection keys. getPreGeneratedSelectKey in file TMappedStatement.php, method TMappedStatement::getPreGeneratedSelectKey() Gets the insert generated ID before executing an insert statement. getPreparedSql in file TPreparedStatement.php, method TPreparedStatement::getPreparedSql() getPreparedStatement in file TStaticSql.php, method TStaticSql::getPreparedStatement() getResult in file TMappedStatement.php, method TResultSetListItemParameter::getResult() getResultMapGroupKey in file TMappedStatement.php, method TMappedStatement::getResultMapGroupKey() Gets the result 'group by' groupping key for each row. getResultObject in file TMappedStatement.php, method TPostSelectBinding::getResultObject() getResultProperty in file TMappedStatement.php, method TPostSelectBinding::getResultProperty() getScalarResult in file TMappedStatement.php, method TMappedStatement::getScalarResult() Converts the first array value to scalar value of given type. getSqlString in file TMappedStatement.php, method TMappedStatement::getSqlString() getStatement in file TMappedStatement.php, method TPostSelectBinding::getStatement() getStatement in file TCachingStatement.php, method TCachingStatement::getStatement() getStatement in file IMappedStatement.php, method IMappedStatement::getStatement() getStatement in file TMappedStatement.php, method TMappedStatement::getStatement() getValue in file TMappedStatement.php, method TResultSetMapItemParameter::getValue() top ## h hasChildren in file TMappedStatement.php, method TSqlMapObjectCollectionTree::hasChildren() top ## i IMappedStatement.php procedural page IMappedStatement.php IMappedStatement in file IMappedStatement.php, class IMappedStatement Interface for all mapping statements. initialGroupByResults in file TMappedStatement.php, method TMappedStatement::initialGroupByResults() Empty the group by results cache. isEmpty in file TMappedStatement.php, method TSqlMapObjectCollectionTree::isEmpty() top ## o onChildNodesVisited in file TMappedStatement.php, method TSqlMapObjectCollectionTree::onChildNodesVisited() Set the object properties for all the child nodes visited. onExecuteQuery in file TMappedStatement.php, method TMappedStatement::onExecuteQuery() Raise the execute query event. top ## p prepare in file TPreparedStatementFactory.php, method TPreparedStatementFactory::prepare() top ## r raiseRowDelegate in file TMappedStatement.php, method TMappedStatement::raiseRowDelegate() Raises delegate handler. replaceDynamicParameter in file TSimpleDynamicSql.php, method TSimpleDynamicSql::replaceDynamicParameter() runQueryForList in file TMappedStatement.php, method TMappedStatement::runQueryForList() Executes the SQL and retuns a List of result objects. runQueryForMap in file TMappedStatement.php, method TMappedStatement::runQueryForMap() Executes the SQL and retuns all rows selected in a map that is keyed on the property named in the keyProperty parameter. The value at each key will be the value of the property specified in the valueProperty parameter. runQueryForObject in file TMappedStatement.php, method TMappedStatement::runQueryForObject() Executes an SQL statement that returns a single row as an object of the type of the <tt>$result</tt> passed in as a parameter. top ## s setGenerate in file TSqlMapStatement.php, method TSqlMapSelect::setGenerate() setKeys in file TMappedStatement.php, method TPostSelectBinding::setKeys() setMethod in file TMappedStatement.php, method TPostSelectBinding::setMethod() setObjectProperty in file TMappedStatement.php, method TMappedStatement::setObjectProperty() Set a property of the result object with appropriate value. setParameterNames in file TPreparedStatement.php, method TPreparedStatement::setParameterNames() setParameterValues in file TPreparedStatement.php, method TPreparedStatement::setParameterValues() setPreparedSql in file TPreparedStatement.php, method TPreparedStatement::setPreparedSql() setResultObject in file TMappedStatement.php, method TPostSelectBinding::setResultObject() setResultProperty in file TMappedStatement.php, method TPostSelectBinding::setResultProperty() setStatement in file TMappedStatement.php, method TPostSelectBinding::setStatement() top ## t TCachingStatement.php procedural page TCachingStatement.php TDeleteMappedStatement.php procedural page TDeleteMappedStatement.php TInsertMappedStatement.php procedural page TInsertMappedStatement.php TMappedStatement.php procedural page TMappedStatement.php TPreparedCommand.php procedural page TPreparedCommand.php TPreparedStatementFactory.php procedural page TPreparedStatementFactory.php TPreparedStatement.php procedural page TPreparedStatement.php TSelectMappedStatement.php procedural page TSelectMappedStatement.php TSimpleDynamicSql.php procedural page TSimpleDynamicSql.php TStaticSql.php procedural page TStaticSql.php TUpdateMappedStatement.php procedural page TUpdateMappedStatement.php TCachingStatement in file TCachingStatement.php, class TCachingStatement TCacheingStatement class. TDeleteMappedStatement in file TDeleteMappedStatement.php, class TDeleteMappedStatement TDeleteMappedStatement class. TInsertMappedStatement in file TInsertMappedStatement.php, class TInsertMappedStatement TInsertMappedStatement class. TMappedStatement in file TMappedStatement.php, class TMappedStatement TMappedStatement class executes SQL mapped statements. Mapped Statements can hold any SQL statement and use Parameter Maps and Result Maps for input and output. TPostSelectBinding in file TMappedStatement.php, class TPostSelectBinding TPostSelectBinding class. TPreparedCommand in file TPreparedCommand.php, class TPreparedCommand TPreparedCommand class. TPreparedStatement in file TPreparedStatement.php, class TPreparedStatement TpreparedStatement class. TPreparedStatementFactory in file TPreparedStatementFactory.php, class TPreparedStatementFactory TPreparedStatementFactory class. TResultSetListItemParameter in file TMappedStatement.php, class TResultSetListItemParameter TResultSetListItemParameter class TResultSetMapItemParameter in file TMappedStatement.php, class TResultSetMapItemParameter TResultSetMapItemParameter class. TSelectMappedStatement in file TSelectMappedStatement.php, class TSelectMappedStatement TSelectMappedStatment class. TSimpleDynamicSql in file TSimpleDynamicSql.php, class TSimpleDynamicSql TSimpleDynamicSql class. TSqlMapObjectCollectionTree in file TMappedStatement.php, class TSqlMapObjectCollectionTree TSQLMapObjectCollectionTree class. TSqlMapSelect in file TSqlMapStatement.php, class TSqlMapSelect TSqlMapSelect class file. TStaticSql in file TStaticSql.php, class TStaticSql TStaticSql class. TUpdateMappedStatement in file TUpdateMappedStatement.php, class TUpdateMappedStatement TUpdateMappedStatement class. top ## u QUERY_FOR_ARRAY in file TMappedStatement.php, class constant TMappedStatement::QUERY_FOR_ARRAY QUERY_FOR_LIST in file TMappedStatement.php, class constant TMappedStatement::QUERY_FOR_LIST QUERY_FOR_OBJECT in file TMappedStatement.php, class constant TMappedStatement::QUERY_FOR_OBJECT top