class Comment(db.Model):
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(30))
email = db.Column(db.String(64))
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)
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')
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
post = db.relationship('Post', back_populates='comments')
class Comment(Base):
"""
文章评论数据表模型类
"""
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(16))
email = db.Column(db.String(64))
site = db.Column(db.String(256))
content = db.Column(db.Text)
create_time = db.Column(db.DateTime, default=datetime.utcnow)
from_admin = db.Column(db.Boolean, default=False)
reviewed = db.Column(db.Boolean, default=False)
replied_id = db.Column(db.Integer, db.ForeignKey('comment.id'))
replied = db.relationship('Comment', remote_side=[id], uselist=False)
replies = db.relationship('Comment', cascade='all')
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
post = db.relationship('Post', uselist=False)
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_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')
from app.libs.extensions import db
# Post 表和 Category 表多对多关系中间表
post_category_middle = db.Table(
'post_category_middle',
db.Column('post_id',
db.Integer,
db.ForeignKey('post.id'),
primary_key=True),
db.Column('category_id',
db.Integer,
db.ForeignKey('category.id'),
primary_key=True))