#!/bin/bash -e

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

func_override import__table_run

import()

{

	echo_func

	before_import_cmds

	self_make import__table_run "$@"

	after_import_cmds

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

.rel subdir.run

if self_not_included; then

: "${table=$subdir}"; export table

install_log_rel=logs/install.log.sql

table_make_install()

	echo_func; local install_log="${install_log-$top_dir/$install_log_rel}"

	local verbosity_min= # install logs require default verbosity

datasrc_make_install()

map_table()

{

	echo_func; set_make_vars

	table_make map.csv

	psql <<EOF

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

ALTER TABLE pg_temp.map DISABLE TRIGGER map_filter_insert;

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

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

EOF

mk_derived()

remake_VegBIEN_mappings()

{

	echo_func; set_make_vars

	public_schema_exists || return 0

	if remaking; then in_top_dir rm header.csv map.csv; fi # remake them

	piped_cmd yes|table_make test

}

postprocess() # overridable

{

	echo_func; set_make_vars

	local file="$top_dir"/postprocess.sql

load_data()

{

	echo_func; set_make_vars

	datasrc_make_install schema

	table_make_install ${_remake:+re}install # just the table

}

import()

{

	echo_func; set_make_vars

	self_make load_data

	map_table

	remake_VegBIEN_mappings

	mk_derived

}