An bash function for opening the project's database in TablePlus config in zshconfig

dbopen.sh

function dbopen() {
  if [ -d '/Applications/TablePlus.app' ]; then
    DRIVER=$(grep -m1 DB_CONNECTION .env | cut -d '=' -f2)
    HOST=$(grep -m1 DB_HOST .env | cut -d '=' -f2)
    USER=$(grep -m1 DB_USERNAME .env | cut -d '=' -f2)
    PASSWORD=$(grep -m1 DB_PASSWORD .env | cut -d '=' -f2)
    DATABASE=$(grep -m1 DB_DATABASE .env | cut -d '=' -f2)

    if [ $DRIVER = "sqlite" ]; then
      open $DATABASE
    else
      open $DRIVER://$USRE:$PASSWORD@$HOST/$DATABASE
    fi
  else
    echo "This command uses TablePlus, are you sure it's installed?"
    echo "Install here: https://tableplus.com/"
  fi
}