Element index for package System.Data.Common
[ a ]
[ b ]
[ c ]
[ f ]
[ g ]
[ h ]
[ i ]
[ j ]
[ n ]
[ r ]
[ s ]
[ t ]
[ _ ]
top
top
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
top
top
top
top
top
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
|