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 }