sqlalchemy IS NOT NULL select

Question

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

User · Accepted Answer

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    Demo    gt  gt  gt  from sqlalchemy sql import column  gt  gt  gt  column  YourColumn      None  lt sqlalchemy sql elements BinaryExpression object at 0x10c8d8b90 gt   gt  gt  gt  str column  YourColumn      None    YourColumn  IS NOT NULL   gt  gt  gt  column  YourColumn   isnot None   lt sqlalchemy sql elements BinaryExpression object at 0x104603850 gt   gt  gt  gt  str column  YourColumn   isnot None     YourColumn  IS NOT NULL

User · Answer

Starting in version 0 7 9 you can use the filter operator  isnot instead of comparing constraints  like this   query filter User name isnot None    This method is only necessary if pep8 is a concern   source  sqlalchemy documentation

User · Answer

In case anyone else is wondering  you can use is  to generate foo IS NULL        from sqlalchemy sql import column     print column  foo   is  None  foo IS NULL     print column  foo   isnot None  foo IS NOT NULL

[python] sqlalchemy IS NOT NULL select

Examples related to python

Examples related to sqlalchemy