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

app = create_app()
with app.app_context():
    # Check for active contracts
    contracts = Contract.query.filter_by(status='active').all()
    print(f"Active contracts: {len(contracts)}")
    
    # Check for contracts pending rating
    pending = Contract.query.filter_by(status='completed_pending_rating').all()
    print(f"Contracts pending rating: {len(pending)}")
    
    # Show contract statuses
    all_contracts = Contract.query.limit(5).all()
    if all_contracts:
        print("\nExisting contracts:")
        for c in all_contracts:
            print(f"  Contract {c.id}: {c.status} (Job {c.job_id}, Contractor {c.contractor_id}, Worker {c.worker_id})")
    else:
        print("\nNo contracts found in database")