On Aug 6, 4:05 pm, "Michael Bayer" <mike...@zzzcomputing.com> wrote:
> allen.fowler wrote:
>
> >> I tried:
>
> >> children = relation("Node", backref=backref("parent",
> >> remote_side="nodes.id"))
>
> > got it to work with:
>
> > remote_side=[id]
>
> > But:
>
> > 1) Why is remote_side a list?
>
> in this case you could just say remote_side=id. its optionally a list if
> multiple columns occur on the "remote side" of the join condition (i.e. as
> in a composite primary key).
>
> > 2) Where does single_parent fit in to this?
>
> single_parent is a flag that gets suggested to you if you attempt to use
> "delete-orphan" cascade with a many-to-one or many-to-many foreign key
> combination (meaning they are essentially distilled into "one-to-one" or
> "one-to-many"). it's basically requiring you to sign the agreement "I
> promise not to connect this object to more than one parent of this type so
> that delete-orphan does what's advertised". if it hasn't been suggested
> to you, there's no need to use it (unless you want to enforce that
> contract otherwise).
Thank you for the clarification, Mike.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
