From 9560f41b30a0460ff3d88313eead30039ac9ecdf Mon Sep 17 00:00:00 2001
From: "martin f. krafft" <madduck@madduck.net>
Date: Sun, 16 Sep 2007 11:58:40 +0200
Subject: [PATCH 1/1] add sqlite msgid index

---
 procmail/msgid-index | 27 +++++++++++++++++++++++++++
 procmail/procmailrc  |  1 +
 2 files changed, 28 insertions(+)
 create mode 100644 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
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
-- 
2.39.5