#!/bin/sh

# How to use
# ./convert DATABASE_USERNAME DATABASE_NAME DATABASE_PASSWORD(OPTIONAL)
# Example if Database password is p@ssw0rd:
#  ./convert root laravel p@ssw0rd
# Outputs:
# Analyzing and fixing: table1
# Analyzing and fixing: table2
# Analyzing and fixing: table3
#
# Database may have no password, so password field is not mandatory, use this command
#  ./convert root laravel
# Outputs:
# Analyzing and fixing: table1
# Analyzing and fixing: table2
# Analyzing and fixing: table3

USER=$1
DATABASE=$2
PASSWORD=$3
CHARSET="utf8_general_ci"
MYSQL_PATH="mysql"

for t in $($MYSQL_PATH --user=$USER --password=$PASSWORD  --database=$DATABASE -e "show tables";);do echo "Analyzing and fixing:" $t;$MYSQL_PATH --user=$USER --password=$PASSWORD --database=$DATABASE -e "ALTER TABLE $t CONVERT TO CHARACTER SET utf8 COLLATE $CHARSET;";done