Here's a brief description of what I'm trying to do:
I have a database of businesses and I want to let the business owners
enter their hours of operation. In order to normalize the display of
the hours I've decided to have owners enter hours for each day. This
represents a one (business) to many (hours) relationship.
The way my models are below (abbreviated for clarity) the hours don't
show up in the business detail of the "Businesses" section in the
admin application but the hours do show in the "Hours" section of the
admin application.
If there's a better way to model this or handle this relationship I'd
be happy to hear it.
I'm also unclear how I'd display them in a template since they'd
probably be passed to the template as something like a dictionary.
Thanks in advance for any help.
class Business(models.Model):
id = models.AutoField(primary_key=True)
business_name = models.CharField(maxlength=255)
phone = models.CharField(maxlength=12, blank=True)
email = models.CharField(maxlength=100, blank=True)
url = models.URLField("URL", maxlength=100, blank=True)
def __str__(self):
return self.business_name
class Hours(models.Model):
""" Defines the hours a store is open or closed """
AM_PM_CHOICES = (
('A', 'AM'),
('P', 'PM'),
)
DAY_CHOICES = (
(1, 'Monday'),
(2, 'Tuesday'),
...
)
business = models.ForeignKey(Business, db_column='business_id')
day = models.IntegerField(maxlength=1, blank=True,
choices=DAY_CHOICES)
open_time = models.IntegerField(maxlength=2, blank=True)
open_ap = models.CharField("Open Time AM/PM", maxlength=1,
blank=True, choices=AM_PM_CHOICES, default='A')
close_time = models.IntegerField(maxlength=2, blank=True)
close_ap = models.CharField("Close Time AM/PM", maxlength=1,
blank=True, choices=AM_PM_CHOICES, default='P')
closed = models.BooleanField(default=True, blank=True)
def __str__(self):
...
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
