#!/bin/bash -e

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

import ()

	echo_func

	before_import_cmds

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

	after_import_cmds

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

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

if self_not_included; then

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

mk_esc_name schema

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

mk_esc_name table

export schema table

input_make ()

{

	echo_func

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

}

map_table ()

	echo_func

	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 ()

	echo_func

	"$root_dir"/schemas/VegCore/mk_derived

	echo_func

	echo_run rm header.csv map.csv # remake them

	yes|input_make test

}

	echo_func

	local file="$top_dir"/postprocess.sql

	echo_func

	map_table

}