[Zope] Relational Philosophy

[Steve Alexander]

Paul Holman wrote:
> I'm working on writing an app in Zope and would like to try using the 
> Zope object database exclusively.  The problem I run into is how to best 
> go about modeling relational data.  For instance, I might have a list of 
> courses and a list of students.  If I create a course object and put 
> student objects under it, I'll end up with duplicate student objects as 
> students are in more than one course:
> 
> Basketweaving
>     Trent
>     Eve
>     Alice
> Object-Relational Modeling 101
>     Bob
>     Trent
>     Alice
> 
> Obviously if I do it the other way around, and put courses inside 
> student objects, I have the same problem.  I need to do a many-to-many 
> relationship.

Take a look at the Specialist pattern from the ZPatterns documentation.
You don't need to use ZPatterns to use a Specialist pattern.

http://www.zope.org/Members/pje/Wikis/ZPatterns/Specialists

--
Steve Alexander