Changeset 34596

Timestamp:

07/24/09 11:06:23 (4 years ago)

Author:

nowelium

Message:

merge IN(?,?,...) and VALUES(?,?,...)

Files:

• platform/mysql/mprofile.php/trunk/mpfilter.php (modified) (2 diffs)

platform/mysql/mprofile.php/trunk/mpfilter.php

@@ -4 +4 @@
 $replacement = array(
     '/\r?\n/' => ' ',
+    '/((?<=\W)-?(?:0x[0-9a-f]+))/i' => '?',
     '/(\"([^\"]+)\")/' => '?',
     '/(\'([^\']+)\')/' => '?',
     '/\s{2,}/' => ' '
-
 );
 $replacepattern = array_keys($replacement);
 $replace = array_values($replacement);
+
+function __replace_place_folder__($matches){
+    $buf = $matches[2];
+    $buf = preg_replace('/(([^\,\s\(\)\?]+))+/', '?', $buf);
+    return $matches[1] . ' ' . $buf;
+}
 
 $stdin = fopen('php://stdin', 'r');
@@ -23 +29 @@
     }
     foreach($rows as $row){
-        $returnValue[] = preg_replace($replacepattern, $replace, $row->Info);
+        if(!isset($row->Info)){
+            continue;
+        }
+        $info = $row->Info;
+        $info = preg_replace($replacepattern, $replace, $info);
+        $info = preg_replace_callback('/(VALUES|IN)\s*(\(.*\))/i', '__replace_place_folder__',  $info);
+        $returnValue[] = $info;
     }
     echo json_encode($returnValue), PHP_EOL;