class OAuth2Account(db.Model):
__tablename__ = "oauth2_account"
client_id = db.Column(db.Integer, primary_key=True, nullable=False)
client_secret = db.Column(db.Integer, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey("user_profile.id"), nullable=False)
provider = db.Column(db.Integer, nullable=False)
user_profile = db.relationship(
"UserProfile", backref=db.backref("user_profile", uselist=False)
)
class QuestionSetToTag(db.Model):
__tablename__ = "question_set_to_tag"
question_set_id = db.Column(db.Integer,
db.ForeignKey("question_set.id"),
primary_key=True)
tag_id = db.Column(db.Integer,
db.ForeignKey("question_set_tag.id"),
primary_key=True)
question_set = db.relationship("QuestionSet", back_populates="tags")
tag = db.relationship("QuestionSetTag", back_populates="question_sets")
difficulty_level = db.Column(db.String(32))
class PromotionAction(db.Model):
__tablename__ = "promotion_action"
id = db.Column(db.Integer, primary_key=True, nullable=False)
question_set_id = db.Column(db.Integer,
db.ForeignKey("question_set.id"),
nullable=False)
type = db.Column(db.String(128), nullable=False)
start_time = db.Column(db.TIMESTAMP, nullable=False)
end_time = db.Column(db.TIMESTAMP)
question_set = db.relationship("QuestionSet",
backref=db.backref("promotion_actions",
lazy=True))
class QuestionSet(db.Model):
__tablename__ = "question_set"
id = db.Column(db.Integer, primary_key=True, nullable=False)
name = db.Column(db.String(128), unique=True, nullable=False)
details = db.Column(db.Text, nullable=False)
creation_date = db.Column(db.TIMESTAMP,
nullable=False,
default=datetime.now)
owner_id = db.Column(db.Integer,
db.ForeignKey("user_profile.id"),
nullable=False)
close_date = db.Column(db.TIMESTAMP)
open_date = db.Column(db.TIMESTAMP)
to_update = db.Column(db.Boolean, server_default="0")
owner_profile = db.relationship("UserProfile",
backref=db.backref("question_sets",
lazy=True))
tags = db.relationship("QuestionSetToTag", back_populates="question_set")
@hybrid_property
def question_count(self):
return len(self.questions)
@question_count.expression
def question_count(cls):
return func.count(cls.questions)
@hybrid_property
def report_count(self):
return len(self.reports)
class Question(db.Model):
__tablename__ = "question"
id = db.Column(db.Integer, primary_key=True, nullable=False)
question_set_id = db.Column(db.Integer,
db.ForeignKey("question_set.id"),
nullable=False)
payload = db.Column(db.JSON, nullable=False)
question_set = db.relationship("QuestionSet",
backref=db.backref("questions", lazy=True))
@hybrid_property
def answer_count(self):
return len(self.answers)
class QuestionAnswer(db.Model):
__tablename__ = "question_answer"
id = db.Column(db.Integer, primary_key=True, nullable=False)
user_id = db.Column(db.Integer,
db.ForeignKey("user_profile.id"),
nullable=False)
question_id = db.Column(db.Integer,
db.ForeignKey("question.id"),
nullable=False)
payload = db.Column(db.JSON, nullable=False)
creation_time = db.Column(db.TIMESTAMP,
nullable=False,
default=datetime.now)
question = db.relationship("Question",
backref=db.backref("answers", lazy=True))
user = db.relationship("UserProfile",
backref=db.backref("answered_questions", lazy=True))
class UserAccount(db.Model):
__tablename__ = 'user_account'
user_id = db.Column(db.Integer,
db.ForeignKey('user_profile.id'),
primary_key=True,
nullable=False)
email = db.Column(db.String(128), nullable=False)
password_hash = db.Column(db.String(128), nullable=False)
password_reset_tok = db.Column(db.String(128))
password_reset_exp = db.Column(db.TIMESTAMP)
user_state = db.Column(db.String(32),
nullable=False,
server_default=UserState.UNVERIFIED.value)
user_profile = db.relationship("UserProfile",
backref=db.backref("user_account",
uselist=False))
def set_password(self, password: str) -> None:
self.password_hash = generate_password_hash(password)
def check_password(self, password: str) -> bool:
return check_password_hash(self.password_hash, password)
def check_code(self, code: str) -> bool:
return self.password_reset_tok == code
def set_email_as_verified(self) -> None:
self.user_state = UserState.VERIFIED.value
class UserProfile(db.Model):
__tablename__ = "user_profile"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), unique=True, nullable=False)
role = db.Column(db.String(128), nullable=False)
accuracy = db.Column(db.Float, nullable=False)
wiet_points = db.Column(db.Integer, nullable=False, default=0)
creation_time = db.Column(db.TIMESTAMP,
nullable=False,
default=datetime.now)
@hybrid_property
def answered_question_count(self):
return len(self.answers)
@hybrid_property
def created_question_set_count(self):
return len(self.question_sets)
class QuestionSetReport(db.Model):
__tablename__ = "question_set_report"
id = db.Column(db.Integer, primary_key=True, nullable=False)
user_id = db.Column(db.Integer,
db.ForeignKey("user_profile.id"),
nullable=False)
question_set_id = db.Column(db.Integer,
db.ForeignKey("question_set.id"),
nullable=False)
type = db.Column(db.String(128), nullable=False)
details = db.Column(db.String(255), nullable=False)
creation_time = db.Column(db.TIMESTAMP,
nullable=False,
default=datetime.now)
question_set = db.relationship("QuestionSet",
backref=db.backref("reports", lazy=True))
user = db.relationship("UserProfile",
backref=db.backref("reports_sent", lazy=True))
class QuestionSetTag(db.Model):
__tablename__ = "question_set_tag"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), nullable=False)
question_sets = db.relationship("QuestionSetToTag", back_populates="tag")