Fetch a value of SQLalchemy instrumentedattribute

Question

How can I fetch the value of a InstrumentedAttribute object in SQLalchemy:

(Pdb) ResultLine.item_reference_1
<sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x793dc90>

The above statement prints me the sqlalchemy object.

What I actually need is the value associated with it.

Answer 1

There is no value associated with an InstrumentedAttribute; you are looking at a table declaration, not a result set. InstrumentedAttribute is used to define a relationship to another table, for example.

Query the database for results, and the resulting objects will have the reference filled in for you:

 for res in session.query(ResultLine).filter(somefilter):
     print res.item_reference_1