Jose Soares wrote: > Hi all, > > Probably this is a stupid question, :-[ but I don't > understand how to iterate an object mapper to get fields value. > --- > > user = session.query(User).select(id=1) > > for j in user.c: > print j.name > > logname > id > password > > > > for j in user.c: > print j.value > > 'Column' object has no attribute 'value' >
The fields are attributes of the 'user' object itself, so the values are at user.logname, user.id and user.password. To get an attribute whose name is stored in a variable, you can use 'getattr': for col in user.c: value = getattr(user, col.name) print col.name, value Hope that helps, Simon --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---