#!/bin/bash

# Variable setup
DB_NAME="employees"
USER_NAME="nhncloud"
USER_PASSWORD="nhnpassword"
DB_URL="https://github.com/datacharmer/test_db.git"

# 1. Clone the test_db repository
echo "Cloning test_db repository..."
cd ~
git clone $DB_URL

# 2. Load employees.sql file into MySQL
echo "Loading employees.sql into MySQL..."
cd ~/test_db
sudo mysql -u root < employees.sql

# 3. Configure MySQL user and permissions
echo "Configuring MySQL user and permissions..."
sudo mysql -u root <<EOF
USE $DB_NAME;

# Create user (for localhost and 192.168.0.% range)
CREATE USER '$USER_NAME'@'localhost' IDENTIFIED BY '$USER_PASSWORD';
CREATE USER '$USER_NAME'@'192.168.0.%' IDENTIFIED BY '$USER_PASSWORD';

# Grant privileges
GRANT ALL PRIVILEGES ON $DB_NAME.* TO '$USER_NAME'@'localhost';
GRANT ALL PRIVILEGES ON $DB_NAME.* TO '$USER_NAME'@'192.168.0.%';

# Apply privileges
FLUSH PRIVILEGES;
EOF

echo "MySQL user '$USER_NAME' created and configured successfully!"