[Linux] Useful Alias | ~/.bashrc

# --------------------------------
# DB ALIAS
# ---------------------------------

# reload PostgreSQL configuration
pgsql_reload_config(){
    sudo pg_lsclusters
    sudo pg_ctlcluster 9.6 main reload
    sudo pg_lsclusters
}

pgsql_version(){
    psql --username=postgres -A -t -c "select version()"
}

pgsql_sessions(){
    clear
    psql --username=postgres -A -t -c "SELECT datname as database, pid, usename, application_name as application, client_addr, query FROM pg_stat_activity"
}

pgsql_diskspace(){
# for each tablespace
for tablespace in $(psql --username=postgres -A -t -c "select spcname from pg_tablespace"); do
  tablespace_size=$(psql --username=postgres -A -t -c "select pg_size_pretty(pg_tablespace_size('${tablespace}'))")
  printf "%15s  %s\n" "${tablespace_size}" "$tablespace"

  # for each database
  for database in $(psql --username=postgres -A -t -c "select datname from pg_database join pg_tablespace on pg_database.dattablespace=pg_tablespace.oid where datistemplate is false and spcname like '${tablespace}'"); do
    database_size=$(psql --username=postgres -A -t -c "select pg_size_pretty(pg_database_size('${database}'))")
    printf "%15s    %s\n" "$database_size" "$database"

    # for each schema
    for schema in $(psql --username=postgres -A -t -c "SELECT nspname FROM pg_namespace WHERE nspname not like 'pg_%' AND nspname not like  'information_schema'" -d ${database}); do
      schema_size=$(psql --username=postgres -A -t -c "select pg_size_pretty(sum(pg_total_relation_size(pg_class.oid))) from pg_class join pg_namespace on pg_class.relnamespace=pg_namespace.oid where nspname like '$schema'" -d ${database})
      if [ -z "$schema_size" ]; then
        schema_size="0 bytes"
      fi
      printf "%15s      %s\n" "$schema_size" "$schema"

      # for each table
      for table in $(psql --username=postgres -A -t -c "SELECT tablename FROM pg_tables where schemaname='${schema}'" -d ${database}); do
        table_size=$(psql --username=postgres -A -t -c "select pg_size_pretty(pg_total_relation_size(pg_class.oid)) from pg_class join pg_namespace on pg_class.relnamespace=pg_namespace.oid where nspname like '$schema' and relname like '$table'"  -d ${database})
        printf "%15s        %s\n" "$table_size" "$table"
      done
    done
  done
done
tablespaces_size=$(psql --username=postgres -A -t -c "select pg_size_pretty(sum(pg_tablespace_size(spcname))) from pg_tablespace")
printf "%15s\n" "$tablespaces_size"
}

# ---------------------------------
# SECURITY ALIAS
# ---------------------------------
alias gen_pass="openssl rand -base64 16 | colrm 17"

# ---------------------------------
# DEV ALIAS
# ---------------------------------
alias clipper="hbmk2"
alias basic="bwbasic"
alias lisp="clisp"

# ---------------------------------
# TERMINAL ALIAS
# ---------------------------------
alias clear_history='history -cw'
alias bashrc='nano ~/.bashrc'
alias lastcmd='history -p !!'
alias c='clear'
alias df='df -hPT | column -T'
alias ls='ls -l --color=auto'
alias cd..='cd ..'
alias cd..1='cd ..'
alias cd..2='cd ../..'
alias cd..3='cd ../../../'
alias cd..4='cd ../../../..'
alias grep='grep --color=auto'
alias egrep='egrep --color=auto'
alias fgrep='fgrep --color=auto'
alias bc='bc -l'
alias mkdir='mkdir -pv'
alias diff='colordiff'
alias h='history'
alias now='date +"%T"'
alias nowtime=now
alias nowdate='date +"%d-%m-%Y"'
# Parenting changing perms on / #
alias chown='chown --preserve-root'
alias chmod='chmod --preserve-root'
alias chgrp='chgrp --preserve-root'
# do not delete / or prompt if deleting more than 3 files at a time #
alias rm='rm -I --preserve-root'
alias ubuntu_version="lsb_release -a"
alias reboot="sudo reboot"
alias halt="sudo halt"
alias shutdown="sudo shutdown -h now"
alias poweroff="sudo shutdown -h now"
alias update-alternatives="sudo update-alternatives"
alias get_architecture="dpkg --print-architecture"
alias chmod="sudo chmod"

# ---------------------------------
# APT ALIAS
# ---------------------------------
alias apt_add_repo="sudo apt-add-repository -y"
alias apt_install="sudo apt-get install -y"
alias apt_fix_broken="sudo apt-get -f install && sudo dpkg --configure -a"
alias get_apt_sources_external="grep -r --include '*.list' '^deb ' /etc/apt/sources.list /etc/apt/sources.list.d/"
alias get_apt_sources_all="grep -r --include '*.list' '^deb ' /etc/apt/sources.list*"
alias dpkg="sudo dpkg"
get_apt_sources(){
    apt-cache policy | awk '/http/ { printf "%s %s\n",$2,$3 }' | sort | uniq
}

# ---------------------------------
# ROOT ALIAS
# ---------------------------------
alias root='sudo su'
alias su='sudo su'

# ---------------------------------
# TEXT EDITOR ALIAS
# ---------------------------------
alias vi='vim'
alias edit='nano -c'
alias nano='nano -c'
alias pico='nano -c'
alias sublime="/usr/bin/sublime_text_3/sublime_text"

# ---------------------------------
# WEB SERVER ALIAS
# ---------------------------------
alias apache2_restart="sudo service apache2 restart"
alias nginx_restart="sudo service nginx restart"

# ---------------------------------
# HARDWARE ALIAS
# ---------------------------------
alias meminfo='clear && free -m -l -t'
# get top process eating memory
alias psmem='clear && ps auxf | sort -nr -k 4'
alias psmem10='clear && ps auxf | sort -nr -k 4 | head -10'
# get top process eating cpu
alias pscpu='clear && ps auxf | sort -nr -k 3'
alias pscpu10='clear && ps auxf | sort -nr -k 3 | head -10'
# Get server cpu info
alias cpuinfo='clear && lscpu'
alias top='htop'
# ex: psg java
alias psg='ps aux | grep -i $i'

# ---------------------------------
# NETWORK ALIAS
# ---------------------------------
alias my_ip='curl http://ipecho.net/plain; echo'
alias get_ip='host $1'
alias get_host='nslookup $1'
alias get_mac_address="ifconfig -a | grep 'HWaddr' | cut -d ' ' -f 11"
alias ping='ping -c 5'
alias ports='netstat -tulanp'
alias wget="wget --no-check-certificate"

# ---------------------------------
# MATH ALIAS
# ---------------------------------
add(){
    if [[ -z "$1" || -z "$2" ]];  then
        echo "Usage: add n1 n2"
    else
        echo "$(($1+$2))"
    fi
}
sub(){
    if [[ -z "$1" || -z "$2" ]];  then
        echo "Usage: sub n1 n2"
    else
        echo "$(($1-$2))"
    fi
}
mult(){
    if [[ -z "$1" || -z "$2" ]];  then
        echo "Usage: mult n1 n2"
    else
        echo "$(($1*$2))"
    fi
}
div(){
    if [[ -z "$1" || -z "$2" ]];  then
        echo "Usage: div n1 n2"
    else
        echo "$(($1/$2))"
    fi
}

# is_int -1 => true
is_int(){
    if [[ -z "$1" ]];  then
        echo "Usage: is_int n1"
    else
        if [[ $1 == ?(-)+([0-9]) ]];  then
            echo "true"
        else
            echo "false"
        fi
    fi
}
alias prime_number_factor='factor $1'

hypotenuse(){
    if [[ -z "$1" || -z "$2" ]];  then
        echo "Usage: hypotenuse a b"
    else
        a_squared=$(($1 ** 2))
        b_squared=$(($2 ** 2))
        c_squared=$(($a_squared + $b_squared))
        echo "scale=3;sqrt($c_squared)" | bc
    fi
}

# ---------------------------------
# BASE CONVERSION ALIAS
# ---------------------------------

# dec_to_hex 10 => A
dec_to_hex(){
    if [[ -z "$1" ]];  then
        echo "Usage: dec_to_hex n1"
    else
        echo "obase=16;$1" | bc
    fi
}
# hex_to_dec A => 10
hex_to_dec(){
    if [[ -z "$1" ]];  then
        echo "Usage: hex_to_dec n1"
    else
        echo "ibase=16;$1" | bc
    fi
}

# dec_to_bin 2 => 10
dec_to_bin(){
    if [[ -z "$1" ]];  then
        echo "Usage: dec_to_bin n1"
    else
        echo "obase=2;$1" | bc
    fi
}
# bin_to_dec 11 => 3
bin_to_dec(){
    if [[ -z "$1" ]];  then
        echo "Usage: bin_to_dec n1"
    else
        echo "ibase=2;$1" | bc
    fi
}

# dec_to_octal 8 => 10
dec_to_octal(){
    if [[ -z "$1" ]];  then
        echo "Usage: dec_to_octal n1"
    else
        echo "obase=8;$1" | bc
    fi
}
# octal_to_dec 10 => 8
octal_to_dec(){
    if [[ -z "$1" ]];  then
        echo "Usage: octal_to_dec n1"
    else
        echo "ibase=8;$1" | bc
    fi
}
# bin_to_octal 1010101 = 125
bin_to_octal(){
    if [[ -z "$1" ]];  then
        echo "Usage: octal_to_dec n1"
    else
        echo "ibase=2;obase=8;$1" | bc
    fi
}


# ---------------------------------
# STRING ALIAS
# ---------------------------------

# Tests whether *entire string* is alphabetic.
# is_alpha "abcd1234" -> true
# is_alpha "abcd1234-" -> false
is_alpha (){
    if [[ -z "$1" ]];  then
        echo "Usage: is_alpha str1"
    else
        case $1 in
         *[^[:alnum:]]*) echo "false" ;;
                      *) echo "true" ;;

        esac
    fi
}

# str_upper "ola Mundo"
str_upper(){
    if [[ -z "$1" ]];  then
        echo "Usage: str_upper str1"
    else
        echo $1 | tr a-z A-Z
    fi
}

# str_lower "OLA MUNDO"
str_lower(){
    if [[ -z "$1" ]];  then
        echo "Usage: str_lower str1"
    else
        echo $1 | tr A-Z a-z
    fi
}

# str_rep "ola" 3
str_rep(){
    if [[ -z "$1" || -z "$2" ]];  then
        echo "Usage: str_rep str1 n1"
    else
        yes "$1" | head -n $2
    fi
}

# str_len "ola mundo"
str_len(){
    if [[ -z "$1" ]];  then
        echo "Usage: str_len str1"
    else
        myvar=$1
        size=${#myvar}
        echo "$size"
    fi
}

# str_strip "    ola     mundo    " => "olamundo"
str_strip(){
    if [[ -z "$1" ]];  then
        echo "Usage: str_strip str1"
    else
        echo "$1" | sed '/^$/d;s/[[:blank:]]//g'
    fi
}

# str_trim "    ola mundo    " => "ola mundo"
str_trim(){
    if [[ -z "$1" ]];  then
        echo "Usage: str_strip str1"
    else
        echo "$1" | xargs
    fi
}

# print_ascii
print_ascii(){
    START=33   # Range of printable ASCII characters (decimal).
    END=127    # Will not work for unprintable characters (> 127).

    echo " Decimal   Hex     Character"   # Header.
    echo " -------   ---     ---------"

    for ((i=START; i<=END; i++))
    do
        echo $i | awk '{printf("  %3d       %2x         %c\n", $1, $1, $1)}'
    done
}

is_root (){
    if [[ $(id -u) -ne 0 ]]; then
        echo "True"
    else
        echo "False"
    fi
}