- 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:
TInvalidPropertyException
TLazyLoadList
TObjectProxy
TPropertyAccess
TSqlMapApplicationCache
TSqlMapCache
TSqlMapConfig
TSqlMapConfigurationException
TSqlMapDuplicateException
TSqlMapException
TSqlMapExecutionException
TSqlMapFifoCache
TSqlMapGateway
TSqlMapLruCache
TSqlMapManager
TSqlMapPagedList
TSqlMapTypeHandler
TSqlMapTypeHandlerRegistry
TSqlMapUndefinedException

Keyword

# Element index for package System.Data.SqlMap

[ a ] [ c ] [ d ] [ f ] [ g ] [ h ] [ i ] [ l ] [ n ] [ o ] [ p ] [ q ] [ r ] [ s ] [ t ] [ u ] [ _ ]

## _

$_cache
  in file TSqlMapCache.php, variable TSqlMapCache::$_cache
$_cacheSize
  in file TSqlMapCache.php, variable TSqlMapCache::$_cacheSize
$_keyList
  in file TSqlMapCache.php, variable TSqlMapCache::$_keyList
__call
  in file TLazyLoadList.php, method TObjectProxy::__call()
  Relay the method call to the handler object (if able to be handled), otherwise it calls the proxied object's method.
__construct
  in file TSqlMapManager.php, method TSqlMapManager::__construct()
  Constructor, create a new SqlMap manager.
__construct
  in file TSqlMapPagedList.php, method TSqlMapPagedList::__construct()
  Create a new SqlMap paged list.
__construct
  in file TSqlMapGateway.php, method TSqlMapGateway::__construct()
__construct
  in file TSqlMapCache.php, method TSqlMapCache::__construct()
  Create a new cache with limited cache size.
__construct
  in file TLazyLoadList.php, method TObjectProxy::__construct()
__construct
  in file TLazyLoadList.php, method TLazyLoadList::__construct()
  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
  in file TSqlMapException.php, method TSqlMapException::__construct()
  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.

top

## a

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

top

## c

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

top

## d

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

top

## f

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

top

## g

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

top

## h

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

top

## i

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

top

## l

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

top

## n

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

top

## o

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

top

## p

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

top

## q

queryForList
  in file TSqlMapGateway.php, method TSqlMapGateway::queryForList()
  Executes a Sql SELECT statement that returns data to populate a number of result objects.
queryForMap
  in file TSqlMapGateway.php, method TSqlMapGateway::queryForMap()
  Executes the SQL and retuns all rows selected in a map that is keyed on
queryForMapWithRowDelegate
  in file TSqlMapGateway.php, method TSqlMapGateway::queryForMapWithRowDelegate()
  Runs a query with a custom object that gets a chance to deal with each row as it is processed.
queryForObject
  in file TSqlMapGateway.php, method TSqlMapGateway::queryForObject()
  Executes a Sql SELECT statement that returns that returns data to populate a single object instance.
queryForPagedList
  in file TSqlMapGateway.php, method TSqlMapGateway::queryForPagedList()
  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
  in file TSqlMapGateway.php, method TSqlMapGateway::queryForPagedListWithRowDelegate()
  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
  in file TSqlMapGateway.php, method TSqlMapGateway::queryWithRowDelegate()
  Runs a query for list with a custom object that gets a chance to deal with each row as it is processed.

top

## r

registerTypeHandler
  in file TSqlMapTypeHandlerRegistry.php, method TSqlMapTypeHandlerRegistry::registerTypeHandler()
registerTypeHandler
  in file TSqlMapGateway.php, method TSqlMapGateway::registerTypeHandler()

top

## s

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

top

## t

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

top

## u

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

top