.aliases-base

# 📖 WP CLI Auto Completion
autoload bashcompinit
bashcompinit
source ~/wp-completion.bash

# 🏷️ System Paths
export PATH="$PATH:$HOME/.composer/vendor/bin"
export PATH="$PATH:$HOME/.config/composer/vendor/bin"

# ZSH Customization
prompt_context() {}
prompt_dir() {
  prompt_segment blue black '%c'
}

# 📌 Helpers
alias reload_alias="source ~/.zshrc"
alias edit_zsh="code ~/.zshrc"
alias edit_alias="code ~/.aliases"
alias edit_hosts="code /etc/hosts"

# 🚢 Docker
alias docker_up="docker-compose up -d"
alias docker_stop="docker-compose stop"
alias docker_down="docker-compose down -v"
docker_stop_all() { docker stop $(docker ps -a -q) 1 }

# 🔄 Git - Sync Fork With Upstream
git_sync_fork() {
    echo "\n🎤 You are in ..."
    pwd

    echo "\n👉 Fetching Upstream ...\n"
    git fetch upstream

    echo "\n👉 Switching to origin master branch ...\n"
    git checkout master

    echo "\n👉 Merging upstream master into fork ...\n"
    git merge upstream/master

    echo "\n🎉 Fork updated.\n"
}

#Git Empty branch
# @param branchname
git_empty_branch() {
    echo "\n🎤 You are in ..."
    pwd

    echo "\n👉 Checking our empty branch ...\n"
    git checkout --orphan $1

    echo "\n👉 Cleaning cache ...\n"
    git rm --cached -r .
    git clean -f -d -x

    echo "\n🎉 Empty branch $1 created.\n"
}

# 📋 MySQL - Create database, user and assign privileges
# @param database/user  used for database and user name
# @param password  used for database password
mysql_create_db() {
    echo "\n👉 Creating database ...\n"
    sudo mysql -e "CREATE DATABASE $1"

    echo "\n👉 Creating user ...\n"
    sudo mysql -e "CREATE USER '$1'@'localhost' IDENTIFIED BY '$2'"

    echo "\n👉 Granting privileges ...\n"
    sudo mysql -e "GRANT ALL PRIVILEGES on $1.* TO '$1'@'localhost'"

    echo "\n🎉 Database Created.\n"
}

# List Users
mysql_list_users(){
    echo "\n👉 Listing Users ...\n"
    sudo mysql -e "SELECT user FROM mysql.user";
}

# Drop database with user
# @param database/user
mysql_drop_db() {
    echo "\n👉 Droppping database ...\n"
    sudo mysql -e "DROP DATABASE $1"

    echo "\n👉 Dropping user ...\n"
    sudo mysql -e "DROP USER '$1'@'localhost'"

    echo "\n🎉 Database Dropped.\n"
}

# 💡 SSH Connections to servers
alias connect_servername="ssh root@websitedomain_or_ip"