• Главная
• Prado
• Data
• SqlMap
• Statements
• TMappedStatement

PHP Класс Prado\Data\SqlMap\Statements\TMappedStatement

This class is usualy instantiated during SQLMap configuration by TSqlDomBuilder. Показать файл Открыть проект

Открытые методы

Метод	Описание
__construct ( TSqlMapManager $sqlMap, TSqlMapStatement $statement )	Creates a new mapped statement.
__sleep ( )
__wakeup ( )
executeInsert ( $connection, $parameter ) : string	Execute an insert statement. Fill the parameter object with the ouput parameters if any, also could return the insert generated key.
executeQueryForList ( $connection, $parameter, $result = null, $skip, $max, $delegate = null ) : array	Executes the SQL and retuns a List of result objects.
executeQueryForMap ( $connection, $parameter, $keyProperty, $valueProperty = null, $skip, $max, $delegate = null ) : array	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.
executeQueryForObject ( $connection, $parameter, $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.
executeUpdate ( $connection, $parameter ) : integer	Execute an update statement. Also used for delete statement.
getCommand ( ) : TPreparedCommand
getID ( ) : string
getManager ( ) : TSqlMapper
getSqlString ( )
getStatement ( ) : TSqlMapStatement
onExecuteQuery ( $sql )	Raise the execute query event.
runQueryForList ( $connection, $parameter, $sql, $result, $delegate = null ) : array	Executes the SQL and retuns a List of result objects.
runQueryForMap ( $connection, $parameter, $command, $keyProperty, $valueProperty = null, $delegate = null ) : array	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.
runQueryForObject ( $connection, $command, &$result ) : object	Executes an SQL statement that returns a single row as an object of the type of the $result passed in as a parameter.

Защищенные методы

Метод	Описание
addResultMapGroupBy ( $resultMap, $row, $parent, &$resultObject ) : object	ResultMap with GroupBy property. Save object collection graph in a tree and collect the result later.
applyResultMap ( $row, &$resultObject = null ) : object	Apply result mapping.
enquequePostSelect ( $select, $resultMap, $property, $row, $resultObject )	Add nested result property to post select queue.
executePostSelect ( $connection )	Process 'select' result properties
executeSQLQueryLimit ( $connection, $command, $max, $skip ) : mixed	Execute SQL Query with limits.
executeSelectKey ( $connection, $parameter, $selectKey ) : string	Execute the select key statement, used to obtain last insert ID.
fillArrayResultMap ( $resultMap, $row, $resultObject ) : array	Retrieve the result map as an array.
fillDefaultResultMap ( $resultMap, $row, $resultObject ) : mixed	Fill the result map using default settings. If $resultMap is null the result object returned will be guessed from $resultObject.
fillPropertyWithResultMap ( $resultMap, $row, &$resultObject ) : boolean	Fills the property with result mapping results.
fillResultArrayList ( $row, $resultObject ) : object	Apply the result to a TList or an array.
fillResultClass ( $resultClass, $row, $resultObject ) : object	Fill the result using ResultClass, will creates new result object if required.
fillResultMap ( $resultMapName, $row, $parentGroup = null, &$resultObject = null ) : object	Fills the result object according to result mappings.
fillResultObjectProperty ( $row, $resultObject ) : object	Apply the result to an object.
getPostGeneratedSelectKey ( $connection, $parameter ) : string	Gets the inserted row ID after executing an insert statement.
getPostSelectKeys ( $resultMap, $property, $row ) : array	Finds in the post select property the SQL statement primary selection keys.
getPreGeneratedSelectKey ( $connection, $parameter ) : string	Gets the insert generated ID before executing an insert statement.
getResultMapGroupKey ( $resultMap, $row ) : string	Gets the result 'group by' groupping key for each row.
getScalarResult ( $result, $type ) : mixed	Converts the first array value to scalar value of given type.
initialGroupByResults ( )	Empty the group by results cache.
raiseRowDelegate ( $handler, $param )	Raises delegate handler.
setObjectProperty ( $resultMap, $property, $row, &$resultObject )	Set a property of the result object with appropriate value.

Описание методов