class CourseRelationship(db.Model):
one_course_id = db.Column(db.Integer,
db.ForeignKey('course.id'),
primary_key=True)
other_course_id = db.Column(db.Integer,
db.ForeignKey('course.id'),
primary_key=True)
def __repr__(self):
return f"CourseRelationship('{self.one_course_id}', '{self.other_course_id}')"
class ProjectPicture(db.Model):
id = db.Column(db.Integer, primary_key=True)
image = db.Column(db.String(20), nullable=False, default='default.jpg')
project_id = db.Column(db.Integer,
db.ForeignKey('project.id'),
nullable=False)
def __repr__(self):
return f"ProjectPicture('{self.id}', '{self.project_id}')"
class PageText(db.Model):
id = db.Column(db.Integer, primary_key=True)
primary_text = db.Column(db.Text)
image = db.Column(db.String(20))
secondary_text = db.Column(db.Text)
position = db.Column(db.Integer, nullable=False, default=1)
page_id = db.Column(db.Integer, db.ForeignKey('page.id'), nullable=False)
def __repr__(self):
return f"PageText('{self.primary_text}', '{self.secondary_text}', '{self.position}', '{self.page_id}')"
class NewsComment(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(50), nullable=False)
email = db.Column(db.String(30), nullable=False)
message = db.Column(db.Text, nullable=False)
datetime = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
news_id = db.Column(db.Integer, db.ForeignKey('news.id'), nullable=False)
def __repr__(self):
return f"NewsComment('{self.username}', '{self.email}', '{self.datetime}', '{self.message}')"
class News(db.Model):
id = db.Column(db.Integer, primary_key=True)
header = db.Column(db.String(70), nullable=False)
description = db.Column(db.Text, nullable=False)
date_posted = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
image = db.Column(db.String(20), nullable=False, default='default.jpg')
text = db.Column(db.Text, nullable=False)
category_id = db.Column(db.Integer, db.ForeignKey('news_category.id'))
comments = db.relationship('NewsComment', backref='news', lazy=True)
def __repr__(self):
return f"News('{self.header}', '{self.description}', '{self.date_posted}')"