Changeset 20492 for lang/php/misc/Hermit/src/Hermit/parameter/HermitProcedureParameter.php

Timestamp:

10/02/08 18:12:10 (3 months ago)

Author:

nowelium

Message:

mysql の procedure サポートは終わり。
General error: 2014 Cannot execute queries while other unbuffered queries are active. とかは、PDOのPDO::MYSQL_ATTR_USE_BUFFERED_QUERY をいくら設定してもダメなので、少し逃げ。一端切断すればなんとかなるけど、Datasource設定とかは管理外なので、やらない。
multi rows は 2次元配列で。

Files:

• lang/php/misc/Hermit/src/Hermit/parameter/HermitProcedureParameter.php (modified) (1 diff)

lang/php/misc/Hermit/src/Hermit/parameter/HermitProcedureParameter.php

@@ -30 +30 @@
     public function bind(PDOStatement $stmt, $value){
         $param = $value[0];
+        $propertyNames = $param->getPropertyNames();
+
         foreach($this->bindKeys as $index => $key){
             $bindKey = ':' . $key;
             if($this->info->typeofIn($key)){
+                if(!in_array($key, $propertyNames)){
+                    throw new InvalidArgumentException('param ' . $param . ' has not propery: ' . $key . ' instatement: ' . $stmt->queryString);
+                }
                 $stmt->bindParam($bindKey, $param->$key);
                 continue;
             }
-            $paramValue = $param->$key;
+            
+            $paramValue = null;
+            if(isset($param->$key)){
+                $paramValue =  $param->$key;
+            }
             if(null === $paramValue){
-                $stmt->bindParam($bindKey, null, PDO::PARAM_NULL | PDO::PARAM_INPUT_OUTPUT);
+                $stmt->bindParam($bindKey, $paramValue, PDO::PARAM_NULL | PDO::PARAM_INPUT_OUTPUT);
                 continue;
             }