WIP import script

1 files changed, 35 insertions, 1 deletions

diff --git a/dbinit/makefile b/dbinit/makefile
index d6ab70e..0e335b7 100644
--- a/dbinit/makefile
+++ b/dbinit/makefile
@@ -1,5 +1,39 @@
-dbinit.sql: base.sql data.sql
+SQL = mysql
+USER = $(shell id -un)
+HOST = localhost
+
+.PHONY: clean permissions init data procedures full
+
+# delete old tables and create new tables
+init: base.sql
+	$(SQL) < $<
+
+# fill tables with data
+data: data.sql
+	$(SQL) < $<
+
+# add procedures/sql functions
+procedures: procedures.sql
+	$(SQL) < $<
+
+# do all of the above in one go
+full: full.sql
+	$(SQL) < $<
+
+base.sql: reset.sql init.sql
+	cat $^ > $@
+
+full.sql: reset.sql init.sql data.sql procedures.sql
 	cat $^ > $@
 
 data.sql:
 	./import.py > $@
+
+# grant all database permissions (development only)
+permissions:
+	echo "grant all privileges on formula1.* to '$(USER)'@'$(HOST)';" | sudo $(SQL)
+
+# delete generated sql files
+clean:
+	$(RM) full.sql base.sql data.sql
+