# create table messages (msgid text unique not null, filename text # primary key not null unique, release_ts integer not null); DELAYED_QUEUE_DB=$PMVAR/delayed-queue.sqlite DO_QUERY="$SQLITE $DELAYED_QUEUE_DB" DATA="$MSGID" INCLUDERC=$PMDIR/sql-escape QUERY="insert into messages values ($DATA, '\\'\$DESTFILE\\'', $RELEASE_TS); select * from messages where msgid = $DATA" TRAP="$TRAP; case \"$($DO_QUERY '$QUERY')\" in '') echo 'delay: failed to insert reference into database';; esac" QUERY DATA DO_QUERY DELAYED_QUEUE_DB