class User(db.Model, UserMixin):
__tablename__ = "users"
id = db.Column(db.String(10), primary_key=True)
name = db.Column(db.String(100), nullable=False)
image_file = db.Column(db.String(100),
nullable=False,
server_default='default.jpg')
password = db.Column(db.String(100), nullable=False)
student = db.relationship('Students', backref='info', lazy=True)
prof = db.relationship('Professors', backref='info', lazy=True)
thread = db.relationship('Threads', backref='creator', lazy=True)
post = db.relationship('Posts', backref='author', lazy=True)
def roles(self):
role = []
if Students.query.get(self.id):
role.append("Student")
if TeachingAssistants.query.filter_by(sid=self.id, is_ta=True).first():
role.append("TA")
if Professors.query.get(self.id):
role.append("Professor")
return role
def get_id(self):
return (self.id)
def __repr__(self):
return f"User('{self.id}', {self.name}', '{self.image_file}')"
class Courses(db.Model):
__tablename__ = "courses"
cid = db.Column(db.String(10), primary_key=True)
cname = db.Column(db.String(100), nullable=False)
taken = db.relationship('TakenCourses', backref='courseinfo', lazy=True)
prof = db.relationship('Professors', backref='courseinfo', lazy=True)
def __repr__(self):
return f"Courses('{self.cid}', '{self.cname}')"
class ForumInfo(db.Model):
__tablename__ = "foruminfo"
fid = db.Column(db.Integer,
db.ForeignKey('forums.fid', ondelete='CASCADE'),
primary_key=True)
gid = db.Column(db.Integer, db.ForeignKey('groups.gid'), primary_key=True)
def __repr__(self):
return f"ForumInfo: fid={self.fid} gid={self.gid}"
class GroupInfo(db.Model):
__tablename__ = "groupinfo"
gid = db.Column(db.Integer, db.ForeignKey('groups.gid'), primary_key=True)
sid = db.Column(db.Integer,
db.ForeignKey('students.sid'),
primary_key=True)
def __repr__(self):
return f"GroupInfo('{self.gid}', '{self.sid}')"
class Students(db.Model):
__tablename__ = "students"
sid = db.Column(db.String(10), db.ForeignKey('users.id'), primary_key=True)
year = db.Column(db.Integer,
db.CheckConstraint('year >= 1 AND year <= 5'),
nullable=False)
taken = db.relationship('TakenCourses', backref='student', lazy=True)
group = db.relationship('GroupInfo', backref='student', lazy=True)
def __repr__(self):
return f"Students('{self.sid}', '{self.year}')"
class TeachingAssistants(db.Model):
__tablename__ = "teachingassistants"
__table_args__ = (db.ForeignKeyConstraint(
['sid', 'cid'], ['takencourses.sid', 'takencourses.cid']), )
sid = db.Column(db.String(10), primary_key=True)
cid = db.Column(db.String(10), primary_key=True)
is_ta = db.Column(db.Boolean, nullable=False, server_default='0')
group = db.relationship('Groups', backref='ta', lazy=True)
def __repr__(self):
return f"TeachingAssistants('{self.sid}', '{self.cid}', '{self.is_ta}')"
class Professors(db.Model):
__tablename__ = "professors"
pid = db.Column(db.String(10), db.ForeignKey('users.id'), primary_key=True)
cid = db.Column(db.String(10),
db.ForeignKey('courses.cid'),
unique=True,
nullable=False)
group = db.relationship('Groups', backref='prof', lazy=True)
forum = db.relationship('Forums', backref='prof', lazy=True)
def __repr__(self):
return f"Professors('{self.pid}', '{self.cid}')"
class Ratings(db.Model):
__tablename__ = "ratings"
__table_args__ = (db.ForeignKeyConstraint(
['fid', 'tid', 'post_num'],
['posts.fid', 'posts.tid', 'posts.post_num'],
ondelete='CASCADE'), )
fid = db.Column(db.Integer, primary_key=True)
tid = db.Column(db.Integer, primary_key=True)
post_num = db.Column(db.Integer, primary_key=True)
id = db.Column(db.String(10), db.ForeignKey('users.id'), primary_key=True)
rating = db.Column(db.Integer,
db.CheckConstraint('rating >= 0 AND rating <= 5'),
nullable=False)
def __repr__(self):
return f"Ratings: fid={self.fid} tid={self.tid} post_num={self.post_num} id={self.id} rating={self.rating}"
class Forums(db.Model):
__tablename__ = "forums"
fid = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(60), nullable=False)
pid = db.Column(db.String(10),
db.ForeignKey('professors.pid'),
nullable=False)
date_created = db.Column(db.DateTime, nullable=False, default=datetime.now)
thread = db.relationship('Threads', backref='forum', lazy=True)
foruminfo = db.relationship('ForumInfo', backref='info', lazy=True)
threadcascade = db.relationship('Threads',
cascade='all, delete-orphan',
backref='parent')
def __repr__(self):
return f"Forums('{self.gid}', '{self.sid}', '{self.name}')"
class Groups(db.Model):
__tablename__ = "groups"
__table_args__ = (db.ForeignKeyConstraint(
['sid', 'cid'],
['teachingassistants.sid', 'teachingassistants.cid']), )
gid = db.Column(db.Integer, primary_key=True)
gname = db.Column(db.String(50), nullable=False)
pid = db.Column(db.String(10),
db.ForeignKey('professors.pid'),
nullable=False)
sid = db.Column(db.String(10))
cid = db.Column(db.String(10))
groupinfo = db.relationship('GroupInfo', backref='groupinfo', lazy=True)
group = db.relationship('ForumInfo', backref='group', lazy=True)
def __repr__(self):
return f"Groups('{self.gid}', '{self.gname}', '{self.pid}', '{self.sid}')"
class TakenCourses(db.Model):
__tablename__ = "takencourses"
sid = db.Column(db.String(10),
db.ForeignKey('students.sid'),
primary_key=True)
cid = db.Column(db.String(10),
db.ForeignKey('courses.cid'),
primary_key=True)
year = db.Column(db.String(10), nullable=False)
sem = db.Column(db.Integer,
db.CheckConstraint('sem = 1 OR sem = 2'),
nullable=False)
grade = db.Column(db.String(5), server_default='')
is_rated = db.Column(db.Boolean, nullable=False, server_default='0')
rating = db.Column(db.Float, nullable=False, server_default='0.0')
is_pending = db.Column(db.Boolean, nullable=False, server_default='0')
ta = db.relationship('TeachingAssistants', backref='courseinfo', lazy=True)
def __repr__(self):
return f"TakenCourses('{self.sid}', '{self.cid}', '{self.year}', '{self.sem}', '{self.grade}')"
class Threads(db.Model):
__tablename__ = "threads"
fid = db.Column(db.Integer,
db.ForeignKey('forums.fid', ondelete='CASCADE'),
primary_key=True)
tid = db.Column(db.Integer, primary_key=True)
id = db.Column(db.String(10), db.ForeignKey('users.id'), nullable=False)
title = db.Column(db.String(60), nullable=False)
content = db.Column(db.Text, nullable=False)
date_created = db.Column(db.DateTime, nullable=False, default=datetime.now)
posts = db.relationship('Posts', backref='thread', lazy=True)
postcascade = db.relationship('Posts',
cascade='all, delete-orphan',
backref='parent')
# threadinfo = db.relationship('ThreadInfo', backref='info', lazy=True)
def __repr__(self):
return f"Threads: fid={self.fid} tid={self.tid} id={self.id} title={self.title} date_created={self.date_created}"
class Posts(db.Model):
__tablename__ = "posts"
__table_args__ = (
db.ForeignKeyConstraint(['fid', 'tid'], ['threads.fid', 'threads.tid'],
ondelete='CASCADE'),
db.ForeignKeyConstraint(['pfid', 'ptid', 'ppost_num'],
['posts.fid', 'posts.tid', 'posts.post_num'],
ondelete='CASCADE'),
db.CheckConstraint('pfid = fid'),
db.CheckConstraint('ptid = tid'),
db.CheckConstraint('ppost_num IS NULL OR ppost_num <> post_num'),
)
fid = db.Column(db.Integer, primary_key=True)
tid = db.Column(db.Integer, primary_key=True)
post_num = db.Column(db.Integer, primary_key=True)
id = db.Column(db.String(10), db.ForeignKey('users.id'), nullable=False)
title = db.Column(db.String(60), nullable=False)
content = db.Column(db.Text, nullable=False)
date_posted = db.Column(db.DateTime, nullable=False, default=datetime.now)
date_edited = db.Column(db.DateTime, nullable=True)
pfid = db.Column(db.Integer)
ptid = db.Column(db.Integer)
ppost_num = db.Column(db.Integer)
postcascade = db.relationship('Posts', cascade='all, delete-orphan')
ratingcascade = db.relationship('Ratings', cascade='all, delete-orphan')
def __repr__(self):
return f"Posts: fid={self.fid} tid={self.tid} post_num={self.post_num} pfid={self.pfid} ptid={self.ptid} ppost_num={self.ppost_num} id={self.id} title={self.title} date={self.date_posted} rating={self.rating}"
