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

app = create_app()

with app.app_context():
    # Get an active contract
    contract = Contract.query.filter_by(status='active').first()
    if contract:
        print(f"Testing Contract {contract.id}:")
        print(f"  Before: {contract.status}")
        
        # Simulate worker marking complete
        contract.status = 'pending_review'
        contract.completion_status = 'pending_review'
        contract.worker_completion_date = datetime.utcnow()
        db.session.commit()
        
        print(f"  After: {contract.status}")
        print(f"✅ Worker can now mark jobs complete!")
    else:
        print("No active contracts found")
        print("Creating a test contract...")
        # Show existing contracts
        contracts = Contract.query.limit(5).all()
        for c in contracts:
            print(f"  Contract {c.id}: status={c.status}")