#!/bin/bash

# Variables
CRM_BACKUP_URL="https://studiostaff.tv/crm_backup_ason.zip"  # URL of the CRM backup zip
SQL_BACKUP_URL="https://studiostaff.tv/db_backup_ason.sql"  # URL of the database SQL file

DOWNLOAD_DIR="/var/www"
RESTORE_DIR="/var/www"
DB_NAME="live_db"
DB_USER="root1"
DB_PASSWORD="Outrigth@321#"
PERMISSION_DIR="html"
# Ensure directories exist
mkdir -p "$DOWNLOAD_DIR" "$RESTORE_DIR"

# Download the CRM backup
CRM_ARCHIVE_NAME=$(basename "$CRM_BACKUP_URL")
CRM_ARCHIVE_PATH="${DOWNLOAD_DIR}/${CRM_ARCHIVE_NAME}"
echo "Downloading CRM backup..."
wget -O "$CRM_ARCHIVE_PATH" "$CRM_BACKUP_URL"

# Extract the CRM backup
echo "Extracting CRM backup..."
unzip "$CRM_ARCHIVE_PATH" -d "$RESTORE_DIR"

# Download the database backup
SQL_FILE_NAME=$(basename "$SQL_BACKUP_URL")
SQL_FILE_PATH="${DOWNLOAD_DIR}/${SQL_FILE_NAME}"
echo "Downloading database backup..."
wget -O "$SQL_FILE_PATH" "$SQL_BACKUP_URL"

# Drop and recreate the database
echo "Checking if the database exists..."
DB_EXIST=$(mysql -u"$DB_USER" -p"$DB_PASSWORD" -e "SHOW DATABASES LIKE '$DB_NAME';" | grep "$DB_NAME")

if [ -n "$DB_EXIST" ]; then
    echo "Database '$DB_NAME' exists. Dropping the database..."
    mysql -u"$DB_USER" -p"$DB_PASSWORD" -e "DROP DATABASE $DB_NAME;"
fi

echo "Creating a new database '$DB_NAME'..."
mysql -u"$DB_USER" -p"$DB_PASSWORD" -e "CREATE DATABASE $DB_NAME;"

# Restore the database
echo "Restoring database..."
mysql -u"$DB_USER" -p"$DB_PASSWORD" "$DB_NAME" < "$SQL_FILE_PATH"

# Cleanup
# rm -rf "$DOWNLOAD_DIR"/*


# chmod -R 777 "$PERMISSION_DIR"
echo "Restore completed."