X-Git-Url: https://git.madduck.net/etc/mailfilter.git/blobdiff_plain/a0f03dbfefec79510c486c42c79a9e4997e0d740..9560f41b30a0460ff3d88313eead30039ac9ecdf:/procmail/msgid-index

diff --git a/procmail/msgid-index b/procmail/msgid-index
new file mode 100644
index 0000000..cef6476
--- /dev/null
+++ b/procmail/msgid-index
@@ -0,0 +1,27 @@
+# create table logfiles (sender text not null, recipient text not null,
+# subject text not null, msgid text unique not null, filename text primary key
+# not null unique, timestamp timestamp with time zone);
+#
+# create trigger insert_logfiles_timestamp after insert on logfiles begin
+# update logfiles set timestamp = datetime('now') where filename
+# = new.filename; end;
+
+SQLITE=/usr/bin/sqlite3
+MSGID_INDEX_DB=$PMVAR/msgid-index.sqlite
+
+DO_QUERY="$SQLITE $MSGID_INDEX_DB"
+
+SQ="'\\''"
+SQE="'\\\''"
+FIELDS="$FROM$NL$ORIGINAL_TO$NL$SUBJECT$NL$MSGID"
+QUERY="insert into logfiles (sender, recipient, subject, msgid, filename) values (
+  `echo \"$FIELDS\" | sed -e 's,\\\",\\\\\",g; s,'\'','$SQE$SQE',g; s/^.*$/'\$SQE'&'\$SQE',/'`
+  $SQ$THISLOGFILE_REL$SQ)"
+TRAP="$TRAP; $DO_QUERY '$QUERY'"
+
+QUERY
+FIELDS
+SQE
+SQ
+DO_QUERY
+MSGID_INDEX_DB