class Users(BaseModelPrimaryKey): username = db.Column(db.String(32), nullable=False, unique=True) _password = db.Column(db.String(128), nullable=False) @property def password(self): raise Exception("保存密码异常") @password.setter def password(self, pwd): self._password = generate_password_hash(pwd) def verify_password(self, pwd): return check_password_hash(self._password, pwd)
class UserComment(BaseModelPrimaryKey): conten = db.Column(db.Text(), nullable=False) user_id = db.Column(db.Integer, db.ForeignKey("users.id"))
class BaseModelPrimaryKey(BaseModels): __abstract__ = True id = db.Column(db.Integer, primary_key=True, autoincrement=True)
class Books(BaseModelPrimaryKey): b_name = db.Column(db.String(32), nullable=False) b_author = db.Column(db.String(32), nullable=False) b_user_id = db.Column(db.Integer, db.ForeignKey("users.id"))
class UserBlog(BaseModelPrimaryKey): title = db.Column(db.String(32), nullable=False) content = db.Column(db.Text()) user_id = db.Column(db.Integer, db.ForeignKey("users.id"))
class HobbyBlog(BaseModelPrimaryKey): user_id = db.Column(db.Integer, db.ForeignKey("users.id")) blog_id = db.Column(db.Integer, db.ForeignKey("user_blog.id"))