Hello Everyone:
I am trying my luck with django again, and I found a way to show a
list of related objects in a many-to-many relationship, using the
following model and view:
Model
# Flight Frequency
class Frequency(models.Model):
day_translated = {'Sa': 'Saturday', 'Su': 'Sunday', 'Mo': 'Monday',
'Tu': 'Tuesday', 'We': 'Wednesday', 'Th': 'Thursday', 'Fr': 'Friday'}
days = models.CharField('Frequency', maxlength=2)
def __str__(self):
return self.day_translated[self.days];
# Flight Schedule
class Schedule(models.Model):
flightNumber = models.CharField('Flight', maxlength=20)
from_city = models.ForeignKey(Destination, related_name='From',
verbose_name='Origin')
to_city = models.ForeignKey(Destination, related_name='To',
verbose_name='Destination')
airline = models.ForeignKey(Airline)
departs = models.TimeField(help_text='All times are local')
arrives = models.TimeField(help_text='All times are local')
from_date = models.DateField('Valid From', blank=True, null=True)
till_date = models.DateField('Valid Till', blank=True, null=True)
freq =
models.ManyToManyField(Frequency,filter_interface=models.HORIZONTAL,
verbose_name='Occurance')
def __str__(self):
return 'Flight '+self.flightNumber
class Admin:
list_display = ('flightNumber','from_city','to_city','airline',
'departs', 'arrives')
list_filter = ['freq','from_city','to_city',
'departs','arrives']
search_fields = ['from_city','to_city','freq']
View:
def index(request):
flight_list = Schedule.objects.all().order_by('-departs')
output = '<table border="0"
width="50%"><tr><td>Flight</td><td>Airline</td><td>Frequency</td></tr>'
for fl in flight_list:
output = output + '<tr><td>' + fl.flightNumber + '</td><td>'
output = output + fl.airline.aname + '</td><td>'
foo = fl.freq.all().values()
for x in foo:
output = output + ' ' + x['days']
output = output + '</td></tr>'
output = output + '</table>'
return HttpResponse(output)
Now this does work, but is there a better way to get the same result?
The way I did it seems a bit of a hack.
Thanks
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---
