import asyncio
from sqlalchemy.ext.asyncio import create_async_engine, AsyncSession
from sqlalchemy.orm import sessionmaker
from app.core.config import settings
from app.services.project_service import ProjectService

async def main():
    engine = create_async_engine(settings.DATABASE_URL)
    async_session = sessionmaker(engine, class_=AsyncSession, expire_on_commit=False)
    
    service = ProjectService()
    async with async_session() as db:
        res = await service.get_by_id(db, 21)
        print("Success:", res.success)
        if not res.success:
            print("Message:", res.message)
        else:
            print("Name:", res.data.get("name"))

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