PROGS=SelectUsingMetaHDBC
DSN=MetaHDBC_PQ_DSN

all: clean $(PROGS)

SelectUsingMetaHDBC: SelectUsingMetaHDBC.hs
	ghc -fglasgow-exts --make -Wall SelectUsingMetaHDBC.hs

.PHONY: clean carTable deleteFromCarTable dropCarTable selectCarTable runCarTests

clean: deleteFromCarTable
	- rm *.o *.hi *~ $(PROGS)

carTable:
	- make dropCarTable
	echo "CREATE TABLE Car (make VARCHAR(25) PRIMARY KEY NOT NULL UNIQUE, topSpeed INT NOT NULL)" | isql $(DSN) -b
	echo "INSERT INTO Car (make, topSpeed) VALUES ('Honda', 160)" | isql $(DSN) -b
	echo "INSERT INTO Car (make, topSpeed) VALUES ('Lotus', 225)" | isql $(DSN) -b
	echo "SELECT * FROM Car" | isql $(DSN) -b

selectCarTable:
	echo "SELECT * FROM Car" | isql $(DSN) -b

dropCarTable:
	echo "DROP TABLE Car" | isql $(DSN) -b

deleteFromCarTable:
	echo "DELETE FROM CAR" | isql $(DSN) -b

runCarTests: SelectUsingMetaHDBC
	make dropCarTable
	make carTable
	./SelectUsingMetaHDBC