add sqlite msgid index

diff --git a/procmail/msgid-index b/procmail/msgid-index
new file mode 100644 (file)
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 282b6d83322a6e394f1f9576d5939720cef06493..e1f817d200e97d399fd80a2445c326fdfaeaab06 100755 (executable)
--- 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