From: martin f. krafft <madduck@madduck.net>
Date: Fri, 29 Feb 2008 16:29:48 +0000 (+0100)
Subject: add script to release delayed messages
X-Git-Url: https://git.madduck.net/etc/mailfilter.git/commitdiff_plain/3a35a72b02f689e9ed9ec92f45f084f761d5c8b5

add script to release delayed messages
---

diff --git a/bin/release-delayed-messages b/bin/release-delayed-messages
new file mode 100755
index 0000000..6a057c9
--- /dev/null
+++ b/bin/release-delayed-messages
@@ -0,0 +1,12 @@
+#!/bin/sh
+set -eu
+
+MAILDIR=$HOME/.maildir
+
+SQLITE=/usr/bin/sqlite3
+DELAYED_QUEUE_DB=$HOME/.var/procmail/delayed-queue.sqlite
+
+QUERY="update messages set release_ts = strftime('%s', 'now') - 10 where filename like '.delayed/%'"
+
+$SQLITE $DELAYED_QUEUE_DB "$QUERY"
+exec $HOME/.etc/mailfilter/bin/process-delayed-queue