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

Module « sqlalchemy »

Fonction or_ - module sqlalchemy

Signature de la fonction or_

def or_(*clauses) 

Description

help(sqlalchemy.or_)

Produce a conjunction of expressions joined by ``OR``.

E.g.::

    from sqlalchemy import or_

    stmt = select(users_table).where(
        or_(users_table.c.name == "wendy", users_table.c.name == "jack")
    )

The :func:`.or_` conjunction is also available using the
Python ``|`` operator (though note that compound expressions
need to be parenthesized in order to function with Python
operator precedence behavior)::

    stmt = select(users_table).where(
        (users_table.c.name == "wendy") | (users_table.c.name == "jack")
    )

The :func:`.or_` construct must be given at least one positional
argument in order to be valid; a :func:`.or_` construct with no
arguments is ambiguous.   To produce an "empty" or dynamically
generated :func:`.or_`  expression, from a given list of expressions,
a "default" element of :func:`_sql.false` (or just ``False``) should be
specified::

    from sqlalchemy import false

    or_criteria = or_(false(), *expressions)

The above expression will compile to SQL as the expression ``false``
or ``0 = 1``, depending on backend, if no other expressions are
present.  If expressions are present, then the :func:`_sql.false` value
is ignored as it does not affect the outcome of an OR expression which
has other elements.

.. deprecated:: 1.4  The :func:`.or_` element now requires that at
   least one argument is passed; creating the :func:`.or_` construct
   with no arguments is deprecated, and will emit a deprecation warning
   while continuing to produce a blank SQL string.

.. seealso::

    :func:`.and_`

Vous êtes un professionnel et vous avez besoin d'une formation ? Machine Learning
avec Scikit-Learn Voir le programme détaillé