class Notifications(db.Model):
id = db.Column(db.Integer, primary_key=True)
grade = db.Column(db.String(100))
title = db.Column(db.String(500))
message = db.Column(db.String(1000))
sent_date = db.Column(db.DateTime, default=datetime.datetime.utcnow)
def __repr__(self):
return f"Notification '{self.title}' for grade '{self.grade}' created on '{self.sent_date}'"
class SamplePapers(db.Model):
id = db.Column(db.Integer, primary_key=True)
paper_name = db.Column(db.String(500))
subject = db.Column(db.String(100))
grade = db.Column(db.String(10))
paper_url = db.Column(db.String(500))
year = db.Column(db.String(200))
def _repr_(self):
return f"Sample Paper '{self.paper_name}' for grade '{self.grade}' created on '{self.uploaded_date}'"
class Notes(db.Model):
id = db.Column(db.Integer, primary_key=True)
notes_name = db.Column(db.String(500), unique=True)
subject = db.Column(db.String(10))
grade = db.Column(db.String(10))
topic = db.Column(db.String(400))
notes_url = db.Column(db.String(700), unique=True)
posted_date = db.Column(db.DateTime, default=datetime.datetime.utcnow)
def __repr__(self):
return f"Notes '{self.notes_name}' for grade '{self.grade}' created on '{self.posted_date}'"
class Videos(db.Model):
id = db.Column(db.Integer, primary_key=True)
video_name = db.Column(db.String(500), unique=True)
subject = db.Column(db.String(10))
grade = db.Column(db.String(10))
topic = db.Column(db.String(400))
description = db.Column(db.String(1000), unique=True)
video_url = db.Column(db.String(700), unique=True)
thumbnail_url = db.Column(db.String(700), unique=True)
posted_date = db.Column(db.DateTime, default=datetime.datetime.utcnow)
def __repr__(self):
return f"Video '{self.video_name}' for grade '{self.grade}' created on '{self.posted_date}'"