Greetings, I've tried doing the following using ordering_list for many to many relations but it didn't work:
post_table = Table('posts', metadata,
Column('id', Integer, primary_key=True),
Column('headline', String(255), nullable=False),
Column('body', String)
)
post_keywords = Table('post_keywords', metadata,
Column('post_id', Integer, ForeignKey('posts.id')),
Column('keyword_id', Integer, ForeignKey('keywords.id')),
Column('position', Integer))
keywords_table = Table('keywords', metadata,
Column('id', Integer, primary_key=True),
Column('keyword', String(50), nullable=False, unique=True))
mapper(Keyword, keywords_table)
mapper(BlogPost, post_table, properties={
'keywords':relation(Keyword, secondary=post_keywords,
collection_class=ordering_list('position'),
order_by=[post_keywords.c.position] )
})
...
bp = BlogPost('head', 'body')
bp.keywords = [Keyword('k0'), Keyword('k1')]
session.save(bp)
session.flush()
For what I could see in the docs, this extension only works for one to many
relations.
Is there something like the ordering_list extension that works in many to many
relations?
--
Fernando J. Zunino
Zauber S.A.
http://www.zauber.com.ar/
signature.asc
Description: OpenPGP digital signature
