BirdNET-stream/.ideas/fill_taxa.sh

70 lines
1.6 KiB
Bash
Raw Permalink Normal View History

2022-08-12 18:01:01 +02:00
#! /usr/bin/env bash
set -e
# Load config file
2022-08-21 06:13:15 +02:00
config_filepath="./config/birdnet.conf"
2022-08-12 18:01:01 +02:00
if [ -f "$config_filepath" ]; then
source "$config_filepath"
else
echo "Config file not found: $config_filepath"
exit 1
fi
# Check if database location is specified
if [ -z "$DATABASE" ]; then
echo "DATABASE location not specified"
echo "Defaults to ./var/db.sqlite"
DATABASE="./var/db.sqlite"
fi
# Check if species list is specified
if [ -z "$SPECIES_LIST" ]; then
echo "SPECIES_LIST location not specified"
exit 1
fi
function insert_taxa()
{
for taxon in "$(cat $SPECIES_LIST)"; do
taxon_scientific_name=$(echo $taxon | cut -d'_' -f1)
taxon_common_name=$(echo $taxon | cut -d'_' -f2)
if $(taxon_exists $taxon_scientific_name); then
echo "Taxon already exists: $taxon_scientific_name"
else
echo "Inserting taxon: $taxon_scientific_name"
statement="INSERT INTO taxon (scientific_name, common_name) VALUES ('$taxon_scientific_name', '$taxon_common_name')"
echo $statement
result=$(sqlite3 "$DATABASE" "$statement")
echo "$result"
fi
done
}
function taxon_exists()
{
taxon_scientific_name="$1"
statement="SELECT scientific_name FROM taxon WHERE scientific_name='$taxon_scientific_name'"
result=$(sqlite3 "$DATABASE" "$statement")
if [ -z "$result" ]; then
return 1
else
return 0
fi
}
function purge_taxa()
{
statement="DELETE FROM taxon"
result=$(sqlite3 "$DATABASE" "$statement")
echo "$result"
}
function main()
{
purge_taxa
insert_taxa
}
main