#!/bin/bash

echo "============================================"
echo "一键修复登录问题"
echo "============================================"
echo ""

echo "请确保："
echo "1. MySQL服务已启动"
echo "2. 数据库 books_db 已创建"
echo "3. 已知道MySQL root密码"
echo ""

read -p "请输入MySQL root密码: " mysql_password

echo ""
echo "正在修复管理员账号..."
echo ""

cd "$(dirname "$0")/../book"

mysql -u root -p"$mysql_password" books_db < src/main/resources/db/fix_admin_user.sql

if [ $? -eq 0 ]; then
    echo ""
    echo "============================================"
    echo "修复完成！"
    echo "============================================"
    echo ""
    echo "默认管理员账号："
    echo "用户名: admin"
    echo "密码: admin123"
    echo ""
    echo "现在可以重新登录了！"
else
    echo ""
    echo "============================================"
    echo "修复失败！"
    echo "============================================"
    echo ""
    echo "请检查："
    echo "1. MySQL服务是否启动"
    echo "2. 数据库 books_db 是否存在"
    echo "3. MySQL root密码是否正确"
    echo ""
    echo "或者手动执行SQL脚本："
    echo "mysql -u root -p books_db < src/main/resources/db/fix_admin_user.sql"
fi