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

fi

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

bin_dir="$import_sh_dir"/../bin

table="$(basename "$PWD")"

schema="$(cd ..; basename "$PWD")"

psql ()

{

	(echo "SET search_path TO \"$schema\", functions;"; cat)|

	env no_search_path=1 "$bin_dir"/psql_verbose_vegbien

}

map_table ()

{

	make --directory=.. --makefile=../input.Makefile "$table"/map.csv

	(psql <<EOF

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

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

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

EOF

	)

}