Bash functions and scripts

example.sh

#!/usr/bin/env bash
#
# Example script structure.
#

set -o errexit -o pipefail
source "$(dirname "$0")/util"

main() {
  ...
}

main

print_log.sh

print_log() {
  printf "$CYAN%s $GREEN%s: $END%s\\n" "$(date "+%Y-%m-%d %H:%M:%S")" "$PROGRAM_NAME" "$*"
}

run_command.sh

run_command() {
  print_log "run_command: $*"
  # Use short options to `nl` for MacOS compatibility:
  # -s = separator, -ba = number all lines
  if "$@" | nl -s" │ " -ba
  then
    :
  else
    status=$?
    print_log "$1 failed with exit status $status"
    exit $status
  fi
}

run_sql.sh

run_sql() {
  print_log "run_sql: $1"
  PGPASSWORD=$DB_PASSWORD \
  psql --host="$DB_HOST" \
       --username="$DB_USERNAME" \
       "$DB_NAME" \
       --command="$1"
}

run_sql_output() {
  print_log "run_sql_output: $1 -> $2"
  PGPASSWORD=$DB_PASSWORD \
  psql --host="$DB_HOST" \
       --username="$DB_USERNAME" \
       "$DB_NAME" \
       --command="$1" \
       --no-align --field-separator=" " \
       --output="$2"
}

util.sh

PROGRAM_NAME=$(basename "$0")

CYAN='\033[96m'
GREEN='\033[92m'
END='\033[0m'