Query processing in SQL Alchemy - Python

Question

I need the dynamic Query processing with the SQLAlchemy.

Consider there is the table which is having three field name,age,city.

From the table I need to fetch the city like city name having (s,r,t) characters.

For that SQLAlchemy Query which I framed is as follows:

query = query.filter(or_(model.city.like('%s%'),model.city.like('%r%'),model.city.like('%t%')))

It is working as I expected.

But now my issue is regarding processing of the values during my code execution.

Because in my case those characters needs to be taken from the list in python.

Consider python list:

['s','m','n']

So here now Querying is needs to be done for those values in list dynamically.

I can't be sure regarding the number of entries in list too, So that it should be working dynamically.

Main goal here here is doing "like" and "or" in SQLAlchemy dynamically.

6c1 · Accepted Answer · 2015-11-18 18:31:38Z

2

You can map the list characters through the like() method and splat the result into _or(). Something along the lines of:

chars = ['s','m','n']

query = query.filter(or_(*map(
                              lambda x: model.city.like('%{}%'.format(x)),
                              chars
)))

answered Nov 18, 2015 at 18:31

6c1

4022 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query processing in SQL Alchemy - Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related