Hi,

I am trying to use a column property, I have a class Foo:

class Foo(object):
   pass

which is mapped to a table foo_table and it has multiple names which
are stored in bar_table with foo_id as the primary key in Foo and
ForeignKey in bar_table.

I am trying to use a column property to access these:

mapper(Foo, foo_table, properties={ "names" :
column_property(select([bar_table.c.name], bar_table.c.foo_id ==
foo_table.c.foo_id).label("names")) } )

so when I try to query any of the objects I just get no results back,
but when I try it without the column property I get something back.

Am I just doing something incredibly stupid wrong?

Many thanks in advance,

Nathan

--~--~---------~--~----~------------~-------~--~----~
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 
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to