TDbCommandBuilder provides basic methods to create query commands for tables giving by setTableInfo the property.
Located in /Data/Common/TDbCommandBuilder.php (line 22)
TComponent | --TDbCommandBuilder
Class | Description |
---|---|
TMssqlCommandBuilder | TMssqlCommandBuilder provides specifics methods to create limit/offset query commands for MSSQL servers. |
TMysqlCommandBuilder | TMysqlCommandBuilder implements default TDbCommandBuilder |
TOracleCommandBuilder | TOracleCommandBuilder provides specifics methods to create limit/offset query commands for Oracle database. |
TPgsqlCommandBuilder | TPgsqlCommandBuilder provides specifics methods to create limit/offset query commands for Pgsql database. |
TSqliteCommandBuilder | TSqliteCommandBuilder provides specifics methods to create limit/offset query commands for Sqlite database. |
Alters the sql to apply $limit and $offset. Default implementation is applicable for PostgreSQL, MySQL and SQLite.
Bind the name-value pairs of $values where the array keys correspond to column names.
Creates a count(*) command for the table described in setTableInfo.
Creates a delete command for the table described in setTableInfo.
The conditions for delete is given by the $where argument and the parameters for the condition is given by $parameters.
Appends the $where condition to the string "SELECT * FROM tableName WHERE ".
The tableName is obtained from the TableInfo property.
Creates an insert command for the table described in setTableInfo for the given data.
Each array key in the $data array must correspond to the column name of the table (if a column allows to be null, it may be omitted) to be inserted with the corresponding array value.
Creates an update command for the table described in setTableInfo for the given data.
Each array key in the $data array must correspond to the column name to be updated with the corresponding array value.
Create a name-value or position-value if $position=true binding strings.
Returns a list of insert field name and a list of binding names.
Iterate through all the columns and returns the last insert id of the first column that has a sequence or serial.
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).
Inherited From TComponent
TComponent::addParsedObject()
TComponent::attachEventHandler()
TComponent::canGetProperty()
TComponent::canSetProperty()
TComponent::createdOnTemplate()
TComponent::detachEventHandler()
TComponent::evaluateExpression()
TComponent::evaluateStatements()
TComponent::getEventHandlers()
TComponent::getSubProperty()
TComponent::hasEvent()
TComponent::hasEventHandler()
TComponent::hasProperty()
TComponent::raiseEvent()
TComponent::setSubProperty()
TComponent::__get()
TComponent::__set()
Documentation generated on Mon, 21 Apr 2008 11:34:51 -0400 by phpDocumentor 1.3.0RC4