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
-~----------~----~----~----~------~----~------~--~---

Reply via email to