selfDir_AkFFYJ := $(dir $(lastword $(MAKEFILE_LIST)))

root := $(selfDir_AkFFYJ)..

include $(root)/lib/common.Makefile

##### Vars/functions

# Make

SHELL := /bin/bash

##### General targets

all = vegbien.sql vegbien.my.sql functions.sql py_functions.sql

all: _always $(all) ;

clean: _always

	$(RM) $(all)

%/reinstall: _always %/uninstall %/install ;

##### Installation

schemas := temp functions py_functions

install: $(schemas:%=%/install) ;

schemasReversed := py_functions functions temp

uninstall: $(schemasReversed:%=%/uninstall) ;

psqlOpts := --set ON_ERROR_STOP=1 --quiet

asAdmin := sudo -E -u postgres

psqlAsAdmin := $(asAdmin) psql $(psqlOpts)

    # -E preserves env vars so PGOPTIONS is passed to psql

psqlAsAdminVegbien := $(psqlAsAdmin) vegbien

psqlNoSearchPath := env no_search_path=1 ../bin/psql_script_vegbien

# Must come before `%/install: vegbien.sql` to override it

%/install: %.sql _always

	-<$< $(psqlNoSearchPath)

# ignore errors if schema exists

%/uninstall: _always

	@$(if $(filter public% r%,$*),$(call confirmRmPublicSchema,$*))

	echo $(call rmSchemaCmd,$*)|$(psqlNoSearchPath)

#### public

confirmRmPublicSchema = $(call confirm,WARNING: This will delete the $(1)\

schema of your VegBIEN DB!,$(2))

# Installs a version of the public schema

%/install: vegbien.sql _always

	echo $(call mkSchemaCmd,$*)\

"COMMENT ON SCHEMA $* IS 'Version: $* ($(date))';"|$(psqlNoSearchPath)

	<$< $(sed) 's/( )public([,; ])/\1$*\2/g'|$(psqlNoSearchPath)

# Replaces the current public schema with the given version

%/publish: _always

	@$(call confirmRmPublicSchema,public,To save it: make schemas/rotate)

	echo $(call rmSchemaCmd,public)'ALTER SCHEMA "$*" RENAME TO public;'\

|$(psqlNoSearchPath) --file - --single-transaction

	@echo $(emph)'In your shell, run:'$(endEmph)'unset version'

rename/%: _always

	echo 'ALTER SCHEMA public RENAME TO "$*";'|$(psqlNoSearchPath)

	$(MAKE) public/install

rotate: _always rename/$(version) ;

#### py_functions

py_functions/install: py_functions.sql _always

	-<$< $(psqlAsAdminVegbien)

# ignore errors if schema exists

#### Others

# Needed on Ubuntu 12.04 (also other Linuxes?) because %/reinstall is ignored.

temp/reinstall: _always temp/uninstall temp/install ;

##### MySQL schema for ERD

repl = ../bin/repl

%.my.sql: %.sql ../lib/PostgreSQL-MySQL.csv filter_ERD.csv

	$(repl) <$(wordlist 1,2,$+)|$(repl) $(word 3,$+) >$@

##### DDL generation

pg_dump = env schema= ../bin/pg_dump_vegbien $(1) >$@

vegbien.sql:

	unset version; $(call pg_dump,public)

py_functions.sql:

	env owners=1 $(call pg_dump,py_functions)

# Must come after %.my.sql so that gets matched first

%.sql:

	$(call pg_dump,$*)