found it out myself.
a commit was missing
thanks for your time
robert
robert rottermann schrieb:
> Hi there,
> I try to grasp relations ..
>
> I have an m:n association between two tables.
>
> this is what I do:
> engine = sa.create_engine('mysql://[EMAIL PROTECTED]/energie_2', echo=True)
> Session = sessionmaker(bind=engine)
> session = Session()
>
> this is what I have:
> tblPersonTable and tblSupplierTable derived from BASE and work fine on
> their own
>
> class User(tblPersonTable):
> suppliers = relation(
> tblSupplierTable,
> secondary=tblPersonSupplierTable.__table__,
> backref='suppliers')
>
>
> def getRecordsForUser():
> supplier = session.query(tblSupplierTable).filter_by(id=12).one()
> user=session.query(User).filter_by(plone_id='johndoe').one()
> user.suppliers.append(supplier)
> session.update(user)
> ...
>
> as you can see User has a relation that connects to Supplier via an
> association table.
> in the above method I get supplier and user as expected.
> user.suppliers has one entry as it should have, so the relation works.
>
> user.suppliers.append(supplier) adds a second supplier.
> now session.update(user) should write a new entry into the association
> table I *think*.
> but it does not.
>
> can somebody give me a hint what I should do to make it happen?
>
> robert
>
> >
>
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
