Method fetch_one

ormar/databases/query_executor.py:37–46

Execute a query and fetch one row. :param query: SQLAlchemy query expression :return: Single Row object or None

(self, query: Executable)

        return list(result.mappings().all())

    async def fetch_one(self, query: Executable) -> Optional[RowMapping]:
        """
        Execute a query and fetch one row.

        :param query: SQLAlchemy query expression
        :return: Single Row object or None
        """
        result: CursorResult[Any] = await self._connection.execute(query)
        row = result.mappings().first()
        return row

    async def fetch_val(self, query: Executable, column: int = 0) -> Optional[Any]:
        """