[Zope] [ADVANCED] How do YOU guys do many-to-many in Zope without relational?

[Thomas B. Passin]

Good job in explaining some places where relational databases are strong.

Tom P

[Max M]

> I am in the situation where I have to do what corresponds to a
many-to-many
> relation in Zope.
>
> I basically have two zClassses. students and subjects. There can be many
> subjects, and in any subject there can be any number of students.
>
> What I do now is having a studentlist under each subject. But this doesn't
> really work because any single student can belong to any number of
subjects.
>
> So if this was an ordinary relational db it would be many to many.
>
> Now I considder making a global student list and then do a recursive
search
> for subjects in the site, so that each student can be related to a subject
> with a selectbox or somesuch.
>
> But if someone renames, deletes or moves a subject I am f.*?d Or the
student
> is. The relation to the subject is invalidated.
>
> I have never seen it used, but would it be possible to store the "global
> object id" in a list in a user object, and then get the path to the
subject
> object from that?
>
> Or should I make the subject a global list to? That way I only have to
check
> if the object exists or not. Not where it is in the object hierachy.
>
> This sort of defeats the purpose of Zope's tree like structure. Doesn't
it?
>
> So, how do YOU guys do many-to-many in Zope ?
>