How do I access the data in a join SQLAlchemy

Question

Given the following sess query:

sess = DBSession()  
reg =  sess.query(Registration,Schedule).join(Schedule,Registration.classcode==Schedule.classcode).filter(Registration.registration_no==reg_id)

How the heck do I address the fields in the result 'reg'?

reg.timeofentry throws an error: TypeError: Can't convert 'int' object to str implicitly

I am rapidly learning to loath SQLAlchemy for all it's cryptic wrappers around perfectly simply SQL syntaxes.

zzzeek · Accepted Answer · 2013-11-19 20:09:44Z

6

oddly enough, the names within the named tuple row as returned from iterating the result reg in this case would be be Registration and Schedule:

for row in reg:
   print row.Registration, row.Schedule

I'm not able to reproduce your specific error message "can't convert 'int' object to str implicitly". If I attempt to access a name on the KeyedTuple that doesn't exist, there's a clear message:

AttributeError: 'KeyedTuple' object has no attribute 'imfake'

The behavior of the return value of query should be less cryptic after reading the intro to Querying in the ORM tutorial.

answered Nov 19, 2013 at 20:09

zzzeek

75.8k24 gold badges204 silver badges190 bronze badges

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

Collectives™ on Stack Overflow

How do I access the data in a join SQLAlchemy

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related