class Permissions(db.Model): """ 权限表 """ __tablename__ = 'permissions' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64)) url = db.Column(db.String(64), nullable=True) available = db.Column(db.Boolean, default=1) time_create = db.Column(db.DateTime, default=datetime.now)
class Roles(db.Model): """ 角色 """ __tablename__ = 'roles' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64)) available = db.Column(db.Boolean, default=1) time_create = db.Column(db.DateTime, default=datetime.now)
class Users(db.Model): __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) uid = db.Column(db.String(64), unique=True, index=True) username = db.Column(db.String(64), unique=True, index=True) password = db.Column(db.String(256)) email = db.Column(db.String(64), nullable=True) mobile = db.Column(db.String(32), nullable=True) sex = db.Column(db.Integer, default=0) avatar_url = db.Column(db.String(32), nullable=True) available = db.Column(db.Boolean, default=1) time_create = db.Column(db.DateTime, default=datetime.now) time_modify = db.Column(db.String(32), onupdate=datetime.now) def set_password(self, password): self.password = generate_password_hash(password) def check_password(self, password): return check_password_hash(self.password, password)