Flask SQLAlchemy: Selecting all rows with IDs from array

Question

I'm using Flask-SQLAlchemy and I have a few tables from a database.

I'm trying to select all the rows with a specific id, to run a function. Right now I'm doing it using an if statement like this:

IDs = [1,2,3,4]
for id in IDs:
    data = Data.query.filter_by(id=id).first()
    data.somefunction()

This does not seem very optimized, as I have to call the database for every id. I was wondering if there was a way to use Flask-SQLAlchemy to do a single query that returns all the rows from the database, and then I can run my function for every row and commit() at the end?

Use IN stackoverflow.com/questions/8603088/sqlalchemy-in-clause to fetch all matching data with a single query. — Ilja Everilä
– Ilja Everilä, Commented Jun 10, 2020 at 15:22

marvls · Accepted Answer · 2020-06-12 19:57:19Z

4

IN:

DataResults = Data.query.filter(Data.id.in_(IDs)).all()

and for good measure, NOT IN:

DataResults = Data.query.filter(~Data.id.in_(IDs)).all()

answered Jun 12, 2020 at 19:57

marvls

3443 silver badges6 bronze badges

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

Collectives™ on Stack Overflow

Flask SQLAlchemy: Selecting all rows with IDs from array

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related