]>
git.madduck.net Git - etc/mailfilter.git/blobdiff - procmail/msgid-index
madduck's git repository
Every one of the projects in this repository is available at the canonical
URL git://git.madduck.net/madduck/pub/<projectpath> — see
each project's metadata for the exact URL.
All patches and comments are welcome. Please squash your changes to logical
commits before using git-format-patch and git-send-email to
patches@ git. madduck. net .
If you'd read over the Git project's submission guidelines and adhered to them,
I'd be especially grateful.
SSH access, as well as push access can be individually
arranged .
If you use my repositories frequently, consider adding the following
snippet to ~/.gitconfig and using the third clone URL listed for each
project:
[url "git://git.madduck.net/madduck/"]
insteadOf = madduck:
# create table messages (sender text not null, recipient text not null,
# create table messages (sender text not null, recipient text not null,
-# subject text not null, msgid text unique not null, filename text primary key
+# subject text not null, msgid text not null, filename text primary key
# not null unique, timestamp integer, dest text not null);
#
# create trigger insert_messages_timestamp after insert on messages begin
# not null unique, timestamp integer, dest text not null);
#
# create trigger insert_messages_timestamp after insert on messages begin
INCLUDERC=$PMDIR/sql-escape
QUERY="insert into messages (sender, recipient, subject, msgid, filename, dest) values (
INCLUDERC=$PMDIR/sql-escape
QUERY="insert into messages (sender, recipient, subject, msgid, filename, dest) values (
- $DATA, '\\'$THISLOGFILE_REL\\'', '\\'\$DESTFILE\\'')"
-TRAP="$TRAP; $DO_QUERY '$QUERY'"
+ $DATA, '\\'$THISLOGFILE_REL\\'', '\\'\$DESTFILE\\'');
+ select * from messages where filename = '\\'$THISLOGFILE_REL\\''"
+TRAP="$TRAP; case \"$($DO_QUERY '$QUERY')\" in '')
+ echo 'msgid-index: failed to insert reference into database';; esac"
projects / etc / mailfilter.git / blobdiff