On Jun 20, 2011, at 1:02 AM, Carlos Mendoza wrote:
> Hi, I want to remove an association in many to many relation, but I
> don't want delete the related objects, just the association.
> If I have:
>
> ProjectUser = Table('PROJECT_USER', metadata,
> Column('id_user', Integer, ForeignKey('USER.id_user')),
> Column('id_project',Integer, ForeignKey('PROJECT.id_project')),
> )
> class Project(DeclarativeBase):
>
> __tablename__ = 'PROJECT'
>
> #{ Columns
>
> id_project = Column(Integer, Sequence('id_project_seq'),
> primary_key=True)
> name = Column(Unicode(25), nullable=False)
> description = Column(Unicode(200), nullable=False)
>
> #{ Relations
> users = relation("Users", secondary=ProjectUser,
> backref=backref('projects',order_by=id_project))
>
> I append a user with:
> aProject.users.append(aUser)
>
> But, if I want to delete this association between aProject and aUser,
> how I must proceed?
When you use "secondary", the contents of the table marked by "secondary" are
managed automatically upon next flush as you append or remove items from the
"users" or "projects" collection, using append(), remove() or other collection
modifiers.
--
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.
