How can I easily flatten the tupled elements that come out of SQLAlchemy?

Asked Oct 04 '16 at 20:40

Active Oct 04 '16 at 20:40

Viewed 976 times

I'm writing code similar to the example below, but it feels clunky. Is there a better way to get a flat list out of a SQLAlchemy query? If I don't do the list comprehension, the list is a list of tuples.

names = [x[0] for x in session.query(User.name).all()]

I'd like some magical function like Query.scalar but for a list.

asked Oct 04 '16 at 20:40

Jim Hunziker

14,111
8
58
64

You could define a function and use that... List comprehensions are great for this sort of thing – Oct 04 '16 at 20:46
It's not an answer to your question, but you can write `x.name` instead of `x[0]`. – skovorodkin Oct 04 '16 at 20:47
Yup! Thanks. I voted to close it. – Jim Hunziker Oct 04 '16 at 20:57

How can I easily flatten the tupled elements that come out of SQLAlchemy?

0 Answers0