from app import create_app
from app.models.user import User
from app.models.contract import Contract
from app.extensions import db

app = create_app()

with app.app_context():
    # Check users
    users = User.query.all()
    print(f"Total users: {len(users)}")
    
    # Check contract 7
    contract = Contract.query.get(7)
    if contract:
        print(f"\nContract 7:")
        print(f"  Status: {contract.status}")
        print(f"  Contractor ID: {contract.contractor_id}")
        print(f"  Worker ID: {contract.worker_id}")
        
        # Check if those users exist
        contractor = User.query.get(contract.contractor_id)
        worker = User.query.get(contract.worker_id)
        print(f"  Contractor exists: {contractor is not None}")
        print(f"  Worker exists: {worker is not None}")
        
        if contractor:
            print(f"  Contractor: {contractor.email}")
        if worker:
            print(f"  Worker: {worker.email}")