#!/bin/sh

#
# simple shell script to generate c macros from the query .sql files
#
rm -f query_defs.h
touch query_defs.h
for f in $*
do
    cat $f | sed -e 's/--.*$//' -e 's/[ 	][ 	]*/ /g' | \
    nawk '
        BEGIN { printf "%s \"", macro }
        /.*/ { printf "%s ", $0 }
        END {printf "\"\n"}
    ' macro="#define `basename $f .sql | tr a-z A-Z`" >> query_defs.h
done