Wrapper to open ".env" files with MyCLI or PgCLI. Search in parent directories.

opener_for_pgcli_mycli.sh

#!/bin/bash

function dbe() {
    local slashes=${PWD//[^\/]/}
    local directory="$PWD"
    for (( n=${#slashes}; n>0; --n ))
    do
        if [ -f "$directory/.env" ]; then
            echo -e "Load file:\\033[0;31m$(readlink -f -- "$directory/.env") \\033[0m"
            while read p; do
                if [ -n "$p" ]; then
                    eval "local $p"
                fi
            done <"$directory/.env"
            if [ $DB_CONNECTION="mysql" ]; then
                mycli $DB_DATABASE -h $DB_HOST -u $DB_USERNAME -p$DB_PASSWORD
            else
                pgcli $DB_DATABASE -h $DB_HOST -u $DB_USERNAME -p$DB_PASSWORD
            fi
            return
        fi
        directory="$directory/.." 
    done
    echo ".env file not found."
}