Files
2026-02-22 18:58:55 +08:00

13 lines
386 B
Python

from __future__ import annotations
from sqlalchemy import select
from sqlalchemy.ext.asyncio import AsyncSession
from app.db.models.images import Image
async def get_image_by_id(session: AsyncSession, *, image_id: int) -> Image | None:
stmt = select(Image).where(Image.id == int(image_id), Image.status == 1).limit(1)
return (await session.execute(stmt)).scalars().first()