aboutsummaryrefslogtreecommitdiff
path: root/dbinit/makefile
blob: 1f07ca92dcd0049bfa51d93fdbc329cd9e12300b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
SQL = mysql
USER = $(shell id -un)
HOST = localhost

.PHONY: clean permissions base data full

all: full

# delete old tables and create new tables
base: base.sql
	$(SQL) < $<

# fill tables with data
data: data.sql
	$(SQL) < $<

# do everything
full: full.sql
	$(SQL) < $<

base.sql: reset.sql init.sql
	cat $^ > $@

data.sql:
	./import.py 2017 2020 > $@

full.sql: base.sql data.sql views.sql functions.sql procedures.sql triggers.sql update.sql
	cat $^ > $@

# grant all database permissions (development only)
permissions:
	echo "grant all privileges on formula1.* to '$(USER)'@'$(HOST)';" | sudo $(SQL)
	echo "grant file on *.* to '$(USER)'@'$(HOST)';" | sudo $(SQL)

# delete generated sql files
clean:
	$(RM) full.sql base.sql data.sql