mygpo/data/models.py

   1 from django.db import models
   2 from django.contrib.auth.models import User
   3 from mygpo.api.models import Podcast, Episode, Device
   4
   5 class HistoricPodcastData(models.Model):
   6     podcast = models.ForeignKey(Podcast)
   7     date = models.DateField()
   8     subscriber_count = models.IntegerField()
   9
  10     class Meta:
  11         db_table = 'historic_podcast_data'
  12         unique_together = ('podcast', 'date')
  13
  14
  15 class BackendSubscription(models.Model):
  16     """
  17     Represents the data in the subscriptions table, which
  18     contains all subscriptions, even those for currently deleted devices
  19     """
  20     device = models.ForeignKey(Device)
  21     podcast = models.ForeignKey(Podcast)
  22     user = models.ForeignKey(User)
  23     subscribed_since = models.DateTimeField()
  24
  25     class Meta:
  26         unique_together = ('device', 'podcast', 'user')
  27         db_table = 'subscriptions'
  28
  29
  30 class Listener(models.Model):
  31     device = models.ForeignKey(Device)
  32     user = models.ForeignKey(User)
  33     episode = models.ForeignKey(Episode)
  34     podcast = models.ForeignKey(Podcast)
  35     first_listened = models.DateTimeField()
  36     last_listened = models.DateTimeField()
  37
  38     class Meta:
  39         db_table = 'listeners'
  40         managed = False
  41