From 903ae8a581fac1e6917fc3e31d2ad8fb91df80c3 Mon Sep 17 00:00:00 2001 From: ctrlaltca <> Date: Thu, 12 Jul 2012 11:21:01 +0000 Subject: standardize the use of unix eol; use svn properties to enforce native eol --- .../Data/SqlMap/Statements/TPreparedCommand.php | 132 ++++++++++----------- 1 file changed, 66 insertions(+), 66 deletions(-) (limited to 'framework/Data/SqlMap/Statements/TPreparedCommand.php') diff --git a/framework/Data/SqlMap/Statements/TPreparedCommand.php b/framework/Data/SqlMap/Statements/TPreparedCommand.php index 1d4a7088..7aa249ee 100644 --- a/framework/Data/SqlMap/Statements/TPreparedCommand.php +++ b/framework/Data/SqlMap/Statements/TPreparedCommand.php @@ -1,67 +1,67 @@ - - * @link http://www.pradosoft.com/ + + * @link http://www.pradosoft.com/ * @copyright Copyright © 2005-2012 PradoSoft - * @license http://www.pradosoft.com/license/ - * @version $Id$ - * @package System.Data.SqlMap.Statements - */ - -Prado::using('System.Data.Common.TDbMetaData'); -Prado::using('System.Data.Common.TDbCommandBuilder'); - -/** - * TPreparedCommand class. - * - * @author Wei Zhuo - * @version $Id$ - * @package System.Data.SqlMap.Statements - * @since 3.1 - */ -class TPreparedCommand -{ - public function create(TSqlMapManager $manager, $connection, $statement, $parameterObject,$skip=null,$max=null) - { - $sqlText = $statement->getSQLText(); - - $prepared = $sqlText->getPreparedStatement($parameterObject); - $connection->setActive(true); - $sql = $prepared->getPreparedSql(); - - if($sqlText instanceof TSimpleDynamicSql) - $sql = $sqlText->replaceDynamicParameter($sql, $parameterObject); - - if($max!==null || $skip!==null) - { - $builder = TDbMetaData::getInstance($connection)->createCommandBuilder(); - $sql = $builder->applyLimitOffset($sql,$max,$skip); - } - $command = $connection->createCommand($sql); - $this->applyParameterMap($manager, $command, $prepared, $statement, $parameterObject); - - return $command; - } - - protected function applyParameterMap($manager,$command,$prepared, $statement, $parameterObject) - { - $properties = $prepared->getParameterNames(); - $parameters = $prepared->getParameterValues(); - $registry=$manager->getTypeHandlers(); - for($i = 0, $k=$properties->getCount(); $i<$k; $i++) - { - $property = $statement->parameterMap()->getProperty($i); - $value = $statement->parameterMap()->getPropertyValue($registry,$property, $parameterObject); - $dbType = $property->getDbType(); - if($dbType=='') //relies on PHP lax comparison - $command->bindValue($i+1,$value, TDbCommandBuilder::getPdoType($value)); - else if(strpos($dbType, 'PDO::')===0) - $command->bindValue($i+1,$value, constant($property->getDbType())); //assumes PDO types, e.g. PDO::PARAM_INT - else - $command->bindValue($i+1,$value); - } - } -} - + * @license http://www.pradosoft.com/license/ + * @version $Id$ + * @package System.Data.SqlMap.Statements + */ + +Prado::using('System.Data.Common.TDbMetaData'); +Prado::using('System.Data.Common.TDbCommandBuilder'); + +/** + * TPreparedCommand class. + * + * @author Wei Zhuo + * @version $Id$ + * @package System.Data.SqlMap.Statements + * @since 3.1 + */ +class TPreparedCommand +{ + public function create(TSqlMapManager $manager, $connection, $statement, $parameterObject,$skip=null,$max=null) + { + $sqlText = $statement->getSQLText(); + + $prepared = $sqlText->getPreparedStatement($parameterObject); + $connection->setActive(true); + $sql = $prepared->getPreparedSql(); + + if($sqlText instanceof TSimpleDynamicSql) + $sql = $sqlText->replaceDynamicParameter($sql, $parameterObject); + + if($max!==null || $skip!==null) + { + $builder = TDbMetaData::getInstance($connection)->createCommandBuilder(); + $sql = $builder->applyLimitOffset($sql,$max,$skip); + } + $command = $connection->createCommand($sql); + $this->applyParameterMap($manager, $command, $prepared, $statement, $parameterObject); + + return $command; + } + + protected function applyParameterMap($manager,$command,$prepared, $statement, $parameterObject) + { + $properties = $prepared->getParameterNames(); + $parameters = $prepared->getParameterValues(); + $registry=$manager->getTypeHandlers(); + for($i = 0, $k=$properties->getCount(); $i<$k; $i++) + { + $property = $statement->parameterMap()->getProperty($i); + $value = $statement->parameterMap()->getPropertyValue($registry,$property, $parameterObject); + $dbType = $property->getDbType(); + if($dbType=='') //relies on PHP lax comparison + $command->bindValue($i+1,$value, TDbCommandBuilder::getPdoType($value)); + else if(strpos($dbType, 'PDO::')===0) + $command->bindValue($i+1,$value, constant($property->getDbType())); //assumes PDO types, e.g. PDO::PARAM_INT + else + $command->bindValue($i+1,$value); + } + } +} + -- cgit v1.2.3