## [System.Data.SqlMap] 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.DataGateway
- System.Data.SqlMap.Configuration
- System.Data.SqlMap.Statements
- 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

$_cache
  TSqlMapCache::$_cache in TSqlMapCache.php
$_cacheSize
  TSqlMapCache::$_cacheSize in TSqlMapCache.php
$_keyList
  TSqlMapCache::$_keyList in TSqlMapCache.php
__call
  TObjectProxy::__call() in TLazyLoadList.php
  Relay the method call to the handler object (if able to be handled), otherwise it calls the proxied object's method.
__construct
  TSqlMapManager::__construct() in TSqlMapManager.php
  Constructor, create a new SqlMap manager.
__construct
  TSqlMapPagedList::__construct() in TSqlMapPagedList.php
  Create a new SqlMap paged list.
__construct
  TSqlMapGateway::__construct() in TSqlMapGateway.php
__construct
  TSqlMapCache::__construct() in TSqlMapCache.php
  Create a new cache with limited cache size.
__construct
  TObjectProxy::__construct() in TLazyLoadList.php
__construct
  TLazyLoadList::__construct() in TLazyLoadList.php
  Create a new proxy list that will execute the mapped statement when any of the list's method are accessed for the first time.
__construct
  TSqlMapException::__construct() in TSqlMapException.php
  Constructor, similar to the parent constructor. For parameters that are of SimpleXmlElement, the tag name and its attribute names and values are expanded into a string.

a
top

add
  TSqlMapCache::add() in TSqlMapCache.php
add
  TSqlMapApplicationCache::add() in TSqlMapCache.php
addCacheModel
  TSqlMapManager::addCacheModel() in TSqlMapManager.php
  Adds a named cache.
addMappedStatement
  TSqlMapManager::addMappedStatement() in TSqlMapManager.php
  Adds a (named) MappedStatement.
addParameterMap
  TSqlMapManager::addParameterMap() in TSqlMapManager.php
addResultMap
  TSqlMapManager::addResultMap() in TSqlMapManager.php

c
top

cacheSqlMapManager
  TSqlMapConfig::cacheSqlMapManager() in TSqlMapConfig.php
  Saves the current SqlMap manager to cache.
clearCache
  TSqlMapConfig::clearCache() in TSqlMapConfig.php
  Deletes the configuration cache.
configureXml
  TSqlMapManager::configureXml() in TSqlMapManager.php
  Loads and parses the SqlMap configuration file.
convertToType
  TSqlMapTypeHandlerRegistry::convertToType() in TSqlMapTypeHandlerRegistry.php
  Converts the value to given type using PHP's settype() function.
createInstanceOf
  TSqlMapTypeHandlerRegistry::createInstanceOf() in TSqlMapTypeHandlerRegistry.php
  Creates a new instance of a particular class (for PHP primative types, their corresponding default value for given type is used).
createNewInstance
  TSqlMapTypeHandler::createNewInstance() in TSqlMapTypeHandlerRegistry.php
  Casts the string representation of a value into a type recognized by
createSqlMapGateway
  TSqlMapManager::createSqlMapGateway() in TSqlMapManager.php
  Configures the current TSqlMapManager using the given xml configuration file defined in ConfigFile.
createSqlMapGateway
  TSqlMapConfig::createSqlMapGateway() in TSqlMapConfig.php
  Configure the data mapper using sqlmap configuration file.

d
top

delete
  TSqlMapGateway::delete() in TSqlMapGateway.php
  Executes a Sql DELETE statement. Delete returns the number of rows effected.
delete
  TSqlMapCache::delete() in TSqlMapCache.php
delete
  TSqlMapApplicationCache::delete() in TSqlMapCache.php

f
top

fetchDataFromStatement
  TSqlMapPagedList::fetchDataFromStatement() in TSqlMapPagedList.php
  Fetch data by executing the SqlMap statement.
fetchListData
  TLazyLoadList::fetchListData() in TLazyLoadList.php
  Load the data by executing the mapped statement.
flush
  TSqlMapCache::flush() in TSqlMapCache.php
  Clears the cache.
flush
  TSqlMapApplicationCache::flush() in TSqlMapCache.php
  Deletes all items in the cache.
flushCacheModels
  TSqlMapManager::flushCacheModels() in TSqlMapManager.php
  Flushes all cached objects that belong to this SqlMap
flushCaches
  TSqlMapGateway::flushCaches() in TSqlMapGateway.php
  Flushes all cached objects that belong to this SqlMap

g
top

get
  TPropertyAccess::get() in TPropertyAccess.php
  Gets the property value.
get
  TSqlMapFifoCache::get() in TSqlMapCache.php
get
  TSqlMapLruCache::get() in TSqlMapCache.php
get
  TSqlMapApplicationCache::get() in TSqlMapCache.php
getCache
  TSqlMapApplicationCache::getCache() in TSqlMapCache.php
getCacheModel
  TSqlMapManager::getCacheModel() in TSqlMapManager.php
  Gets a cache by name
getCacheSize
  TSqlMapCache::getCacheSize() in TSqlMapCache.php
getClient
  TSqlMapConfig::getClient() in TSqlMapConfig.php
  Initialize the sqlmap if necessary, returns the TSqlMapGateway instance.
getConfigFile
  TSqlMapConfig::getConfigFile() in TSqlMapConfig.php
getDbConnection
  TSqlMapManager::getDbConnection() in TSqlMapManager.php
getDbConnection
  TSqlMapGateway::getDbConnection() in TSqlMapGateway.php
getDbType
  TSqlMapTypeHandler::getDbType() in TSqlMapTypeHandlerRegistry.php
getDbTypeHandler
  TSqlMapTypeHandlerRegistry::getDbTypeHandler() in TSqlMapTypeHandlerRegistry.php
getEnableCache
  TSqlMapConfig::getEnableCache() in TSqlMapConfig.php
getErrorMessageFile
  TSqlMapException::getErrorMessageFile() in TSqlMapException.php
getIsLastPage
  TSqlMapPagedList::getIsLastPage() in TSqlMapPagedList.php
getIsMiddlePage
  TSqlMapPagedList::getIsMiddlePage() in TSqlMapPagedList.php
getIsNextPageAvailable
  TSqlMapPagedList::getIsNextPageAvailable() in TSqlMapPagedList.php
getIsPreviousPageAvailable
  TSqlMapPagedList::getIsPreviousPageAvailable() in TSqlMapPagedList.php
getMappedStatement
  TSqlMapManager::getMappedStatement() in TSqlMapManager.php
  Gets a MappedStatement by name.
getMappedStatements
  TSqlMapManager::getMappedStatements() in TSqlMapManager.php
getOffsetAndLimit
  TSqlMapPagedList::getOffsetAndLimit() in TSqlMapPagedList.php
  Calculate the data fetch offsets and limits.
getParameter
  TSqlMapTypeHandler::getParameter() in TSqlMapTypeHandlerRegistry.php
  Performs processing on a value before it is used to set the parameter of a IDbCommand.
getParameterMap
  TSqlMapManager::getParameterMap() in TSqlMapManager.php
getParameterMaps
  TSqlMapManager::getParameterMaps() in TSqlMapManager.php
getResult
  TSqlMapTypeHandler::getResult() in TSqlMapTypeHandlerRegistry.php
  Performs processing on a value before after it has been retrieved
getResultMap
  TSqlMapManager::getResultMap() in TSqlMapManager.php
  Gets a named result map
getResultMaps
  TSqlMapManager::getResultMaps() in TSqlMapManager.php
getSqlmapGateway
  TSqlMapManager::getSqlmapGateway() in TSqlMapManager.php
getSqlMapManager
  TSqlMapGateway::getSqlMapManager() in TSqlMapGateway.php
getType
  TSqlMapTypeHandler::getType() in TSqlMapTypeHandlerRegistry.php
getTypeHandler
  TSqlMapTypeHandlerRegistry::getTypeHandler() in TSqlMapTypeHandlerRegistry.php
getTypeHandlers
  TSqlMapManager::getTypeHandlers() in TSqlMapManager.php

h
top

has
  TPropertyAccess::has() in TPropertyAccess.php
hasMethod
  TLazyLoadList::hasMethod() in TLazyLoadList.php
  Try to fetch the data when any of the proxy collection method is called.

i
top

implodeNode
  TSqlMapException::implodeNode() in TSqlMapException.php
initialize
  TSqlMapPagedList::initialize() in TSqlMapPagedList.php
  Initialize the paged list.
insert
  TSqlMapGateway::insert() in TSqlMapGateway.php
  Executes a Sql INSERT statement.
intercept
  TLazyLoadList::intercept() in TLazyLoadList.php
  Relay the method call to the underlying collection.

l
top

loadCachedSqlMapManager
  TSqlMapConfig::loadCachedSqlMapManager() in TSqlMapConfig.php
  Loads SqlMap manager from cache.

n
top

newInstance
  TLazyLoadList::newInstance() in TLazyLoadList.php
  Create a new instance of a lazy collection.
nextPage
  TSqlMapPagedList::nextPage() in TSqlMapPagedList.php
  Switches to the next page.

o
top

CONFIG_FILE_EXT
  TSqlMapConfig::CONFIG_FILE_EXT in TSqlMapConfig.php
  File extension of external configuration file

p
top

populateData
  TSqlMapPagedList::populateData() in TSqlMapPagedList.php
  Populate the list with the fetched data.
previousPage
  TSqlMapPagedList::previousPage() in TSqlMapPagedList.php
  Switches to the previous page.

q
top

queryForList
  TSqlMapGateway::queryForList() in TSqlMapGateway.php
  Executes a Sql SELECT statement that returns data to populate a number of result objects.
queryForMap
  TSqlMapGateway::queryForMap() in TSqlMapGateway.php
  Executes the SQL and retuns all rows selected in a map that is keyed on
queryForMapWithRowDelegate
  TSqlMapGateway::queryForMapWithRowDelegate() in TSqlMapGateway.php
  Runs a query with a custom object that gets a chance to deal with each row as it is processed.
queryForObject
  TSqlMapGateway::queryForObject() in TSqlMapGateway.php
  Executes a Sql SELECT statement that returns that returns data to populate a single object instance.
queryForPagedList
  TSqlMapGateway::queryForPagedList() in TSqlMapGateway.php
  Executes the SQL and retuns a subset of the results in a dynamic TPagedList that can be used to automatically scroll through results from a database table.
queryForPagedListWithRowDelegate
  TSqlMapGateway::queryForPagedListWithRowDelegate() in TSqlMapGateway.php
  Executes the SQL and retuns a subset of the results in a dynamic TPagedList that can be used to automatically scroll through results from a database table.
queryWithRowDelegate
  TSqlMapGateway::queryWithRowDelegate() in TSqlMapGateway.php
  Runs a query for list with a custom object that gets a chance to deal with each row as it is processed.

r
top

registerTypeHandler
  TSqlMapTypeHandlerRegistry::registerTypeHandler() in TSqlMapTypeHandlerRegistry.php
registerTypeHandler
  TSqlMapGateway::registerTypeHandler() in TSqlMapGateway.php

s
top

set
  TSqlMapFifoCache::set() in TSqlMapCache.php
  Stores a value identified by a key into cache.
set
  TPropertyAccess::set() in TPropertyAccess.php
  Sets the property value.
set
  TSqlMapApplicationCache::set() in TSqlMapCache.php
  Stores a value identified by a key into cache.
set
  TSqlMapLruCache::set() in TSqlMapCache.php
  Stores a value identified by a key into cache.
setCacheSize
  TSqlMapCache::setCacheSize() in TSqlMapCache.php
  Maximum number of items to cache. Default size is 100.
setConfigFile
  TSqlMapConfig::setConfigFile() in TSqlMapConfig.php
setCustomPaging
  TSqlMapPagedList::setCustomPaging() in TSqlMapPagedList.php
setDbConnection
  TSqlMapManager::setDbConnection() in TSqlMapManager.php
setDbType
  TSqlMapTypeHandler::setDbType() in TSqlMapTypeHandlerRegistry.php
setEnableCache
  TSqlMapConfig::setEnableCache() in TSqlMapConfig.php
  Set true to cache sqlmap instances.
setType
  TSqlMapTypeHandler::setType() in TSqlMapTypeHandlerRegistry.php

t
top

TLazyLoadList.php
  TLazyLoadList.php in TLazyLoadList.php
TPropertyAccess.php
  TPropertyAccess.php in TPropertyAccess.php
TSqlMapCache.php
  TSqlMapCache.php in TSqlMapCache.php
TSqlMapException.php
  TSqlMapException.php in TSqlMapException.php
TSqlMapPagedList.php
  TSqlMapPagedList.php in TSqlMapPagedList.php
TSqlMapTypeHandlerRegistry.php
  TSqlMapTypeHandlerRegistry.php in TSqlMapTypeHandlerRegistry.php
TSqlMapConfig.php
  TSqlMapConfig.php in TSqlMapConfig.php
TSqlMapGateway.php
  TSqlMapGateway.php in TSqlMapGateway.php
TSqlMapManager.php
  TSqlMapManager.php in TSqlMapManager.php
TInvalidPropertyException
  TInvalidPropertyException in TSqlMapException.php
  TInvalidPropertyException, raised when setting or getting an invalid property.
TLazyLoadList
  TLazyLoadList in TLazyLoadList.php
  TLazyLoadList executes mapped statements when the proxy collection is first accessed.
TObjectProxy
  TObjectProxy in TLazyLoadList.php
  TObjectProxy sets up a simple object that intercepts method calls to a particular object and relays the call to handler object.
TPropertyAccess
  TPropertyAccess in TPropertyAccess.php
  TPropertyAccess class provides dot notation stype property access and setting.
TSqlMapApplicationCache
  TSqlMapApplicationCache in TSqlMapCache.php
  TSqlMapApplicationCache uses the default Prado application cache for caching SqlMap results.
TSqlMapCache
  TSqlMapCache in TSqlMapCache.php
  Allow different implementation of caching strategy. See <tt>TSqlMapFifoCache</tt> for a first-in-first-out implementation. See <tt>TSqlMapLruCache</tt> for a least-recently-used cache implementation.
TSqlMapConfig
  TSqlMapConfig in TSqlMapConfig.php
  TSqlMapConfig module configuration class.
TSqlMapConfigurationException
  TSqlMapConfigurationException in TSqlMapException.php
  TSqlMapConfigurationException, raised during configuration file parsing.
TSqlMapDuplicateException
  TSqlMapDuplicateException in TSqlMapException.php
  TSqlMapDuplicateException, raised when a duplicate mapped statement is found.
TSqlMapException
  TSqlMapException in TSqlMapException.php
  TSqlMapException is the base exception class for all SqlMap exceptions.
TSqlMapExecutionException
  TSqlMapExecutionException in TSqlMapException.php
  TSqlMapException is the base exception class for all SqlMap exceptions.
TSqlMapFifoCache
  TSqlMapFifoCache in TSqlMapCache.php
  First-in-First-out cache implementation, removes object that was first added when the cache is full.
TSqlMapGateway
  TSqlMapGateway in TSqlMapGateway.php
  DataMapper client, a fascade to provide access the rest of the DataMapper framework. It provides three core functions:
TSqlMapLruCache
  TSqlMapLruCache in TSqlMapCache.php
  Least recently used cache implementation, removes object that was accessed last when the cache is full.
TSqlMapManager
  TSqlMapManager in TSqlMapManager.php
  TSqlMapManager class holds the sqlmap configuation result maps, statements parameter maps and a type handler factory.
TSqlMapPagedList
  TSqlMapPagedList in TSqlMapPagedList.php
  TSqlMapPagedList implements a list with paging functionality that retrieves data from a SqlMap statement.
TSqlMapTypeHandler
  TSqlMapTypeHandler in TSqlMapTypeHandlerRegistry.php
  A simple interface for implementing custom type handlers.
TSqlMapTypeHandlerRegistry
  TSqlMapTypeHandlerRegistry in TSqlMapTypeHandlerRegistry.php
  TTypeHandlerFactory provides type handler classes to convert database field type to PHP types and vice versa.
TSqlMapUndefinedException
  TSqlMapUndefinedException in TSqlMapException.php
  TSqlMapUndefinedException, raised when mapped statemented are undefined.

u
top

update
  TSqlMapGateway::update() in TSqlMapGateway.php
  Executes a Sql UPDATE statement.