|
Class TCachingStatement
TCacheingStatement class.
-
TComponent
-
TCachingStatement
implements
IMappedStatement
Methods summary
public
|
#
__construct( TMappedStatement $statement )
The common __construct If desired by the new object, this will auto install
and listen to global event functions as defined by the object via 'fx' methods.
This also attaches any predefined behaviors. This function installs all class
behaviors in a class hierarchy from the deepest subclass through each parent to
the top most class, TComponent.
The common __construct If desired by the new object, this will auto install
and listen to global event functions as defined by the object via 'fx' methods.
This also attaches any predefined behaviors. This function installs all class
behaviors in a class hierarchy from the deepest subclass through each parent to
the top most class, TComponent.
Overrides
|
public
string
|
#
getID( )
Returns
string Name used to identify the MappedStatement amongst the others.
Implementation of
|
public
TSqlMapStatement
|
#
getStatement( )
Returns
Implementation of
|
public
TSqlMap
|
#
getManager( )
Returns
TSqlMap The TSqlMap used by this TMappedStatement
Implementation of
|
public
TMap
|
#
executeQueryForMap( IDbConnection $connection, mixed $parameter, string $keyProperty, string $valueProperty = null, mixed $skip = -1, mixed $max = -1, mixed $delegate = 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 to execute the query
- $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)
- $skip
- $max
- $delegate
Returns
TMap
A map of object containing the rows keyed by $keyProperty.
Implementation of
|
public
integer
|
#
executeUpdate( IDbConnection $connection, mixed $parameter )
Execute an update statement. Also used for delete statement. Return the
number of row effected.
Execute an update statement. Also used for delete statement. Return the
number of row effected.
Parameters
- $connection
IDbConnection database connection to execute the query
- $parameter
mixed The object used to set the parameters in the SQL.
Returns
integer The number of row effected.
Implementation of
|
public
|
#
executeInsert( mixed $connection, mixed $parameter )
|
public
TList
|
#
executeQueryForList( IDbConnection $connection, mixed $parameter, TList $result = null, integer $skip = -1, integer $max = -1, mixed $delegate = null )
Executes the SQL and retuns a subset of the rows selected.
Executes the SQL and retuns a subset of the rows selected.
Parameters
- $connection
IDbConnection database connection to execute the query
- $parameter
mixed The object used to set the parameters in the SQL.
- $result
TList
A list to populate the result with.
- $skip
integer The number of rows to skip over.
- $max
integer The maximum number of rows to return.
- $delegate
Returns
TList
A TList of result objects.
Implementation of
|
public
object
|
#
executeQueryForObject( IDbConnection $connection, mixed $parameter, object $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 to execute the query
- $parameter
mixed The object used to set the parameters in the SQL.
- $result
object The result object.
Returns
object result.
Implementation of
|
protected
|
#
getCacheKey( mixed $object )
|
protected
|
#
createCommand( mixed $connection, mixed $parameter, mixed $skip = null, mixed $max = null )
|
Methods inherited from TComponent
__call(),
__destruct(),
__get(),
__isset(),
__set(),
__sleep(),
__unset(),
__wakeup(),
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()
|
|