• 本帖最后由 ccnif 于 2016-10-13 16:20 编辑 *
  • common_usergroup_permissions = db.Table('common_usergroup_permissions',
  • db.Column('common_user_id', db.Integer, db.ForeignKey('common_user.id')),
  • db.Column('common_usergroup_id', db.Integer, db.ForeignKey('common_usergroup.id'))
  • )
  • common_block_permissions = db.Table('common_block_permissions',
  • db.Column('common_block_id', db.Integer, db.ForeignKey('common_block.id')),
  • db.Column('common_usergroup_id', db.Integer, db.ForeignKey('common_usergroup.id'))
  • )
  • class common_user(UserMixin,db.Model):
  • __tablename__ = 'common_user'
  • id = db.Column(db.Integer, primary_key=True)
  • user = db.Column(db.String(128),unique=True,nullable=False)
  • password_hash = db.Column(db.String(128))
  • name = db.Column(db.String(128))
  • class common_usergroup(db.Model):
  • __tablename__ = 'common_usergroup'
  • id = db.Column(db.Integer, primary_key=True)
  • name = db.Column(db.String(60), unique=True, index=True, nullable=False)
  • common_users = db.relationship('common_user', secondary=common_usergroup_permissions,backref=db.backref('common_usergroups', lazy='joined'), lazy='joined')
  • class common_block(db.Model):
  • __tablename__ = 'common_block'
  • id = db.Column(db.Integer, primary_key=True)
  • name = db.Column(db.String(60), unique=True, index=True, nullable=False)
  • common_usergroups = db.relationship('common_usergroup', secondary=common_block_permissions,backref=db.backref('common_blocks', lazy='joined'), lazy='joined')
  • - def __repr__(self): 复制代码

有什么办法可以通过用户查询到common_block.name 我现在的做法是先循环用户对应的组 然后在循环组对应的common_block.name有什么办法可以直接查询出来不用循环

问题已经解决 贴上验证模块

  • def block_auth():
  • def permissions(f):
  • @wraps(f)
  • def permissions_function(*args, **kwargs):
  • if current_user.id == 1 : return f(*args, **kwargs)
  • if list(set(common_user.query.filter_by(id=current_user.id).first().common_usergroups.all()).intersection(set(common_block.query.filter_by(nav_url=request.path).first().common_usergroups.all()))):
  • print(time.time())
  • return f(*args, **kwargs)
  • return render_template('error/permissions_error.htm')
  • return permissions_function
  • return permissions复制代码