sqlalchemy IS NOT NULL select

How can I add the filter as in SQL to select values that are NOT NULL from a certain column ?

    SELECT * 
    FROM table 
    WHERE YourColumn IS NOT NULL;

How can I do the same with SQLAlchemy filters?

    select = select(table).select_from(table).where(all_filters)

column_obj != None will produce a IS NOT NULL constraint:

In a column context, produces the clause a != b. If the target is None, produces a IS NOT NULL.

or use isnot() (new in 0.7.9):

Implement the IS NOT operator.

Normally, IS NOT is generated automatically when comparing to a value of None, which resolves to NULL. However, explicit usage of IS NOT may be desirable if comparing to boolean values on certain platforms.


    >>> from sqlalchemy.sql import column
    >>> column('YourColumn') != None
    <sqlalchemy.sql.elements.BinaryExpression object at 0x10c8d8b90>
    >>> str(column('YourColumn') != None)
    '"YourColumn" IS NOT NULL'
    >>> column('YourColumn').isnot(None)
    <sqlalchemy.sql.elements.BinaryExpression object at 0x104603850>
    >>> str(column('YourColumn').isnot(None))
    '"YourColumn" IS NOT NULL'

From: stackoverflow.com/q/21784851

Back to homepage or read more recommendations: