sync_wca_database.sh

#!/usr/bin/env sh

dir="$(dirname "$0")"
data_dir="$dir/data"
dump_dir="$data_dir/extracted"

echo "Downloading WCA Database"
curl https://www.worldcubeassociation.org/results/misc/WCA_export.tsv.zip -o "$data_dir/WCA_export.tsv.zip"

if [ -e "$dump_dir/metadata.json" ]
then
    mv "$dump_dir/metadata.json" "$dump_dir/previous_metadata.json"
fi

echo "Unzipping archive"
unzip -o "$data_dir/WCA_export.tsv.zip" -d "$dump_dir"

echo "Importing WCA data"
python "$dir/manage.py" import_wca_data