#!/bin/bash

set -o errexit

if false; then #### run script template:

#!/bin/bash

set -o errexit

. "$(dirname "${BASH_SOURCE[0]}")"/path/to/table.run

import ()

{

	before_import_cmds

	echo_cmd "$(dirname "${BASH_SOURCE[0]}")"/path/to/table.run import

	after_import_cmds

}

run_cmd "$@"

fi ####

. "$(dirname "${BASH_SOURCE[0]}")"/util.run

root_dir="$(dirname "${BASH_SOURCE[0]}")"/..

bin_dir="$root_dir"/bin

: "${schema="$(cd "$top_dir"/..; basename "$PWD")"}"

: "${table="$( cd "$top_dir"   ; basename "$PWD")"}"

export schema table

psql () # usage: ([file=...] [dir=...]; self)

{

	local dir="$dir"

	if test -n "$file"; then

		set -- --file "$file" "$@"

		: "${dir:=$(dirname "$file")}"

	fi

	: "${dir:=$top_dir}"

	(cat <<EOF

\cd $dir

\set schema "$schema"

\set table "$table"

\set table_str '''"$table"'''

SET search_path TO "$schema", util;

EOF

	cat)|

	echo_cmd env no_search_path=1 "$bin_dir"/psql_verbose_vegbien "$@"

}

input_make ()

{

	echo_cmd env make --directory="$top_dir"/.. "${@/#/$table/}"

}

map_table ()

{

	input_make map.csv

	psql <<EOF

SELECT util.reset_map_table('pg_temp.map');

\copy pg_temp.map FROM 'map.csv' CSV HEADER;

SELECT util.set_col_names('"$table"', 'pg_temp.map'::regclass);

EOF

}

mk_derived () { "$root_dir"/schemas/VegCore/mk_derived; }

remake_VegBIEN_mappings ()

{

	echo_cmd rm header.csv map.csv # remake them

	yes|input_make test

}

postprocess () # overridable

{

	local file="$top_dir"/postprocess.sql

	if test -e "$file"; then psql "$@"; fi

}

import ()

{

	echo_cmd map_table

	echo_cmd postprocess

	echo_cmd mk_derived

}

run_cmd "$@"