From: martin f. krafft <madduck@madduck.net>
Date: Sun, 16 Sep 2007 09:58:40 +0000 (+0200)
Subject: add sqlite msgid index
X-Git-Url: https://git.madduck.net/etc/mailfilter.git/commitdiff_plain/9560f41b30a0460ff3d88313eead30039ac9ecdf

add sqlite 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
diff --git a/procmail/procmailrc b/procmail/procmailrc
index 282b6d8..e1f817d 100755
--- a/procmail/procmailrc
+++ b/procmail/procmailrc
@@ -17,6 +17,7 @@ INCLUDERC=$PMDIR/smsmail
 #VERBOSE=yes
 
 INCLUDERC=$PMDIR/logging
+INCLUDERC=$PMDIR/msgid-index
 
 INCLUDERC=$PMDIR/dejavu
 INCLUDERC=$PMDIR/eqdomains