Greetengs !! I'm having trouble getting a list from a recursive relationship. The relation is between NodeA and NodeB, where NodeA whould be the parent and NodeB the child. If the recursive relatioship is lazy the list is loaded correctly when the property is requested, but when child elements need to be loaded eagerly the list never loads, even using eagerload option.
------------------------------------------------------------------- Test Case: from sqlalchemy import * from sqlalchemy.ext.assignmapper import assign_mapper from sqlalchemy.ext.sessioncontext import SessionContext from sqlalchemy.ext.selectresults import SelectResults ctx = SessionContext(create_session) session = ctx.current metadata = MetaData() table = Table("node_table", metadata, Column('id', Integer, primary_key=True), Column('number', Unicode(10), nullable=False), Column('parent_id', Integer, ForeignKey('node_table.id')) ) class NodeA(object): pass class NodeB(object): pass assign_mapper(ctx, NodeB, table) # With lazy=True here the list IS loaded when needed assign_mapper(ctx, NodeA, table, properties={'b_childs': relation(NodeB, lazy=False)}) metadata.bind = create_engine('sqlite://', echo=True) metadata.create_all() table.insert().execute(number=1) table.insert().execute(number=2) table.insert().execute(number=3, parent_id=1) table.insert().execute(number=4, parent_id=1) table.insert().execute(number=5, parent_id=2) a = SelectResults(session.query(NodeA)).filter(NodeA.c.id==1).list() [0] # If recursive relationship is lazy b child nodes are loaded, but if relationship is not lazy they are never loaded # even when using eagerload option print a.b_childs Does anyone knows what's the problem here ? I'm using sqlalchemy version 0.3.9. Regards ! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---