Method get

backend/app/dao/base.py:39–47

Fetch a single record by its primary key ID.

(self, id: Any)

                    _session_ctx.reset(token)

    async def get(self, id: Any) -> ModelType | None:
        """Fetch a single record by its primary key ID."""
        async with self.session() as db:
            if hasattr(db, "get"):
                return await db.get(self.model, id)
            # Fallback for custom mock DB clients in tests
            stmt = select(self.model).where(self.model.id == id)
            result = await db.execute(stmt)
            return result.scalar_one_or_none()

    async def is_empty(self) -> bool:
        """Check if the table is empty (no records)."""