Converting string formatted query to SQLAlchemy format

Asked Jul 12 '22 at 13:12

Active Jul 16 '22 at 04:27

Viewed 23 times

I created query in string format as i had many manipulations within. but couldn't combine the query with actually query:

string='and_(ContentCard.release_date.between("2016-01-01","2017-12-31"),ContentCard.content_type =="Movie",ContentCard.language_codes =="ja",or_(genre_ids.ilike("%35%"),genre_ids.ilike("%16%")))'

I need something like

query = query.filter(string)

If I tried directly, it gives me a format error. Any suggestions?

edited Jul 16 '22 at 04:27

Daniel Walker

6,380
5
22
45

asked Jul 12 '22 at 13:12

Neha Bankar

you can't do that. this is a method in a class – r3a9670 Jul 12 '22 at 13:21
@r3a9670 what is suitable option to do this? – Neha Bankar Jul 12 '22 at 13:27
what you want grab from database ? – r3a9670 Jul 12 '22 at 13:33
query = query.filter( and_(ContentCard.release_date.between("2016-01-01","2017-12-31"), ContentCard.content_type =="Movie", ContentCard.language_codes =="ja", or_(genre_ids.ilike("%35%"), genre_ids.ilike("%16%"))) ) – r3a9670 Jul 12 '22 at 13:38
i have to apply filters on perticular data I am fetching from DB, where number and types of filters are dynamic – Neha Bankar Jul 12 '22 at 13:38
i will recieve filter values like release_date = '2016-01-01','2017-12-31', content_type =Movie, language_codes = 'ja. here everything is optional – Neha Bankar Jul 12 '22 at 13:40
1

[check here](https://stackoverflow.com/questions/37336520/sqlalchemy-dynamic-filter) – r3a9670 Jul 12 '22 at 13:41

Converting string formatted query to SQLAlchemy format

0 Answers0