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\\'');
- select * from messages where filename = '\\'$THISLOGFILE_REL\\''"
-TRAP="$TRAP; case \"$($DO_QUERY '$QUERY')\" in '')
- echo 'msgid-index: failed to insert reference into database';; esac"
+ $DATA, '$THISLOGFILE_REL', '\$DESTFILE');"
+TRAP="$TRAP; OUT=\"$(echo \"$QUERY\" | $DO_QUERY 2>&1)\";
+ [ -n \"\$OUT\" ] && echo \"msgid-index: failed to insert reference into database: \$OUT\""
projects / etc / mailfilter.git / blobdiff