我正在尝试根据“用户”和“角色”模型设置flask-admin model views with SQLAlchemy。我得到的不是函数管理视图:
ValueError: Invalid model property name <class 'app.models.Role'>.desc
堆栈跟踪:
^{pr2}$我使用的是一个带有蓝图的烧瓶应用工厂方法。这是我的应用工厂。在
我的__init__.py
文件,我尝试在第49行创建视图:
from flask import Flask
from flask.ext.bootstrap import Bootstrap
from flask.ext.mail import Mail
from flask.ext.moment import Moment
from flask.ext.sqlalchemy import SQLAlchemy
from flask.ext.security import Security
from flask.ext.admin import Admin
from flask_s3 import FlaskS3
from flask.ext.cdn import CDN
from flask.ext.assets import Environment
from flask.ext.assets import PythonLoader as PythonAssetsLoader
from config import config
# app setup
bootstrap = Bootstrap()
mail = Mail()
moment = Moment()
db = SQLAlchemy()
security = Security()
admin = Admin()
s3 = FlaskS3()
cdn = CDN()
assets_env = Environment()
def create_app(config_name):
app = Flask(__name__)
app.config.from_object(config[config_name])
app.name = app.config['APP_NAME']
config[config_name].init_app(app)
from .models import user_datastore, User, Role
from .auth.views import RoleAdmin, UserAdmin
bootstrap.init_app(app)
mail.init_app(app)
moment.init_app(app)
db.init_app(app)
security.init_app(app, user_datastore)
admin.init_app(app)
s3.init_app(app)
cdn.init_app(app)
assets_env.init_app(app)
# Here's where I'm trying to create the views
admin.add_view(RoleAdmin(Role, db.session))
admin.add_view(UserAdmin(User, db.session))
from . import assets
assets_loader = PythonAssetsLoader(assets)
for name, bundle in assets_loader.load_bundles().iteritems():
assets_env.register(name, bundle)
# attach asset bundles, routes, and custom error pages here
from main import main as main_blueprint
app.register_blueprint(main_blueprint)
import main.assets as main_assets
assets_loader = PythonAssetsLoader(main_assets)
for name, bundle in assets_loader.load_bundles().iteritems():
assets_env.register(name, bundle)
from auth import auth as auth_blueprint
app.register_blueprint(auth_blueprint)
return app
我的ModelView类:
from flask.ext.admin.contrib.sqla import ModelView
__author__ = 'dbg'
class RoleAdmin(ModelView):
column_display_pk = True
form_columns = ['id', 'desc']
class UserAdmin(ModelView):
column_display_pk = True
form_columns = ['id', 'email', 'active', 'last_login_at', 'login_count', 'roles']
编辑
Models.py
from app import db
from flask.ext.security import UserMixin, RoleMixin, SQLAlchemyUserDatastore
roles_users = db.Table('roles_users',
db.Column('user_id', db.Integer(), db.ForeignKey('user.id')),
db.Column('role_id', db.Integer(), db.ForeignKey('role.id')))
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(256), unique=True)
password = db.Column(db.String(36))
active = db.Column(db.Boolean())
confirmed_at = db.Column(db.DateTime())
last_login_at = db.Column(db.DateTime())
current_login_at = db.Column(db.DateTime())
last_login_ip = db.Column(db.String(45))
current_login_ip = db.Column(db.String(45))
login_count = db.Column(db.Integer())
roles = db.relationship('Role', secondary=roles_users,
backref=db.backref('users', lazy='dynamic'))
user_datastore = SQLAlchemyUserDatastore(db, User, Role)
更新
通过这个good soul找到了一个非常有用的here。还是卡住了。新错误。在
Traceback (most recent call last):
File "/Users/dbg/Projects/Python/Current/ziff/flaskbase/manage.py", line 18, in <module>
app = create_app(os.getenv('APP_CONFIG') or 'default')
File "/Users/dbg/Projects/Python/Current/ziff/flaskbase/app/__init__.py", line 83, in create_app
admin.add_view(RoleAdmin(RoleAdmin, db.session))
File "/usr/local/share/anaconda/envs/flaskbase27/lib/python2.7/site-packages/Flask_Admin-1.0.9-py2.7.egg/flask_admin/contrib/sqla/view.py", line 288, in __init__
menu_icon_value=menu_icon_value)
File "/usr/local/share/anaconda/envs/flaskbase27/lib/python2.7/site-packages/Flask_Admin-1.0.9-py2.7.egg/flask_admin/model/base.py", line 570, in __init__
self._refresh_cache()
File "/usr/local/share/anaconda/envs/flaskbase27/lib/python2.7/site-packages/Flask_Admin-1.0.9-py2.7.egg/flask_admin/model/base.py", line 632, in _refresh_cache
self._list_columns = self.get_list_columns()
File "/usr/local/share/anaconda/envs/flaskbase27/lib/python2.7/site-packages/Flask_Admin-1.0.9-py2.7.egg/flask_admin/model/base.py", line 708, in get_list_columns
columns = self.scaffold_list_columns()
File "/usr/local/share/anaconda/envs/flaskbase27/lib/python2.7/site-packages/Flask_Admin-1.0.9-py2.7.egg/flask_admin/contrib/sqla/view.py", line 371, in scaffold_list_columns
for p in self._get_model_iterator():
File "/usr/local/share/anaconda/envs/flaskbase27/lib/python2.7/site-packages/Flask_Admin-1.0.9-py2.7.egg/flask_admin/contrib/sqla/view.py", line 310, in _get_model_iterator
return model._sa_class_manager.mapper.iterate_properties
AttributeError: type object 'RoleAdmin' has no attribute '_sa_class_manager'
以下是使用蓝图的另一种方法:
^{pr2}$好吧,这很古老,但我是这样做的:
重要的部分是以某种方式存储您要添加的视图(这里,我只是将它们附加到蓝图中),然后使用APP CONTEXT添加它们。否则,一切都会变得疯狂(没有应用程序上下文,可能会多次添加同一个模型,导致在应用程序实例化期间出现难看的名称冲突错误)。在
值得注意的是,您在这里添加的任何视图都将显示在flask admin菜单中,就像它是一个模型视图一样,即使它是其他类型的视图。您可以通过更改视图的is-visible和is-unu-accessible方法来解决此问题。在
相关问题 更多 >
编程相关推荐