How to query specific columns from an array with sqlalchemy?

Question

I'm building a flask application and need an dict from my database model. The query should filter by user_ids and only query a few rows. I guess the best way is to filter the rows and the use the internal __dict__ object to return my dict. Currently I know how to filter by ids, but I have no idea how to select specific rows. Users.query.filter(Users.id.in_(user_ids)).all()

the array of rows looks like rows = ["username", "role", "last_seen"]

any ideas how to do that?

Perhaps you're looking for stackoverflow.com/a/45905714/2681632, stackoverflow.com/questions/50995345/…, or stackoverflow.com/questions/21102412/…. — Ilja Everilä
– Ilja Everilä, Commented Jan 2, 2019 at 20:09

Dani G · Accepted Answer · 2019-01-02 20:33:03Z

3

load_only should do the job:

from sqlalchemy.orm import load_only
rows = ["username", "role", "last_seen"]
session.query(Users).filter(Users.id.in_(user_ids)).options(load_only(*rows)).all()

edited Jan 2, 2019 at 20:33

answered Jan 2, 2019 at 20:22

Dani G

1,2409 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

How to query specific columns from an array with sqlalchemy?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related