src/p4l/models/data.py
changeset 13 6296aa12fd71
parent 10 c4e7d66b7dc2
child 14 52fa6990e0bb
equal deleted inserted replaced
12:57efd01f1715 13:6296aa12fd71
     9     imprintCity = models.CharField(max_length=512, blank=True, null=True, db_index=True)
     9     imprintCity = models.CharField(max_length=512, blank=True, null=True, db_index=True)
    10     publisher = models.CharField(max_length=512, blank=True, null=True, db_index=True)
    10     publisher = models.CharField(max_length=512, blank=True, null=True, db_index=True)
    11     imprintDate = models.CharField(max_length=512, blank=True, null=True, db_index=True)    
    11     imprintDate = models.CharField(max_length=512, blank=True, null=True, db_index=True)    
    12 
    12 
    13 
    13 
    14 class Serie(P4lModel):
    14 class Serie(P4lModelLang):
       
    15     record = models.ForeignKey('p4l.Record', related_name="series")
    15     title = models.CharField(max_length=2048, blank=False, null=False, db_index=True)
    16     title = models.CharField(max_length=2048, blank=False, null=False, db_index=True)
    16     volume = models.CharField(max_length=2048, blank=True, null=True, db_index=True)
    17     volume = models.CharField(max_length=2048, blank=True, null=True, db_index=True)
    17     class Meta(P4lModel.Meta):
       
    18         unique_together = ['title', 'volume']
       
    19 
       
    20 class RecordSerie(P4lModelLang):
       
    21     record = models.ForeignKey('p4l.Record', related_name="series+")
       
    22     serie = models.ForeignKey('p4l.Serie', related_name="records")
       
    23     class Meta(P4lModelLang.Meta):
       
    24         unique_together = ['record','serie']
       
    25 
       
    26 
    18 
    27 
    19 
    28 class ProjectName(P4lModel):
    20 class ProjectName(P4lModel):
    29     label = models.CharField(max_length=2048, blank=False, null=False, db_index=True)
    21     label = models.CharField(max_length=2048, blank=False, null=False, db_index=True)
    30     acronym = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:acronym
    22     acronym = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:acronym
    31     class Meta(P4lModel.Meta):
    23     class Meta(P4lModel.Meta):
    32         unique_together = ['label', 'acronym']
    24         unique_together = ['label', 'acronym']
    33 
    25 
    34 
    26 
    35 class CorporateAuthor(P4lModel):
    27 class CorporateAuthor(P4lModel):
       
    28     record = models.ForeignKey('p4l.Record', related_name="corporateAuthors", db_index=True)
    36     label = models.CharField(max_length=2048, blank=False, null=False, db_index=True)
    29     label = models.CharField(max_length=2048, blank=False, null=False, db_index=True)
    37     acronym = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:acronym
    30     acronym = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:acronym
    38     class Meta(P4lModel.Meta):
       
    39         unique_together = ['label', 'acronym']
       
    40 
    31 
    41 
    32 
    42 class Url(P4lModel):
    33 class Url(P4lModel):
    43     record = models.ForeignKey('p4l.Record', related_name="urls")
    34     record = models.ForeignKey('p4l.Record', related_name="urls", db_index=True)
    44     address = models.CharField(max_length=2048, blank=False, null=False, db_index=True) #iiep:address
    35     address = models.CharField(max_length=2048, blank=False, null=False, db_index=True) #iiep:address
    45     display = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:display
    36     display = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:display
    46     accessLevel = models.CharField(max_length=512, blank=True, null=True, db_index=True) #iiep:accessLevel
    37     accessLevel = models.CharField(max_length=512, blank=True, null=True, db_index=True) #iiep:accessLevel
    47 
    38 
    48 
    39 
    59     country = models.URLField(max_length=2048, unique=True, db_index=True)
    50     country = models.URLField(max_length=2048, unique=True, db_index=True)
    60     label = models.CharField(max_length=2048, blank=True, null=True, db_index=True) # filled from sparql request after import
    51     label = models.CharField(max_length=2048, blank=True, null=True, db_index=True) # filled from sparql request after import
    61 
    52 
    62 
    53 
    63 class Isbn(P4lModelLang):
    54 class Isbn(P4lModelLang):
    64     record = models.ForeignKey('p4l.Record', related_name="isbns")
    55     record = models.ForeignKey('p4l.Record', related_name="isbns", db_index=True)
    65     isbn = models.CharField(max_length=128) #iiep:isbn
    56     isbn = models.CharField(max_length=128) #iiep:isbn
    66 
    57 
    67 
    58 
    68 class Issn(P4lModelLang):
    59 class Issn(P4lModelLang):
    69     record = models.ForeignKey('p4l.Record', related_name="issns")
    60     record = models.ForeignKey('p4l.Record', related_name="issns", db_index=True)
    70     issn = models.CharField(max_length=128) #iiep:issn
    61     issn = models.CharField(max_length=128) #iiep:issn
    71 
    62 
    72 class DocumentCode(P4lModelLang):
    63 class DocumentCode(P4lModelLang):
    73     record = models.ForeignKey('p4l.Record', related_name="documentCodes")
    64     record = models.ForeignKey('p4l.Record', related_name="documentCodes", db_index=True)
    74     documentCode = models.CharField(max_length=128) #iiep:issn
    65     documentCode = models.CharField(max_length=128) #iiep:issn
    75 
    66 
    76 class Language(P4lModel):
    67 class Language(P4lModel):
    77     language = models.URLField(max_length=2048, unique=True, db_index=True)
    68     language = models.URLField(max_length=2048, unique=True, db_index=True)
    78     label = models.CharField(max_length=2048, blank=True, null=True, db_index=True) # filled from sparql request after import
    69     label = models.CharField(max_length=2048, blank=True, null=True, db_index=True) # filled from sparql request after import
    83     title = models.CharField(max_length=2048, blank=False, null=False, db_index=True)
    74     title = models.CharField(max_length=2048, blank=False, null=False, db_index=True)
    84     class Meta(P4lModelLang.Meta):
    75     class Meta(P4lModelLang.Meta):
    85         abstract = True
    76         abstract = True
    86 
    77 
    87 class Title(BaseTitle):
    78 class Title(BaseTitle):
    88     record = models.ForeignKey('p4l.Record', related_name="titles")
    79     record = models.ForeignKey('p4l.Record', related_name="titles", db_index=True)
    89 
    80 
    90 class AddedTitle(BaseTitle):
    81 class AddedTitle(BaseTitle):
    91     record = models.ForeignKey('p4l.Record', related_name="addedTitles")
    82     record = models.ForeignKey('p4l.Record', related_name="addedTitles", db_index=True)
    92 
    83 
    93 class TitleMainDocument(BaseTitle):
    84 class TitleMainDocument(BaseTitle):
    94     record = models.ForeignKey('p4l.Record', related_name="titlesMainDocument")
    85     record = models.ForeignKey('p4l.Record', related_name="titlesMainDocument", db_index=True)
    95 
    86 
    96 
    87 
    97 class Abstract(P4lModelLang):
    88 class Abstract(P4lModelLang):
    98     record = models.ForeignKey('p4l.Record', related_name="abstracts")
    89     record = models.ForeignKey('p4l.Record', related_name="abstracts", db_index=True)
    99     abstract = models.TextField(blank=True, null=True)
    90     abstract = models.TextField(blank=True, null=True)
   100 
    91 
   101 
    92 
   102 class Collation(P4lModelLang):
    93 class Collation(P4lModelLang):
   103     record = models.ForeignKey('p4l.Record', related_name="collations")
    94     record = models.ForeignKey('p4l.Record', related_name="collations", db_index=True)
   104     collation = models.CharField(max_length=1024, blank=False, null=False, db_index=True)
    95     collation = models.CharField(max_length=1024, blank=False, null=False, db_index=True)
   105 
    96 
   106 
    97 
   107 class VolumeIssue(P4lModelLang):
    98 class VolumeIssue(P4lModelLang):
   108     record = models.ForeignKey('p4l.Record', related_name="volumeIssues")
    99     record = models.ForeignKey('p4l.Record', related_name="volumeIssues", db_index=True)
   109     volume = models.CharField(max_length=1024, blank=True, null=True, db_index=True) #iiep:volume
   100     volume = models.CharField(max_length=1024, blank=True, null=True, db_index=True) #iiep:volume
   110     number = models.CharField(max_length=1024, blank=True, null=True, db_index=True) #iiep:number
   101     number = models.CharField(max_length=1024, blank=True, null=True, db_index=True) #iiep:number
   111 
   102 
   112 
   103 
   113 class P4lPerson(P4lModel):
   104 class P4lPerson(P4lModel):
   114     name = models.CharField(max_length=2048, blank=False, null=False, db_index=True, unique=True)
   105     name = models.CharField(max_length=2048, blank=False, null=False, db_index=True)
   115     class Meta(P4lModel.Meta):
   106     class Meta(P4lModel.Meta):
   116         abstract = True
   107         abstract = True
   117 
   108 
   118 
   109 
   119 class Author(P4lPerson):
   110 class Author(P4lPerson):
   120     pass
   111     record = models.ForeignKey('p4l.Record', related_name="authors", db_index=True)
   121     
   112     
   122 class SubjectPerson(P4lPerson):
   113 class SubjectPerson(P4lPerson):
   123     pass
   114     record = models.ForeignKey('p4l.Record', related_name="subjectPersons", db_index=True)
   124 
   115 
   125 
   116 class Periodical(P4lModelLang):
   126 class Periodical(P4lModel):
   117     record = models.ForeignKey('p4l.Record', related_name="periodicals", db_index=True)
   127     label = models.CharField(max_length=2048, blank=False, null=False, db_index=True, unique=True) #iiep:periodical
   118     label = models.CharField(max_length=2048, blank=False, null=False, db_index=True) #iiep:periodical
   128 
       
   129 class RecordPeriodical(P4lModelLang):
       
   130     record = models.ForeignKey('p4l.Record', related_name="periodicals+")
       
   131     periodical = models.ForeignKey('p4l.Periodical', related_name="records")
       
   132     class Meta(P4lModelLang.Meta):
       
   133         unique_together = ['record','periodical']
       
   134 
   119 
   135 
   120 
   136 class BaseMeeting(P4lModel):
   121 class BaseMeeting(P4lModel):
   137     label = models.CharField(max_length=2048, blank=False, null=False, db_index=True) #rdfs:label
   122     label = models.CharField(max_length=2048, blank=False, null=False, db_index=True) #rdfs:label
   138     meetingNumber = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:meetingNumber
   123     meetingNumber = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:meetingNumber
   139     meetingPlace = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:meetingPlace
   124     meetingPlace = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:meetingPlace
   140     meetingDate = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:meetingDate
   125     meetingDate = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:meetingDate
   141     meetingYear = models.PositiveSmallIntegerField(blank=True, null=True, db_index=True) #iiep:meetingYear
   126     meetingYear = models.PositiveSmallIntegerField(blank=True, null=True, db_index=True) #iiep:meetingYear
   142     class Meta(P4lModel.Meta):
   127     class Meta(P4lModel.Meta):
   143         abstract = True
   128         abstract = True
   144         unique_together = ['label', 'meetingNumber', 'meetingPlace', 'meetingDate', 'meetingYear']
       
   145 
   129 
   146 
   130 
   147 class Meeting(BaseMeeting):
   131 class Meeting(BaseMeeting):
   148     pass
   132     lang = models.CharField(max_length=15, blank=True, null=True, db_index=True) #@xml:lang
   149 
   133     record = models.ForeignKey('p4l.Record', related_name="meetings")
   150 class RecordMeeting(P4lModelLang):
       
   151     record = models.ForeignKey('p4l.Record', related_name="meetings+")
       
   152     meeting = models.ForeignKey('p4l.Meeting', related_name="records")
       
   153     class Meta(P4lModelLang.Meta):
       
   154         unique_together = ['record','meeting']
       
   155 
   134 
   156 
   135 
   157 class SubjectMeeting(BaseMeeting):
   136 class SubjectMeeting(BaseMeeting):
   158     pass
   137     record = models.ForeignKey('p4l.Record', related_name="subjectMeetings", db_index=True)
   159 
   138 
   160 
   139 
   161 class CorporateBody(P4lModel):
   140 class CorporateBody(P4lModel):
   162     label = models.CharField(max_length=2048, blank=False, null=False, db_index=True) #rdfs:label
   141     label = models.CharField(max_length=2048, blank=False, null=False, db_index=True) #rdfs:label
   163     acronym = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:acronym
   142     acronym = models.CharField(max_length=2048, blank=True, null=True, db_index=True) #iiep:acronym
   175     #isbns foreign key from Isbn #iiep:isbn
   154     #isbns foreign key from Isbn #iiep:isbn
   176     #documentCodes foreign key from Isbn #iiep:documentCode
   155     #documentCodes foreign key from Isbn #iiep:documentCode
   177     language = models.ForeignKey('p4l.Language', blank=True, null=True) #dct:language                                    # Language
   156     language = models.ForeignKey('p4l.Language', blank=True, null=True) #dct:language                                    # Language
   178     otherLanguages = models.ManyToManyField('p4l.Language', related_name='otherLanguage_record') #iiep:otherLanguage     # Language
   157     otherLanguages = models.ManyToManyField('p4l.Language', related_name='otherLanguage_record') #iiep:otherLanguage     # Language
   179     #titles foreign Key from Title #dct:title
   158     #titles foreign Key from Title #dct:title
       
   159     #abstracts foreign Key from Abstract #dct:abstract
   180     #addedTitles foreign Key from AddedTitle #iiep:addedTitle
   160     #addedTitles foreign Key from AddedTitle #iiep:addedTitle
   181     #titlesMainDocument foreign Key from TitleMainDocument #iiep:titleMainDocument
   161     #titlesMainDocument foreign Key from TitleMainDocument #iiep:titleMainDocument
   182     editionStatement = models.CharField(max_length=1024, blank=True, null=True) #iiep:editionStatement
   162     editionStatement = models.CharField(max_length=1024, blank=True, null=True) #iiep:editionStatement
   183     #imprints foreign Key from Imprint #iiep:imprint
   163     #imprints foreign Key from Imprint #iiep:imprint
   184     #collations = foreign Key from Collation #iiep:collation
   164     #collations = foreign Key from Collation #iiep:collation
   185     #volumeIssues = foreign Key from VolumeIssue #iiep:volumeIssue
   165     #volumeIssues = foreign Key from VolumeIssue #iiep:volumeIssue
   186     projectNames = models.ManyToManyField('p4l.ProjectName') #iiep:projectName
   166     projectNames = models.ManyToManyField('p4l.ProjectName') #iiep:projectName
   187     periodicals = models.ManyToManyField('p4l.Periodical', through='p4l.RecordPeriodical') #iiep:periodical
   167     #periodicals = foreign key from 'p4l.Periodical' #iiep:periodical
   188     meetings = models.ManyToManyField('p4l.Meeting', through='p4l.RecordMeeting') #iiep:meeting
   168     #meetings = foreign key from 'p4l.Meeting' #iiep:meeting
   189     series = models.ManyToManyField('p4l.Serie', through='p4l.RecordSerie')  #iiep:serie
   169     #series = foreign key from 'p4l.Serie'  #iiep:serie
   190     authors = models.ManyToManyField('p4l.Author') #iiep:author
   170     #authors = foreign key from 'p4l.Author' #iiep:author
   191     subjectPersons = models.ManyToManyField('p4l.SubjectPerson') #iiep:subjectPerson
   171     #subjectPersons = foreign key from 'p4l.SubjectPerson' #iiep:subjectPerson
   192     subjectCorporateBodies = models.ManyToManyField('p4l.CorporateBody') #iiep:subjectCorporateBody                       # Organisation ?
   172     subjectCorporateBodies = models.ManyToManyField('p4l.CorporateBody') #iiep:subjectCorporateBody                       # Organisation ?
   193     subjectMeetings = models.ManyToManyField('p4l.SubjectMeeting') #iiep:subjectMeeting
   173     #subjectMeetings = foreign key from 'p4l.SubjectMeeting' #iiep:subjectMeeting
   194     corporateAuthors = models.ManyToManyField('p4l.CorporateAuthor') #iiep:corporateAuthor                                # Organisation ?
   174     #corporateAuthors = foreign key from 'p4l.CorporateAuthor' #iiep:corporateAuthor                                # Organisation ?
   195     #urls foreign Key from Url #iiep:url
   175     #urls foreign Key from Url #iiep:url
   196     recordType = models.URLField(max_length=2048) #dct:type
   176     recordType = models.URLField(max_length=2048) #dct:type
   197     isDocumentPart = models.BooleanField() #iiep:isDocumentPart
   177     isDocumentPart = models.BooleanField() #iiep:isDocumentPart
   198 
   178 
   199     def __unicode__(self):
   179     def __unicode__(self):