sqlalchemy filter multiple columns

Question

How do I combine two columns and apply filter  For example  I want to search in both the  firstname  and  lastname  columns at the same time   Here is how I have been doing it if searching only one column   query   meta Session query User  filter User firstname like searchVar

User · Answer

You can use SQLAlchemy s or  function to search in more than one column  the underscore is necessary to distinguish it from Python s own or    Here s an example   from sqlalchemy import or  query   meta Session query User  filter or  User firstname like searchVar                                               User lastname like searchVar

User · Answer

A generic piece of code that will work for multiple columns  This can also be used if there is a need to conditionally implement search functionality in the application   search key    abc  search args    col ilike     s      search key  for col in   col1    col2    col3    query   Query table  filter or   search args   session execute query  fetchall     Note  the    are important to skip   formatting  the query

User · Answer

There are number of ways to do it   Using filter    and operator   query   meta Session query User  filter      User firstname like search var1       User lastname like search var2          Using filter by    and operator   query   meta Session query User  filter by      firstname like search var1       lastname like search var2          Chaining filter   or filter by    and operator   query   meta Session query User        filter by firstname like search var1         filter by lastname like search var2     Using or     and     and not    from sqlalchemy import and   or   not   query   meta Session query User  filter      and           User firstname like search var1           User lastname like search var2

User · Answer

You can simply call filter multiple times   query   meta Session query User  filter User firstname like searchVar1                                       filter User lastname like searchVar2

[python] sqlalchemy filter multiple columns

Examples related to python

Examples related to sql

Examples related to database

Examples related to sqlalchemy