sqlscript.sh

#!/bin/bash

delimiter=";"
DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
OPTIND=1

function generateAlias {
 if [ ! -f ~/.bash_aliases ]; then
 touch ~/.bash_aliases
 echo "alias sqlscript=$DIR/sqlscript.sh" > ~/.bash_aliases
 else
 grep "sqlscript" ~/.bash_aliases
 if [ ! "$?" = "0" ]; then
 echo "alias sqlscript=$DIR/sqlscript.sh" >> ~/.bash_aliases
 else
 echo "alias already exists"
 fi
 fi
}

if [ ! -f ~/.sqllogindata ]; then
 echo ">No login file found in home, creating a new one."
 echo ">WARNING: use only in secure environments, data is stored in plain text"
 echo ">Please enter your username"
 read username
 echo ">Hi $username, nice to meet you."
 echo ">Please enter your password."
 read -s password
 echo "${username}${delimiter}${password}" > ~/.sqllogindata
fi


#handle cl arguments
while getopts "a" opt; do
 case "$opt" in
 a) generateAlias 
 ;;
 esac
done

login="$(cat ~/.sqllogindata)"
IFS=\\$delimiter read -a loginarr <<<"$login"
mysql -h 193.196.143.168 -u "${loginarr[0]}" -p"${loginarr[1]}"