Shell script to extract details from DATABASE URL

heroku-database-url-to-config.sh

  # Sample DATABASE_URL = dbms://username:password@hostname:port/dbname

  DB_PROTOCOL=$(echo $DATABASE_URL | cut -d':' -f1)
  DB_DETAILS=$(echo $DATABASE_URL | cut -d'/' -f3)
  DB_NAME=$(echo $DATABASE_URL | cut -d'/' -f4)
  HOST_NAME=$(echo $DB_DETAILS | cut -d'@' -f2 | cut -d':' -f1)
  PORT=$(echo $DB_DETAILS | cut -d'@' -f2 | cut -d':' -f2)
  USER_NAME=$(echo $DB_DETAILS | cut -d'@' -f1 | cut -d':' -f1)
  PASSWORD=$(echo $DB_DETAILS | cut -d'@' -f1 | cut -d':' -f2)