具有多对多关系模型的Flask-Admin视图 [英] Flask-Admin view with many to many relationship model
本文介绍了具有多对多关系模型的Flask-Admin视图的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我具有用户和用户角色的基本flask-admin设置
I have this basic flask-admin set-up with users and user roles
class Role(db.Model, RoleMixin):
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(80), unique=True)
description = db.Column(db.String(255))
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(255), unique=True)
password = db.Column(db.String(255))
active = db.Column(db.Boolean())
confirmed_at = db.Column(db.DateTime())
roles = db.relationship('Role', secondary="roles_users",
backref=db.backref('users', lazy='dynamic'))
class RolesUsers(db.Model):
__tablename__="roles_users"
id = db.Column(db.Integer(), primary_key=True)
user_id = db.Column(db.Integer(), db.ForeignKey('user.id', ondelete='CASCADE'))
role_id = db.Column(db.Integer(), db.ForeignKey('role.id', ondelete='CASCADE'))
我想显示将显示特定用户角色的用户视图.有了一对多的关系,我会做这样的事情
I want to display user view that will show roles specific user has. With one to many relationship I would do somethin like this
class UserView(ModelView):
column_hide_backrefs = False
class Role(db.Model, RoleMixin):
...
def __str__(self):
return self.name
我如何通过多对多关系来做到这一点
How would I do this with many to many relationship
推荐答案
所以事实证明,我只需要像这样向UserView添加column_list属性
So it turns out that I only needed to add column_list property to UserView like this
class UserView(ModelView):
column_hide_backrefs = False
column_list = ('email', 'active', 'roles')
其余的由flask-admin处理
the rest is handled by flask-admin
这篇关于具有多对多关系模型的Flask-Admin视图的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文