From 55f72fea81c98b5769218e3fce6b9a1bb34c9059 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 29 Jun 2018 16:07:27 +0800 Subject: [PATCH] src/strip.vala --- src/strip.vala | 57 ++++++++++++++++++++++++++++++++++++++++++++------ 1 file changed, 51 insertions(+), 6 deletions(-) diff --git a/src/strip.vala b/src/strip.vala index e52d8c6..e05a408 100644 --- a/src/strip.vala +++ b/src/strip.vala @@ -445,7 +445,7 @@ public class Strip : GLib.Object { var file_path = attachment.get_header("X-strip-path"); var fn = StripApplication.opt_target_path + "/" + file_path; var chksum = this.md5_file(fn); - var mime_filename = attachment.get_header("X-strip-content-type"); + var mime_type = attachment.get_header("X-strip-content-type"); var fileinfo = File.new_for_path(fn) .query_info(GLib.FileAttribute.STANDARD_SIZE+","+GLib.FileAttribute.TIME_MODIFIED @@ -456,18 +456,63 @@ public class Strip : GLib.Object { this.query(""" - INSERT INTO Attachment - (id, msgid, checksum, mime_type, filesize) - values + + + INSERT INTO Attachment ( + id, + + msgid , + queue_id , + mime_filename , + mime_type, + + stored_filename , + mime_charset , + mime_cdisp , + mime_is_cover , + + mime_is_multi , + mime_is_mail, + mime_size , + filesize, + + checksum + + ) VALUES ( + %d, -- id + '%s' , -- msgid + 0, + '%s' , -- filename + '', + '', + '', + 'attachment', + 0, + 0, + 0, + %d, -- size + %d, -- size + '%s' -- checkum + + )" + + + INSERT INTO Attachment ( + id, msgid, checksum, mime_type, + mime_filename, filesize,mime_size, mime_cdisp + ) values ( ( - %d, '%s', '%s', '%s', %d + %d, '%s', '%s', '%s', + '%s' %d, %d, 'attachment', + ) """.printf( id, this.mysql_escape(this.active_message_exim_id), this.mysql_escape(chksum), - this.mysql_escape(mime_filename), + this.mysql_escape(mime_type), + this.mysql_escape(filename), file_size )); -- 2.39.2