X-Git-Url: https://git.madduck.net/etc/mailfilter.git/blobdiff_plain/18ac4f995c4d175bc636fdd78919a18e131afdcf..788ea8914a78296e6ef98a9be37a67485c34d32b:/procmail/delay-delivery

diff --git a/procmail/delay-delivery b/procmail/delay-delivery
index c1ca0c0..3817715 100644
--- a/procmail/delay-delivery
+++ b/procmail/delay-delivery
@@ -1,6 +1,3 @@
-# create table messages (msgid text unique not null, filename text
-# primary key not null unique, release_ts integer not null);
-
 #TODO: create config/delay-(disabled|tonight|weekend)
 
 :0
@@ -28,19 +25,11 @@
 
     LOG="delay:       delay delivery of $MSGID until $RELEASE_TIME$NL"
 
-    DELAYED_QUEUE_DB=$PMVAR/delayed-queue.sqlite
-    DO_QUERY="$SQLITE $DELAYED_QUEUE_DB"
-
-    DATA="$MSGID"
-    INCLUDERC=$PMDIR/sql-escape
-
-    Q="insert into messages values
-      ($DATA, '\\'\$DESTFILE\\'', $RELEASE_TS)"
-    TRAP="$TRAP; $DO_QUERY '$Q'"
-
     :0 fw
     |$FORMAIL -I "X-Delayed: $RELEASE_TS ($RELEASE_TIME)"
 
+    INCLUDERC=$PMDIR/record-delayed-mail
+
     :0
     $DELAYED_QUEUE
   }