"creator" is in terms of creating a new association:
Dossier.LesTar = association_proxy("tarifer_dossier", "article_tarife",
creator=lambda art:DossierTarife(article_tarife=art))
ArticleTarife.LesTar = association_proxy("tarifer_dossier", "dossier",
creator=lambda dos:DossierTarife(dossier=dos))
On Mar 28, 2012, at 6:38 AM, Christian Démolis wrote:
> # Many to Many
> class DossierTarife(Base):
> __tablename__ = 'tarifer_dossier'
> IdDossier = Column(Integer, ForeignKey('dossier.IdDossier'),
> primary_key=True)
> IdAt = Column(Integer, ForeignKey('article_tarife.IdAt'),
> primary_key=True)
>
> dossier = relationship(Dossier, backref=backref("tarifer_dossier",
> cascade="all, delete-orphan"))
> article_tarife = relationship(ArticleTarife,
> backref=backref("tarifer_dossier"))
>
> class Dossier(Base):
> __tablename__ = 'dossier'
> IdDossier = Column('IdDossier', Integer, primary_key=True)
> ...
>
> class ArticleTarife(Base):
> __tablename__ = 'article_tarife'
> IdAt = Column('IdAt', Integer, primary_key=True)
> ...
>
> Dossier.LesTar = association_proxy("tarifer_dossier", "article_tarife")
> ArticleTarife.LesTar = association_proxy("tarifer_dossier", "dossier")
>
> I do my simulation with this
> print "====================================="
> d =
> model.session.query(model.Dossier).filter(model.Dossier.IdDossier==500315).first()
> print d.NomDossier, len(d.LesTar), d.LesTar
>
> print "------"
> s =
> model.session.query(model.ArticleTarife).filter(model.ArticleTarife.IdAt==366).first()
>
> if s in d.LesTar:
> d.LesTar.remove(s)
> else:
> d.LesTar.append(s)
> print len(d.LesTar), d.LesTar
>
> common.merge_object(d)
> print s.Nom or s.Valeur
> print s.LesTar
> print "-------------------"
>
>
> print "========================================"
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
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.
