Models for store opening times

models.py

from django.db import models
from django.utils.translation import ugettext_lazy as _


class WeekdayOpeningPeriod(models.Model):

    store = models.ForeignKey('stores.Store', related_name='opening_periods')

    SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY = range(7)
    weekday_choices = (
        (SUNDAY, _("Sunday")),
        (MONDAY, _("Monday")),
        (TUESDAY, _("Tuesday")),
        (WEDNESDAY, _("Wednesday")),
        (THURSDAY, _("Thursday")),
        (FRIDAY, _("Friday")),
        (SATURDAY, _("Saturday")),
    )
    weekday = models.PositiveIntegerField(choices=weekday_choices)
    start = models.TimeField()
    end = models.TimeField()


class OpeningHoursOverride(models.Model):
    """
    Override the opening hours for a given date
    """
    store = models.ForeignKey('stores.Store', related_name='opening_periods')
    date = models.DateField()
    start = models.TimeField()
    end = models.TimeField()

    # Explain why normal hours are being overridden
    description = models.TextField()


# To determine normal opening hours:
# 1. fetch all WeekdayOpeningPeriods ordered by weekday
# 2. fetch any OpeningHoursOverrides that occurs in the next x weeks
# 3. render this information

# To determine is a store is open at a given datetime:
# 1. look for override for date in question that covers datetime
# 2. if nothing, look for weekday opening for today