src/strip.vala
authorAlan Knowles <alan@roojs.com>
Fri, 4 May 2018 05:15:56 +0000 (13:15 +0800)
committerAlan Knowles <alan@roojs.com>
Fri, 4 May 2018 05:15:56 +0000 (13:15 +0800)
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";