|
Class TUpdateMappedStatement
TUpdateMappedStatement class.
-
TComponent
-
TMappedStatement
implements
IMappedStatement
-
TUpdateMappedStatement
Methods summary
public
string
|
#
executeInsert( IDbConnection $connection, mixed $parameter )
Execute an insert statement. Fill the parameter object with the ouput
parameters if any, also could return the insert generated key.
Execute an insert statement. Fill the parameter object with the ouput
parameters if any, also could return the insert generated key.
Parameters
- $connection
IDbConnection database connection
- $parameter
mixed The parameter object used to fill the statement.
Returns
string the insert generated key.
Overrides
|
public
array
|
#
executeQueryForMap( IDbConnection $connection, mixed $parameter, string $keyProperty, string $valueProperty = null )
Executes the SQL and retuns all rows selected in a map that is keyed on the
property named in the keyProperty parameter. The value at each key will be the
value of the property specified in the valueProperty parameter. If valueProperty
is null, the entire result object will be entered.
Executes the SQL and retuns all rows selected in a map that is keyed on the
property named in the keyProperty parameter. The value at each key will be the
value of the property specified in the valueProperty parameter. If valueProperty
is null, the entire result object will be entered.
Parameters
- $connection
IDbConnection database connection
- $parameter
mixed The object used to set the parameters in the SQL.
- $keyProperty
string The property of the result object to be used as the key.
- $valueProperty
string The property of the result object to be used as the value (or null).
Returns
array An array of object containing the rows keyed by keyProperty.
Overrides
|
public
array
|
#
executeQueryForList( IDbConnection $connection, mixed $parameter, object $result = null, integer $skip = -1, integer $max = -1 )
Executes the SQL and retuns a List of result objects.
Executes the SQL and retuns a List of result objects.
Parameters
- $connection
IDbConnection database connection
- $parameter
mixed The object used to set the parameters in the SQL.
- $result
object result collection object.
- $skip
integer The number of rows to skip over.
- $max
integer The maximum number of rows to return.
Returns
array a list of result objects
See
Overrides
|
public
mixed
|
#
executeQueryForObject( IDbConnection $connection, mixed $parameter, mixed $result = null )
Executes an SQL statement that returns a single row as an object of the type
of the $result passed in as a parameter.
Executes an SQL statement that returns a single row as an object of the type
of the $result passed in as a parameter.
Parameters
- $connection
IDbConnection database connection
- $parameter
mixed The parameter data (object, arrary, primitive) used to set the parameters in the
SQL
- $result
mixed The result object.
Returns
mixed ${return}
Overrides
|
Methods inherited from TMappedStatement
__construct(),
__sleep(),
__wakeup(),
addResultMapGroupBy(),
applyResultMap(),
enquequePostSelect(),
executePostSelect(),
executeSQLQueryLimit(),
executeSelectKey(),
executeUpdate(),
fillArrayResultMap(),
fillDefaultResultMap(),
fillPropertyWithResultMap(),
fillResultArrayList(),
fillResultClass(),
fillResultMap(),
fillResultObjectProperty(),
getCommand(),
getID(),
getManager(),
getPostGeneratedSelectKey(),
getPostSelectKeys(),
getPreGeneratedSelectKey(),
getResultMapGroupKey(),
getScalarResult(),
getSqlString(),
getStatement(),
initialGroupByResults(),
onExecuteQuery(),
raiseRowDelegate(),
runQueryForList(),
runQueryForMap(),
runQueryForObject(),
setObjectProperty()
|
Methods inherited from TComponent
__call(),
__destruct(),
__get(),
__isset(),
__set(),
__unset(),
addParsedObject(),
asa(),
attachBehavior(),
attachBehaviors(),
attachClassBehavior(),
attachEventHandler(),
canGetProperty(),
canSetProperty(),
clearBehaviors(),
createdOnTemplate(),
detachBehavior(),
detachBehaviors(),
detachClassBehavior(),
detachEventHandler(),
disableBehavior(),
disableBehaviors(),
enableBehavior(),
enableBehaviors(),
evaluateExpression(),
evaluateStatements(),
fxAttachClassBehavior(),
fxDetachClassBehavior(),
getAutoGlobalListen(),
getBehaviorsEnabled(),
getClassHierarchy(),
getEventHandlers(),
getListeningToGlobalEvents(),
getSubProperty(),
hasEvent(),
hasEventHandler(),
hasProperty(),
isa(),
listen(),
raiseEvent(),
setSubProperty(),
unlisten()
|
|