Method count

src/core/db/repository.py:260–268

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

            return result.scalar_one_or_none()

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

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

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

    async def exists(self, filters: list[Filter]) -> bool:
        query = select(1)