| author | cavaliet |
| Fri, 30 Aug 2013 13:08:29 +0200 | |
| changeset 10 | c4e7d66b7dc2 |
| parent 9 | 3bc55f57b2b1 |
| child 13 | 6296aa12fd71 |
| permissions | -rw-r--r-- |
| 0 | 1 |
# -*- coding: utf-8 -*- |
2 |
||
3 |
from django.db import models |
|
4 |
from p4l.models.common import P4lModel, P4lModelLang |
|
5 |
||
6 |
||
7 |
class Imprint(P4lModelLang): |
|
8 |
record = models.ForeignKey('p4l.Record', related_name="imprints") |
|
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) |
|
11 |
imprintDate = models.CharField(max_length=512, blank=True, null=True, db_index=True) |
|
12 |
||
13 |
||
14 |
class Serie(P4lModel): |
|
15 |
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 |
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 |
||
27 |
||
28 |
class ProjectName(P4lModel): |
|
29 |
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 |
|
31 |
class Meta(P4lModel.Meta): |
|
32 |
unique_together = ['label', 'acronym'] |
|
33 |
||
34 |
||
35 |
class CorporateAuthor(P4lModel): |
|
36 |
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 |
|
38 |
class Meta(P4lModel.Meta): |
|
39 |
unique_together = ['label', 'acronym'] |
|
40 |
||
41 |
||
42 |
class Url(P4lModel): |
|
43 |
record = models.ForeignKey('p4l.Record', related_name="urls") |
|
44 |
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 |
|
46 |
accessLevel = models.CharField(max_length=512, blank=True, null=True, db_index=True) #iiep:accessLevel |
|
47 |
||
48 |
||
49 |
class Subject(P4lModel): |
|
50 |
subject = models.URLField(max_length=2048, unique=True, db_index=True) |
|
| 9 | 51 |
label = models.CharField(max_length=2048, blank=True, null=True, db_index=True) # filled from sparql request after import |
| 0 | 52 |
|
53 |
class Theme(P4lModel): |
|
54 |
theme = models.URLField(max_length=2048, unique=True, db_index=True) |
|
| 9 | 55 |
label = models.CharField(max_length=2048, blank=True, null=True, db_index=True) # filled from sparql request after import |
| 0 | 56 |
|
57 |
||
58 |
class Country(P4lModel): |
|
59 |
country = models.URLField(max_length=2048, unique=True, db_index=True) |
|
|
10
c4e7d66b7dc2
add sparql request for languages and countries labels
cavaliet
parents:
9
diff
changeset
|
60 |
label = models.CharField(max_length=2048, blank=True, null=True, db_index=True) # filled from sparql request after import |
| 0 | 61 |
|
62 |
||
63 |
class Isbn(P4lModelLang): |
|
64 |
record = models.ForeignKey('p4l.Record', related_name="isbns") |
|
65 |
isbn = models.CharField(max_length=128) #iiep:isbn |
|
66 |
||
67 |
||
68 |
class Issn(P4lModelLang): |
|
69 |
record = models.ForeignKey('p4l.Record', related_name="issns") |
|
70 |
issn = models.CharField(max_length=128) #iiep:issn |
|
71 |
||
72 |
class DocumentCode(P4lModelLang): |
|
73 |
record = models.ForeignKey('p4l.Record', related_name="documentCodes") |
|
74 |
documentCode = models.CharField(max_length=128) #iiep:issn |
|
75 |
||
76 |
class Language(P4lModel): |
|
77 |
language = models.URLField(max_length=2048, unique=True, db_index=True) |
|
|
10
c4e7d66b7dc2
add sparql request for languages and countries labels
cavaliet
parents:
9
diff
changeset
|
78 |
label = models.CharField(max_length=2048, blank=True, null=True, db_index=True) # filled from sparql request after import |
| 0 | 79 |
|
80 |
||
81 |
||
82 |
class BaseTitle(P4lModelLang): |
|
83 |
title = models.CharField(max_length=2048, blank=False, null=False, db_index=True) |
|
84 |
class Meta(P4lModelLang.Meta): |
|
85 |
abstract = True |
|
86 |
||
87 |
class Title(BaseTitle): |
|
88 |
record = models.ForeignKey('p4l.Record', related_name="titles") |
|
89 |
||
90 |
class AddedTitle(BaseTitle): |
|
91 |
record = models.ForeignKey('p4l.Record', related_name="addedTitles") |
|
92 |
||
93 |
class TitleMainDocument(BaseTitle): |
|
94 |
record = models.ForeignKey('p4l.Record', related_name="titlesMainDocument") |
|
95 |
||
96 |
||
97 |
class Abstract(P4lModelLang): |
|
98 |
record = models.ForeignKey('p4l.Record', related_name="abstracts") |
|
99 |
abstract = models.TextField(blank=True, null=True) |
|
100 |
||
101 |
||
102 |
class Collation(P4lModelLang): |
|
103 |
record = models.ForeignKey('p4l.Record', related_name="collations") |
|
104 |
collation = models.CharField(max_length=1024, blank=False, null=False, db_index=True) |
|
105 |
||
106 |
||
107 |
class VolumeIssue(P4lModelLang): |
|
108 |
record = models.ForeignKey('p4l.Record', related_name="volumeIssues") |
|
109 |
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 |
|
111 |
||
112 |
||
113 |
class P4lPerson(P4lModel): |
|
114 |
name = models.CharField(max_length=2048, blank=False, null=False, db_index=True, unique=True) |
|
115 |
class Meta(P4lModel.Meta): |
|
116 |
abstract = True |
|
117 |
||
118 |
||
119 |
class Author(P4lPerson): |
|
120 |
pass |
|
121 |
||
122 |
class SubjectPerson(P4lPerson): |
|
123 |
pass |
|
124 |
||
125 |
||
126 |
class Periodical(P4lModel): |
|
127 |
label = models.CharField(max_length=2048, blank=False, null=False, db_index=True, unique=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 |
||
135 |
||
136 |
class BaseMeeting(P4lModel): |
|
137 |
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 |
|
139 |
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 |
|
141 |
meetingYear = models.PositiveSmallIntegerField(blank=True, null=True, db_index=True) #iiep:meetingYear |
|
142 |
class Meta(P4lModel.Meta): |
|
143 |
abstract = True |
|
144 |
unique_together = ['label', 'meetingNumber', 'meetingPlace', 'meetingDate', 'meetingYear'] |
|
145 |
||
146 |
||
147 |
class Meeting(BaseMeeting): |
|
148 |
pass |
|
149 |
||
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 |
||
156 |
||
157 |
class SubjectMeeting(BaseMeeting): |
|
158 |
pass |
|
159 |
||
160 |
||
161 |
class CorporateBody(P4lModel): |
|
162 |
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 |
|
164 |
class Meta(P4lModel.Meta): |
|
165 |
unique_together = ['label','acronym'] |
|
166 |
||
167 |
class Record(P4lModel): |
|
168 |
uri = models.URLField(max_length=2048, unique=True, db_index=True) #subject |
|
| 4 | 169 |
subjects = models.ManyToManyField('p4l.Subject') #dct:subject # Thesaurus with no country |
170 |
themes = models.ManyToManyField('p4l.Theme') #iiep:theme # Theme |
|
171 |
countries = models.ManyToManyField('p4l.Country') #iiep:country # Thesaurus filtered with country only |
|
| 0 | 172 |
identifier = models.CharField(max_length=128, unique=True, db_index=True) #dct:identifier |
173 |
notes = models.TextField(blank=True, null=True) #iiep:notes |
|
174 |
#issns foreign key from Isbn #iiep:issn |
|
175 |
#isbns foreign key from Isbn #iiep:isbn |
|
176 |
#documentCodes foreign key from Isbn #iiep:documentCode |
|
| 4 | 177 |
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 |
|
| 0 | 179 |
#titles foreign Key from Title #dct:title |
180 |
#addedTitles foreign Key from AddedTitle #iiep:addedTitle |
|
181 |
#titlesMainDocument foreign Key from TitleMainDocument #iiep:titleMainDocument |
|
182 |
editionStatement = models.CharField(max_length=1024, blank=True, null=True) #iiep:editionStatement |
|
183 |
#imprints foreign Key from Imprint #iiep:imprint |
|
184 |
#collations = foreign Key from Collation #iiep:collation |
|
185 |
#volumeIssues = foreign Key from VolumeIssue #iiep:volumeIssue |
|
186 |
projectNames = models.ManyToManyField('p4l.ProjectName') #iiep:projectName |
|
187 |
periodicals = models.ManyToManyField('p4l.Periodical', through='p4l.RecordPeriodical') #iiep:periodical |
|
188 |
meetings = models.ManyToManyField('p4l.Meeting', through='p4l.RecordMeeting') #iiep:meeting |
|
189 |
series = models.ManyToManyField('p4l.Serie', through='p4l.RecordSerie') #iiep:serie |
|
190 |
authors = models.ManyToManyField('p4l.Author') #iiep:author |
|
191 |
subjectPersons = models.ManyToManyField('p4l.SubjectPerson') #iiep:subjectPerson |
|
| 4 | 192 |
subjectCorporateBodies = models.ManyToManyField('p4l.CorporateBody') #iiep:subjectCorporateBody # Organisation ? |
| 0 | 193 |
subjectMeetings = models.ManyToManyField('p4l.SubjectMeeting') #iiep:subjectMeeting |
| 4 | 194 |
corporateAuthors = models.ManyToManyField('p4l.CorporateAuthor') #iiep:corporateAuthor # Organisation ? |
| 0 | 195 |
#urls foreign Key from Url #iiep:url |
196 |
recordType = models.URLField(max_length=2048) #dct:type |
|
197 |
isDocumentPart = models.BooleanField() #iiep:isDocumentPart |
|
198 |
||
199 |
def __unicode__(self): |
|
200 |
return "Record id %s { identifier: %s, uri: %s, editionStatement: %s, recordType: %s, isDocumentPart: %s, notes: %s, language : %s}" \ |
|
201 |
% ( |
|
202 |
self.id, |
|
203 |
self.identifier, |
|
204 |
self.uri, |
|
205 |
self.editionStatement, |
|
206 |
self.recordType, |
|
207 |
self.isDocumentPart, |
|
208 |
self.notes[:100] if self.notes else None, |
|
209 |
self.language.id if self.language else None |
|
210 |
) |
|
211 |
||
212 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}issn', 3) |
|
213 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}documentCode', 3) |
|
214 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}country', 44) |
|
215 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}imprint', 5) |
|
216 |
#('{http://purl.org/dc/terms/}title', 4) |
|
217 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}isDocumentPart', 1) |
|
218 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}notes', 1) |
|
219 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}isbn', 8) |
|
220 |
#('{http://purl.org/dc/terms/}identifier', 1) |
|
221 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}meeting', 4) |
|
222 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}projectName', 10) |
|
223 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}addedTitle', 18) |
|
224 |
#('{http://purl.org/dc/terms/}subject', 29) |
|
225 |
#('{http://purl.org/dc/terms/}language', 1) |
|
226 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}serie', 4) |
|
227 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}volumeIssue', 3) |
|
228 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}url', 20) |
|
229 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}titleMainDocument', 3) |
|
230 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}otherLanguage', 13) |
|
231 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}periodical', 3) |
|
232 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}editionStatement', 1) |
|
233 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}collation', 4) |
|
234 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}subjectMeeting', 6) |
|
235 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}corporateAuthor', 7) |
|
236 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}author', 26) |
|
237 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}subjectPerson', 2) |
|
238 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}subjectCorporateBody', 8) |
|
239 |
#('{http://www.iiep.unesco.org/plan4learning/model.owl#}theme', 6) |
|
240 |
#('{http://purl.org/dc/terms/}abstract', 3) |
|
241 |
#('{http://purl.org/dc/terms/}type', 1) |