. "$(dirname "${BASH_SOURCE[0]}")"/../../lib/runscripts/table.run

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

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

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

. "$(dirname "${BASH_SOURCE[0]}")"/../../lib/runscripts/util.run

#!/bin/bash -e

# runscripts: a bash-based replacement for make

# unlike make, supports full bash functionality including multiline commands

# usage: path/to/dir/run cmd args

if false; then #### run script template:

#!/bin/bash -e

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

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

cmd ()

{

	echo_func "$@"

	"$(dirname "${BASH_SOURCE[0]}")"/path_relative_to_self

	"$(dirname "${BASH_SOURCE[1]}")"/path_relative_to_caller

	"$top_dir"/path_relative_to_outermost_script

}

fi ####

: "${verbosity=2}"

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

if self_not_included; then

# users can override this function to perform other commands (or no commands)

# after the script is read

on_exit () { run_args_cmd; }

trap on_exit EXIT

fi

#!/bin/bash -e

if false; then #### run script template:

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

}

fi ####

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

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

if self_not_included; then

quote='"'

esc_name () { echo "$quote${1//$quote/$quote$quote}$quote"; }

mk_esc_name () { set_var "$1"_esc "$(esc_name "${!1}")"; }

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

mk_esc_name schema

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

mk_esc_name table

export schema table

mysql ()

{

	echo_func "$@"

	echo_run "$bin_dir"/mysql_bien --database="$schema" --verbose "$@"

}

mysql_ANSI ()

{

	echo_func "$@"

	(echo "SET sql_mode = 'ANSI';"; cat)|mysql "$@"

}

psql () # usage: ([file=...] [dir=...]; self)

{

	echo_func "$@"

	local dir="$dir"

	if test -n "$file"; then

		set -- --file "$file" "$@"

		: "${dir:=$(dirname "$file")}"

	fi

	: "${dir:=$top_dir}"

	(cat <<EOF

\cd $dir

\set schema "$schema"

\set table "$table"

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

SET search_path TO "$schema", util;

EOF

	cat)|

	echo_run env no_search_path=1 "$bin_dir"/psql_verbose_vegbien "$@"

}

input_make ()

{

	echo_func "$@"

	echo_run 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

}

remake_VegBIEN_mappings ()

{

	echo_func "$@"

	echo_run rm header.csv map.csv # remake them

	yes|input_make test

}

postprocess () # overridable

{

	echo_func "$@"

	local file="$top_dir"/postprocess.sql

	if test -e "$file"; then psql "$@"; fi

}

import ()

{

	echo_func "$@"

	map_table

	postprocess

	mk_derived

}

fi

#!/bin/bash -e

if false; then #### run script template:

#!/bin/bash -e

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

import ()

{

	echo_func "$@"

	import_cmds

}

fi ####

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

if self_not_included; then

import ()

{

	echo_func "$@"

}

all ()

{

	echo_func "$@"

	import

}

fi

#!/bin/bash -e

# links to locally-available resources

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

if self_not_included; then

root_dir="$(dirname "${BASH_SOURCE[0]}")"/../..

bin_dir="$root_dir"/bin

export PATH="$bin_dir:$PATH"

fi

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