| 1 |
10891
|
aaronmk
|
#!/bin/bash -e
|
| 2 |
|
|
. "$(dirname "${BASH_SOURCE[0]}")"/../../lib/runscripts/util.run
|
| 3 |
|
|
.rel ../../lib/sh/db.sh
|
| 4 |
|
|
|
| 5 |
|
|
# exports each BIEN2 country's species list
|
| 6 |
|
|
|
| 7 |
|
|
if self_not_included; then
|
| 8 |
|
|
|
| 9 |
10892
|
aaronmk
|
all() # runtime: 1 min ("0m56.053s")
|
| 10 |
10891
|
aaronmk
|
{
|
| 11 |
12779
|
aaronmk
|
begin_target; deferred_check_target_exists
|
| 12 |
10891
|
aaronmk
|
|
| 13 |
|
|
if ! isset password; then
|
| 14 |
|
|
local_export password; read -rsp 'Enter your MySQL password: ' password
|
| 15 |
|
|
fi
|
| 16 |
|
|
local_export database=bien_web table=country_species
|
| 17 |
|
|
|
| 18 |
|
|
split $'\n' "$(query="SELECT DISTINCT country FROM $table" mysql_export|tail -n +2)"
|
| 19 |
|
|
local countries=("${parts[@]}")
|
| 20 |
|
|
|
| 21 |
|
|
local country; for country in "${countries[@]}"; do
|
| 22 |
|
|
filter="country = '$country'" stdout="$top_dir/$country.tsv" to_file \
|
| 23 |
|
|
mysql_export
|
| 24 |
|
|
done
|
| 25 |
|
|
}
|
| 26 |
|
|
|
| 27 |
|
|
fi
|
