class Admin(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True, autoincrement=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) superword = db.Column(db.String(128)) is_admin = db.Column(db.Boolean, default=False) is_superadmin = db.Column(db.Boolean, default=False) posts = db.relationship('Post', back_populates='admin') comments = db.relationship('Comment', back_populates='admin') # 生成密码函数 def set_password(self, password): self.password_hash = generate_password_hash(password) def set_super(self, password): self.superword = generate_password_hash(password) def validate_super(self, password): return check_password_hash(self.superword, password) # 验证密码函数 def validate_password(self, password): return check_password_hash(self.password_hash, password)
class Ports(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) category_id = db.Column(db.Integer, db.ForeignKey('category.id')) category = db.relationship('Category', back_populates='ports') comments = db.relationship('Comments', back_populates='ports', cascade='all, delete-orphan')
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(30)) timestamp = db.Column(db.DateTime, default=datetime.utcnow) # 时间戳 body = db.Column(db.Text) can_comments = db.Column(db.Boolean, default=True) category_id = db.Column(db.Integer, db.ForeignKey('category.id')) # 将category_id设置为外键 category = db.relationship('Category', back_populates='posts') comments = db.relationship('Comment', back_populates='post', cascade='all, delete-orphan') # cascade设置级联操作
class Comments(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) posts_id = db.Column(db.Integer, db.ForeignKey('ports.id')) posts = db.relationship('Post', back_populates='comments') replied_id = db.Column(db.Integer, db.ForeignKey('comments.id')) replies = db.relationship('Comments', back_populates='replied', cascade='all, delete-orphan') replied = db.relationship('Comments', back_populates='replies', remote_side=[id])
class Admin(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, index=True) email = db.Column(db.String(254), unique=True, index=True) password_hash = db.Column(db.String(128)) name = db.Column(db.String(30)) about = db.Column(db.Text) confirmed = db.Column(db.Boolean, default=False) posts = db.relationship('Post', back_populates='author', cascade='all') comments = db.relationship('Comment', back_populates='author', cascade='all') 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 Comment(db.Model): id = db.Column(db.Integer, primary_key=True) author_name = db.Column(db.String(30)) body = db.Column(db.Text) reviewed = db.Column(db.Boolean, default=False) timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True) author_id = db.Column(db.Integer, db.ForeignKey('admin.id')) replied_id = db.Column(db.Integer, db.ForeignKey('comment.id')) post_id = db.Column(db.Integer, db.ForeignKey('post.id')) post_id_r = db.Column(db.Integer) author = db.relationship('Admin', back_populates='comments') 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 Comment(db.Model): id = db.Column(db.Integer, primary_key=True) author = db.Column(db.String(20)) timestamp = db.Column(db.DateTime, default=datetime.utcnow) 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表示被回复评论的标量关系属性, remote_side=[id]将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(30), unique=True) # 分类名不允许重复,unique=True # back_populates为SQLAlchemy的关系函数参数,用于定义反向引用,建立双向关系,在关系的另一侧也必须显式定义关系属性 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) ports = db.relationship('Ports', back_populates='category')