#!/usr/bin/env python
"""Quick database check for production"""
from app import app, db
from sqlalchemy import inspect

with app.app_context():
    inspector = inspect(db.engine)
    tables = inspector.get_table_names()
    
    print("="*60)
    print("DATABASE SCHEMA CHECK")
    print("="*60)
    print(f"\nTables found: {len(tables)}")
    for table in sorted(tables):
        print(f"  - {table}")
    
    # Check specific tables
    expected = ['users', 'jobs', 'contracts', 'messages', 'ratings']
    missing = [t for t in expected if t not in tables]
    
    if missing:
        print(f"\n⚠ Missing tables: {missing}")
    else:
        print("\n✓ All core tables present")
    
    # Check user table columns
    if 'users' in tables:
        columns = inspector.get_columns('users')
        col_names = [c['name'] for c in columns]
        print(f"\nUser table columns ({len(col_names)}):")
        for col in col_names[:10]:  # Show first 10
            print(f"  - {col}")
        if len(col_names) > 10:
            print(f"  ... and {len(col_names)-10} more")
    
    # Quick data count
    from app.models import User
    user_count = User.query.count()
    print(f"\nUser records: {user_count}")