X-Git-Url: https://git.madduck.net/etc/mailfilter.git/blobdiff_plain/ede6a5e4adbf5f6f345768cb15e2018363750c14..3a35a72b02f689e9ed9ec92f45f084f761d5c8b5:/bin/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