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

root := $(selfDir_NzrNZp)..

include $(root)/lib/common.Makefile

##### Vars/functions

# Make

SHELL := /bin/bash

# Paths

bin := $(root)/bin

# DB

psqlNoSearchPath := env no_search_path=1 $(bin)/psql_script_vegbien

pg_dump := $(bin)/pg_dump_vegbien

backup := "time" env data=1 $(pg_dump)

restore := "time" $(bin)/postgres_vegbien pg_restore --exit-on-error --verbose

restoreBien := $(restore) --dbname=vegbien

# pg_restore doesn't support PGDATABASE env var

##### Backups

backups := $(wildcard *.backup)

#### Checksums

md5s: _always $(backups:%=%.md5) ;

#### SQL

# Must come before %.sql with no prerequisites to be matched first

%.sql: %

	$(restore) $< >$@

# Full DB

# Must come before %.backup to be matched first

vegbien.%.backup:

	$(backup) all >$@

	$(MAKE) $@.md5

backup* = $(backup) $* >$@

# Note: This can't be used for the current (unrotated) public schema because

# pg_dump doesn't back up the CREATE SCHEMA statement for it, assuming falsely

# that public already exists because it's in template1.

%.backup:

	$(backup*)

	$(MAKE) $@.md5

# When testing, turn off %.sql so make won't skip `%.sql: %` in favor of it

ifeq ($(filter %.backup/test,$(MAKECMDGOALS)),)

%.sql:

	env plain=1 $(backup*)

endif

# runtime: 11 h ("10:50:23elapsed"); ~5 h to insert data

%.backup/restore: %.backup _always

	$(restoreBien) $<

%.sql/restore: %.sql _always

	$(bin)/psql_script_vegbien <$<

# pg_restore only supports "non-plain-text formats"

# (http://www.postgresql.org/docs/9.1/static/app-pgrestore.html)

%.backup/test: %.backup.sql _always

	rm $<

#### Archived imports

confirmRm = $(call confirm,WARNING: This will delete the archived import $(1)!)

public* = $(*:vegbien.%=%)

%.backup/remove: %.backup _always

	@$(call confirmRm,$(public*))

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

##### Synchronization

rsyncBackups := $(rsync) --include="/*.backup" --include="/*.sql"\

--include="/*.csv" --include="/*.md5" --exclude="**"

upload: _always

	$(bin)/sync_upload './**'

%/download: _always

	-$(if $(filter %.md5,$*),,$(MAKE) $*.md5/download)

	$(rsync) $(remote)$* $(local)$*

# ignore errors if $*.md5 does not exist