Python: How to use SQLALCHEMY to filter SQL object in array

Question

I have a SQLAlchemy query in python where I want to filter output if a column value exists in a locally created array. However, this always returns None.

offices = ['US', 'UK', 'MEX']
users_db = models.s.query(models.User).filter(models.User.location in offices).all()

Is there a different implementation to that in SQLAlchemy or am I doing something wrong?

Ian Wilson · Accepted Answer · 2021-09-02 16:40:24Z

1

Use in_ to create SQL IN clause.


models.s.query(models.User).filter(models.User.location.in_(offices)).all()

answered Sep 2, 2021 at 16:40

Ian Wilson

9,3392 gold badges27 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

Python: How to use SQLALCHEMY to filter SQL object in array

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