MINIMALDB = eve-minimal.db



all:			dbfiles

clean:			clean-db clean-sql clean-csv

dbfiles:		eve-minimal.db

sqlfiles:		invTypes.sql mapDenormalize.sql

csvfiles:		invTypes.csv mapDenormalize.csv

invTypes.sql:		mk-invTypes.sqlite apo120-sqlite3-v1.db
	echo "BEGIN EXCLUSIVE TRANSACTION;" > invTypes.sql
	echo "DROP TABLE invTypes;" >> invTypes.sql
	sqlite3 -batch apo120-sqlite3-v1.db < mk-invTypes.sqlite | egrep -iv "double|graphicID|tinyint|marketGroupID|groupID|portionSize|description|CREATE INDEX" >> invTypes.sql
	echo "COMMIT TRANSACTION;" >> invTypes.sql

mapDenormalize.sql:	mk-mapDenormalize.sqlite apo120-sqlite3-v1.db
	echo "BEGIN EXCLUSIVE TRANSACTION;" > mapDenormalize.sql
	echo "DROP TABLE mapDenormalize;" >> mapDenormalize.sql
	sqlite3 -batch apo120-sqlite3-v1.db < mk-mapDenormalize.sqlite | egrep -iv "typeID|groupID|solarSystemID|constellationID|regionID|orbitID|double|celestialIndex|orbitIndex" >> mapDenormalize.sql
	echo "COMMIT TRANSACTION;" >> mapDenormalize.sql

eve-minimal.db:		*.sql
	sqlite3 -batch $(MINIMALDB) < $*.sql

%.csv:	mk-%.sqlite apo120-sqlite3-v1.db
	sqlite3 -batch apo120-sqlite3-v1.db < mk-$*.sqlite > $*.csv


clean-db:
	rm -f mapDenormalize.db invTypes.db

clean-sql:
	rm -f *.sql

clean-csv:
	rm -f *.csv

apo120-sqlite3-v1.db:	apo120-sqlite3-v1.db.bz2
	bunzip2 -kv apo120-sqlite3-v1.db.bz2

apo120-sqlite3-v1.db.bz2:
	wget -m -nd http://eve.no-ip.de/apo120/apo120-sqlite3-v1.db.bz2

.PHONY: sqlfiles dbfiles clean-db clean-sql clean-csv download