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

root := $(selfDir_AkFFYJ)..

include $(root)/lib/common.Makefile

##### Vars/functions

# Make

SHELL := /bin/bash

##### General targets

all = public_.sql vegbien.sql vegbien.my.sql util.sql py_util.sql

all: _always $(all) ;

clean: _always

	$(RM) $(all)

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

##### Installation

schemas := temp util py_util

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

schemasReversed := py_util util temp

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

psqlAsAdminVegbien := $(psqlAsAdmin) vegbien

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

psql_verbose := env no_search_path=1 ../bin/psql_verbose_vegbien

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

%/install: %.sql _always

	-<$< $(psqlNoSearchPath)

# ignore errors if schema exists

# must come before `%/uninstall: vegbien.sql` to override it

%/uninstall: %.sql _always

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

#### public

schema_exists = $(shell $(psql_verbose) <<<'CREATE TEMP TABLE "$(1)".t ();'\

2>&1|grep -F 'cannot create temporary relation in non-temporary schema')

confirmRmPublicSchema = $(if $(schema_exists),$(call\

confirm,WARNING: This will delete the $(1) schema of your VegBIEN DB!,$(2)))

*q = $(if $(filter public,$*),,")

# Installs a version of the public schema

# usage: make schemas/public/reinstall

#        make schemas/r#/reinstall

%/install: public_.sql _always

	echo $(call mkSchemaCmd,$*)\

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

	# create a custom *_validation schema for *each* public schema, rather than

	# one for the most recently-created public schema. this allows validations

	# to continue to be run against a previous version of the DB while a new

	# version is being imported.

	<$< $(sed) -e \

's/([ (]|::)public(_[[:alnum:]_]+)?([.,;]| [^[:lower:]])/\1$(*q)$*\2$(*q)\3/g'\

|$(psqlNoSearchPath) # [[:alnum:]_]+, not ...*, because public_ is a username

%/uninstall: public_.sql _always

	$(call confirmRmPublicSchema,$*)

	# don't use public.rm(), because when the public schema is incompletely

	# imported, this function will not yet exist

	$(psqlNoSearchPath) <<<"SELECT util.schema_bundle_rm('$*');"

# Replaces the current public schema with the given version

# usage: make schemas/r#/publish

# **IMPORTANT**: you should not publish a schema until you are satisfied that it

# can replace the previous public schema, so that the previous public schema

# doesn't need to be saved.

%/publish: _always

	@$(call confirmRmPublicSchema,public)

	$(psqlNoSearchPath) <<<'SELECT "$*".publish();'

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

#### py_util

py_util/install: py_util.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) >$@

public_.sql:

	# include schemas that depend on `public` so they are restored along with it

	unset version dump_opts; $(call pg_dump,public --schema='public_*')

vegbien.sql: public_.sql _always

	rm=1 ../inputs/.TNRS/schema.sql.run # its contents change along with this

	(cat public_.sql; schema=1 ../bin/pg_dump_vegbien all --schema='geoscrub' \

--schema='"TNRS"' --exclude-table='*."~"*' --exclude-table='*.*\y"Source"\y*') \

>$@

# `all`: prevents auto-adding a --schema entry

# exclude the same set of Source tables excluded by inputs/.TNRS/schema.sql, so

# that reinstalling TNRS doesn't change the contents of this file

py_util.sql:

	env owners=1 $(call pg_dump,py_util)

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

%.sql:

	$(call pg_dump,$*)