##### Configuration

src_server ?= jupiter

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

root := $(selfDir_NzrNZp)..

include $(root)/lib/common.Makefile

##### Vars/functions

# Make

SHELL := /bin/bash

# OS

os := $(shell uname)

isMac := $(filter Darwin,$(os))

# System

dateFmt := %Y-%m-%d-%H-%M-%S

mtime = $(shell $(if $(isMac),stat -f %Sm -t "$(dateFmt)" $(1),date\

--reference=$(1) +"$(dateFmt)"))

# Terminal

esc := '['

reset := $(esc)'0m'

emph := $(esc)'7m '

endEmph := ' '$(reset)

# User interaction

confirm = $(if $(shell read -p $(emph)"$(1)"$(endEmph)$$'$(if\

$(2),\n$(2))\nContinue? (y/n) ' REPLY; test "$$REPLY" = y && echo t),,\

$(error Aborting))

# Paths

bin := $(root)/bin

# DB

psqlVerbose := $(bin)/psql_script_vegbien --echo-all

pg_dump := $(bin)/pg_dump_vegbien

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

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

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

# pg_restore doesn't support PGDATABASE env var

rmSchema = 'DROP SCHEMA IF EXISTS "$(1)" CASCADE;'

##### Backups

backups := $(wildcard *.backup)

#### Checksums

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

%.md5: %

	nice -n +5 md5sum $<|cut -d ' ' -f 1 >$@

%.md5/test: %.md5 % _always

	echo '$(shell cat $<)  $*'|nice -n +5 md5sum -$(if $(isMac),v)c /dev/stdin

#### 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

%.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 $<

%.backup/rotate: %.backup _always

	mv $< $*.$(call mtime,$<).backup

#### Archived imports

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

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

%.backup/remove: %.backup _always

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

	echo $(call rmSchema,$(public*))|$(bin)/psql_script_vegbien

%.backup/rm_indexes: %.backup _always

	$(pg_dump) $*|$(bin)/mk_rm_indexes|$(psqlVerbose)

##### Synchronization

remote := $(src_user)@$(src_server):/data/dev/aaronmk/VegBIEN.backups/

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

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

upload: _always

	$(rsyncBackups) $(local) $(remote)

download: _always

	$(rsyncBackups) $(remote) $(local)