factor out recording of delayed delivery

[etc/mailfilter.git] / procmail / record-delayed-mail

diff --git a/procmail/record-delayed-mail b/procmail/record-delayed-mail
new file mode 100644 (file)
index 0000000..e83391b
--- /dev/null
+++ b/procmail/record-delayed-mail
@@ -0,0 +1,18 @@
+# create table messages (msgid text unique not null, filename text
+# primary key not null unique, release_ts integer not null);
+
+DELAYED_QUEUE_DB=$PMVAR/delayed-queue.sqlite
+
+DO_QUERY="$SQLITE $DELAYED_QUEUE_DB"
+
+DATA="$MSGID"
+INCLUDERC=$PMDIR/sql-escape
+
+QUERY="insert into messages values
+  ($DATA, '\\'\$DESTFILE\\'', $RELEASE_TS)"
+TRAP="$TRAP; $DO_QUERY '$QUERY'"
+
+QUERY
+DATA
+DO_QUERY
+DELAYED_QUEUE_DB