#!/bin/bash

echo ''
echo 'COMMAND: grep processor /proc/cpuinfo | wc -l'
echo ''
echo "CPU Core: $(grep processor /proc/cpuinfo | wc -l)";
echo ''
echo '=================================================='
echo ''
echo 'COMMAND: free -hm'
echo ''
free -m
echo ''

user=$1
database=$2
password=$3

table_names=$(mysql -u $user $database -s -e 'show tables;');


echo '============================================'
echo '============================================'
echo '               Table Schema'
echo '============================================'
echo '============================================'
echo ''
for table_name in $table_names; do
  echo $table_name
  mysql -u $user $database -e "desc $table_name";
  echo ''
done

echo '============================================'
echo '============================================'
echo '               Sample Data'
echo '============================================'
echo '============================================'
echo ''
for table_name in $table_names; do
  echo $table_name
  echo "SELECT * FROM $table_name LIMIT 5;"
  mysql -u $user $database -e "SELECT * FROM $table_name LIMIT 5";
  echo ''
done