| 1 | from django.db import models
|
|---|
| 2 | from gheat import managers
|
|---|
| 3 | import datetime
|
|---|
| 4 |
|
|---|
| 5 | class Accespoint(models.Model):
|
|---|
| 6 | mac = models.CharField(max_length=17)
|
|---|
| 7 | ssid = models.CharField(max_length=64)
|
|---|
| 8 | encryptie = models.BooleanField()
|
|---|
| 9 | def __unicode__(self):
|
|---|
| 10 | return "%s - %s" % (self.mac, self.ssid)
|
|---|
| 11 |
|
|---|
| 12 | class Gebruiker(models.Model):
|
|---|
| 13 | naam = models.CharField(max_length=64)
|
|---|
| 14 | email = models.CharField(max_length=64)
|
|---|
| 15 | def __unicode__(self):
|
|---|
| 16 | return "%s - %s" % (self.naam, self.email)
|
|---|
| 17 |
|
|---|
| 18 | class Apparatuur(models.Model):
|
|---|
| 19 | antenne = models.CharField(max_length=64)
|
|---|
| 20 | kaart = models.CharField(max_length=64)
|
|---|
| 21 | def __unicode__(self):
|
|---|
| 22 | return "%s - %s" % (self.antenne, self.kaart)
|
|---|
| 23 |
|
|---|
| 24 | class MeetRondje(models.Model):
|
|---|
| 25 | datum = models.DateTimeField()
|
|---|
| 26 | naam = models.CharField(max_length=60)
|
|---|
| 27 | gebruiker = models.ForeignKey(Gebruiker)
|
|---|
| 28 | apparatuur = models.ForeignKey(Apparatuur)
|
|---|
| 29 | def __unicode__(self):
|
|---|
| 30 | return "%s - %s" % (self.gebruiker.naam, self.naam)
|
|---|
| 31 |
|
|---|
| 32 | class Meting(models.Model):
|
|---|
| 33 | meetrondje = models.ForeignKey(MeetRondje)
|
|---|
| 34 | accespoint = models.ForeignKey(Accespoint)
|
|---|
| 35 | latitude = models.FloatField(name='Latitude', db_column='lat')
|
|---|
| 36 | longitude = models.FloatField(name='Longitude', db_column='lng')
|
|---|
| 37 | signaal = models.IntegerField(max_length=3)
|
|---|
| 38 | objects = managers.MetingManager()
|
|---|
| 39 | def __unicode__(self):
|
|---|
| 40 | return "%s @ %s,%s : %s" % (self.accespoint.ssid, self.latitude, self.longitude, self.signaal)
|
|---|