Makefile

CLANG_OPTS = -I /usr/local/include -L /usr/local/lib
Compiler   = clang
Options    = -lm -Wall pcre_split.c sqlbong.c -lpcre -lsqlite3 -o sqlbong

# Targets

sqlbong: pcre_split/src usage.h *.c *.h
	${Compiler} ${CLANG_OPTS} ${Options}

.PHONY: install
install: sqlbong
	cp sqlbong /usr/local/bin/

.PHONY: uninstall
uninstall:
	rm /usr/local/bin/sqlbong

.PHONY: debug
debug: clean usage.h
	${Compiler} ${CLANG_OPTS} -ggdb -DDEBUG=1 ${Options}

.PHONY: clean
clean:
	rm -rf sqlbong *.o sql*SYM/ usage.h

.PHONY: test
test: sqlbong runtests

.PHONY: testdebug
testdebug: debug runtests

pcre_split/src:
	git submodule update --init --recursive

.PHONY: upload
upload: sqlbong
	$(eval zipfile := $(shell echo "sqlbong-0.1.0-`git rev-parse --short HEAD`-`sw_vers -productName | sed 's/ //g'`-`sw_vers -productVersion`-`sw_vers -buildVersion`.zip"))
	zip $(zipfile) sqlbong README.md
	s3cmd put --acl-public $(zipfile) s3://sordina.binaries/$(zipfile)
	rm $(zipfile)

usage.h:
	# Convert README.md to a printing function
	echo "#ifndef USAGEH"                                                             > usage.h
	echo "#define USAGEH"                                                            >> usage.h
	echo "void usage() {"                                                            >> usage.h
	cat README.md | sed 's/["%\\]/\\&/g;s/^/printf("/;s/$$/\\n");/' | grep -v '<img' >> usage.h
	echo "}"                                                                         >> usage.h
	echo "#endif"                                                                    >> usage.h

.PHONY: runtests
runtests:
	# Multi column data
	(echo 111 222 333; echo 444 555 666; echo 777 888 999) | ./sqlbong "select c1, c2 from data"
	# Increasing columns
	(echo 1; echo 1 2; echo 1 2 3; echo 1 2 3 4)           | ./sqlbong "select c1, c2, c4 from data"
	# Decreasing columns
	(echo 1; echo 1 2; echo 1 2 3; echo 1 2; echo 1)       | ./sqlbong "select c1, c3, c2 from data"
	# Blank lines
	(echo 1 3 2 4; echo; echo 1 2 3)                       | ./sqlbong "select c2 from data"
	# Long words
	(echo ksjdhfklsjdhfksjhdfkjshdl; \
	 echo abdominogenital; \
	 echo skfdjlhasldkfhlaskdjfhlaksdjhflkjahs; \
	 echo foooooooooooofoo fooooof fooooooooooooo)         | ./sqlbong "select c1, c2 from data"
	# Not sure why it's throwing an error, but:
	echo "95585 ttys002    0:03.11 vim sqlbong.c"          | ./sqlbong "select * from data"
	# Lots of words
	echo a b c d e f g h i j k l m n o p q r s t u v w x y | ./sqlbong "select * from data"
	echo 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16            | ./sqlbong "select c15 from data" | grep 15
	(echo 1_3_2_4; echo 5___6__7_8)                        | ./sqlbong -d '_+' "select c1,c2 from data"
	./sqlbong -d , 'select * from data' < test.csv > /dev/null
	(echo 1 2 3; echo 1 2)                                 | ./sqlbong -d ' ' 'select * from data' | wc -l | grep 2