Apply Python Code To Sqlalchemy Filters

Question

I'm trying to figure out how to apply python code (like splitting a list) to a sqlalchemy filter. An example is as follows: my database stores a full name as a field in the table. I want to query my database for all people who have a given first name. So what I want to do is something like:

User.query.filter(User.name.split()[0].lower() == 'henry'.lower())

When I try to run this query, I get the error:

AttributeError: Neither 'InstrumentedAttribute' object nor 'Comparator' object associated with User.name has an attribute 'split'

What is the general way to apply python commands like split(), lower(), etc. to my sqlalchemy queries?

davidism · Accepted Answer · 2015-06-03 01:45:55Z

4

SQLAlchemy is constructing a SQL expression, not a Python expression. You can apply SQL functions to the expression by using the func object.

from sqlalchemy import func
User.query.filter(func.lower(func.substring_index(User.name, ' ', 1)) == 'henry')

answered Jun 3, 2015 at 1:45

davidism

128k31 gold badges417 silver badges348 bronze badges

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

Collectives™ on Stack Overflow

Apply Python Code To Sqlalchemy Filters

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