update-test-lists-source.sh

#!/usr/bin/env bash

TEST_LISTS_STRINGS_SHEET='https://docs.google.com/spreadsheets/d/e/2PACX-1vReAV7XGkpvDnDiVBUSzIcElD5snEjHlpiVaoNfRbx-Km9quA1TfSh2wx-H-7AIuL0GyQ_NFDsYVGou/pub?gid=0&single=true&output=csv'
CSV_FILE_PATH=test-lists-editor/en/strings.csv
JSON_FILE_PATH=test-lists-editor/en/strings.json

echo -n "Fetching latest source strings from spreadsheet..."

curl -sL $TEST_LISTS_STRINGS_SHEET -o $CSV_FILE_PATH

ret=$?

if [ $ret -ne 0 ]; then
  echo "Failed to download CSV file. Curl failed with error code: $ret"
  exit $ret
fi
echo " done."

echo "Converting from CSV format to KEYVALUEJSON"

python csv-to-json.py --csv $CSV_FILE_PATH --json $JSON_FILE_PATH

ret=$?
if [ $ret -ne 0 ]; then
  echo "Failed to convert CSV file to JSON format: $ret"
  exit $ret
fi

echo "Uploading source strings to Transifex..."

tx push -s -r ooni-test-lists-editor.website

ret=$?

if [ $ret -ne 0 ]; then
  echo "Failed to upload source strings."
  exit $ret
fi

echo "✅ Uploaded source strings to Transifex."