web/ldt/ldt_utils/models.py
author ymh <ymh.work@gmail.com>
Sat, 12 Jun 2010 04:25:05 +0200
changeset 0 cc4a51750724
child 5 d42bb045f7d1
permissions -rw-r--r--
first commit
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
0
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
     1
from django.db import models
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
     2
from django.conf import settings
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
     3
from ldt.core.models import Document, Owner
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
     4
from django.utils.translation import ugettext_lazy as _
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
     5
from utils import create_ldt, copy_ldt, create_empty_iri
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
     6
import os
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
     7
import os.path
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
     8
import uuid
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
     9
import xml
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    10
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    11
class Author(models.Model):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    12
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    13
    handle = models.CharField(max_length=512, unique=True, blank=True, null=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    14
    email = models.EmailField(unique=False, blank=True, null=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    15
    firstname = models.CharField(max_length=512, blank=True, null=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    16
    lastname = models.CharField(max_length=512, blank=True, null=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    17
    
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    18
    def __unicode__(self):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    19
        return unicode(self.id) + " - " + self.handle + ", " + self.email + ", " + self.firstname + " " + self.lastname
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    20
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    21
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    22
class Content(models.Model):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    23
    iri_id = models.CharField(max_length=1024, unique=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    24
    iriurl = models.CharField(max_length=1024)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    25
    src = models.CharField(max_length=1024)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    26
    videopath = models.CharField(max_length=1024, null=True, blank=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    27
    creation_date = models.DateTimeField(auto_now_add=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    28
    update_date = models.DateTimeField(auto_now=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    29
    title = models.CharField(max_length=1024, null=True, blank=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    30
    description = models.TextField(null=True, blank=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    31
    external_id = models.CharField(max_length=1024, null=True, blank=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    32
    authors = models.ManyToManyField(Author, blank=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    33
    duration = models.IntegerField(null=True, blank=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    34
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    35
    def get_duration(self):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    36
        if self.duration is None:
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    37
            doc = xml.dom.minidom.parse(self.iri_file_path())
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    38
            doc = Ft.Xml.Domlette.ConvertDocument(doc)        
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    39
            con = xml.xpath.Context.Context(doc, 1, 1, None)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    40
            res = xml.xpath.Evaluate("/iri/body/medias/media[@id='video']/video", context=con)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    41
            self.duration = int(res[0].getAttributeNS(None, u'dur'))
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    42
            self.save()
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    43
        return self.duration
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    44
    
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    45
    def delete(self):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    46
        super(Content, self).delete()
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    47
        writer = lucene.IndexWriter(STORE, ANALYZER, True, lucene.IndexWriter.MaxFieldLength.UNLIMITED)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    48
        writer.deleteDocuments(lucene.Term("iri_id", self.iri_id))
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    49
        writer.commit()
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    50
        
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    51
    def save(self):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    52
        # create iri file if needed
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    53
        try:
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    54
            iri_file_path = self.iri_file_path()
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    55
            if not os.path.exists(iri_file_path):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    56
                dir = os.path.dirname(iri_file_path)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    57
                if not os.path.exists(dir):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    58
                    os.makedirs(dir)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    59
                file = open(iri_file_path,"w")
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    60
                create_empty_iri(file, self, "IRI")
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    61
        except Exception, e:
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    62
            if os.path.exists(iri_file_path):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    63
                os.remove(iri_file_path)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    64
                raise e
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    65
        # update it 
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    66
        super(Content, self).save()
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    67
    
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    68
    def __unicode__(self):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    69
        return str(self.id) + ": " + self.iri_id
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    70
        
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    71
    def iri_url(self, web_url=settings.WEB_URL):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    72
        if 'http' in self.iriurl or 'https' in self.iriurl:
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    73
            return self.iriurl
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    74
        else:
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    75
            return unicode(web_url) + unicode(settings.MEDIA_URL)+u"media/ldt/"+unicode(self.iriurl)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    76
    
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    77
    def iri_file_path(self):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    78
        return os.path.join(os.path.join(os.path.join(os.path.join(settings.MEDIA_ROOT, "media"), "ldt"), self.iri_id), os.path.basename(self.iriurl))
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    79
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    80
    def iri_url_template(self):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    81
        return "${web_url}${media_url}media/ldt/" + unicode(self.iri_id) + "/" + os.path.basename(self.iriurl)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    82
        
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    83
        
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    84
class Project(Document):  
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    85
    STATE_CHOICES=(
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    86
    (1, 'edition'),
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    87
    (2, 'published'),
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    88
    (3, 'moderated'),
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    89
    (4, 'rejected'),
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    90
    (5, 'deleted')
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    91
    )
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    92
    ldt_id = models.CharField(max_length=1024, unique=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    93
    ldt = models.TextField(null=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    94
    title = models.CharField(max_length=1024)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    95
    contents = models.ManyToManyField(Content)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    96
    creation_date = models.DateTimeField(auto_now_add=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    97
    modification_date = models.DateTimeField(auto_now=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    98
    created_by = models.CharField(_("created by"), max_length=70)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
    99
    changed_by = models.CharField(_("changed by"), max_length=70)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   100
    state = models.IntegerField(choices=STATE_CHOICES, default=1)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   101
    
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   102
    def __unicode__(self):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   103
        return unicode(self.id) + u": " + unicode(self.ldt_id)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   104
    
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   105
    def get_description(self, doc=None):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   106
        
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   107
        if doc is None:
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   108
            doc = xml.dom.minidom.parseString(self.ldt)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   109
            doc = Ft.Xml.Domlette.ConvertDocument(doc)        
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   110
        
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   111
        con = xml.xpath.Context.Context(doc, 1, 1, None)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   112
        res = xml.xpath.Evaluate("/iri/project", context=con)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   113
        if len(res) > 0:
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   114
            return res[0].getAttributeNS(None, u'abstract')
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   115
        else:
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   116
            return None
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   117
        
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   118
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   119
    @staticmethod
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   120
    def create_project(user, title, contents):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   121
        owner = Owner.objects.get(user=user)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   122
        project = Project(title=title, owner=owner)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   123
        project.ldt_id = str(uuid.uuid1())
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   124
        project.created_by=user.username
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   125
        project.changed_by=user.username
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   126
        project.state = 1
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   127
        project.save()
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   128
        for content in contents:
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   129
            project.contents.add(content)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   130
        project.save()
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   131
        return create_ldt(project, user)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   132
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   133
    def copy_project(self, user, title):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   134
        owner = Owner.objects.get(user=user)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   135
        project = Project(title=title, owner=owner)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   136
        project = copy_ldt(self, project, user)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   137
        project.save()
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   138
        for content in self.contents.all():
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   139
            project.contents.add(content)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   140
        project.save()
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   141
        return project
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   142
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   143
class Segment(models.Model):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   144
    
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   145
    project_obj = models.ForeignKey(Project, null=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   146
    content = models.ForeignKey(Content)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   147
    project_id = models.CharField(max_length=1024, unique=False, blank=True, null=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   148
    iri_id = models.CharField(max_length=1024, unique=False)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   149
    ensemble_id = models.CharField(max_length=1024, unique=False)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   150
    cutting_id = models.CharField(max_length=1024, unique=False)    
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   151
    element_id = models.CharField(max_length=1024, unique=False)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   152
    tags = models.CharField(max_length=2048, unique=False, null=True, blank=True)  
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   153
    title = models.CharField(max_length=2048, unique=False, null=True, blank=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   154
    duration = models.IntegerField(null=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   155
    start_ts = models.IntegerField(null=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   156
    author = models.CharField(max_length=1024, unique=False, null=True, blank=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   157
    date = models.CharField(max_length=128, unique=False, null=True, blank=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   158
    abstract = models.TextField(null=True, blank=True)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   159
    
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   160
    def __unicode__(self):
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   161
        return "/".join((unicode(self.project_id), unicode(self.iri_id), unicode(self.ensemble_id), unicode(self.cutting_id), unicode(self.element_id)))
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   162
    
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   163
    class Meta:
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   164
        unique_together = (('project_id', 'iri_id', 'ensemble_id', 'cutting_id', 'element_id'),)
cc4a51750724 first commit
ymh <ymh.work@gmail.com>
parents:
diff changeset
   165