Not to dampen your enthusiasm, but this is the response I received from Oleg on the SQLObject mailing list when I asked a similar question:

"This need seems for me so uncommon... You can implement it yourself, though."

Since we're left to implement it ourselves, I would suggest making an explicit join object:

Person -> Call -> PhoneNumber

So a person has a list of calls each of which has a ForeignKey for the PhoneNumber.

I was hoping for a Join type that represented mappings, which seems like a *really* common scenario. If it weren't why would Python have mapping types?

On 1 Nov, 2005, at 9:11 pm, pi wrote:

I would like to create a many-to-many relationship between 2 objects,
but with a little twist. I would like to store a few fields for each
row in the relation.

--
Jeff Watkins
http://metrocat.org/

"Advertising directed at children is inherently deceptive and exploits children under eight years of age."
-- American Academy of Pediatrics

Reply via email to