I'd like to be able to map read-only attributes based on a join, but
without mapping the class to a joined table.
----
Given this structure:
class unit:
pass
class recsite:
pass
units = Table('units',metadata,
Column('unit_id',Integer,
primary_key=True,nullable=False),
Column('recsite_id',Integer,
ForeignKey(recsites.c.recsite_id),
nullable=False))
recsites = Table('recsites',metadata,
Column('recsite_id',Integer,
primary_key=True,nullable=False),
Column('depth',Integer,nullable=False))
mapper(unit,units)
mapper(recsite,recsites)
----
Is there a way to map a 'depth' property for unit, without mapping
unit to units.join(recsites)? I tried adding a ColumnProperty to the
mapper, but while it succeeds, it returns the wrong value:
mapper(unit,units,
properties={'depth':ColumnProperty(recsites.c.depth)})
I can't find anything in the documentation for ColumnProperty that
tells me how to specify the join condition.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
