src/strip.vala

[app.mailtrimmer] / src / strip.vala

diff --git a/src/strip.vala b/src/strip.vala
index 88cf364..0c1fd0e 100644 (file)
--- a/src/strip.vala
+++ b/src/strip.vala
@@ -370,11 +370,13 @@ public class Strip : GLib.Object {
        
        // initialize it with known data..
        // that should wipe out dupes.
-       var matches = this.execute("SELECT count(id) FROM Attachment WHERE id = %d".printf(
+       var matches = this.execute("SELECT count(id) as nid FROM Attachment WHERE id = %d".printf(
                        int.parse(sid)));  
-                GLib.error("Got Matches :%s", matches);
+
                 
-               if (matches=="0") {      
+               if (matches=="") {       
+                       // our old mailfort code deleted the crap out of old records...
+                       // if this occurs we will need to create the record again..
                   GLib.error("Failed to find id  :%s", sid);
                   return;
                }
@@ -616,6 +618,8 @@ public class Strip : GLib.Object {
 
         var rs = mysql.use_result();
         
+        //GLib.debug("got %d rows", (int) rs.num_rows());
+        
         var got_row = false;
                string[] row;
                string ret = "";
@@ -625,15 +629,20 @@ public class Strip : GLib.Object {
                
                }
                if (!need_return) {
-                       GLib.debug("got %s", got_row ? "=Nothing=" : ret);
+               if (StripApplication.opt_debug_sql) {
+                               GLib.debug("got %s", got_row ? "=Nothing=" : ret);
+                       }
                        return got_row ? "" : ret;
                }
                if (!got_row) {
+
                         GLib.debug("ERROR : no rows returned");
                        Posix.exit(1);
                        return "";
                }
-               GLib.debug("got %s", ret);
+       if (StripApplication.opt_debug_sql) {
+                       GLib.debug("got %s", ret);
+               }
                return ret;