#!/bin/bash

# Usage: (must be run from a table subdir)

if false; then

#!/bin/bash

cd "$(dirname "$0")"

. path/to/import.sh

map_table

psql <<'EOF'

postprocess_commands...

EOF

mk_derived

fi

set -o errexit

import_sh_dir="$(dirname "${BASH_SOURCE[0]}")"

root_dir="$import_sh_dir"/..

bin_dir="$root_dir"/bin

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

: "${table="$(basename "$PWD")"}"

export schema table

psql()

{

	(cat <<EOF

\set schema "$schema"

\set table "$table"

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

SET search_path TO "$schema", util;

EOF

	cat)|

	env no_search_path=1 "$bin_dir"/psql_verbose_vegbien

}

make()

{

	(set -x; env make --directory=.. --makefile=../input.Makefile \

"${@/#/$table/}")

}

map_table()

{

	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; }

public_schema_exists()

{ "$bin_dir"/psql_script_vegbien </dev/null 2>/dev/null; }

remake_VegBIEN_mappings()

{

	public_schema_exists || return 0

	rm header.csv map.csv # remake them

	yes|make test

}