import sys
import os

# Set PYTHONPATH
sys.path.insert(0, os.path.dirname(__file__))

try:
    # Impor base.py yang mengimpor seluruh model secara resmi
    from app.db.base import Base
    from app.db.session import SessionLocal
    from app.models.user import User
    from app.core.security import verify_password
    
    db = SessionLocal()
    user = db.query(User).filter(User.email == 'admin@silviajewelry.com').first()
    print("====================================")
    print("MySQL Connection: SUCCESS!")
    print("User found in MySQL database:", user is not None)
    if user:
        print("User Email:", user.email)
        print("Password match (admin123):", verify_password('admin123', user.hashed_password))
    else:
        print("ALERT: Superuser 'admin@silviajewelry.com' not found in MySQL!")
    print("====================================")
except Exception as e:
    import traceback
    print("CRITICAL DIAGNOSIS ERROR:")
    traceback.print_exc()