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.Common

[ a ] [ b ] [ c ] [ f ] [ g ] [ h ] [ i ] [ j ] [ n ] [ r ] [ s ] [ t ] [ _ ]

_

__construct
in file TOracleTableInfo.php, method TOracleTableInfo::__construct()
    Sets the database table meta data information.
__construct
in file TDbTableInfo.php, method TDbTableInfo::__construct()
    Sets the database table meta data information.
__construct
in file TDbTableColumn.php, method TDbTableColumn::__construct()
    Sets the table column meta data.
__construct
in file TDbMetaData.php, method TDbMetaData::__construct()
__construct
in file TDbCommandBuilder.php, method TDbCommandBuilder::__construct()
top

a

applyCriterias
in file TDbCommandBuilder.php, method TDbCommandBuilder::applyCriterias()
applyLimitOffset
in file TOracleCommandBuilder.php, method TOracleCommandBuilder::applyLimitOffset()
    Overrides parent implementation to use Oracle way of get paginated RecordSet instead of using LIMIT sql clause.
applyLimitOffset
in file TMssqlCommandBuilder.php, method TMssqlCommandBuilder::applyLimitOffset()
    Overrides parent implementation. Alters the sql to apply $limit and $offset.
applyLimitOffset
in file TSqliteCommandBuilder.php, method TSqliteCommandBuilder::applyLimitOffset()
    Alters the sql to apply $limit and $offset.
applyLimitOffset
in file TDbCommandBuilder.php, method TDbCommandBuilder::applyLimitOffset()
    Alters the sql to apply $limit and $offset. Default implementation is applicable for PostgreSQL, MySQL and SQLite.
applyOrdering
in file TDbCommandBuilder.php, method TDbCommandBuilder::applyOrdering()
top

b

bindArrayValues
in file TDbCommandBuilder.php, method TDbCommandBuilder::bindArrayValues()
bindColumnValues
in file TDbCommandBuilder.php, method TDbCommandBuilder::bindColumnValues()
    Bind the name-value pairs of $values where the array keys correspond to column names.
top

c

createCommand
in file TDbCommandBuilder.php, method TDbCommandBuilder::createCommand()
createCommandBuilder
in file TDbTableInfo.php, method TDbTableInfo::createCommandBuilder()
createCommandBuilder
in file TDbMetaData.php, method TDbMetaData::createCommandBuilder()
    Creates a command builder for a given table name.
createCommandBuilder
in file TOracleTableInfo.php, method TOracleTableInfo::createCommandBuilder()
createCountCommand
in file TDbCommandBuilder.php, method TDbCommandBuilder::createCountCommand()
    Creates a count(*) command for the table described in setTableInfo.
createDeleteCommand
in file TDbCommandBuilder.php, method TDbCommandBuilder::createDeleteCommand()
    Creates a delete command for the table described in setTableInfo.
createFindCommand
in file TDbCommandBuilder.php, method TDbCommandBuilder::createFindCommand()
    Appends the $where condition to the string "SELECT * FROM tableName WHERE ".
createInsertCommand
in file TDbCommandBuilder.php, method TDbCommandBuilder::createInsertCommand()
    Creates an insert command for the table described in setTableInfo for the given data.
createTableInfo
in file TDbMetaData.php, method TDbMetaData::createTableInfo()
    This method should be implemented by decendent classes.
createUpdateCommand
in file TDbCommandBuilder.php, method TDbCommandBuilder::createUpdateCommand()
    Creates an update command for the table described in setTableInfo for the given data.
top

f

findOrdering
in file TMssqlCommandBuilder.php, method TMssqlCommandBuilder::findOrdering()
    Base on simplified syntax http://msdn2.microsoft.com/en-us/library/aa259187(SQL.80).aspx
top

g

getAllowNull
in file TDbTableColumn.php, method TDbTableColumn::getAllowNull()
getColumn
in file TOracleTableInfo.php, method TOracleTableInfo::getColumn()
getColumn
in file TDbTableInfo.php, method TDbTableInfo::getColumn()
getColumnBindings
in file TDbCommandBuilder.php, method TDbCommandBuilder::getColumnBindings()
    Create a name-value or position-value if $position=true binding strings.
getColumnId
in file TDbTableColumn.php, method TDbTableColumn::getColumnId()
getColumnIndex
in file TDbTableColumn.php, method TDbTableColumn::getColumnIndex()
getColumnName
in file TDbTableColumn.php, method TDbTableColumn::getColumnName()
getColumnNames
in file TDbTableInfo.php, method TDbTableInfo::getColumnNames()
getColumnNames
in file TOracleTableInfo.php, method TOracleTableInfo::getColumnNames()
getColumns
in file TOracleTableInfo.php, method TOracleTableInfo::getColumns()
getColumns
in file TDbTableInfo.php, method TDbTableInfo::getColumns()
getColumnSize
in file TDbTableColumn.php, method TDbTableColumn::getColumnSize()
getDbConnection
in file TDbMetaData.php, method TDbMetaData::getDbConnection()
getDbConnection
in file TDbCommandBuilder.php, method TDbCommandBuilder::getDbConnection()
getDbType
in file TDbTableColumn.php, method TDbTableColumn::getDbType()
getDefaultValue
in file TDbTableColumn.php, method TDbTableColumn::getDefaultValue()
getForeignKeys
in file TOracleTableInfo.php, method TOracleTableInfo::getForeignKeys()
getForeignKeys
in file TDbTableInfo.php, method TDbTableInfo::getForeignKeys()
getInfo
in file TOracleTableInfo.php, method TOracleTableInfo::getInfo()
getInfo
in file TDbTableInfo.php, method TDbTableInfo::getInfo()
getInfo
in file TDbTableColumn.php, method TDbTableColumn::getInfo()
getInsertFieldBindings
in file TDbCommandBuilder.php, method TDbCommandBuilder::getInsertFieldBindings()
    Returns a list of insert field name and a list of binding names.
getInstance
in file TDbMetaData.php, method TDbMetaData::getInstance()
    Obtain database specific TDbMetaData class using the driver name of the database connection.
getIsExcluded
in file TDbTableColumn.php, method TDbTableColumn::getIsExcluded()
getIsForeignKey
in file TDbTableColumn.php, method TDbTableColumn::getIsForeignKey()
getIsPrimaryKey
in file TDbTableColumn.php, method TDbTableColumn::getIsPrimaryKey()
getIsView
in file TOracleTableInfo.php, method TOracleTableInfo::getIsView()
getIsView
in file TDbTableInfo.php, method TDbTableInfo::getIsView()
getLastInsertID
in file TDbCommandBuilder.php, method TDbCommandBuilder::getLastInsertID()
    Iterate through all the columns and returns the last insert id of the first column that has a sequence or serial.
getLastInsertID
in file TMssqlCommandBuilder.php, method TMssqlCommandBuilder::getLastInsertID()
    Overrides parent implementation. Uses "SELECT @@Identity".
getLowerCaseColumnNames
in file TDbTableInfo.php, method TDbTableInfo::getLowerCaseColumnNames()
getLowerCaseColumnNames
in file TOracleTableInfo.php, method TOracleTableInfo::getLowerCaseColumnNames()
getMaxiumNumericConstraint
in file TDbTableColumn.php, method TDbTableColumn::getMaxiumNumericConstraint()
getNumericPrecision
in file TDbTableColumn.php, method TDbTableColumn::getNumericPrecision()
getNumericScale
in file TDbTableColumn.php, method TDbTableColumn::getNumericScale()
getPdoType
in file TDbTableColumn.php, method TDbTableColumn::getPdoType()
getPdoType
in file TDbCommandBuilder.php, method TDbCommandBuilder::getPdoType()
getPHPType
in file TDbTableColumn.php, method TDbTableColumn::getPHPType()
    Returns the derived PHP primitive type from the db type. Default returns 'string'.
getPrimaryKeys
in file TOracleTableInfo.php, method TOracleTableInfo::getPrimaryKeys()
getPrimaryKeys
in file TDbTableInfo.php, method TDbTableInfo::getPrimaryKeys()
getSearchCondition
in file TDbCommandBuilder.php, method TDbCommandBuilder::getSearchCondition()
getSearchCondition
in file TPgsqlCommandBuilder.php, method TPgsqlCommandBuilder::getSearchCondition()
    Overrides parent implementation to use PostgreSQL's ILIKE instead of LIKE (case-sensitive).
getSearchExpression
in file TDbCommandBuilder.php, method TDbCommandBuilder::getSearchExpression()
    Computes the SQL condition for search a set of column using regular expression (or LIKE, depending on database implementation) to match a string of keywords (default matches all keywords).
getSearchExpression
in file TPgsqlCommandBuilder.php, method TPgsqlCommandBuilder::getSearchExpression()
    Overrides parent implementation. Only column of type text or character (and its variants) accepts the LIKE criteria.
getSearchExpression
in file TOracleCommandBuilder.php, method TOracleCommandBuilder::getSearchExpression()
    Overrides parent implementation. Only column of type text or character (and its variants) accepts the LIKE criteria.
getSequenceName
in file TDbTableColumn.php, method TDbTableColumn::getSequenceName()
getTableFullName
in file TDbTableInfo.php, method TDbTableInfo::getTableFullName()
getTableFullName
in file TOracleTableInfo.php, method TOracleTableInfo::getTableFullName()
getTableInfo
in file TDbCommandBuilder.php, method TDbCommandBuilder::getTableInfo()
getTableInfo
in file TDbMetaData.php, method TDbMetaData::getTableInfo()
    Obtains table meta data information for the current connection and given table name.
getTableInfoClass
in file TDbMetaData.php, method TDbMetaData::getTableInfoClass()
getTableName
in file TDbTableInfo.php, method TDbTableInfo::getTableName()
getTableName
in file TOracleTableInfo.php, method TOracleTableInfo::getTableName()
top

h

hasIntegerKey
in file TDbCommandBuilder.php, method TDbCommandBuilder::hasIntegerKey()
hasSequence
in file TDbTableColumn.php, method TDbTableColumn::hasSequence()
top

i

isSearchableColumn
in file TPgsqlCommandBuilder.php, method TPgsqlCommandBuilder::isSearchableColumn()
isSearchableColumn
in file TOracleCommandBuilder.php, method TOracleCommandBuilder::isSearchableColumn()
top

j

joinOrdering
in file TMssqlCommandBuilder.php, method TMssqlCommandBuilder::joinOrdering()
top

n

UNDEFINED_VALUE
in file TDbTableColumn.php, class constant TDbTableColumn::UNDEFINED_VALUE
top

r

reverseDirection
in file TMssqlCommandBuilder.php, method TMssqlCommandBuilder::reverseDirection()
rewriteLimitOffsetSql
in file TMssqlCommandBuilder.php, method TMssqlCommandBuilder::rewriteLimitOffsetSql()
    Rewrite sql to apply $limit > and $offset > 0 for MSSQL database.
top

s

setDbConnection
in file TDbCommandBuilder.php, method TDbCommandBuilder::setDbConnection()
setInfo
in file TOracleTableInfo.php, method TOracleTableInfo::setInfo()
setInfo
in file TDbTableInfo.php, method TDbTableInfo::setInfo()
setInfo
in file TDbTableColumn.php, method TDbTableColumn::setInfo()
setTableInfo
in file TDbCommandBuilder.php, method TDbCommandBuilder::setTableInfo()
top

t

TMssqlCommandBuilder.php
procedural page TMssqlCommandBuilder.php
TMysqlCommandBuilder.php
procedural page TMysqlCommandBuilder.php
TOracleCommandBuilder.php
procedural page TOracleCommandBuilder.php
TOracleTableInfo.php
procedural page TOracleTableInfo.php
TPgsqlCommandBuilder.php
procedural page TPgsqlCommandBuilder.php
TSqliteCommandBuilder.php
procedural page TSqliteCommandBuilder.php
TDbCommandBuilder.php
procedural page TDbCommandBuilder.php
TDbMetaData.php
procedural page TDbMetaData.php
TDbTableColumn.php
procedural page TDbTableColumn.php
TDbTableInfo.php
procedural page TDbTableInfo.php
TDbCommandBuilder
in file TDbCommandBuilder.php, class TDbCommandBuilder
    TDbCommandBuilder provides basic methods to create query commands for tables giving by setTableInfo the property.
TDbMetaData
in file TDbMetaData.php, class TDbMetaData
    TDbMetaData is the base class for retrieving metadata information, such as table and columns information, from a database connection.
TDbTableColumn
in file TDbTableColumn.php, class TDbTableColumn
    TDbTableColumn class describes the column meta data of the schema for a database table.
TDbTableInfo
in file TDbTableInfo.php, class TDbTableInfo
    TDbTableInfo class describes the meta data of a database table.
TMssqlCommandBuilder
in file TMssqlCommandBuilder.php, class TMssqlCommandBuilder
    TMssqlCommandBuilder provides specifics methods to create limit/offset query commands for MSSQL servers.
TMysqlCommandBuilder
in file TMysqlCommandBuilder.php, class TMysqlCommandBuilder
    TMysqlCommandBuilder implements default TDbCommandBuilder
TOracleCommandBuilder
in file TOracleCommandBuilder.php, class TOracleCommandBuilder
    TOracleCommandBuilder provides specifics methods to create limit/offset query commands for Oracle database.
TOracleTableInfo
in file TOracleTableInfo.php, class TOracleTableInfo
    TDbTableInfo class describes the meta data of a database table.
TPgsqlCommandBuilder
in file TPgsqlCommandBuilder.php, class TPgsqlCommandBuilder
    TPgsqlCommandBuilder provides specifics methods to create limit/offset query commands for Pgsql database.
TSqliteCommandBuilder
in file TSqliteCommandBuilder.php, class TSqliteCommandBuilder
    TSqliteCommandBuilder provides specifics methods to create limit/offset query commands for Sqlite database.
top