UILPractice/models.py at master · rawells14/UILPractice · GitHub

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
83
84
85
86
87
88
89
90
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from sqlalchemy import *

Base = declarative_base()


class User(Base):
    __tablename__ = 'users'
    uid = Column(Integer, primary_key=True, unique=True, autoincrement=True)
    username = Column(String(50))
    fullname = Column(String(50))
    password = Column(String(1000))
    score = Column(Integer)
    totalattempted = Column(Integer)
    totalcorrect = Column(Integer)
    settings = Column(String(1000))

    def __repr__(self):
        return "<User(uid='%d', username='%s', fullname='%s', password='%s', score='%d')>" % (self.uid,
                                                                                              self.username,
                                                                                              self.fullname,
                                                                                              self.password, self.score)

    def is_authenticated(self):
        return True

    def is_active(self):
        return True

    def is_anonymous(self):
        return False

    def get_id(self):
        return self.uid


class Badge(Base):
    __tablename__ = 'badges'
    uid = Column(Integer, primary_key=True)
    badgeids = Column(String(5000))

    def __repr__(self):
        return "<Badge(uid='%d', badgeids='%s')>" % (
            self.uid,
            self.badgeids)


class Flag(Base):
    __tablename__ = 'flags'
    qid = Column(Integer, primary_key=True, autoincrement=True)
    flags = Column(Integer)

    def __repr__(self):
        return "<Question(qid='%d', flags='%s')>" % (
            self.qid,
            self.flags)


class Question(Base):
    __tablename__ = 'questions'
    qid = Column(Integer, primary_key=True, unique=True, autoincrement=True)
    questionheader = Column(String(16000))
    questiontext = Column(String(16000))
    answerchoices = Column(String(16000))
    correctanswer = Column(Integer)
    explanation = Column(String(16000))
    subject = Column(String(250))

    def get_qid(self):
        return self.qid

    def __repr__(self):
        return "<Question(qid='%d', questionheader='%s', questiontext='%s', answerchoices='%s', correctanswer='%s', explanation='%d', subject='%s')>" % (
            self.qid,
            self.questiontext,
            self.answerchoices,
            self.correctanswer, self.explanation, self.subject)


class Submission(Base):
    __tablename__ = 'submissions'

    uid = Column(Integer())
    status = Column(String(50))
    time_stamp = Column(Integer, primary_key=True)

    def __repr__(self):
        return "<Submission(uid='%d', status='%s', time_stamp='%d')>" % (
            self.username, self.status, self.time_stamp)