import asyncio
from sqlalchemy.ext.asyncio import create_async_engine, AsyncSession
from sqlalchemy import select
from app.models.employee import Employee
from app.core.config import settings

async def main():
    engine = create_async_engine(settings.DATABASE_URL)
    async with AsyncSession(engine) as session:
        result = await session.execute(select(Employee).where(Employee.id == 1))
        emp = result.scalar_one_or_none()
        print(f"Emp Code: {emp.employee_code}, Designation ID: {emp.designation_id}")

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