PRADO Component Framework for PHP 5
  • Home
  • About
  • Testimonials
  • Demos
  • Download
  • Documentation
  • Forum
  • Development
  • Tutorials
  • Class Docs
  • API Manual
  • Wiki

Packages

  • None
  • System
    • Caching
    • Collections
    • Data
      • ActiveRecord
        • Relations
        • Scaffold
          • InputBuilder
      • Commom
        • Sqlite
      • Common
        • Mssql
        • Mysql
        • Oracle
        • Pgsql
        • Sqlite
      • DataGateway
      • SqlMap
        • Configuration
        • Statements
    • Exceptions
    • I18N
    • IO
    • Security
    • Util
    • Web
      • Javascripts
      • Services
      • UI
        • ActiveControls
        • WebControls
    • Xml
  • Wsat
    • pages
  • Overview
  • Package
  • Class
  • Tree
  • Deprecated
  • Todo

Class TCachingStatement

TCacheingStatement class.

TComponent
Extended by TCachingStatement implements IMappedStatement
Package: System\Data\SqlMap\Statements
Copyright: Copyright © 2005-2014 PradoSoft
License: http://www.pradosoft.com/license/
Author: Wei Zhuo <weizhuo[at]gmail[dot]com>
Since: 3.1
Located at Data/SqlMap/Statements/TCachingStatement.php
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

TComponent::__construct()
public string
# getID( )

Returns

string
Name used to identify the MappedStatement amongst the others.

Implementation of

IMappedStatement::getID()
public TSqlMapStatement
# getStatement( )

Returns

TSqlMapStatement
The SQL statment used by this TMappedStatement.

Implementation of

IMappedStatement::getStatement()
public TSqlMap
# getManager( )

Returns

TSqlMap
The TSqlMap used by this TMappedStatement

Implementation of

IMappedStatement::getManager()
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

IMappedStatement::executeQueryForMap()
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

IMappedStatement::executeUpdate()
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

IMappedStatement::executeQueryForList()
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

IMappedStatement::executeQueryForObject()
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()
Constants inherited from TComponent
GLOBAL_RAISE_EVENT_LISTENER
Terms of Service | Contact Us
PRADO v3.2.4 API Manual API documentation generated by ApiGen 2.8.0
Copyright © 2006-2014 by the PRADO Group.
Powered by PRADO