models.py 13.8 KB
Newer Older
1
2
3
4
5
6
7
8
9
10
# -*- coding: utf-8 -*- vim:fileencoding=utf-8:
# vim: tabstop=4:shiftwidth=4:softtabstop=4:expandtab

'''
TODO main description
'''

from django.db import models
from django.utils.translation import ugettext as _

11
12
13
14
from django.contrib.contenttypes.models import ContentType
from django.contrib.contenttypes import generic


15
16
17
18
19
LANGS = (
        ('en', 'English' ),
        ('el', 'Ελληνικά'),
    )

20
21

# FIXME: use idp, sp, idpsp as keys not in the velue part. Get rid of 1,2,3
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
ERTYPES = (
        (1, 'idp: IdP only' ),
        (2, 'sp: SP only'),
        (3, 'idpsp: IdP and SP'),
    )

RADPROTOS = (
        ('radius', 'traditional RADIUS over UDP' ),
        ('radius-tcp', 'RADIUS over TCP (RFC6613)'),
        ('radius-tls', 'RADIUS over TLS (RFC6614)'),
        ('radius-dtls', 'RADIUS over datagram TLS (RESERVED)'),
    )


class Name_i18n(models.Model):
    '''
    Name in a particular language
    '''

    name = models.CharField(max_length=80)
    lang = models.CharField(max_length=5, choices=LANGS)
43
44
45
    content_type = models.ForeignKey(ContentType, blank=True, null=True)
    object_id = models.PositiveIntegerField(blank=True, null=True)
    content_object = generic.GenericForeignKey('content_type', 'object_id')
46
47
48

    def __unicode__(self):
        return self.name
49
        
50
51
52
53
54
55

class Contact(models.Model):
    '''
    Contact
    '''

56
57
    firstname = models.CharField(max_length=80, db_column='contact_firstname')
    lastname = models.CharField(max_length=80, db_column='contact_lastname')
58
59
60
61
    email = models.CharField(max_length=80, db_column='contact_email')
    phone = models.CharField(max_length=80, db_column='contact_phone')

    def __unicode__(self):
62
        return '%s %s <%s> (%s)' % (self.firstname, self.lastname, self.email, self.phone)
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132

class URL_i18n(models.Model):
    '''
    URL of a particular type in a particular language
    '''

    URLTYPES = (
                ('info', 'Info' ),
                ('policy', 'Policy'),
               )
    url = models.CharField(max_length=180, db_column='URL')
    lang = models.CharField(max_length=5, choices=LANGS)
    urltype = models.CharField(max_length=10, choices=URLTYPES, db_column='type')

    def __unicode__(self):
        return self.url

class InstRealm(models.Model):
    '''
    Realm (including wildcards) of an IdP Institution
    '''

    realmexpr = models.CharField(max_length=20)
    priority = models.PositiveIntegerField(max_length=3)
    instid = models.ForeignKey("Institution")
    # accept if instid.ertype: 1 (idp) or 3 (idpsp)
    proxyto = models.ManyToManyField("InstServer")

    def __unicode__(self):
        return _('Institution: %(inst)s, Realm: %(realmexpr)s, Priority: %(priority)s') % {
        # but name is many-to-many from institution
            'inst': self.instid.name,
            'realmexpr': self.realmexpr,
            'priority': self.priority,
            }

class InstServer(models.Model):
    '''
    Server of an Institution
    '''
    instid = models.ForeignKey("Institution")
    ertype = models.PositiveIntegerField(max_length=1, choices=ERTYPES, db_column='type')
    # ertype:
    # 1: accept if instid.ertype: 1 (idp) or 3 (idpsp)
    # 2: accept if instid.ertype: 2 (sp) or 3 (idpsp)
    # 3: accept if instid.ertype: 3 (idpsp)

    # hostname/ipaddr or descriptive label of server
    name = models.CharField(max_length=80)
    # hostname/ipaddr of server, overrides name
    host = models.CharField(max_length=80)

    # accept if type: 1 (idp) or 3 (idpsp)
    port = models.PositiveIntegerField(max_length=5)
    acct_port = models.PositiveIntegerField(max_length=5)
    timeout = models.PositiveIntegerField(max_length=2)
    retry = models.PositiveIntegerField(max_length=2)

    status_server = models.BooleanField()
    secret = models.CharField(max_length=16)
    proto = models.CharField(max_length=12, choices=RADPROTOS)
    ts = models.DateTimeField(auto_now=True)

    def __unicode__(self):
        return _('Institution: %(inst)s, Server: %(servername)s, Type: %(ertype)s') % {
        # but name is many-to-many from institution
            'inst': self.instid.name,
            'servername': self.name,
        # the human-readable name would be nice here
            'ertype': self.ertype,
133
134
135
            }    
    
    
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
class InstRealmMon(models.Model):
    '''
    Realm of an IdP Institution to be monitored
    '''

    MONTYPES = (
                ('local', 'Institution provides account for the NRO to monitor the realm' ),
                ('proxyback', 'Institution proxies the realm back to the NRO'),
               )

    instid = models.ForeignKey("Institution")
    realm = models.CharField(max_length=20)
    mon_type = models.CharField(max_length=8, choices=MONTYPES)

    def __unicode__(self):
        return _('Institution: %(inst)s, Monitored Realm: %(monrealm)s, Monitoring Type: %(montype)s') % {
        # but name is many-to-many from institution
            'inst': self.instid.name,
            'monrealm': self.realm,
            'montype': self.mon_type,
            }

class MonProxybackClient(models.Model):
    '''
    Server of an Institution that will be proxying back requests for a monitored realm
    '''

    instrealmmonid = models.ForeignKey("InstRealmMon")
    # hostname/ipaddr or descriptive label of server
    name = models.CharField(max_length=80)
    # hostname/ipaddr of server, overrides name
    host = models.CharField(max_length=80)
    status_server = models.BooleanField()
    secret = models.CharField(max_length=16)
    proto = models.CharField(max_length=12, choices=RADPROTOS)
    ts = models.DateTimeField(auto_now=True)

    def __unicode__(self):
        return _('Institution: %(inst)s, Monitored Realm: %(monrealm)s, Proxyback Client: %(servername)s') % {
        # but name is many-to-many from institution
            'inst': self.instid.name,
            'monrealm': self.instrealmmonid.realm,
            'servername': self.name,
            }

class MonLocalEAPOLData(models.Model):
    '''
    EAPOL data for an old-style monitored realm
    '''

    EAPTYPES = (
                ('PEAP', 'EAP-PEAP' ),
                ('TTLS', 'EAP-TTLS'),
                ('TLS', 'EAP-TLS'),
               )
    EAP2TYPES = (
                ('PAP', 'PAP' ),
                ('CHAP', 'CHAP'),
                ('MS-CHAPv2', 'MS-CHAPv2'),
               )
    MONRESPTYPES = (
                ('accept', 'Access-Accept expected' ),
                ('reject', 'Access-Reject expected'),
                ('both', 'RESERVED'),
               )

    instrealmmonid = models.ForeignKey("InstRealmMon")
    eap_method = models.CharField(max_length=16, choices=EAPTYPES)
    phase2 = models.CharField(max_length=16, choices=EAP2TYPES)
    # only local-part, no realm
    username = models.CharField(max_length=24)
    passwp = models.CharField(max_length=24, db_column='pass')
    cert = models.CharField(max_length=32)
    exp_response = models.CharField(max_length=6, choices=MONRESPTYPES)

    def __unicode__(self):
        return _('Institution: %(inst)s, Monitored Realm: %(monrealm)s, EAP Method: %(eapmethod)s, Phase 2: %(phase2)s, Username: %(username)s') % {
        # but name is many-to-many from institution
            'inst': self.instid.name,
            'monrealm': self.instrealmmonid.realm,
            'eapmethod': self.eap_method,
            'phase2': self.phase2,
            'username': self.username,
            }

class ServiceLoc(models.Model):
    '''
    Service Location of an SP/IdPSP Institution
    '''

    ENCTYPES = (
                ('WPA/TKIP', 'WPA-TKIP' ),
                ('WPA/AES', 'WPA-AES'),
                ('WPA2/TKIP', 'WPA2-TKIP'),
                ('WPA2/AES', 'WPA2-AES'),
               )

    # accept if institutionid.ertype: 2 (sp) or 3 (idpsp)
    institutionid = models.ForeignKey("Institution")
    longitude = models.DecimalField(max_digits=8, decimal_places=6)
    latitude = models.DecimalField(max_digits=8, decimal_places=6)
    # TODO: multiple names can be specified [...] name in English is required
238
    loc_name = generic.GenericRelation(Name_i18n)
239
240
    address_street = models.CharField(max_length=96)
    address_city = models.CharField(max_length=64)
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
    contact = models.ManyToManyField(Contact)
    SSID = models.CharField(max_length=16)
    enc_level = models.CharField(max_length=10, choices=ENCTYPES)
    port_restrict = models.BooleanField()
    transp_proxy = models.BooleanField()
    IPv6 = models.BooleanField()
    NAT = models.BooleanField()
    AP_no = models.PositiveIntegerField(max_length=3)
    wired = models.BooleanField()
    # only urltype = 'info' should be accepted here
    url = models.ManyToManyField(URL_i18n)
    ts = models.DateTimeField(auto_now=True)

    def __unicode__(self):
        return _('Institution: %(inst)s, Service Location: %(locname)s') % {
        # but name is many-to-many from institution
257
            'inst': self.institutionid,
258
259
260
        # but locname is many-to-many
            'locname': self.loc_name,
            }
261
262
263
264
265
266
267
268
269
270
271
272
    
    
    def get_name(self, lang=None):
        name = ', '.join([i.name for i in self.loc_name.all()])
        if not lang:
            return name
        else:
            try:
                name = self.loc_name.get(lang=lang)
                return name
            except Exception as e:
                return name
273
274
275
276
277

class Institution(models.Model):
    '''
    Institution
    '''
278
    
279
    realmid = models.ForeignKey("Realm")
280
    org_name = generic.GenericRelation(Name_i18n)
281
    
282
    
283
284
    def __unicode__(self):
        return "%s" % ', '.join([i.name for i in self.org_name.all()])
285
286
    
    
287
    def get_name(self, lang=None):
288
289
290
291
        name = ', '.join([i.name for i in self.org_name.all()])
        if not lang:
            return name
        else:
292
            try:
293
294
295
296
297
                name = self.org_name.get(lang=lang)
                return name
            except Exception as e:
                return name
            
298
299
300
301
302
303

class InstitutionDetails(models.Model):
    '''
    Institution Details
    '''
    institution = models.OneToOneField(Institution)
304
305
    ertype = models.PositiveIntegerField(max_length=1, choices=ERTYPES, db_column='type')
    # TODO: multiple names can be specified [...] name in English is required
306
307
    address_street = models.CharField(max_length=96)
    address_city = models.CharField(max_length=64)
308
309
310
311
312
313
314
315
316
317
318
319
    contact = models.ManyToManyField(Contact)
    url = models.ManyToManyField(URL_i18n)
    # accept if ertype: 2 (sp) or 3 (idpsp)
    oper_name = models.CharField(max_length=24)
    # accept if ertype: 1 (idp) or 3 (idpsp)
    number_user = models.PositiveIntegerField(max_length=6)
    number_id = models.PositiveIntegerField(max_length=6)
    ts = models.DateTimeField(auto_now=True)

    def __unicode__(self):
        return _('Institution: %(inst)s, Type: %(ertype)s') % {
        # but name is many-to-many from institution
320
            'inst': ', '.join([i.name for i in self.institution.org_name.all()]),
321
322
323
            'ertype': self.ertype,
            }

324
325


326
327
328
329
330
331
332
333
334
335
336
337
class Realm(models.Model):
    '''
    Realm
    '''

    COUNTRIES = (
                ('gr', 'Greece' ),
               )

    country = models.CharField(max_length=2, choices=COUNTRIES)
    stype = models.PositiveIntegerField(max_length=1, default=0, editable=False)
    # TODO: multiple names can be specified [...] name in English is required
338
    org_name = generic.GenericRelation(Name_i18n)
339
340
341
342
343
344
345
346
347
    address_street = models.CharField(max_length=32)
    address_city = models.CharField(max_length=24)
    contact = models.ManyToManyField(Contact)
    url = models.ManyToManyField(URL_i18n)
    ts = models.DateTimeField(auto_now=True)

    def __unicode__(self):
        return _('Country: %(country)s, NRO: %(orgname)s') % {
        # but name is many-to-many from institution
348
            'orgname': ', '.join([i.name for i in self.org_name.all()]),
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
            'country': self.country,
            }


# TODO: this represents a *database view* "realm_data", find a better way to write it
class RealmData(models.Model):
    '''
    Realm statistics
    '''

    realmid = models.OneToOneField(Realm)
    # db: select count(institution.id) as number_inst from institution, realm where institution.realmid == realm.realmid
    number_inst = models.PositiveIntegerField(max_length=5, editable=False)
    # db: select sum(institution.number_user) as number_user from institution, realm where institution.realmid == realm.realmid
    number_user = models.PositiveIntegerField(max_length=9, editable=False)
    # db: select sum(institution.number_id) as number_id from institution, realm where institution.realmid == realm.realmid
    number_id = models.PositiveIntegerField(max_length=9, editable=False)
    # db: select count(institution.id) as number_IdP from institution, realm where institution.realmid == realm.realmid and institution.type == 1
    number_IdP = models.PositiveIntegerField(max_length=5, editable=False)
    # db: select count(institution.id) as number_SP from institution, realm where institution.realmid == realm.realmid and institution.type == 2
    number_SP = models.PositiveIntegerField(max_length=5, editable=False)
    # db: select count(institution.id) as number_IdPSP from institution, realm where institution.realmid == realm.realmid and institution.type == 3
    number_IdPSP = models.PositiveIntegerField(max_length=5, editable=False)
    # db: select greatest(max(realm.ts), max(institution.ts)) as ts from institution, realm where institution.realmid == realm.realmid
    ts = models.DateTimeField(editable=False)

    def __unicode__(self):
        return _('Country: %(country)s, NRO: %(orgname)s, Institutions: %(inst)s, IdPs: %(idp)s, SPs: %(sp)s, IdPSPs: %(idpsp)s, Users: %(numuser)s, Identities: %(numid)s') % {
        # but name is many-to-many from institution
            'orgname': self.org_name,
            'country': self.country,
            'inst': self.number_inst,
            'idp': self.number_IdP,
            'sp': self.number_SP,
            'idpsp': self.number_IdPSP,
            'numuser': self.number_user,
            'numid': self.number_id,
            }