import asyncio
from app.core.database import AsyncSessionLocal
from sqlalchemy import select
from app.models.models import Customer
from fastapi.templating import Jinja2Templates
import os

async def test():
    async with AsyncSessionLocal() as session:
        result = await session.execute(select(Customer))
        customers = result.scalars().all()
        BASE_DIR = r"C:/Users/MF Sangadji/bestweb"
        templates = Jinja2Templates(directory=os.path.join(BASE_DIR, "app/templates"))
        try:
            print(templates.TemplateResponse("customers.html", {"request": None, "customers": customers}))
        except Exception as e:
            import traceback
            traceback.print_exc()

asyncio.run(test())