class Students(db.Model): """Users(students) model.""" __tablename__ = 'students' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String) password = db.Column(db.String) isadmin = db.Column(db.Integer) def __init__(self, name, password, isadmin): self.name = name self.password = password self.isadmin = isadmin # These methods go with flask_login def is_authenticated(self): return True def is_active(self): return True def is_anonymous(self): return False def get_id(self): return str(self.id)
class Tests(db.Model): """Tests model.""" __tablename__ = 'tests' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String)
class Results(db.Model): """Results model.""" __tablename__ = 'results' id = db.Column(db.Integer, primary_key=True) attempt_id = db.Column(db.Integer, db.ForeignKey("attempts.id")) question_id = db.Column(db.Integer, db.ForeignKey("questions.id")) fact_id = db.Column(db.Integer)
class Answers(db.Model): """Answers model.""" __tablename__ = 'answers' id = db.Column(db.Integer, primary_key=True) value = db.Column(db.String) question_id = db.Column(db.Integer, db.ForeignKey("questions.id")) iscorrect = db.Column(db.Integer)
class Questions(db.Model): """Questions model.""" __tablename__ = 'questions' id = db.Column(db.Integer, primary_key=True) value = db.Column(db.String) test_id = db.Column(db.Integer, db.ForeignKey("tests.id")) ismultiple = db.Column(db.Integer)
class Attempts(db.Model): """Attempts model.""" __tablename__ = 'attempts' id = db.Column(db.Integer, primary_key=True) student_id = db.Column(db.Integer, db.ForeignKey("students.id")) starttime = db.Column(db.DateTime) endtime = db.Column(db.DateTime) test_id = db.Column(db.Integer, db.ForeignKey("tests.id"))