Save database functions

database.sh

# vi: syntax=sh

backupDatabase() {
  local db=$1
  if [ -z $db ]; then
    echo "You must pass a database name"
    return 1
  fi

  if [ ! -z $2 ]; then
    pg_dump -U postgres -f "${TOAST}/db/${db}"-$(date +"%Y-%m-%dT%H:%M:%SZ")-"${2}".dump "${db}"
  else
    pg_dump -U postgres -f "${TOAST}/db/${db}"-$(date +"%Y-%m-%dT%H:%M:%SZ").dump "${db}"
  fi
}

backupToastDev() {
  if [ ! -z $1 ]; then
    backupDatabase toast_dev
  else
    backupDatabase toast_dev "${1}"
  fi
}

restoreDatabase() {
  local db=$1
  local file=$2
  if [ -z $db ]; then
    echo "You must pass a database name"
    return 1
  fi

  if [ -z $file ] || [ ! -f "${file}" ]; then
    echo "You must pass a valid file name."
    return 1
  fi

  dropdb -U postgres "${db}"; createdb -U postgres -O toast "${db}"
  psql -U postgres "${db}" <  "${file}"
}

restoreToastDev() {
  restoreDatabase toast_dev "${1}"
}