From: martin f. krafft 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?ds=sidebyside 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