Hi there. Long-time PHP developer now getting into Python and Django.
I'm using the latest version of Django from SVN and are building a query
that does the following:
Give me all the games where
homeTeam = searchTeam OR awayTeam = searchTeam
AND game_date is between start_date and end_date
ORDER BY game_date, start_date.
Here's the code for it
games = Game.objects.filter(home_team=searchTeam,
game_date__range=(date_form.cleaned_data['startDate'],
date_form.cleaned_data['endDate'])).order_by('game_date', 'start_time') |
Game.objects.filter(away_team=searchTeam,
game_date__range=(date_form.cleaned_data['startDate'],
date_form.cleaned_data['endDate'])).order_by('game_date', 'start_time')
Now, it gets me the desired results but it just looks ugly. I'm wondering
if there is a better way to do this? I spent some time googling around for
answers but didn't find anything that could help me.
Thanks in advance.
--
Chris Hartjes
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
