Project

General

Profile

1 6912 aaronmk
selfDir_AkFFYJ := $(dir $(lastword $(MAKEFILE_LIST)))
2
root := $(selfDir_AkFFYJ)..
3
include $(root)/lib/common.Makefile
4
5
6 6979 aaronmk
##### Vars/functions
7
8
# Make
9
SHELL := /bin/bash
10
11 785 aaronmk
##### General targets
12 387 aaronmk
13 8183 aaronmk
all = vegbien.sql vegbien.my.sql util.sql py_util.sql
14 387 aaronmk
15 418 aaronmk
all: _always $(all) ;
16 387 aaronmk
17
clean: _always
18
	$(RM) $(all)
19
20 6916 aaronmk
%/reinstall: _always %/uninstall %/install ;
21
22
##### Installation
23
24 8183 aaronmk
schemas := temp util py_util
25 6916 aaronmk
install: $(schemas:%=%/install) ;
26
27 8183 aaronmk
schemasReversed := py_util util temp
28 6916 aaronmk
uninstall: $(schemasReversed:%=%/uninstall) ;
29
30
psqlAsAdminVegbien := $(psqlAsAdmin) vegbien
31
psqlNoSearchPath := env no_search_path=1 ../bin/psql_script_vegbien
32 11793 aaronmk
psql_verbose := env no_search_path=1 ../bin/psql_verbose_vegbien
33 6916 aaronmk
34 6935 aaronmk
# Must come before `%/install: vegbien.sql` to override it
35
%/install: %.sql _always
36
	-<$< $(psqlNoSearchPath)
37
# ignore errors if schema exists
38
39 6933 aaronmk
%/uninstall: _always
40 11822 aaronmk
	@$(call confirmRmPublicSchema,$*)
41 6933 aaronmk
	echo $(call rmSchemaCmd,$*)|$(psqlNoSearchPath)
42
43 6916 aaronmk
#### public
44
45 11793 aaronmk
schema_exists = $(shell $(psql_verbose) <<<'CREATE TEMP TABLE "$(1)".t ();'\
46
2>&1|grep -F 'cannot create temporary relation in non-temporary schema')
47 6916 aaronmk
48 11793 aaronmk
confirmRmPublicSchema = $(if $(schema_exists),$(call\
49
confirm,WARNING: This will delete the $(1) schema of your VegBIEN DB!,$(2)))
50
51 6919 aaronmk
# Installs a version of the public schema
52 6935 aaronmk
%/install: vegbien.sql _always
53 6982 aaronmk
	echo $(call mkSchemaCmd,$*)\
54 10882 aaronmk
"COMMENT ON SCHEMA \"$*\" IS 'Version: $* ($(date))';"|$(psqlNoSearchPath)
55 10983 aaronmk
	<$< $(if $(filter public,$*),,$(sed) 's/( )public([,; ])/\1"$*"\2/g'|)$(psqlNoSearchPath)
56 6919 aaronmk
57 6922 aaronmk
# Replaces the current public schema with the given version
58 6932 aaronmk
%/publish: _always
59 6928 aaronmk
	@$(call confirmRmPublicSchema,public,To save it: make schemas/rotate)
60 6986 aaronmk
	echo $(call rmSchemaCmd,public)'ALTER SCHEMA "$*" RENAME TO public;'\
61
|$(psqlNoSearchPath) --file - --single-transaction
62 6945 aaronmk
	@echo $(emph)'In your shell, run:'$(endEmph)'unset version'
63 6922 aaronmk
64 6916 aaronmk
rename/%: _always
65
	echo 'ALTER SCHEMA public RENAME TO "$*";'|$(psqlNoSearchPath)
66
	$(MAKE) public/install
67
68 6936 aaronmk
rotate: _always rename/$(version) ;
69 6916 aaronmk
70 8183 aaronmk
#### py_util
71 6916 aaronmk
72 8183 aaronmk
py_util/install: py_util.sql _always
73 6955 aaronmk
	-<$< $(psqlAsAdminVegbien)
74 6916 aaronmk
# ignore errors if schema exists
75
76
#### Others
77
78
# Needed on Ubuntu 12.04 (also other Linuxes?) because %/reinstall is ignored.
79
temp/reinstall: _always temp/uninstall temp/install ;
80
81 785 aaronmk
##### MySQL schema for ERD
82 533 aaronmk
83 809 aaronmk
repl = ../bin/repl
84 541 aaronmk
85 809 aaronmk
%.my.sql: %.sql ../lib/PostgreSQL-MySQL.csv filter_ERD.csv
86
	$(repl) <$(wordlist 1,2,$+)|$(repl) $(word 3,$+) >$@
87 2979 aaronmk
88 6916 aaronmk
##### DDL generation
89 2979 aaronmk
90 6029 aaronmk
pg_dump = env schema= ../bin/pg_dump_vegbien $(1) >$@
91 2979 aaronmk
92
vegbien.sql:
93 7093 aaronmk
	unset version dump_opts; $(call pg_dump,public)
94 2979 aaronmk
95 8183 aaronmk
py_util.sql:
96
	env owners=1 $(call pg_dump,py_util)
97 2979 aaronmk
98
# Must come after %.my.sql so that gets matched first
99
%.sql:
100
	$(call pg_dump,$*)