Skip to content

Instantly share code, notes, and snippets.

@erikgaal
Created September 17, 2020 20:51
Show Gist options
  • Save erikgaal/3793d90aa454c5a1286082aea87195ca to your computer and use it in GitHub Desktop.
Save erikgaal/3793d90aa454c5a1286082aea87195ca to your computer and use it in GitHub Desktop.
opendb () {
[ ! -f .env ] && { echo "No .env file found."; return 1; }
DB_CONNECTION=$(grep DB_CONNECTION .env | grep -v -e '^\s*#' | cut -d '=' -f 2-)
DB_HOST=$(grep DB_HOST .env | grep -v -e '^\s*#' | cut -d '=' -f 2-)
DB_PORT=$(grep DB_PORT .env | grep -v -e '^\s*#' | cut -d '=' -f 2-)
DB_DATABASE=$(grep DB_DATABASE .env | grep -v -e '^\s*#' | cut -d '=' -f 2-)
DB_USERNAME=$(grep DB_USERNAME .env | grep -v -e '^\s*#' | cut -d '=' -f 2-)
DB_PASSWORD=$(grep DB_PASSWORD .env | grep -v -e '^\s*#' | cut -d '=' -f 2-)
if [ $DB_CONNECTION = 'pgsql' ]; then
DB_CONNECTION='postgres'
fi
if [ -z $DB_PASSWORD ]; then
DB_URL="${DB_CONNECTION}://${DB_USERNAME}@${DB_HOST}:${DB_PORT}/${DB_DATABASE}"
else
DB_URL="${DB_CONNECTION}://${DB_USERNAME}:${DB_PASSWORD}@${DB_HOST}:${DB_PORT}/${DB_DATABASE}"
fi
echo "Opening ${DB_URL}"
open $DB_URL
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment