wrapper for mysql with http://zx2c4.com/projects/password-store/

myw.sh

#!/bin/sh

[[ $# > 2 || $# < 1 ]] && exit 1;
[[! hash pass 2>&-]] && exit 2

IFS=$'\n' data=($(pass work/sql-$1))

cmd=" -p'${data[0]}'"

for (( i=1; i<${#data[@]}; i++ )); do
  IFS=': ' read -r k v <<< ${data[i]}
  case $k in
    user|username)
      cmd+=" -u $v"
      ;;
    host|hostname)
      cmd+=" -h $v"
      ;;
    dbname|database|db)
      cmd+=" $v"
      ;;
  esac
done

if [ $# = 2 ] && [ $2 = 'dump' ]; then
  fn=~/tmp/$1-$(date +'%y-%m-%d').sql
  cmd="mysqldump -C $cmd > $fn"
  echo dumping to $fn
else
  cmd="mysql -C $cmd"
fi

eval $cmd