DB= miniu.sql
FILES= build.txt q1.txt q2.txt readme.txt makefile

all: build demo1 demo2

demo: input.txt
	sqlite3 $(DB) < build.txt
	sqlite3 $(DB) < q1.txt
	sqlite3 $(DB) < q2.txt

build: build.txt
	sqlite3 $(DB) < build.txt
	touch build

demo1: q1.txt  build
	sqlite3 $(DB) < q1.txt

demo2: q2.txt  build
	sqlite3 $(DB) < q2.txt

clean:
	\rm -rf $(DB) build 

spotless: all.zip
	\rm -rf q1.txt q2.txt build.txt makefile

all.zip: sqldemo.zip

sqldemo.zip: $(FILES)
	zip -r sqldemo.zip $(FILES)

