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') can_comment = db.Column(db.Boolean, default=True)
class Post(db.Model): id=db.Column(db.Integer,primary_key=True) blog_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,delete-orphan')
class Comment(db.Model): id=db.Column(db.Integer,primary_key=True) author=db.Column(db.String(40)) email=db.Column(db.String(256)) site=db.Column(db.String(255)) timestamp=db.Column(db.DateTime,default=datetime.utcnow,index=True) body=db.Column(db.Text) from_admin=db.Column(db.Boolean,default=False) #是否是管理员评论 reviewed=db.Column(db.Boolean,default=False) #是否通过审核,为了防止垃圾评论或者是不当的评论 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_site=[id]) #子评论 replies=db.relationship('Comment',back_populates='replied',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) 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')
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(60)) #与模型Post建立一对多关系 posts=db.relationship('Post',back_populates='category')
class Category(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(60), unique=True) post = db.relationship('Post', back_populates='category')