#!/bin/bash

#
# DBUSER=user DBPASSWORD=password [DBPORT=3306] [DOCKERMODE=false] ./trunc-tables.sh (container_id|host) database[,database2]
#

db_user=${DBUSER:-'root'}
db_pass=${DBPASSWORD:-''}
db_port=${DBPORT:-'3306'}
docker_mode=${DOCKERMODE:-false}

if [ "$DOCKERMODE" -eq "false" ]
then
  ip=$1
else
  ip=`docker inspect --format '{{ .NetworkSettings.IPAddress }}' $1`
fi

if [[ $2 == *","* ]]
then
  IFS=',' read -ra databases <<< "$2"
else
  databases=($2)
fi

for db in "${databases[@]}"
do
  mysql -h $ip -u${db_user} -p${db_pass} --port ${db_port} -Nse 'show tables' $db | while read table; do mysql -h $ip -u${db_user} -p${db_pass} --port ${db_port} -e "truncate table \`$table\`" $db; done
done

echo Exit code: $?