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 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 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='post')
comment = 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 Admin(db.Model, UserMixin):
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)
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 AdminUser(db.Model,UserMixin):
__tablename__='admins'
id=db.Column(db.Integer,primary_key=True)
username=db.Column(db.String(40),nullable=False,index=True)
password_hash=db.Column(db.String(128))
blog_title=db.Column(db.String(60))
blog_sub_title=db.Column(db.String(120))
name=db.Column(db.String(60))
about=db.Column(db.Text)
@property.setter
def set_password(self,password):
self.password_hash=generate_password_hash(password)
def verify_password(self,password):
return check_password_hash(self.password_hash,password)
class Link(db.Model):
id=db.Column(db.Integer,primary_key=True)
name=db.Column(db.String(40))
url=db.Column(db.String(255))
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')
