Changeset 22683 for branches/camp/camp-2_13-plugin/data/class/plugin/SC_Plugin_Installer.php

Timestamp:

2013/03/10 05:10:58 (11 years ago)

Author:

adachi

Message:

#2181 insertとかを動くように修正

File:

• branches/camp/camp-2_13-plugin/data/class/plugin/SC_Plugin_Installer.php (modified) (6 diffs)

branches/camp/camp-2_13-plugin/data/class/plugin/SC_Plugin_Installer.php

@@ -126 +126 @@
             if (!is_null($error_message)) {
                 $this->log("verify sql: invalid sql " . $sql['sql']);
+                $this->log("verify sql: $error_message");
                 $arrErr[] = $error_message;
             }
@@ -131 +132 @@
         
         if (count($arrErr) > 0) {
-            $this->log("verify sql: err");
             return $arrErr;
         }
@@ -141 +141 @@
             $this->log("exec sql: " . $sql['sql']);
             $objQuery->query($sql['sql'], $sql['params']);
+        }
+        
+        $arrInsertQuery = $this->arrInstallData['insert'];
+        foreach ($arrInsertQuery as $query) {
+            $objQuery->insert(
+                    $query['table'],
+                    $query['arrVal'],
+                    $query['arrSql'],
+                    $query['arrSqlVal'],
+                    $query['form'],
+                    $query['arrFromVal']
+            );
+        }
+        
+        $arrUpdateQuery = $this->arrInstallData['update'];
+        foreach ($arrUpdateQuery as $query) {
+            $objQuery->update(
+                    $query['table'],
+                    $query['arrVal'],
+                    $query['where'],
+                    $query['arrWhereVal'],
+                    $query['arrRawSql'],
+                    $query['arrRawSqlVal']
+            );
         }
         
@@ -217 +241 @@
      */
     function sqlAterTableAdd($table_name, $col_name, $col_type) {
-        $sql = ("ALTER TABLE $table_name ADD $col_name $col_type ");
+        $sql = "ALTER TABLE $table_name ADD $col_name $col_type ";
         $this->sql($sql);
     }
@@ -229 +253 @@
      */
     function sqlAterTableDrop($table_name, $col_name) {
-        $sql = ("ALTER TABLE $table_name DROP $col_name");
+        $sql = "ALTER TABLE $table_name DROP $col_name";
         $this->sql($sql);
     }
@@ -235 +259 @@
     
     function sqlInsert($table, $arrVal, $arrSql = array(), $arrSqlVal = array(), $from = '', $arrFromVal = array()) {
-        $this->arrInstallData['insert'] = array(
-            'params'   => array(
-                'table' => $table,
-                'arrVal' => $arrVal, 
-                'arrSql' => $arrSql, 
-                'arrSqlVal' => $arrSqlVal, 
-                'form' =>$from,
-                'arrFromVal' => $arrFromVal)
+        $this->arrInstallData['insert'][] = array(
+            'table' => $table,
+            'arrVal' => $arrVal, 
+            'arrSql' => $arrSql, 
+            'arrSqlVal' => $arrSqlVal, 
+            'form' =>$from,
+            'arrFromVal' => $arrFromVal
         );
     }
     
     function sqlUpdate($table, $arrVal, $where = '', $arrWhereVal = array(), $arrRawSql = array(), $arrRawSqlVal = array()) {
-        $this->arrInstallData['update'] = array(
-            'params'   => array(
-                'table' => $table,
-                'arrVal' => $arrVal, 
-                'where' => $where, 
-                'arrWhereVal' => $arrWhereVal, 
-                'arrRawSql' =>$arrRawSql,
-                'arrRawSqlVal' => $arrRawSqlVal)
+        $this->arrInstallData['update'][] = array(
+            'table' => $table,
+            'arrVal' => $arrVal, 
+            'where' => $where, 
+            'arrWhereVal' => $arrWhereVal, 
+            'arrRawSql' =>$arrRawSql,
+            'arrRawSqlVal' => $arrRawSqlVal
         );
     }