class Category(db.Model): """生成分类的类 规定了分类的各个属性及与文章的关系 Attributes: id:分类的id,主键 name: 分类的名称,长度限制30,不能重复 posts: 设置中间表名称 """ id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30), unique=True) posts = db.relationship('Post', back_populates='category') def delete(self): """删除分类 删除分类并将此分类下的文章移至默认分类 """ default_category = Category.query.get(1) posts = self.posts[:] for post in posts: post.category = default_category db.session.delete(self) db.session.commit()
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): """评论模型""" 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 Category(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30), unique=True) posts = db.relationship('Post', back_populates='category') def __repr__(self): return f'<Category {self.name}>'
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 Category(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30), unique=True) # 集合关系属性 posts = db.relationship('Post', back_populates='category') pass
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 Tag(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(16), unique=True) posts = db.relationship('Post', secondary=association_table, back_populates='tags') def delete(self): db.session.delete(self) db.session.commit()
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 Category(db.Model): #文章的分类 __table_args__ = {'extend_existing': True} id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30), unique=True) posts = db.relationship('Post', back_populates='category') def __repr__(self): return '<Category {}>'.format(self.name)
class Category(db.Model): """博客分类""" __tablename__ = 'category' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20), nullable=False, unique=True) # category.posts 知道category求category下所有的post # post.post_of_category 知道post,求post所在的category posts = db.relationship('Post', back_populates='category', 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 Category(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30), unique=True) posts = db.relationship("Post", back_populates="category") def delete(self): default_category = Category.query.get(1) posts = self.posts[:] for post in posts: post.category = default_category db.session.delete(self) db.session.commit()
class Category(db.Model): __tablename__ = 'category' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30), unique=True) # 分类名称不能重复 posts = db.relationship('Post', back_populates='category') def delete(self): default_category = Category.query.get(1) posts = self.posts[:] for post in posts: post.category = default_category db.session.delete(self) db.session.commit()
class Link(db.Model): """生成链接表的类 生成链接的各个属性 Attributes: id:链接的表,主键 name:链接的名字 url:链接的链接 """ id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30)) url = db.Column(db.String(255))
class Blogger(db.Model, UserMixin): __tablename__ = 'blogger' id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20)) password_hash = db.Column(db.String(128)) title = db.Column(db.Enum('博客专家', '博客牛人', '博客新人', '游客'), server_default='游客') def set_password(self, password): self.password_hash = generate_password_hash(password) def validate_password(self, password): return check_password_hash(self.password_hash, password)
class Category(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30), unique=True) # 分类名称不允许重复 # 和Post的双向关系 posts = db.relationship('Post', back_populates='category') def delete(self): default_category = Category.query.get(1) posts = self.posts[:] # 把当前分类下的所有文章都归类到默认分类 for post in posts: post.category = default_category db.session.delete(self) db.session.commit()
class Category(db.Model): """文章分类""" id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30), unique=True) # 集合关系属性 posts = db.relationship('Post', back_populates='category') def delete(self): # 获取默认分类记录 default_category = Category.query.get(1) posts = self.posts[:] for post in posts: post.category = default_category db.session.delete(self) db.session.commit()
class Category(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30), unique=True) status = db.Column(db.Enum('使用中', '废弃'), server_default='使用中', nullable=False) posts = db.relationship('Post', back_populates='category') def delete(self): default_category = Category.query.get(1) posts = self.posts[:] for post in posts: post.category = default_category db.session.delete(self) db.session.commit()
class Category(db.Model): """ 分类 """ id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30), unique=True) posts = db.relationship('Post', back_populates='category') def delete(self): default_category = Category.query.filter_by(id=1).first() posts = self.posts[:] for post in posts: # 用于循环的列表不能变化,如果这里用self.posts,它每次遍历时,值就不一样了 post.category = default_category db.session.delete(self) db.session.commit()
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 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 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)) # 从文章标题生成 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 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 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 Admin(db.Model): id = db.Column(db.INTEGER, primary_key=True) username = db.Column(db.String(20)) password_hash = db.Column(db.String(128)) blog_title = db.Column(db.String(60)) blog_sub_title = db.Column(db.String(100)) name = db.Column(db.String(30)) about = db.Column(db.Text)
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 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): 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')