| 12345678910111213141516171819202122232425262728293031323334353637 |
- from sqlalchemy import String, Column, Integer, INT
- from werkzeug.security import check_password_hash, generate_password_hash
- from app.modle import Base
- from app.utils.util import cn_now
- class User(Base):
- """用户表"""
- __tablename__ = "users"
- id = Column(Integer, primary_key=True, autoincrement=True, nullable=False, unique=True, doc='用户id')
- user_name = Column(String, nullable=False, unique=True, index=False, doc='用户名')
- password = Column(String, nullable=False, unique=False, index=False, doc='密码')
- photograph = Column(String, nullable=True, unique=False, index=False, doc='照片')
- name = Column(String, nullable=True, unique=False, index=False, doc='姓名')
- phone = Column(String, nullable=True, unique=False, index=False, doc='电话')
- email = Column(String, nullable=True, unique=False, index=False, doc='邮箱')
- company = Column(String, nullable=True, unique=False, index=False, doc='公司')
- department = Column(String, nullable=True, unique=False, index=False, doc='部门')
- role = Column(String, nullable=True, unique=False, index=False, doc='角色')
- permission = Column(String, nullable=True, unique=False, index=False, doc='权限')
- on_job_status = Column(String, nullable=True, unique=False, index=False, doc='在职状态')
- duty = Column(String, nullable=True, unique=False, index=False, doc='职务')
- account_status = Column(Integer, nullable=True, unique=False, index=False, default=0,
- doc='账户状态,0为正常，1为禁用')
- nationality = Column(String, nullable=True, unique=False, index=False, doc='国籍')
- register_time = Column(String, nullable=True, unique=False, index=False, default=cn_now(), doc='注册时间')
- common_menus = Column(String, nullable=True, unique=False, index=False, doc='常用功能')
- # 赋值password，则自动加密存储。
- def generate_password(self, value):
- return generate_password_hash(value)
- # 使用check_password,进行密码校验，返回True False。
- def check_password(self, pasword):
- return check_password_hash(self.password, pasword)
|
