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 TInsertMappedStatement

TInsertMappedStatement class.

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

TMappedStatement::executeQueryForMap()
public integer
# executeUpdate( IDbConnection $connection, mixed $parameter )

Execute an update statement. Also used for delete statement. Return the number of rows effected.

Execute an update statement. Also used for delete statement. Return the number of rows effected.

Parameters

$connection
IDbConnection
database connection
$parameter
mixed
The object used to set the parameters in the SQL.

Returns

integer
The number of rows effected.

Overrides

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

TInsertMappedStatement::executeQueryForList()

Overrides

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

TMappedStatement::executeQueryForObject()
Methods inherited from TMappedStatement
__construct(), __sleep(), __wakeup(), addResultMapGroupBy(), applyResultMap(), enquequePostSelect(), executeInsert(), executePostSelect(), executeSQLQueryLimit(), executeSelectKey(), 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()
Constants inherited from TMappedStatement
QUERY_FOR_ARRAY, QUERY_FOR_LIST, QUERY_FOR_OBJECT
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