CODEWITHSUNDEEP
pythondictionarysqlalchemy
cmc
cmc

Reputation: 4413

Sqlalchemy results as dictionary with specified column as key

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?

Upvotes: 0

Views: 311

Answers (1)

Ilja Everil&#228;
Ilja Everil&#228;

Reputation: 53017

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

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

Upvotes: 1

Related Questions