#!/bin/bash -e

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

.rel ../../lib/sh/db.sh

# exports each BIEN2 country's species list

if self_not_included; then

all()

{

	echo_func; set_make_vars; deferred_check_target_exists

	if ! isset password; then

		local_export password; read -rsp 'Enter your MySQL password: ' password

	fi

	local_export database=bien_web table=country_species

	split $'\n' "$(query="SELECT DISTINCT country FROM $table" mysql_export|tail -n +2)"

	local countries=("${parts[@]}")

	local country; for country in "${countries[@]}"; do

		filter="country = '$country'" stdout="$top_dir/$country.tsv" to_file \

		mysql_export

	done

}

fi