src/strip.vala
[app.mailtrimmer] / src / strip.vala
index df3d702..6c2a755 100644 (file)
@@ -415,17 +415,12 @@ public class Strip : GLib.Object {
         
         this.query("""
                SELECT 
-                       id,
-                       DATE_FORMAT(created,"%%Y/%%m/%%d") as create_date,
-                       msgid
-                FROM 
-                       Attachment 
-                       WHERE
-                checksum = '%s'
-                AND
-               filesize = %d
-               LIMIT
-                       1
+               
+               attachment_init(
+                               '%s', -- in_msgid VARCHAR(32),
+                               '%s', -- in_checksum VARCHAR(64),
+                               '%s' -- in_mime_filename varchar(255)
+                       ) as id ;
           """.printf( chksum, file_size)
                );
                var file_id = "0";