CODEWITHSUNDEEP
djangodjango-modelsmodeldays
nnachefski
nnachefski

Reputation: 1562

django days-of-week representation in model

I have this "Jobs Server" model that i'm building. I want to include a field that will save which days of the week this job will run on. Ultimately in the UI, i would like the user to be able to have a series of check boxes(one for each day) that they can select. What would be the best way to represent this "days-of-week" data in my mode?

class Job(models.Model):
    name = models.CharField(max_length=32, unique=True)
    package = models.ForeignKey(Package)
    binary = models.ForeignKey(Binary)
    host = models.ForeignKey(Host)
    colo = models.ForeignKey(Location)
    group = models.ForeignKey(Group)
    type = models.ForeignKey(Type)
    start = models.TimeField()
    end = models.TimeField()
    days = ?

Upvotes: 18

Views: 23684

Answers (4)

MUY Belgium
MUY Belgium

Reputation: 2452

You may want to create DayOfTheWeek field type, which you can improve in various ways.

This will translate automatically into the local language using the multilingual tools.

#myFields.py
from django.utils.translation import gettext as _
# Import from models
# from django.db.models import CharField 

DAY_OF_THE_WEEK = {
    '1': _(u'Monday'),
    '2': _(u'Tuesday'),
    '3': _(u'Wednesday'),
    '4': _(u'Thursday'),
    '5': _(u'Friday'),
    '6': _(u'Saturday'), 
    '7': _(u'Sunday'),
}

class DayOfTheWeekField(models.CharField):
    def __init__(self, *args, **kwargs):
        kwargs['choices'] = tuple(sorted(DAY_OF_THE_WEEK.items()))
        kwargs['max_length'] = 1 
        super(DayOfTheWeekField,self).__init__(*args, **kwargs)

#models.py
import myFields
(..)
    dayOfTheWeek = myFields.DayOfTheWeekField()
(..)

Upvotes: 26

Regneel
Regneel

Reputation: 114

Just implemented django-weekday-field. Works great! Hopefully this helps other people who stumble upon this question

EDIT: updated link to pypi since the bitbucket repo was deleted.

It hasn't been updated since 2014 but looking at the code is a great way to get started on answering this question

Upvotes: 0

silent1mezzo
silent1mezzo

Reputation: 2932

Something like this would work. 

#models.py
DAYS_OF_WEEK = (
    (0, 'Monday'),
    (1, 'Tuesday'),
    (2, 'Wednesday'),
    (3, 'Thursday'),
    (4, 'Friday'),
    (5, 'Saturday'),
    (6, 'Sunday'),
)

days = models.CharField(max_length=1, choices=DAYS_OF_WEEK

#forms.py
widgets = { 'days': forms.CheckboxSelectMultiple }

Or to save multiple days

#models.py
class Days(models.Model):
    day = models.CharField(max_length=8)

days = models.ManyToManyField(Days)

#forms.py
widgets = { 'days': forms.CheckboxSelectMultiple }

Upvotes: 23

Bryce Siedschlaw
Bryce Siedschlaw

Reputation: 4226

If you want a checkbox for each one, then the easiest thing to do is to create BooleanFields for each of them. If you want to store it as a more complex value (eg. comma separated list or something), create your own widget and play with javascript, then you could go that route.

Upvotes: 4

Related Questions