Vous êtes un professionnel et vous avez besoin d'une formation ? Calcul scientifique
avec Python Voir le programme détaillé

Classe « ColumnOperators »

Méthode sqlalchemy.ColumnOperators.iendswith

Signature de la méthode iendswith

def iendswith(self, other: 'Any', escape: 'Optional[str]' = None, autoescape: 'bool' = False) -> 'ColumnOperators' 

Description

help(ColumnOperators.iendswith)

Implement the ``iendswith`` operator, e.g. case insensitive
version of :meth:`.ColumnOperators.endswith`.

Produces a LIKE expression that tests against an insensitive match
for the end of a string value:

.. sourcecode:: sql

    lower(column) LIKE '%' || lower(<other>)

E.g.::

    stmt = select(sometable).where(sometable.c.column.iendswith("foobar"))

Since the operator uses ``LIKE``, wildcard characters
``"%"`` and ``"_"`` that are present inside the <other> expression
will behave like wildcards as well.   For literal string
values, the :paramref:`.ColumnOperators.iendswith.autoescape` flag
may be set to ``True`` to apply escaping to occurrences of these
characters within the string value so that they match as themselves
and not as wildcard characters.  Alternatively, the
:paramref:`.ColumnOperators.iendswith.escape` parameter will establish
a given character as an escape character which can be of use when
the target expression is not a literal string.

:param other: expression to be compared.   This is usually a plain
  string value, but can also be an arbitrary SQL expression.  LIKE
  wildcard characters ``%`` and ``_`` are not escaped by default unless
  the :paramref:`.ColumnOperators.iendswith.autoescape` flag is
  set to True.

:param autoescape: boolean; when True, establishes an escape character
  within the LIKE expression, then applies it to all occurrences of
  ``"%"``, ``"_"`` and the escape character itself within the
  comparison value, which is assumed to be a literal string and not a
  SQL expression.

  An expression such as::

    somecolumn.iendswith("foo%bar", autoescape=True)

  Will render as:

  .. sourcecode:: sql

    lower(somecolumn) LIKE '%' || lower(:param) ESCAPE '/'

  With the value of ``:param`` as ``"foo/%bar"``.

:param escape: a character which when given will render with the
  ``ESCAPE`` keyword to establish that character as the escape
  character.  This character can then be placed preceding occurrences
  of ``%`` and ``_`` to allow them to act as themselves and not
  wildcard characters.

  An expression such as::

    somecolumn.iendswith("foo/%bar", escape="^")

  Will render as:

  .. sourcecode:: sql

    lower(somecolumn) LIKE '%' || lower(:param) ESCAPE '^'

  The parameter may also be combined with
  :paramref:`.ColumnOperators.iendswith.autoescape`::

    somecolumn.endswith("foo%bar^bat", escape="^", autoescape=True)

  Where above, the given literal parameter will be converted to
  ``"foo^%bar^^bat"`` before being passed to the database.

.. seealso::

    :meth:`.ColumnOperators.endswith`

Vous êtes un professionnel et vous avez besoin d'une formation ? RAG (Retrieval-Augmented Generation)
et Fine Tuning d'un LLM Voir le programme détaillé