| 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 |
2978
|
aaronmk
|
all = vegbien.sql vegbien.my.sql functions.sql py_functions.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 |
6952
|
aaronmk
|
schemas := temp functions py_functions
|
| 25 |
6916
|
aaronmk
|
install: $(schemas:%=%/install) ;
|
| 26 |
|
|
|
| 27 |
6952
|
aaronmk
|
schemasReversed := py_functions functions temp
|
| 28 |
6916
|
aaronmk
|
uninstall: $(schemasReversed:%=%/uninstall) ;
|
| 29 |
|
|
|
| 30 |
|
|
psqlOpts := --set ON_ERROR_STOP=1 --quiet
|
| 31 |
|
|
asAdmin := sudo -E -u postgres
|
| 32 |
|
|
psqlAsAdmin := $(asAdmin) psql $(psqlOpts)
|
| 33 |
|
|
# -E preserves env vars so PGOPTIONS is passed to psql
|
| 34 |
|
|
psqlAsAdminVegbien := $(psqlAsAdmin) vegbien
|
| 35 |
|
|
psqlNoSearchPath := env no_search_path=1 ../bin/psql_script_vegbien
|
| 36 |
|
|
|
| 37 |
6935
|
aaronmk
|
# Must come before `%/install: vegbien.sql` to override it
|
| 38 |
|
|
%/install: %.sql _always
|
| 39 |
|
|
-<$< $(psqlNoSearchPath)
|
| 40 |
|
|
# ignore errors if schema exists
|
| 41 |
|
|
|
| 42 |
6933
|
aaronmk
|
%/uninstall: _always
|
| 43 |
|
|
@$(if $(filter public% r%,$*),$(call confirmRmPublicSchema,$*))
|
| 44 |
|
|
echo $(call rmSchemaCmd,$*)|$(psqlNoSearchPath)
|
| 45 |
|
|
|
| 46 |
6916
|
aaronmk
|
#### public
|
| 47 |
|
|
|
| 48 |
6928
|
aaronmk
|
confirmRmPublicSchema = $(call confirm,WARNING: This will delete the $(1)\
|
| 49 |
|
|
schema of your VegBIEN DB!,$(2))
|
| 50 |
6916
|
aaronmk
|
|
| 51 |
6919
|
aaronmk
|
# Installs a version of the public schema
|
| 52 |
6935
|
aaronmk
|
%/install: vegbien.sql _always
|
| 53 |
6982
|
aaronmk
|
echo $(call mkSchemaCmd,$*)\
|
| 54 |
|
|
"COMMENT ON SCHEMA $* IS 'Version: $* ($(date))';"|$(psqlNoSearchPath)
|
| 55 |
|
|
<$< $(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 |
|
|
#### py_functions
|
| 71 |
|
|
|
| 72 |
|
|
py_functions/install: py_functions.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 |
7092
|
aaronmk
|
unset version; $(call pg_dump,public)
|
| 94 |
2979
|
aaronmk
|
|
| 95 |
|
|
py_functions.sql:
|
| 96 |
|
|
env owners=1 $(call pg_dump,py_functions)
|
| 97 |
|
|
|
| 98 |
|
|
# Must come after %.my.sql so that gets matched first
|
| 99 |
|
|
%.sql:
|
| 100 |
|
|
$(call pg_dump,$*)
|
