##### 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 := ../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;'

##### General targets

all:

.SUFFIXES: # turn off built-in suffix rules

.SECONDARY: # don't automatically delete intermediate files

.DELETE_ON_ERROR: # delete target if recipe fails

_always:

.PHONY: _always

##### Backups

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

%.sql: %

	$(restore) $< >$@

# 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) $* >$@

%.backup:

	$(backup*)

%.sql:

	env plain=1 $(backup*)

%.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)!)

%.backup/remove: %.backup _always

	@$(call confirmRm,$*)

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

%.backup/rm_indexes: %.backup _always

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

#### Full DB

vegbien.backup:

	$(backup) all >$@