class ArticleEdits(db.Model):
id = db.Column(db.Integer, primary_key=True)
article_id = db.Column(
db.Integer,
db.ForeignKey('article.id'),
nullable=False,
)
is_edited = db.Column(
db.Boolean,
default=False,
)
is_ready_for_release = db.Column(
db.Boolean,
default=False,
)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
edited = db.Column(db.DateTime, nullable=True, default=datetime.utcnow)
title = db.Column(
db.String(100),
nullable=False,
)
preview = db.Column(db.String(200), nullable=False)
image_file = db.Column(db.String(100), default='default.png')
content = db.Column(db.Text, nullable=False)
tags = db.relationship('EditTags', backref='edit')
def __repr__(self):
return f'ArtEditicle(title={self.title},preview={self.preview},date={self.edited}, edited={self.is_edited}, ready for release={self.is_ready_for_release}'
class Read(db.Model):
id = db.Column(db.Integer, primary_key=True)
message_id = db.Column(db.Integer,
db.ForeignKey('messages.id'),
nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f'UserID:{self.user_id} read MessageID:{self.message_id}'
class Messages(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), nullable=False)
email = db.Column(db.String(120), nullable=False)
reason = db.Column(db.Integer, db.ForeignKey('reasons.id'))
content = db.Column(db.Text, nullable=False)
def __repr__(self):
return f'Message from {self.name} about {self.reason}: {self.content}'
class User(db.Model, UserMixin):
id = db.Column(
db.Integer,
primary_key=True,
)
authorization_level = db.Column(
db.String(60),
nullable=False,
)
linkedin = db.Column(db.String(100), )
full_name = db.Column(
db.String(45),
unique=False,
nullable=False,
)
twitter_handle = db.Column(
db.String(20),
unique=True,
nullable=True,
)
email = db.Column(
db.String(120),
unique=True,
nullable=False,
)
image_file = db.Column(
db.String(20),
nullable=False,
default='default.svg',
)
password = db.Column(
db.String(60),
nullable=False,
)
articles = db.relationship('Article', backref='author', lazy=True)
edits = db.relationship('ArticleEdits', backref='author', lazy=True)
content = db.Column(db.Text, nullable=False)
def __repr__(self):
return f'User(id={self.id},full_name={self.full_name},email={self.email})'
class Update(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(
db.String(150),
nullable=False,
)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
edited = db.Column(db.DateTime, nullable=True, default=None)
content = db.Column(db.Text, nullable=False)
def __repr__(self):
return f'Update(title={self.title},posted={self.posted}'
class Article(db.Model):
id = db.Column(db.Integer, primary_key=True)
current_edit_id = db.Column(
db.Integer, nullable=True) #Used to determine actual displayed content
is_released = db.Column(
db.Boolean,
default=False,
)
author_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
posted = db.Column(
db.DateTime,
nullable=True,
)
edited = db.Column(db.DateTime,
default=datetime.utcnow,
onupdate=datetime.utcnow)
all_edits = db.relationship('ArticleEdits', backref='article')
def __repr__(self):
return f'Article(id={self.id},edit_id={self.current_edit_id},date={self.posted}'
class EditTags(db.Model):
id = db.Column(db.Integer, primary_key=True)
edit_id = db.Column(db.Integer, db.ForeignKey('article_edits.id'))
tag_id = db.Column(db.Integer, db.ForeignKey('tags.id'))
class Tags(db.Model):
id = db.Column(db.Integer, primary_key=True)
desc = db.Column(db.String(20), nullable=False)
def __repr__(self):
return f'Id:{self.id}, desc:{self.desc}'