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

##### Installation

schemas := temp functions py_functions public

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

schemasReversed := public 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

#### public

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

public schema of your VegBIEN DB!,To save it: make schemas/rotate)

rmPublicSchema := $(call rmSchemaCmd,public)

public/install: vegbien.sql _always

	-echo $(call mkSchemaCmd,public)|$(psqlNoSearchPath)

	<$< $(psqlNoSearchPath)

# ignore errors if schema exists

# public schema will be owned by bien

# don't include public in the search_path

public/uninstall: _always

	@$(confirmRmPublicSchema)

	echo $(rmPublicSchema)|$(psqlNoSearchPath)

rename/%: _always

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

	$(MAKE) public/install

rotate: _always rename/public.$(version) ;

#### py_functions

py_functions/install: py_functions.sql _always

	-<$< env public= $(psqlAsAdminVegbien)

# ignore errors if schema exists

#### Others

%/install: %.sql _always

	-<$< $(psqlNoSearchPath)

# ignore errors if schema exists

%/uninstall: _always

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

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

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

##### DDL generation