Sqlalchemy results as dictionary with specified column as key

Question

Looking to conveniently select some data into a dictionary keyed by specified columns, like so:

# pseudocode
results = session.query(MyModel).all(index_result_by=MyModel.id)
print(results.__class__)
<class 'dict'>
print(results[5])
<MyModel 5>

I could use a loop or dict comprehension, but is there anything built in?

Ilja Everilä · Accepted Answer · 2019-05-10 17:02:41Z

1

Just select tuples of id, instance and pass to dict():

results = dict(session.query(MyModel.id, MyModel).all())

answered May 10, 2019 at 17:02

Ilja Everilä

53.4k9 gold badges138 silver badges142 bronze badges

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

1 Comment

Thanks!!! Way cool, I didn't know you could combine columns and full objects like that.