Azure Databases: RIS Compute RDC function

• Simple test to validate postgres pgpass file.
• These functions can also be found at ris-compute-rdc-functions repo.

    test_pgpass <path to pgpass file>

• Provides a execution plan for running sql against the rdc postgres databases.

run_job <connection index> <path to sql script> <devops ticket #> <ignore errors(1 to enable)>

• Dumps the relative environment variables for processing RDC tasks

show_rdc_env

• Tests a log file for Errors, Warning and other artifacts that may be logged while processing sql scripts.

log_test <path to log file>

• Safely lists postgres connection available in .pgpass file set with $PGPASSFILE environment variable.

list_connections

• Sets the psql environment variables to run sql script tasks.

set_connection <index value from list_connections>