Re: Handling unknown data

2008-06-13 Thread [EMAIL PROTECTED]
Thanks guys... to be a little more clear. Each event will have a x of entrants... probably around 30, but I don't really know In event A, they'll have scores in 3 different scored categories, an overall score, there's a couple of fields about them (name, home, etc). No classes. Event B doesn't h

Re: Handling unknown data

2008-06-13 Thread Rajesh Dhawan
Hi, > I've got an "events" model. One of the things many (but not all) of > the events will have is results. Problem is, I don't know what the > results will look like in terms of rows or columns. > > Event 1 may have three classes, two groups and 40 winners, with 5 > fields for each winner (home

Re: Handling unknown data

2008-06-12 Thread Peter Herndon
Or better yet, normalize first. A given Winner can have one or more Fields, so build a Field model with a ManyToMany relationship to the Winner model, and make it unique=True and asymmetric. Work backwards in a similar chain all the way to Event. On the other hand, that this set of models will

Re: Handling unknown data

2008-06-12 Thread Peter Rowell
> I'd like to store the results for the event, but can't > figure out how. The event object is generic, but the results > structures are specific to that event. What first occurs to me is to give the Event class a TextField called 'results' which contains a pickled python object/dict/list (whatev

Handling unknown data

2008-06-12 Thread [EMAIL PROTECTED]
I've got an "events" model. One of the things many (but not all) of the events will have is results. Problem is, I don't know what the results will look like in terms of rows or columns. Event 1 may have three classes, two groups and 40 winners, with 5 fields for each winner (home state, beer pre