django unique for each date

Question

Hello First of all let me show you my model:

class ChannelStatus(models.Model):

        channel = models.ForeignKey(Channel,unique_for_date="date")

        date = models.DateField()

        platform = models.ManyToManyField(Platform)

Right now, when I want to make an ChannelStatus entry, there cant be more than one entry which is the same channel and the date.Now, I want to change this as the uniquess of each channel to the date for each platform, so different platforms can have several same channel with same date. How can I achieve this ?

Answer 1

Ok, what about this. (Untested code.)

class ChannelStatus(models.Model):

        channel = models.ForeignKey(Channel)

        date = models.DateField()
        class Meta:
            unique_together = ('channel', 'date')



class ChannelM2M(models.Model):
    channel_status = models.ForeignKey(Channel)
    platform = models.ForeignKey(Platform, unique = True)

[Old answer]

 class Meta:
    unique_together = ('channel', 'date', 'platform')

Btw, I would change the name of the second field from date, one you are working with datetime, and sometime do from datetime import date, you are going to get bitten