given the structure below (pasted from SA 0.5 docs of association object):
left_table = Table('left', metadata,
Column('id', Integer, primary_key=True),
Column('l_data', String(50))
right_table = Table('right', metadata,
Column('id', Integer, primary_key=True),
Column('r_data', String(50))
association_table = Table('association', metadata,
Column('left_id', Integer, ForeignKey('left.id'), primary_key=True),
Column('right_id', Integer, ForeignKey('right.id'), primary_key=True),
Column('a_data', String(50))
)
mapper(Parent, left_table, properties={
'children':relation(Association, backref="parent")
})
mapper(Association, association_table, properties={
'child':relation(Child, backref="parent_assocs")
})
mapper(Child, right_table)
what I would like to do is query the Association object while filtering
on parent_data and child_data and ordering the union, see below for a
pure sql version, but how in orm (if possible)?
select id as id, l_data as data_ass, a_data as data
from association left outer join left
where l_data = 'filtervalue'
UNION
select id as id, r_data as data_ass, a_data as data
from association left outer join right
where r_data = 'filtervalue'
order by data
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
