#!/bin/bash -e

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

func_override import__table_run

import()

{

	echo_func

	before_import_cmds

	import__table_run "$@"

	after_import_cmds

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

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

. "$(dirname "${BASH_SOURCE[0]}")"/../sh/make.sh

if self_not_included; then

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

export schema table

table_make() # usage: [silent=1] table_make target...

# requires Makefile in datasrc dir with `include ../input.Makefile`

# target names are relative to the table subdir itself, not the datasrc dir

{

	make --directory="$(canon_rel_path "$top_dir"/..)" ${silent:+--silent }\

	# "${@/#/$table/}": replaces empty str at beginning of str (/#) with $table/

}

map_table()

{

	echo_func

	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() { echo_func; "$root_dir"/schemas/VegCore/mk_derived; }

remake_VegBIEN_mappings()

{

	echo_func

	public_schema_exists || return 0

	rm header.csv map.csv # remake them

	yes|table_make test

}

postprocess() # overridable

{

	echo_func

	local file="$top_dir"/postprocess.sql

load_data()

	verbosity_min=3 table_make ${remake:+re}install # just the table

}

import()

{

	echo_func

	load_data

	map_table

}