Method ordered_values

lib/sqlalchemy/sql/dml.py:1680–1710

Specify the VALUES clause of this UPDATE statement with an explicit parameter ordering that will be maintained in the SET clause of the resulting UPDATE statement. E.g.:: stmt = table.update().ordered_values(("name", "ed"), ("ident", "foo")) .. seealso:

(self, *args: Tuple[_DMLColumnArgument, Any])

        super().__init__(table)

    def ordered_values(self, *args: Tuple[_DMLColumnArgument, Any]) -> Self:
        class="st">"""Specify the VALUES clause of this UPDATE statement with an explicit
        parameter ordering that will be maintained in the SET clause of the
        resulting UPDATE statement.

        E.g.::

            stmt = table.update().ordered_values((class="st">"name", class="st">"ed"), (class="st">"ident", class="st">"foo"))

        .. seealso::

           :ref:`tutorial_parameter_ordered_updates` - full example of the
           :meth:`_expression.Update.ordered_values` method.

        .. versionchanged:: 1.4 The :meth:`_expression.Update.ordered_values`
           method
           supersedes the
           :paramref:`_expression.update.preserve_parameter_order`
           parameter, which will be removed in SQLAlchemy 2.0.

        class="st">"""  class="cm"># noqa: E501
        if self._values:
            raise exc.ArgumentError(
                class="st">"This statement already has "
                fclass="st">"{&class="cm">#x27;ordered ' if self._maintain_values_ordering else ''}"
                class="st">"values present"
            )

        self = self.values(dict(args))
        self._maintain_values_ordering = True
        return self

    @_generative
    def inline(self) -> Self: