Method get

ormar/queryset/queryset.py:1143–1194

Gets a single row from the db matching the criteria set by args/kwargs. Passing args/kwargs is a shortcut for ``filter(*args, **kwargs).get()``. When criteria are set (either through args/kwargs here or via a chained :meth:`filter`/:meth:`exclude`) the query fetche

(self, *args: Any, **kwargs: Any)

            return None

    async def get(self, *args: Any, **kwargs: Any) -> "T":  # noqa: CCR001
        """
        Gets a single row from the db matching the criteria set by args/kwargs.

        Passing args/kwargs is a shortcut for ``filter(*args, **kwargs).get()``.

        When criteria are set (either through args/kwargs here or via a
        chained :meth:`filter`/:meth:`exclude`) the query fetches every
        matching row and asserts that exactly one comes back — ``NoMatch``
        is raised when none match and ``MultipleMatches`` when more than one
        matches.

        When no criteria are set, ``get()`` falls back to returning the last
        row of the table ordered by primary key descending (``LIMIT 1``); in
        that mode ``MultipleMatches`` cannot be raised.

        :raises NoMatch: if no rows match the criteria
        :raises MultipleMatches: when criteria are set and more than one row
            matches them.
        :param kwargs: fields names and proper value types
        :type kwargs: Any
        :return: returned model
        :rtype: Model
        """
        if kwargs or args:
            return await self.filter(*args, **kwargs).get()

        if not self.filter_clauses:
            expr = self.build_select_expression(
                limit=1,
                order_bys=(
                    [
                        OrderAction(
                            order_str=f"-{self.model.ormar_config.pkname}",
                            model_cls=self.model_cls,  # type: ignore
                        )
                    ]
                    if not any([x.is_source_model_order for x in self.order_bys])
                    else []
                )
                + self.order_bys,
            )
        else:
            expr = self.build_select_expression()

        async with self.model_config.database.get_query_executor() as executor:
            rows = await executor.fetch_all(expr)
        processed_rows = await self._process_query_result_rows(rows)
        if self._prefetch_related and processed_rows:
            processed_rows = await self._prefetch_related_models(processed_rows, rows)
        self.check_single_result_rows_count(processed_rows)
        return processed_rows[0]  # type: ignore

    async def get_or_create(
        self,