Re: [Openinteract-help] has_many relationships?

[Vsevolod (S. I. <si...@cs...>]

Ray,

  > When you talk about a "has-many" relationship, I think you are just
> looking at the other end of a has-a relationship, right? To use your=20
> example, a bug has-a project that it belongs to. If I interpret=20
> correctly what it is that you want, you're looking for the ability to=20
> define a relationship that would automatically generate methods in your=
=20
> "software project" object to fetch the corresponding list of bugs, for=20
> example.

And vice versa, I want to be able to fetch the project object that a bug=20
object belongs to.

> If so, I invested some effort a few years ago in defining a generalized=
=20
> relationship configuration syntax which handles this case (as well as=20
> the has-a and links-to). You can find my proposal in the=20
> openinteract-dev archives. The first one [1], posted on 7/3/01 is quite=
=20
> long and spells things out in pretty much detail. The second [2] was=20
> posted in Jan 2002 and includes some additions and updates to the=20
> proposed design.

Chris actually sent me those links a while ago. This approach may be=20
more than I bargained for, but if that's the right solution, I could=20
take a stab at it, provided Chris agrees.

However, after reading your posts it seems to me that you only talk=20
about a many-to-many relationship: you always have X between A and B.
I really want to have a system that can handle simple cases of=20
one-to-one and one-to-many relationships with only two tables/objects,=20
as having three tables is inconvenient from the DBA's point of view and=20
should be avoided when possible.

> At the time, Chris seemed pretty interested in eventually having some=20
> variation of this design included in SPOPS. I've implemented only small=
=20
> pieces of it for my own use and I suspect it just that on Chris's end i=
t=20
> just came down to a shortage of tuits.

[Sun Feb 16 16:20:37 2004] [error] [client 143.48.3.90] error parsing=20
"tuits". Word not in dictionary due to foreign classes in the=20
inheritance tree.

Simon
--=20

Simon (Vsevolod ILyushchenko)   si...@cs...
				http://www.simonf.com

The unknown is honoured, the known is neglected -
                              until all is known.

               The C=FA Chulaind myth