有flask
918
- ccnif2016-10-13金牌会员15949
- 本帖最后由 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复制代码