From 3a35a72b02f689e9ed9ec92f45f084f761d5c8b5 Mon Sep 17 00:00:00 2001
From: "martin f. krafft" <madduck@madduck.net>
Date: Fri, 29 Feb 2008 17:29:48 +0100
Subject: [PATCH] add script to release delayed messages

---
 bin/release-delayed-messages | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100755 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
-- 
2.39.2