I have created a Flask app with a SQLAlchemy backend which has been really straight forward. However, I ran into an issue when using the Flask Admin extension. While it works well for most models, some of them are giving me the following error:
TypeError: 'unicode' object is not callable
Here is an example of one of the problem models:
class Trade(db.Model):
__tablename__ = 'trade'
id = db.Column(db.Integer, primary_key=True)
issuer_id = db.Column(db.Integer,
db.ForeignKey('issuer.id'), primary_key=True)
obligation_id = db.Column(db.Integer,
db.ForeignKey('obligation.id'))
obligation = db.relationship('Obligation', backref='trades')
type = db.Column(db.String(50))
purpose = db.Column(db.String(50))
date = db.Column(db.Date)
currency = db.Column(db.Text)
amount = db.Column(db.Float)
__mapper_args__ = {
'polymorphic_on': purpose,
'polymorphic_identity': 'trade',
'with_polymorphic': '*'
}
def __str__(self):
return self.obligation + ' ' + self.date.strftime('%y-%m-%d')
To give some context as to how this is being called by the extension, I have some code that creates admin pages for all of my sqlalchemy models.
from test_app import app
from flask.ext.admin import Admin
from test_app.db import db, get_model, models_list
from flask.ext.admin.contrib import sqla
admin = Admin(app, name='Test App')
for model in sorted(models_list()):
admin_cls = type(model, (sqla.ModelView,), {'column_display_pk': False})
admin_view = admin_cls(get_model(model), db.session)
admin.add_view(admin_view)
The net result is that when I navigate to the admin page for that model I get the following error, which doesn't give much context as to what line of code is causing the problem.
File "/home/user/app/venv/lib/python2.7/site-packages/flask/app.py", line 1836, in __call__
return self.wsgi_app(environ, start_response)
File "/home/user/app/venv/lib/python2.7/site-packages/flask/app.py", line 1820, in wsgi_app
response = self.make_response(self.handle_exception(e))
File "/home/user/app/venv/lib/python2.7/site-packages/flask/app.py", line 1403, in handle_exception
reraise(exc_type, exc_value, tb)
File "/home/user/app/venv/lib/python2.7/site-packages/flask/app.py", line 1817, in wsgi_app
response = self.full_dispatch_request()
File "/home/user/app/venv/lib/python2.7/site-packages/flask/app.py", line 1477, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/home/user/app/venv/lib/python2.7/site-packages/flask/app.py", line 1381, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/home/user/app/venv/lib/python2.7/site-packages/flask/app.py", line 1475, in full_dispatch_request
rv = self.dispatch_request()
File "/home/user/app/venv/lib/python2.7/site-packages/flask/app.py", line 1461, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/home/user/app/venv/lib/python2.7/site-packages/flask_admin/base.py", line 60, in inner
return f(self, *args, **kwargs)
File "/home/user/app/venv/lib/python2.7/site-packages/flask_admin/base.py", line 60, in inner
return f(self, *args, **kwargs)
File "/home/user/app/venv/lib/python2.7/site-packages/flask_admin/base.py", line 60, in inner
return f(self, *args, **kwargs)
File "/home/user/app/venv/lib/python2.7/site-packages/flask_admin/model/base.py", line 1182, in index_view
actions_confirmation=actions_confirmation)
File "/home/user/app/venv/lib/python2.7/site-packages/flask_admin/base.py", line 254, in render
return render_template(template, **kwargs)
File "/home/user/app/venv/lib/python2.7/site-packages/flask/templating.py", line 128, in render_template
context, ctx.app)
File "/home/user/app/venv/lib/python2.7/site-packages/flask/templating.py", line 110, in _render
rv = template.render(context)
File "/home/user/app/venv/lib/python2.7/site-packages/jinja2/environment.py", line 969, in render
return self.environment.handle_exception(exc_info, True)
File "/home/user/app/venv/lib/python2.7/site-packages/jinja2/environment.py", line 742, in handle_exception
reraise(exc_type, exc_value, tb)
File "/home/user/app/venv/lib/python2.7/site-packages/flask_admin/templates/admin/model/list.html", line 4, in top-level template code
{% import 'admin/actions.html' as actionlib with context %}
File "/home/user/app/venv/lib/python2.7/site-packages/flask_admin/templates/admin/master.html", line 1, in top-level template code
{% extends admin_base_template %}
File "/home/user/app/venv/lib/python2.7/site-packages/flask_admin/templates/admin/base.html", line 22, in top-level template code
{% block page_body %}
File "/home/user/app/venv/lib/python2.7/site-packages/flask_admin/templates/admin/base.html", line 50, in block "page_body"
{% block body %}{% endblock %}
File "/home/user/app/venv/lib/python2.7/site-packages/flask_admin/templates/admin/model/list.html", line 49, in block "body"
{% block model_list_table %}
File "/home/user/app/venv/lib/python2.7/site-packages/flask_admin/templates/admin/model/list.html", line 95, in block "model_list_table"
{% block list_row scoped %}
File "/home/user/app/venv/lib/python2.7/site-packages/flask_admin/templates/admin/model/list.html", line 118, in block "list_row"
<td>{{ get_value(row, c) }}</td>
TypeError: 'unicode' object is not callable
Any advice on how to debug this would be appreciated.
Many thanks.
Update:
I found the bug. It it had to do with the @property decorator. In a model definition I had two properties.
@property
def issue(self):
return str(self.description)
@property
def __str__(self):
return self.issue
If you remove the @property above the str then the bug goes away.
It is happening because Flask-Admin wants __unicode__ strings from models on Python 2.
Try changing your __str__ to __unicode__ in your models and application will work. In meanwhile, I will update examples to be more compatible with Python 2.
On python 3, __str__ should not have @property decorator.