X-Git-Url: https://git.madduck.net/etc/mailfilter.git/blobdiff_plain/3045078502871a4f349f35a338f5ae0a568a12d7..8d18b671d3e6e0c871f6cc81cf6ddc58589f35ce:/bin/process-delayed-queue

diff --git a/bin/process-delayed-queue b/bin/process-delayed-queue
index fd84840..6ab1163 100755
--- a/bin/process-delayed-queue
+++ b/bin/process-delayed-queue
@@ -8,41 +8,42 @@ RESUBMIT=$HOME/.etc/mailfilter/bin/resubmit
 
 DELAYED_QUEUE_DB=$HOME/.var/procmail/delayed-queue.sqlite
 
-QUERY='select * from messages where release_ts < strftime("%s", "now")'
-
-$SQLITE -column $DELAYED_QUEUE_DB "$QUERY" | while read msgid basefile ts; do
-
-  file="$MAILDIR/$basefile"
-  files="$file ${file}:2,"
-
-  basename="${file##*/}"
-  dirname="${file%/*}"
-  case "${dirname##*/}" in
-    cur)
-      files="$files ${file}:2,S"
-      file="${dirname%/cur}/new/$basename"
-      files="$files $file ${file}:2,"
-      ;;
-    new)
-      file="${dirname%/new}/cur/$basename"
-      files="$files ${file}:2, ${file}:2,S"
-      ;;
-  esac
-
-  found=0
-  for file in $files; do
-    if [ -f "$file" ]; then
-      $RESUBMIT "$file"
-      echo "I: resubmitted $msgid"
-      found=1
-      break
+QUERY='select * from messages where release_ts <= strftime("%s", "now")'
+
+$SQLITE -list -separator ' ' $DELAYED_QUEUE_DB "$QUERY" \
+  | while read msgid basefile ts; do
+
+    file="$MAILDIR/$basefile"
+    files="$file ${file}:2,"
+
+    basename="${file##*/}"
+    dirname="${file%/*}"
+    case "${dirname##*/}" in
+      cur)
+        files="$files ${file}:2,S"
+        file="${dirname%/cur}/new/$basename"
+        files="$files $file ${file}:2,"
+        ;;
+      new)
+        file="${dirname%/new}/cur/$basename"
+        files="$files ${file}:2, ${file}:2,S"
+        ;;
+    esac
+
+    found=0
+    for file in $files; do
+      if [ -f "$file" ]; then
+        $RESUBMIT "$file"
+        echo "I: resubmitted $msgid"
+        found=1
+        break
+      fi
+    done
+
+    $SQLITE $DELAYED_QUEUE_DB "delete from messages where msgid = '$msgid'"
+
+    if [ $found -eq 0 ]; then
+      echo "E: message $msgid not found in $basefile" >&2
     fi
-  done
-
-  $SQLITE $DELAYED_QUEUE_DB "delete from messages where msgid = '$msgid'"
-
-  if [ $found -eq 0 ]; then
-    echo "E: message $msgid not found in $basefile" >&2
-  fi
 
 done