Changeset 21544 for branches/version-2_12-dev/data/class/SC_Query.php

Timestamp:

2012/02/22 01:27:53 (14 years ago)

Author:

Seasoft

Message:

#1656 (カテゴリ登録のロジックを高速化)
#1661 (共通ロジックを利用する)

• SC_Query#getCol

#1660 (SC_Helper_DB#sfCountCategory メモリ消費が激しい)
#1659 (SC_Helper_DB#sfCountCategory メモリリークが発生する)

File:

• branches/version-2_12-dev/data/class/SC_Query.php (modified) (3 diffs)

branches/version-2_12-dev/data/class/SC_Query.php

@@ -38 +38 @@
     var $groupby = '';
     var $order = '';
-    var $force_run;
+    var $force_run = false;
 
     /**
@@ -469 +469 @@
      * @param array $arrSql array('カラム名' => 'SQL文', ...)の連想配列
      * @param array $arrSqlVal SQL文の中で使用するプレースホルダ配列
-     * @return
-     */
-    function insert($table, $sqlval, $arrSql = array(), $arrSqlVal = array()) {
+     * @param string $from FROM 句・WHERE 句
+     * @param string $arrFromVal FROM 句・WHERE 句で使用するプレースホルダ配列
+     * @return integer|DB_Error 挿入件数またはDB_Error
+     */
+    function insert($table, $sqlval, $arrSql = array(), $arrSqlVal = array(), $from = '', $arrFromVal = array()) {
         $strcol = '';
         $strval = '';
@@ -502 +504 @@
         }
         // 文末の','を削除
-        $strcol = preg_replace("/,$/", "", $strcol);
-        $strval = preg_replace("/,$/", "", $strval);
-        $sqlin = "INSERT INTO $table(" . $strcol. ") VALUES (" . $strval . ")";
+        $strcol = rtrim($strcol, ',');
+        $strval = rtrim($strval, ',');
+        $sqlin = "INSERT INTO $table($strcol) SELECT $strval";
+
+        if (strlen($from) >= 1) {
+            $sqlin .= ' ' . $from;
+            $arrVal = array_merge($arrVal, $arrFromVal);
+        }
+
         // INSERT文の実行
         $ret = $this->query($sqlin, $arrVal, false, null, MDB2_PREPARE_MANIP);