class Comment(db.Model):
"""评论模型"""
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(30))
email = db.Column(db.String(254))
site = db.Column(db.String(255))
body = db.Column(db.Text)
from_admin = db.Column(db.Boolean, default=False)
reviewed = db.Column(db.Boolean, default=False, comment='评论是否通过审核')
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
replied_id = db.Column(db.Integer,
db.ForeignKey("comment.id")) # 设置外键指向自身id
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
post = db.relationship('Post', back_populates='comments')
# 集合关系属性replies 中的cascade参数设为all,当父评论被删除，所有子评论也删除
replies = db.relationship('Comment',
back_populates='replied',
cascade='all,delete-orphan')
# 将remote_side参数设为id字段，
# 把id字段定义为关系的远程侧（Remote Side）,replied_id相应的变为本地侧（Local Side）
replied = db.relationship('Comment',
back_populates='replies',
remote_side=[id])
class Comment(db.Model):
"""每条博客的评论"""
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(20))
email = db.Column(db.String(254))
# site表示发布comment的作者的个人网站
site = db.Column(db.String(255))
body = db.Column(db.Text)
# 是否是自己评论
from_admin = db.Column(db.Boolean, default=False)
timestamp = db.Column(db.DateTime, default=datetime.now(), index=True)
# Post:Comment=One:Many 一对多关系 Comment中含有Post的外键
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
post = db.relationship('Post', back_populates='comments')
# 评论审查是否通过
reviewed = db.Column(db.Boolean, default=False)
# 得到评论的回复列表，此字段在项目中没有用到
# replies = db.relationship('Comment', lazy='select',
# backref=db.backref('replied', remote_side=[id]),
# cascade='all,delete-orphan')
replies = db.relationship('Comment', back_populates='replied', cascade='all, delete-orphan')
# 还有一种特殊的评论，这种评论是对评论的评论，我暂且叫他回复
# 假如还有一个表叫Reply
# Comment:Reply=One:Many 回复同时也是一种特殊的评论，引用自己的主键，叫自关联
# replied_id:表示对那个comment进行的回复
replied_id = db.Column(db.Integer, db.ForeignKey('comment.id'))
# 根据post.html的理解，此字段表示当前reply是对那个comment的回答，这个是特殊的comment
replied = db.relationship('Comment', back_populates='replies', remote_side=[id])
class Comment(db.Model):
"""
author: 作者
email: 电子邮件
site: 站点
body: 正文
from_admin: 是否是管理员评论
reviewed: 是否通过审核
timestamp: 时间戳
"""
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(30))
email = db.Column(db.String(254))
site = db.Column(db.String(255))
body = db.Column(db.Text)
from_admin = db.Column(db.Boolean, default=False)
reviewed = db.Column(db.Boolean, default=False)
timestamp = db.Column(db.DateTime, default=datetime.utcnow)
# post表的id值
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
replied_id = db.Column(db.Integer, db.ForeignKey('comment.id'))
post = db.relationship('Post', back_populates='comments')
replies = db.relationship('Comment',
back_populates='replied',
cascade='all, delete-orphan')
replied = db.relationship('Comment',
back_populates='replies',
remote_side=[id])
class Subcategory(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(15), )
exegesis = db.Column(db.String(30))
frequency = db.Column(db.Integer, index=True, default=0) # 次数
disable = db.Column(db.Boolean, index=True, default=False)
auto_id = db.Column(db.Integer, db.ForeignKey('auto.id'))
major_id = db.Column(db.Integer, db.ForeignKey('major.id'))
major = db.relationship('Major', back_populates='subcategorys')
picture = db.relationship('Picture',
back_populates='subcategorys',
cascade='all, delete')
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
class Picture(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(150), index=True)
description = db.Column(db.Text) # 描述
attribute = db.Column(db.String(150)) # 属性
color = db.Column(db.String(150)) # 颜色
picture = db.Column(db.String(150)) # 图片
price = db.Column(db.Float(5, 2)) # 价格
frequency = db.Column(db.Integer, index=True, default=0) # 次数
auto_id = db.Column(db.Integer, db.ForeignKey('auto.id'))
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
subcategorys_id = db.Column(db.Integer, db.ForeignKey('subcategory.id'))
subcategorys = db.relationship('Subcategory', back_populates='picture')
class Comment(db.Model):
__tablename__ = 'comment'
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(30))
body = db.Column(db.Text)
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
article_id = db.Column(db.Integer, db.ForeignKey('article.id'))
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(60))
# 从文章标题生成
slug = db.Column(db.String(240))
body = db.Column(db.Text)
timestamp = db.Column(db.DateTime, default=datetime.utcnow)
# 是否可以评论
can_comment = db.Column(db.Boolean, default=True)
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
category = db.relationship('Category', back_populates='posts')
# 评论
comments = db.relationship('Comment',
backref='post',
cascade='all,delete-orphan')
def to_json(self):
dict = self.__dict__
dict['category'] = self.category.name
dict['comments'] = len(self.comments)
if "_sa_instance_state" in dict:
del dict["_sa_instance_state"]
dict['timestamp'] = dict['timestamp'].strftime('%Y-%m-%d %H:%M:%S')
return dict
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(60))
body = db.Column(db.Text)
obperson = db.Column(db.Integer)
author = db.Column(db.String(30))
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
# can_comment = db.Column(db.Boolean, default=True)
reviewed = db.Column(db.Boolean, default=False)
suggestion = db.Column(db.Text, default=None)
admin_id = db.Column(db.Integer, db.ForeignKey('admin.id'))
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
admin = db.relationship('Admin', back_populates='posts')
category = db.relationship('Category', back_populates='posts')
class Post(db.Model):
"""生成文章表的类
规定文章表的各个属性
Attributes:
id:文章的 id，主键
title:文章的标题，限制长度60
body:文章的内容
timestamp:文章的创建时间，默认是当前时间
can_coment:文章是否可以评论
category_id:文章的分类id，外键
category:设置和分类的中间表的名称
coments:设置和评论的中间表的名称，规定删除文章时，删除文章下的所有评论
"""
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(60))
body = db.Column(db.Text)
timestamp = db.Column(db.DateTime, default=datetime.utcnow)
can_comment = db.Column(db.Boolean, default=True)
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
category = db.relationship('Category', back_populates='posts')
comments = db.relationship('Comment',
back_populates='post',
cascade='all, delete-orphan')
class Comment(db.Model):
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(50))
email = db.Column(db.String(254))
site = db.Column(db.String(254))
body = db.Column(db.Text)
from_admin = db.Column(db.Boolean, default=False)
reviewed = db.Column(db.Boolean, default=False)
timestamp = db.Column(db.DateTime, default=datetime.utcnow)
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
post = db.relationship('Post', back_populates='comments')
reply_id = db.Column(db.Integer, db.ForeignKey('comment.id'))
reply = db.relationship('Comment',
back_populates='replies',
remote_side=[id])
replies = db.relationship('Comment', back_populates='reply', cascade='all')
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(60))
body = db.Column(db.Text)
timestamp = db.Column(db.DateTime, default=datetime.utcnow)
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
category = db.relationship('Category', back_populates='posts')
comments = db.relationship('Comment', back_populates='post', cascade='all')
class basicsettings(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(150), index=True)
Keyword = db.Column(db.String(150), index=True)
description = db.Column(db.String(500), index=True)
frequency = db.Column(db.Integer, index=True, default=0) # 次数
auto_id = db.Column(db.Integer, db.ForeignKey('auto.id'))
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
class Comment(db.Model):
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(30))
email = db.Column(db.String(254))
site = db.Column(db.String(255))
body = db.Column(db.Text)
from_admin = db.Column(db.Boolean, default=False)
reviewed = db.Column(db.Boolean, default=False)
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
# 子评论与父评论连接起来，多对一关系，在多的一侧建立外键
replied_id = db.Column(db.Integer, db.ForeignKey('comment.id'))
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
post = db.relationship('Post', back_populates='comments')
# 与子评论链接起来，当父评论被删除时，一起删除；属于Comment类
replies = db.relationship('Comment', back_populates='replied', cascade='all, delete-orphan')
replied = db.relationship('Comment', back_populates='replies', remote_side=[id])
class Comment(db.Model):
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(30))
email = db.Column(db.String(254))
site = db.Column(db.String(255))
body = db.Column(db.Text)
from_admin = db.Column(db.Boolean, default=False)
reviewed = db.Column(db.Boolean, default=False)
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
post = db.relationship('Post', back_populates='comments')
# 设置邻接关系,也就是内部的关联，内部的一对多
replied_id = db.Column(db.Integer, db.ForeignKey('comment.id'))
replied = db.relationship('Comment',
back_populates='replies',
remote_side=[id]) # remote_side确定了这个字段为多的一侧
replies = db.relationship('Comment',
back_populates='replied',
cascade='all')
class Comment(db.Model): #文章的评论
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(30))
email = db.Column(db.String(254))
site = db.Column(db.String(255))
body = db.Column(db.Text)
from_admin = db.Column(db.Boolean, default=False)
reviewed = db.Column(db.Boolean, default=False)#判断评论是否通过审核以防止不当评论
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))#文章和评论存在一对多关系
post = db.relationship('Post', back_populates='comments')
replied_id = db.Column(db.Integer, db.ForeignKey('comment.id'))
replied = db.relationship('Comment', back_populates='replies', remote_side=[id]) #父评论
replies = db.relationship('Comment', back_populates='replied', cascade='all') #多个回复
def __repr__(self):
return '<Comment {}>'.format(self.author)
class Comment(db.Model):
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(30))
email = db.Column(db.String(254))
site = db.Column(db.String(255))
body = db.Column(db.Text)
from_admin = db.Column(db.Boolean, default=False) # 是否是管理员的评论
reviewed = db.Column(db.Boolean, default=False) # 该评论是否过了审核
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
post = db.relationship('Post', back_populates='comments')
replied_id = db.Column(db.Integer, db.ForeignKey('comment.id'))
replied = db.relationship('Comment',
back_populates='replies',
remote_side=[id])
replies = db.relationship('Comment',
back_populates='replied',
cascade='all, delete-orphan')
class Article(db.Model):
__tablename__ = 'article'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(60))
body = db.Column(db.Text)
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
blogger_id = db.Column(db.Integer, db.ForeignKey('blogger.id'))
blogger = db.relationship('Blogger', backref='article')
comments = db.relationship('Comment',
backref='article',
cascade='all, delete-orphan')
class Comment(db.Model):
__tablename__ = 'comment'
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(30)) # 评论作者
email = db.Column(db.String(254)) # 评论人电子邮箱
site = db.Column(db.String(254)) # 站点
body = db.Column(db.Text) # 评论信息
from_admin = db.Column(db.Boolean, default=False) # 是否来着管理员的评论
reviewed = db.Column(db.Boolean, default=False) # 是否通过管理员评审
timestamp = db.Column(db.DateTime, default=datetime.utcnow)
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
post = db.relationship('Post', back_populates='comments')
# 评论回复功能设置，评论回复理论上也算做一个评论，一个评论可以有多个回复
# 因此可以设置表内的一对多关系
replied_id = db.Column(db.Integer, db.ForeignKey('comment.id'))
# 通过Comment对象实例的replied可以获得回复对应的原始 评论
replied = db.relationship('Comment', back_populates='replies',
remote_side=[id])
# 通过Comment对象实例的replies可以获得所有的回复
replies = db.relationship('Comment', back_populates='replied',
cascade='all')
class Comment(db.Model):
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(30))
email = db.Column(db.String(254))
site = db.Column(db.String(255))
body = db.Column(db.Text)
from_admin = db.Column(db.Boolean, default=False) # 是否是管理员的评论
reviewed = db.Column(db.Boolean, default=False) # 是否通过审核，以防止垃圾评论或不当评论
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
# 和Post的双向关系
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
post = db.relationship('Post', back_populates='comments')
# 评论回复功能，并在获取某个评论时可以通过关系属性获得对应的回复，这样就可以在模板中显示出评论之间的对应关系
# 因为回复本身也是评论，如果在评论模型内建立层级关系，就可以在一个模型中表示评论和评论的回复
# 这种在同一个模型内部的一对多关系在SQLAlchemy中被称为邻接列表关系(Adjacency List Relationship)
# 在Comment模型内部添加一个外键指向它自身，这样就得到一种层级关系：每个评论对象都可以包含多个自评论，即回复
replied_id = db.Column(db.Integer, db.ForeignKey('comment.id'))
replies = db.relationship('Comment', back_populates='replied', cascade='all, delete-orphan') # 设置级联删除，即评论删除之后对应的回复也一并删除
replied = db.relationship('Comment', back_populates='replies', remote_side=[id])
class Experiment(db.Model):
id = db.Column(db.Integer, primary_key=True)
specimen = db.Column(db.Integer)
user = db.Column(db.String(30))
extensometer = db.Column(db.String(30))
body = db.Column(db.Text)
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
can_edit = db.Column(db.Boolean, default=True)
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
category = db.relationship('Category', back_populates='experiments')
class Comment(db.Model):
"""生成评论表的类
规定评论表的各个属性
Attributes:
id:评论的id
author:评论的作者
email:评论作者的E-mail
site:评论作者的网址
body:评论的内容
form_admin:评论是否来自管理员
reviewed:评论是否经过管理员审核
timestamp:评论的时间，默认为当前时间，并设置索引
post_id:评论文章的评论的外键为文章的id
relied_id:回复评论的评论的外键为评论的id
post:设置和post的中间表
replies:
relied:
"""
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(30))
email = db.Column(db.String(354))
site = db.Column(db.String(255))
body = db.Column(db.Text)
from_admin = db.Column(db.Boolean, default=False)
reviewed = db.Column(db.Boolean, default=False)
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
replied_id = db.Column(db.Integer, db.ForeignKey('comment.id'))
post = db.relationship('Post', back_populates='comments')
replies = db.relationship('Comment',
back_populates='replied',
cascade='all, delete-orphan')
replied = db.relationship('Comment',
back_populates='replies',
remote_side=[id])
class Major(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(15), unique=True)
remarks = db.Column(db.String(300))
exegesis = db.Column(db.String(30))
least = db.Column(db.Float())
maximum = db.Column(db.Float())
frequency = db.Column(db.Integer, index=True, default=0) # 次数
auto_id = db.Column(db.Integer, db.ForeignKey('auto.id'))
subcategorys = db.relationship('Subcategory',
back_populates='major',
cascade='all, delete')
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(60))
body = db.Column(db.Text)
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
can_comment = db.Column(db.Boolean, default=True)
author_id = db.Column(db.Integer, db.ForeignKey('admin.id'))
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
category = db.relationship('Category', back_populates='posts')
comments = db.relationship('Comment',
back_populates='post',
cascade='all, delete-orphan')
# 将表Aticle与表User关联起来,实现需求：
# 1、可以通过一个article 标题查找到对应的作者（username）
# 2、db.backref 可以通过作者username 查找到对应作者写的所有文章
# 注意：
# 1、关联的class名要用引号括起来'User'
# 2、反向关联写成 backref = db.backref('articles'),引号里可以随便命名，以后就用这个名称来关联
author = db.relationship('Admin', backref=db.backref('post'))
class Post(db.Model): #文章模型
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(60))
body = db.Column(db.Text)
timestamp = db.Column(db.DateTime, default=datetime.utcnow)
can_comment = db.Column(db.Boolean, default=True)
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
category = db.relationship('Category', back_populates='posts') #分类和文章之间具有一对多的关系
comments = db.relationship('Comment', back_populates='post', cascade='all,delete-orphan')#级联删除
def __repr__(self):
return '<Post {}>'.format(self.title)
class Post(db.Model):
id = db.Column(db.INTEGER, primary_key=True)
title = db.Column(db.String(100))
body = db.Column(db.TEXT)
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
can_comment = db.Column(db.Boolean, default=True)
category_id = db.Column(db.INTEGER, db.ForeignKey('category.id'))
category = db.relationship('Category', back_populates='posts')
comments = db.relationship('Comment',
back_populates='post',
cascade='all, delete-orphan')
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(60))
body = db.Column(db.Text)
timestamp = db.Column(db.DateTime, default=datetime.utcnow)
can_comment = db.Column(db.Boolean, default=True)
# 和Category的双向关系
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
category = db.relationship('Category', back_populates='posts')
# 和Comment的双向关系
comments = db.relationship('Comment', back_populates='post', cascade='all, delete-orphan') # 设置级联删除，即文章删除之后对应的评论也一并删除
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(60))
body = db.Column(db.Text)
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
can_comment = db.Column(db.Boolean, default=True)
published = db.Column(db.Boolean, default=False) # 默认仅管理员可见
pinned = db.Column(db.Boolean, default=False) # 默认不置顶
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
category = db.relationship('Category', back_populates='posts')
comments = db.relationship('Comment', back_populates='post', cascade='all, delete-orphan')
tags = db.relationship('Tag', secondary=association_table, back_populates='posts')
class Post(db.Model):
__tablename__ = 'post'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(60)) # 文章标题
body = db.Column(db.Text) # 正文
# 使用格林威治时间，不带时区
timestamp = db.Column(db.DateTime, default=datetime.utcnow)
# 是否可以评论
can_comment = db.Column(db.Boolean, default=True)
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
category = db.relationship('Category', back_populates='posts')
# 建立双向关系（一post对多comments），并设置级联删除，当文章删除时，相应的评论也删除掉
comments = db.relationship('Comment', back_populates='post',
cascade='all,delete-orphan')
class Comment(db.Model):
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(30))
email = db.Column(db.String(254))
site = db.Column(db.String(255))
body = db.Column(db.Text)
# is the comment from admin
from_admin = db.Column(db.Boolean, default=False)
reviewed = db.Column(db.Boolean, default=False) # is the comment approved
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
post = db.relationship('Post', back_populates='comments')
# relationship() with parameter remote_side to set
# id => remote side, replied => local side
replied_id = db.Column(db.Integer, db.ForeignKey('comment.id'))
replied = db.relationship('Comment',
back_populates='replies',
remote_side=[id])
replies = db.relationship('Comment',
back_populates='replied',
cascade='all')
class Comment(db.Model):
"""评论"""
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(30))
email = db.Column(db.String(254))
site = db.Column(db.String(255))
body = db.Column(db.Text)
from_admin = db.Column(db.Boolean, default=False)
reviewed = db.Column(db.Boolean, default=False)
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
# 外键
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
# 标量关系属性
post = db.relationship('Post', back_populates='comments')
# 指向自身的外键
replied_id = db.Column(db.Integer, db.ForeignKey('comment.id'))
# 标量关系属性
replied = db.relationship('Comment',
back_populates='replies',
remote_side=[id])
# 集合关系属性，，设置级联删除，父评论删除后，子评论会同时被删除
replies = db.relationship('Comment',
back_populates='replied',
cascade='all')
