reinit.sh

#!/bin/bash
# HEALTH=1 (regenerate projects health metric)
# TSDB_DROP=1 - drop TSDB tables before reinitializing data (new approach handles that per-metric via `drop:` property
if [ -z "$PG_PASS" ]
then
  echo "$0: you need to set PG_PASS env variable to use this script"
  exit 1
fi
function finish {
    sync_unlock.sh
}
if [ -z "$TRAP" ]
then
  sync_lock.sh || exit -1
  trap finish EXIT
  export TRAP=1
fi

if [ ! -z "$SKIPTEMP" ]
then
  if [ ! -z "$TSDB_DROP" ]
  then
    ./devel/drop_ts_tables.sh allcdf || exit 2
  fi
  ./devel/db.sh psql allcdf -c "delete from gha_vars" || exit 3
  ./devel/db.sh psql allcdf -c "delete from gha_computed" || exit 4
  GHA2DB_PROJECT=allcdf PG_DB=allcdf GHA2DB_LOCAL=1 vars || exit 5
  GHA2DB_ENABLE_METRICS_DROP=1 GHA2DB_SKIP_METRICS="projects_health" GHA2DB_EXCLUDE_VARS="projects_health_partial_html" GHA2DB_PROJECT=allcdf PG_DB=allcdf GHA2DB_CMDDEBUG=1 GHA2DB_RESETTSDB=1 GHA2DB_LOCAL=1 GHA2DB_SKIP_VARS=1 gha2db_sync || exit 6
  if [ ! -z "$HEALTH" ]
  then
    TEST_SERVER=1 LIST_FN_PREFIX="./cdf/all_" GHA2DB_PROJECTS_YAML="cdf/projects.yaml" ./devel/add_all_annotations.sh || exit 7
    GHA2DB_ENABLE_METRICS_DROP=1 GHA2DB_PROJECTS_YAML="cdf/projects.yaml" GHA2DB_PROJECT=allcdf PG_DB=allcdf GHA2DB_LOCAL=1 GHA2DB_CMDDEBUG=1 GHA2DB_GHAPISKIP=1 GHA2DB_GETREPOSSKIP=1 GHA2DB_SKIPPDB=1 GHA2DB_RESETTSDB=1 GHA2DB_METRICS_YAML=metrics/all/health.yaml GHA2DB_TAGS_YAML=metrics/shared/empty.yaml GHA2DB_COLUMNS_YAML=metrics/shared/empty.yaml gha2db_sync || exit 8
    GHA2DB_PROJECTS_YAML="cdf/projects.yaml" GHA2DB_PROJECT=allcdf PG_DB=allcdf GHA2DB_LOCAL=1 GHA2DB_VARS_FN_YAML="sync_vars.yaml" vars || exit 9
  fi
else
  ./devel/db.sh pg_dump -Fc allcdf -f /tmp/allcdf_temp.dump || exit 10
  mv /tmp/allcdf_temp.dump . || exit 11
  ./devel/restore_db.sh allcdf_temp || exit 12
  if [ ! -z "$TSDB_DROP" ]
  then
    ./devel/drop_ts_tables.sh allcdf_temp || exit 13
  fi
  ./devel/db.sh psql allcdf_temp -c "delete from gha_vars" || exit 14
  ./devel/db.sh psql allcdf_temp -c "delete from gha_computed" || exit 15
  GHA2DB_PROJECT=all PG_DB=allcdf_temp GHA2DB_LOCAL=1 vars || exit 16
  GHA2DB_ENABLE_METRICS_DROP=1 GHA2DB_SKIP_METRICS="projects_health" GHA2DB_EXCLUDE_VARS="projects_health_partial_html" GHA2DB_PROJECT=all PG_DB=allcdf_temp GHA2DB_CMDDEBUG=1 GHA2DB_RESETTSDB=1 GHA2DB_LOCAL=1 GHA2DB_SKIP_VARS=1 gha2db_sync || exit 17
  # HEALTH=1 unsupported in temp database mode
  ./devel/drop_psql_db.sh allcdf || exit 18
  ./devel/db.sh psql postgres -c "select pg_terminate_backend(pid) from pg_stat_activity where datname = 'allcdf_temp'" || exit 19
  ./devel/db.sh psql postgres -c "alter database \"allcdf_temp\" rename to \"allcdf\"" || exit 20
  rm -f allcdf_temp.dump || exit 21
fi