auf_savoirs_en_partage/savoirs/models.py

   1 # -*- encoding: utf-8 -*-
   2 from django.db import models
   3 import uuid, datetime
   4 from timezones.fields import TimeZoneField
   5
   6
   7 class Discipline(models.Model):
   8     id = models.IntegerField(primary_key=True, db_column='id_discipline')
   9     nom = models.CharField(max_length=765, db_column='nom_discipline')
  10
  11     def __unicode__ (self):
  12         return self.nom
  13
  14     class Meta:
  15         db_table = u'discipline'
  16         ordering = ["nom",]
  17
  18 class SourceActualite(models.Model):
  19     nom = models.CharField(max_length=255)
  20     url = models.CharField(max_length=255)
  21
  22 class Actualite(models.Model):
  23     id = models.AutoField(primary_key=True, db_column='id_actualite')
  24     titre = models.CharField(max_length=765, db_column='titre_actualite')
  25     texte = models.TextField(db_column='texte_actualite')
  26     url = models.CharField(max_length=765, db_column='url_actualite')
  27     logo = models.CharField(max_length=765, db_column='logo_actualite')
  28     date = models.DateField(db_column='date_actualite')
  29     visible = models.CharField(max_length=3, db_column='visible_actualite')
  30     ancienid = models.IntegerField(db_column='ancienId_actualite')
  31
  32     def __unicode__ (self):
  33         return "Actualite %d: %s" % (self.id, self.titre)
  34
  35     class Meta:
  36         db_table = u'actualite'
  37         ordering = ["-date",]
  38
  39
  40 class ActiveManager(models.Manager):
  41     def get_query_set(self):
  42         return super(ActiveManager, self).get_query_set().filter(actif=True)
  43
  44 class Evenement(models.Model):
  45     actif = models.BooleanField(default = True)
  46     uid = models.CharField(max_length = 255, default = uuid.uuid1)
  47     approuve = models.BooleanField(default = False)
  48     titre = models.CharField(max_length=255)
  49     discipline = models.ForeignKey('Discipline', related_name = "discipline",
  50                                    blank = True, null = True)
  51     discipline_secondaire = models.ForeignKey('Discipline', related_name = \
  52                                               "discipline_secondaire",
  53                                               verbose_name = \
  54                                               "Discipline secondaire",
  55                                               blank = True, null = True)
  56     mots_cles = models.TextField('Mots-Clés', blank = True, null = True)
  57     type = models.CharField(max_length = 255, choices = \
  58                             (('Colloque', 'Colloque'),
  59                              ('Conférence', 'Conférence'),
  60                              ('Appel à contribution', 'Appel à contribution'),
  61                              ('Journée d\'étude', 'Journée d\'étude'),
  62                              (None, 'Autre')
  63                             )) #TODO: choices
  64     fuseau = TimeZoneField(verbose_name = 'Fuseau horaire')
  65     debut = models.DateTimeField(default = datetime.datetime.now)
  66     fin = models.DateTimeField(default = datetime.datetime.now)
  67     lieu = models.TextField()
  68     description = models.TextField(blank = True, null = True)
  69     #fichiers = TODO?
  70     contact = models.TextField(blank = True, null = True)
  71     url = models.CharField(max_length=255, blank = True, null = True)
  72
  73     objects = ActiveManager()
  74
  75
  76 class Record(models.Model):
  77     id = models.AutoField(primary_key = True)
  78     title = models.TextField(null = True, blank = True)
  79     alt_title = models.TextField(null = True, blank = True)
  80     creator = models.TextField(null = True, blank = True)
  81     description = models.TextField(null = True, blank = True)
  82     abstract = models.TextField(null = True, blank = True)
  83     creation = models.CharField(max_length = 255, null = True, blank = True)
  84     issued = models.CharField(max_length = 255, null = True, blank = True)
  85     modified = models.CharField(max_length = 255, null = True, blank = True)
  86     identifier = models.CharField(max_length = 255, null = True, blank = True, unique = True)
  87     isbn = models.TextField(null = True, blank = True)
  88     uri = models.CharField(max_length = 255, null = True, blank = True, unique = True)
  89     source = models.TextField(null = True, blank = True)
  90     contributor = models.TextField(null = True, blank = True)
  91     subject = models.TextField(null = True, blank = True)
  92     publisher = models.TextField(null = True, blank = True)
  93     type = models.TextField(null = True, blank = True)
  94     format = models.TextField(null = True, blank = True)
  95     language = models.TextField(null = True, blank = True)
  96     orig_lang = models.TextField(null = True, blank = True)
  97
  98     def __unicode__(self):
  99         return "<R %s, %s>" % (self.id, self.subject)
 100
 101 class HarvestLog(models.Model):
 102     name = models.CharField(max_length = 255, primary_key = True)
 103     date = models.DateTimeField(auto_now = True)
 104     count = models.IntegerField(null = True, blank = True)