class Progress(db.Model):
id = db.Column(db.Integer, primary_key=True)
child_id = db.Column(db.Integer, db.ForeignKey('child.id'), nullable=False)
date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
subject = db.Column(db.String(3), nullable=False)
result = db.Column(db.Boolean, nullable=False)
operation = db.Column(db.String(), nullable=False)
question = db.Column(db.String(), nullable=False)
correct_ans = db.Column(db.String(), nullable=False)
ans_chosen = db.Column(db.String(), nullable=False)
duration = db.Column(db.Integer, nullable=False)
class Parent(db.Model):
id = db.Column(db.Integer, db.ForeignKey('user.id'), primary_key=True)
email = db.Column(db.String(120), unique=True, nullable=True)
last_name = db.Column(db.String(20), nullable=True)
phone = db.Column(db.Integer, nullable=False)
address = db.Column(db.Text, nullable=False)
children = db.relationship('Child', backref='parent', lazy=True)
def __repr__(self):
user = User.query.filter_by(id=self.id).first()
return f"Parent('{self.id}', '{user.first_name}')"
class Child(db.Model):
id = db.Column(db.Integer, db.ForeignKey('user.id'), primary_key=True)
parent_id = db.Column(db.Integer,
db.ForeignKey('parent.id'),
nullable=False)
grade = db.Column(db.String(2), nullable=False)
game_characters = db.relationship('Game_Character_Save',
backref='child',
lazy=True)
def __repr__(self):
user = User.query.filter_by(id=self.id).first()
return f"Child('{self.id}', '{user.first_name}')"
class MonthlyProgress(db.Model):
id = db.Column(db.Integer, primary_key=True)
child_id = db.Column(db.Integer, db.ForeignKey('child.id'), nullable=False)
year = db.Column(db.Integer, nullable=False)
month = db.Column(db.Integer, nullable=False)
subject = db.Column(db.String(3), nullable=False)
operation = db.Column(db.String(), nullable=False)
total_attempted = db.Column(db.Integer, nullable=False)
ans_correct = db.Column(db.Integer, nullable=False)
avg_duration = db.Column(db.Integer, nullable=False)
class Question(db.Model):
id = db.Column(db.Integer, primary_key=True)
subject = db.Column(db.String(3), nullable=False)
grade = db.Column(db.String(2), nullable=False)
qn_txt = db.Column(db.Text, nullable=True)
qn_pic = db.Column(db.String(20), nullable=True)
qn_pic_repeatable = db.Column(db.Boolean, nullable=True)
ans = db.Column(db.String(), nullable=False)
ans_pic = db.Column(db.String(20), nullable=True)
class DailyProgress(db.Model):
id = db.Column(db.Integer, primary_key=True)
child_id = db.Column(db.Integer, db.ForeignKey('child.id'), nullable=False)
date = db.Column(db.Date, nullable=False, default=datetime.utcnow)
subject = db.Column(db.String(3), nullable=False)
operation = db.Column(db.String(), nullable=False)
total_attempted = db.Column(db.Integer, nullable=False)
ans_correct = db.Column(db.Integer, nullable=False)
avg_duration = db.Column(db.Integer, nullable=False)
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
role = db.Column(db.String(20), nullable=False)
first_name = db.Column(db.String(20), nullable=False)
date_joined = db.Column(db.Date, nullable=False, default=datetime.utcnow)
image_file = db.Column(db.String(20),
nullable=False,
default='default.png')
# def get_reset_token(self):
# s = Serializer(app.config['SECRET_KEY'], 'reset password')
# return s.dumps(self.id)
# def verify_reset_token(self, token, max_age=3600):
# s = Serializer(app.config['SECRET_KEY'], 'reset password')
# try:
# user_id = s.loads(token, max_age=max_age)
# except:
# return None
# return User.query.get(int(user_id))
def __repr__(self):
return f"User('{self.id}', '{self.username}', '{self.first_name}', '{self.role}', '{self.date_joined}')"
class PlayTime(db.Model):
id = db.Column(db.Integer, primary_key=True)
child_id = db.Column(db.Integer, db.ForeignKey('child.id'), nullable=False)
date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
start = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
duration = db.Column(db.Integer, nullable=False, default=0)
end = db.Column(db.DateTime, nullable=True)
class Game_Character_Save(db.Model):
id = db.Column(db.Integer, primary_key=True)
child_id = db.Column(db.Integer, db.ForeignKey('child.id'), nullable=False)
game_character = db.Column(db.Text, nullable=False)
save_date = db.Column(db.DateTime, nullable=False)
class Enroll(db.Model):
id = db.Column(db.Integer, primary_key=True)
child_id = db.Column(db.Integer, db.ForeignKey('child.id'), nullable=False)
subject = db.Column(db.String(3), nullable=False)
valid_until = db.Column(db.Date, nullable=False)
class Pricing(db.Model):
id = db.Column(db.Integer, primary_key=True)
duration = db.Column(db.Integer, nullable=False)
price = db.Column(db.Integer, nullable=False)
class Subject(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String, nullable=False)
short_form = db.Column(db.String(3), nullable=False, unique=True)