On 3/7/07, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > This shouldn't be too hard to do (it was a fun problem to think about > over lunch). I would create a method on the model that takes a date > (what you are really interested in is the month and year) and returns a > list of the dates in that month when this event occurs. It could even > return copies of itself (or a lighter-weight class) for each date that > it occurs on, with the date set appropriately. > > Then you can select all your active events and concatenate together all > those lists, do a single sort on the date field in Python and you're > done. > > You could be a little more efficient here by not selecting all events > with repeat = 'Y' and just selecting those in the months they are going > to appear (so one query for most repeat types and another query for 'Y' > types). > > With judicious use of list comprehensions, creating all the events for > all dates in a given month should be close to one or two lines of code > (plus the extra model method). The performance should be pretty decent, > too.
It is one of those problems that's just begging me to have a crack at it in IPython, and see what I can come up with. I'm just occupied with other things right now, so I was hoping someone else had already done it :) I'm not quite understanding part of your first paragraph though: "I would create a method on the model that takes a date (what you are really interested in is the month and year) and returns a list of the dates in that month when this event occurs" If the model is taking a date, then what is "this event"? Part of the goal would be to determine *which* events occur in a given month. The second step would be to figure out all the times those events do occur. Given all the events that do occur in a given month, the rest of your steps make sense, but I'm still not sure how I'd find that initial list of events. Thanks, Jay P. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
