#!/bin/sh
PATH=/usr/local/sqlite3/bin:$PATH
binfile=./tmp/binary-data
cd `dirname $0`

unhexize() {
  perl -n -e 's/([0-9a-f]{2})/print chr hex $1/gie'
}
sqlite3 tmp/binary.sq3 <<EOF | unhexize > $binfile
SELECT quote(filecontent) FROM bin WHERE filename='foo.jpg';
EOF

cat<<EOF
Content-type: `file --mime-type $binfile | cut -d' ' -f2`
Content-Disposition: filename="foo.jpg"
Content-length: `wc -c < $binfile`

EOF
cat $binfile
rm -f $binfile