Hi, Is it possible to have an association_proxy (in the association object pattern) that emulates a set-based collection if it goes through a lazy='dynamic' relationship? I can't for the life of me find a way to make this work (setting collection_class on the dynamic relationship doesn't seem to do anything).
Here's some example code of what I'm trying to do, extracted from the actual project: class ProofOfWork(object): blocks = association_proxy('Intermediatory_nodes', 'block') proof_of_work = Table('proof_of_work', db.metadata) mapper(ProofOfWork, proof_of_work, properties={ 'Intermediatory_nodes': relationship(lambda: Intermediatory, lazy = 'dynamic'), }) class Block(object): proof_of_works = association_proxy('Intermediatory_nodes', 'proof_of_work') block = Table('block', db.metadata) mapper(Block, block, properties={ 'Intermediatory_nodes': relationship(lambda: Intermediatory, lazy = 'dynamic'), }) class Intermediatory(object): pass intermediatory = Table('intermediatory', db.metadata, Column('proof_of_work_id', Integer, ForeignKey('proof_of_work.id'), nullable = False), Column('block_id', Integer, ForeignKey('block.id')), ) mapper(Intermediatory, intermediatory, properties={ 'proof_of_work': relationship(lambda: ProofOfWork, back_populates = 'Intermediatory_nodes', remote_side = lambda: proof_of_work.c.id), 'block': relationship(lambda: Block, back_populates = 'Intermediatory_nodes', remote_side = lambda: block.c.id), }) How can I make ProofOfWork.blocks and Block.proof_of_works return an _AssociationSet instead of _AssociationList? Cheers, Mark -- 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.