fix sql escaping and sqlite error reporting

[etc/mailfilter.git] / procmail / delay-delivery

diff --git a/procmail/delay-delivery b/procmail/delay-delivery
index 405cbcba33f504a327233bcc6ec79d7a194593be..e68d829194c0b8d7121a826f315c058c15f90d70 100644 (file)
--- a/procmail/delay-delivery
+++ b/procmail/delay-delivery
@@ -1,34 +1,37 @@
-# 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
+* ! DISABLE_DELAYS ?? .
 * DELAY ?? .
 * ! DELAYED ?? .
 {
+  :0
+  * DELAY ?? ^[0-9]
+  { DELAY="now + $DELAY" }
+
   #TODO: for tickling, use header date
-  RELEASE="`date -d \"now + $DELAY\" +'%s %c'`"
+  RELEASE="`$BIN_DATE -d \"$DELAY\" +'%s %c'`"
+
   :0
   *$ RELEASE ?? ^\/${RE_NOT_SPACE}+
   { RELEASE_TS=$MATCH }
-  :0
-  *$ RELEASE ?? ^[0-9]+${RE_SPACE}+\/.+
-  { RELEASE_TIME="$MATCH" }
 
-  LOG="delay:       delay delivery of $MSGID until $RELEASE_TIME$NL"
-
-  DELAYED_QUEUE_DB=$PMVAR/delayed-queue.sqlite
-  DO_QUERY="$SQLITE $DELAYED_QUEUE_DB"
+  :0
+  *$  $RELEASE_TS ^0
+  *$ -$OURDATE_TS ^0
+  {
+    :0
+    *$ RELEASE ?? ^[0-9]+${RE_SPACE}+\/.+
+    { RELEASE_TIME="$MATCH" }
 
-  DATA="$MSGID"
-  INCLUDERC=$PMDIR/sql-escape
+    LOG="delay:       delay delivery of $MSGID until $RELEASE_TIME$NL"
 
-  Q="insert into messages values
-     ($DATA, '\\'\$DESTFILE\\'', $RELEASE_TS)"
-  TRAP="$TRAP; $DO_QUERY '$Q'"
+    :0 fw
+    |$FORMAIL -I "X-Delayed: $RELEASE_TS ($RELEASE_TIME)"
 
-  :0 fw
-  |$FORMAIL -I "X-Delayed: $RELEASE_TS ($RELEASE_TIME)"
+    INCLUDERC=$PMDIR/record-delayed-mail
 
-  :0
-  $DELAYED_QUEUE
+    :0
+    $DELAYED_QUEUE
+  }
 }