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
|