summaryrefslogtreecommitdiff
path: root/backend/models.py
blob: 9e0877950ae8addaf62cc04b83d75225fe49fbb4 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
""" ScannerJammer models
"""

from django.db import models


class SJUser(models.Model):
    """ ScannerJammer user model """
    username = models.CharField(max_lenght=32)
    nickname = models.CharField(max_lenght=32)
    password = models.CharField(max_lenght=32)
    score = models.IntegerField(default=0)
    joindate = models.DateFiels()
    seendate = models.DateFiels()
    access = models.IntegerField(default=0)
    bio = models.TextField()
    settings = models.TextField()

    def __unicode__(self):
        return "%s(%s)" % (self.username, self.nickname)

class SJRoom(models.Model):
    """ ScannerJammer room model """
    name = models.CharField(max_lenght=32)
    date = models.DateField()
    private = models.BooleanField(default=False)
    tokbox = models.CharField(max_lenght=64)
    settings = models.TextField()

    def __unicode__(self):
        return self.name

class SJSiteModel(models.Model):
    """ ScannerJammer site base model """
    user = models.ForeignKey(SJUser)
    room = models.ForeignKey(SJRoom)
    date = models.DateField()

class SJBackground(SJSiteModel):
    """ ScannerJammer background model """
    url = models.URLField()

    def __unicode__(self):
        return self.url

class SJURL(SJSiteModel):
    """ ScannerJammer url model """
    url = models.URLField()
    likes = models.IntegerField(default=0)
    # redundant column
    username = models.CharField(max_lenght=32)

    def __unicode__(self):
        return self.url

class SJVideo(SJSiteModel):
    """ ScannerJammer video model """
    url = models.URLField()
    title = models.CharField(max_lenght=100)
    likes = models.IntegerField(default=0)
    removed = models.BooleanField(default=False)
    thumbnail = models.CharField(max_lenght=64)
    # redundant column
    username = models.CharField(max_lenght=32)

    def __unicode__(self):
        return self.url

class SJChat(SJSiteModel):
    """ ScannerJammer chat model """
    msg = models.TextField()
    # redundant column
    username = models.CharField(max_lenght=32)

class SJSearchLog(models.Model):
    """ SannerJammer search log """
    date = models.DateField()
    query = models.CharField(max_lenght=255)
    matches = models.IntegerField(default=0)

    def __unicode__(self):
        return '%s "%s" matched %d' % (self.date, self.query, self.matches)