import asyncio
from sqlalchemy import select
from sqlalchemy.orm import selectinload
from app.core.database import AsyncSessionLocal
from app.models.project import Project
from app.models.status import Status
from app.services.project_service import project_service

async def main():
    async with AsyncSessionLocal() as session:
        query = (
            select(Project)
            .outerjoin(Project.status_rel)
            .where(Project.is_active == True)
            .where(Status.name.in_(project_service._running_status_names()))
        )
        result = await session.execute(query)
        projects = result.scalars().all()
        print(f"Found {len(projects)} projects with running status.")
        for p in projects:
            print(f"ID: {p.id}, Name: {p.name}")

if __name__ == "__main__":
    asyncio.run(main())