Changeset 39 for trunk

Timestamp:

05/15/07 21:25:26 (20 months ago)

Author:

scott

Message:

Fixed a bug in mysql where tabs weren't being unescaped

Files:

• trunk/awkbot/lib/mysql.awk (modified) (3 diffs)

trunk/awkbot/lib/mysql.awk

@@ -51 +51 @@
     if (getline input < mysql[resource]) {
         for (i = split(input, key, "\t"); i > 0; i--)
-            mysql[resource, i] = key[i]
+            mysql[resource, i] = gensub(/\\t/, "\t", "g", key[i])
     }
 
@@ -61 +61 @@
         fields = split(input, row, "\t")
         for (i = 1; i <= fields; i++)
-            row[mysql[resource, i]] = row[i]
+            row[mysql[resource, i]] = gensub(/\\t/, "\t", "g", row[i])
     }
 
@@ -67 +67 @@
 }
 
-function mysql_fetch_row (resource,row  ,input) {
-    if (getline input < mysql[resource])
-        return split(input, row, "\t")
+function mysql_fetch_row (resource,row  ,input,r,i) {
+    if (getline input < mysql[resource]) {
+        r = split(input, row, "\t")
+
+        for (i = 0; i <= r; i++) {
+            row[i] = gensub(/\\t/, "\t", "g", row[i]) # Unescape tabs
+        }
+
+        return r
+    }
 
     return 0