From 2528bcaf1f76e4a6c40c6aa4d6c72a16d37f9177 Mon Sep 17 00:00:00 2001
From: lonkaars <loek@pipeframe.xyz>
Date: Tue, 7 Mar 2023 19:50:24 +0100
Subject: WIP import script

---
 dbinit/makefile | 36 +++++++++++++++++++++++++++++++++++-
 1 file changed, 35 insertions(+), 1 deletion(-)

(limited to 'dbinit/makefile')

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
+
-- 
cgit v1.2.3