Class CSqliteCommandBuilder
CSqliteCommandBuilder provides basic methods to create query commands for
SQLite tables.
-
CComponent
-
CDbCommandBuilder
-
CSqliteCommandBuilder
Methods summary
protected
string
|
#
createCompositeInCondition( CDbTableSchema $table, array $values, string $prefix )
Generates the expression for selecting rows with specified composite key
values. This method is overridden because SQLite does not support the default IN
expression with composite columns.
Generates the expression for selecting rows with specified composite key
values. This method is overridden because SQLite does not support the default IN
expression with composite columns.
Parameters
- $table
CDbTableSchema
$table the table schema- $values
array
$values list of primary key values to be selected within- $prefix
string
$prefix column prefix (ended with dot) Returns
string
the expression for selection
Overrides
|
public
CDbCommand
|
#
createMultipleInsertCommand( mixed $table, array $data )
Creates a multiple INSERT command. This method could be used to achieve
better performance during insertion of the large amount of data into the
database tables. Note that SQLite does not keep original order of the inserted
rows.
Creates a multiple INSERT command. This method could be used to achieve
better performance during insertion of the large amount of data into the
database tables. Note that SQLite does not keep original order of the inserted
rows.
Parameters
- $table
mixed
$table the table schema (CDbTableSchema) or the table name (string).- $data
array[]
$data list data to be inserted, each value should be an array in format (column
name=>column value). If a key is not a valid column name, the corresponding
value will be ignored. Returns
Since
1.1.14
Overrides
|
Methods inherited from CDbCommandBuilder
__construct(),
applyCondition(),
applyGroup(),
applyHaving(),
applyJoin(),
applyLimit(),
applyOrder(),
bindValues(),
composeMultipleInsertCommand(),
createColumnCriteria(),
createCountCommand(),
createCriteria(),
createDeleteCommand(),
createFindCommand(),
createInCondition(),
createInsertCommand(),
createPkCondition(),
createPkCriteria(),
createSearchCondition(),
createSqlCommand(),
createUpdateCommand(),
createUpdateCounterCommand(),
ensureTable(),
getDbConnection(),
getIntegerPrimaryKeyDefaultValue(),
getLastInsertID(),
getSchema()
|
Methods inherited from CComponent
__call(),
__get(),
__isset(),
__set(),
__unset(),
asa(),
attachBehavior(),
attachBehaviors(),
attachEventHandler(),
canGetProperty(),
canSetProperty(),
detachBehavior(),
detachBehaviors(),
detachEventHandler(),
disableBehavior(),
disableBehaviors(),
enableBehavior(),
enableBehaviors(),
evaluateExpression(),
getEventHandlers(),
hasEvent(),
hasEventHandler(),
hasProperty(),
raiseEvent()
|