#!/usr/bin/env python3
"""
Quick diagnostic to see what's actually broken vs fixable
"""

from app import create_app
from app.extensions import db

def check_system_health():
    print("🔍 RateRight System Health Check")
    print("=" * 50)
    
    app = create_app()
    
    with app.app_context():
        try:
            # Test database connection
            result = db.engine.execute("SELECT 1")
            print("✅ Database connection: WORKING")
            
            # Check table existence
            tables = db.engine.table_names()
            expected_tables = ['users', 'jobs', 'applications', 'contracts', 'categories']
            
            print(f"\n📊 Database Tables:")
            for table in expected_tables:
                if table in tables:
                    print(f"   ✅ {table}: EXISTS")
                else:
                    print(f"   ❌ {table}: MISSING")
            
            # Test basic queries
            from app.models.user import User
            from app.models.job import Job
            from app.models.contract import Contract
            
            user_count = User.query.count()
            job_count = Job.query.count()
            contract_count = Contract.query.count()
            
            print(f"\n📈 Data Summary:")
            print(f"   Users: {user_count}")
            print(f"   Jobs: {job_count}")  
            print(f"   Contracts: {contract_count}")
            
            print(f"\n✅ VERDICT: Your app is NOT broken!")
            print(f"   Just needs database schema alignment")
            
        except Exception as e:
            print(f"❌ Error: {e}")
            print(f"   This is fixable with proper migration")

if __name__ == "__main__":
    check_system_health()