Changeset 19094 for trunk/FACT++/src

Timestamp:

07/29/18 19:58:51 (6 years ago)

Author:

tbretz

Message:

Some more improvemnts to the EXPLAIN formating.

File:

• trunk/FACT++/src/rootifysql.cc (modified) (7 diffs)

trunk/FACT++/src/rootifysql.cc

@@ -137 +137 @@
     vector<string> queries;
 
-    string resub(string str, size_t indent)
+    string resub(string str)
     {
         // search for "KEYWORD expression"
@@ -152 +152 @@
             const auto idx = atoi(arg.c_str()+1);
 
-            str.replace(pos, len, resub(vec[idx], indent));
+            str.replace(pos, len, resub(vec[idx]));
         }
 
@@ -175 +175 @@
                 if (vec[idx].substr(0,2)=="({")
                 {
-                    cout << setw(indent) << ' ' << "(" << resub(vec[idx], indent+4) << ") ";
+                    cout << setw(indent) << ' ' << "(" << resub(vec[idx]) << ") ";
                 }
                 else
@@ -181 +181 @@
                     if (indent>0)
                         cout << setw(indent) << ' ';
-                    cout << vec[idx];
+                    cout << resub(vec[idx]);
                 }
         }
@@ -188 +188 @@
             if (indent>0)
                 cout << setw(indent) << ' ';
-            cout << expr;
+            cout << resub(expr);
         }
     }
@@ -199 +199 @@
         const string _com = "\\/\\*\\ select\\#[0-9]+\\ \\*\\/\\ *";
 
-        const string _tok = "[a-zA-Z ]+";
+        const string _tok = "[a-zA-Z_ ]+";
 
         const string _nnn = "\\{[0-9]+\\}|[0-9]+";
@@ -261 +261 @@
 
         // substitute all paranthesis
-        sql = substitute(sql, "\\([^\\(\\)]*\\)");
+        sql = substitute(sql, "[a-zA-Z0-9_]*\\([^\\(\\)]*\\)");
 
         //cout << sql << "\n\n";