Method find_one

src/core/db/repository.py:241–258

(
        self,
        filters: list[Filter] | None = None,
        order_by: list[OrderBy] | None = None,
    )

            return result.scalars().all()

    async def find_one(
        self,
        filters: list[Filter] | None = None,
        order_by: list[OrderBy] | None = None,
    ) -> T | None:
        query = select(self._model)

        if filters:
            query = self._apply_filters(query, filters)

        if order_by:
            query = self._apply_ordering(query, order_by)

        query = query.limit(1)

        async with self.get_session() as session:
            result = await session.execute(query)
            return result.scalar_one_or_none()

    async def count(self, filters: list[Filter] | None = None) -> int:
        query = select(func.count()).select_from(self._model)