class Chapter(db.Model):
__tablename__ = 'chapter'
id_chapter = db.Column(db.Integer, primary_key=True)
part_id = db.Column(db.Integer,
db.ForeignKey('part.id_part', ondelete="CASCADE"))
name_chapter = db.Column(db.String(50), nullable=False)
text_chapter = db.Column(db.String(5000))
task_list = db.relationship('Task',
backref='chapter',
passive_deletes=True,
lazy='dynamic')
seo = db.relationship('Seo',
backref='chapter',
uselist=False,
passive_deletes=True)
def __init__(self, part_id, name_chapter, text_chapter):
self.part_id = part_id
self.name_chapter = name_chapter
self.text_chapter = text_chapter
def get_absolute_url(self):
return url_for('get_chapter',
language=self.part.language.name_language,
name_part=self.part.name_part,
name_chapter=self.name_chapter)
def __repr__(self):
return f"<chapters('{self.id_chapter}', '{self.part_id}', '{self.name_chapter}', '{self.text_chapter}')>"
class Seo(db.Model):
__tablename__ = 'seo'
id = db.Column('id', db.Integer, primary_key=True)
chapter_id = db.Column(
db.Integer, db.ForeignKey('chapter.id_chapter', ondelete='CASCADE'))
keywords = db.Column(db.String(50))
description = db.Column(db.String(2000))
def __init__(self, chapter_id, keywords, description):
self.chapter_id = chapter_id
self.keywords = keywords
self.description = description
def __repr__(self):
return f"<seo('{self.chapter_id}', '{self.keywords}', '{self.description}')>"
class User(db.Model, UserMixin):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), unique=True, nullable=False)
password = db.Column(db.String(60))
email = db.Column(db.String(100), unique=True, nullable=False)
privilages = db.Column(db.String(15), nullable=False, default='is_user')
def __init__(self, name, password, email, privilages):
self.name = name
self.password = password
self.email = email
self.privilages = privilages
def __repr__(self):
return f"<user('{self.id}', '{self.name}', '{self.email}', '{self.privilages}')>"
class Task(db.Model):
__tablename__ = 'task'
id_task = db.Column('id_task', db.Integer, primary_key=True)
chapter_id = db.Column(
db.Integer, db.ForeignKey('chapter.id_chapter', ondelete='CASCADE'))
name_task = db.Column(db.String(100))
text_task = db.Column(db.String(1000))
solution = db.Column(db.String(1000))
hint = db.Column(db.String(500))
def __init__(self, chapter_id, name_task, text_task, solution, hint):
self.chapter_id = chapter_id
self.name_task = name_task
self.text_task = text_task
self.solution = solution
self.hint = hint
def __repr__(self):
return f"<task('{self.chapter_id}', '{self.name_task}', '{self.text_task}', '{self.solution}', '{self.hint}')>"
class Language(db.Model):
__tablename__ = 'language'
id_language = db.Column(db.Integer, primary_key=True)
name_language = db.Column(db.String(40), unique=True)
description_language = db.Column(db.String(1500))
part_list = db.relationship('Part',
backref='language',
passive_deletes=True,
lazy='dynamic')
def __init__(self, name_language, description_language):
self.name_language = name_language
self.description_language = description_language
def get_absolute_url(self):
return redirect(url_for('get_language', language=self.name_language))
def __repr__(self):
return f"<languages('{self.id_language}', '{self.name_language}', '{self.description_language}')>"
class Part(db.Model):
__tablename__ = 'part'
id_part = db.Column(db.Integer, primary_key=True)
language_id = db.Column(
db.Integer, db.ForeignKey('language.id_language', ondelete="CASCADE"))
name_part = db.Column(db.String(50), nullable=False)
chapter_list = db.relationship('Chapter',
backref='part',
passive_deletes=True,
lazy='dynamic')
def __init__(self, language_id, name_part):
self.language_id = language_id
self.name_part = name_part
def __repr__(self):
return f"<parts('{self.id_part}', '{self.language_id}', '{self.name_part}')>"