flask-admin not showing foreignkey columns

Question

class Parent(db.Model):
    id = db.Column(db.Integer, primary_key = True)
    name = db.Column(db.String(120))

    def __repr_(self):
        return '<Parent %r>' % (self.name)

admin.add_view(ModelView(Parent, db.session))


class Child(db.Model):
    id = db.Column(db.Integer, primary_key = True)
    name = db.Column(db.String(120))
    parent = db.Column(db.Integer, db.ForeignKey(Parent))

admin.add_view(ModelView(Child, db.session))

Hello -

The code above is an example of flask-admin page that I am trying to create. The goal is to have on Child's create page a text box for name and a drop down to select a parent.

With the above setup, there is only name field. The parent drop down box is missing.

Any ideas how to make it happen?

score 20 · Answer 1 · answered Apr 25 '13 at 09:19

20

You likely need to specify some additional options to flask-admin via a subclass:

class ChildView(ModelView):
    column_display_pk = True # optional, but I like to see the IDs in the list
    column_hide_backrefs = False
    column_list = ('id', 'name', 'parent')


admin.add_view(ChildView(Parent, db.session))

answered Apr 25 '13 at 09:19

Casey

6,166
3
35
42

Was looking for a way to display the PKs, perfect! – Adversus Apr 25 '16 at 15:21

score 19 · Accepted Answer · answered Apr 24 '13 at 13:29

19

How about if you change the Child class to this:

class Child(db.Model):
    id = db.Column(db.Integer, primary_key = True)
    name = db.Column(db.String(120))
    parent_id = db.Column(db.Integer, db.ForeignKey('parent.id'))
    parent = db.relationship('Parent', backref=db.backref('children', lazy='dynamic'))

I don't know much about this, and I don't know if you need the back reference, but this setup works for me with Flask-Admin.

answered Apr 24 '13 at 13:29

Jasmijn

9,370
2
29
43

Awesome! I will try it tonight. Do I need any primaryjoin/secondaryjoin information? I've been getting a lot of errors about that. Hopefully your change will work awesomely! – screenshot345 Apr 24 '13 at 17:53
Honestly, I wouldn't know. I've never seen anything about primaryjoin/secondaryjoin with Flask-Alchemy or Flask-Admin. – Jasmijn Apr 24 '13 at 20:57
3

Reason why it works: Flask-Admin works with ORM objects, such as models, relations, etc. By default, Flask-Admin will ignore foreign keys in models as they just contain some number and Flask-Admin wants concrete ORM object to work with. So, when you have foreign key on the model, make sure you don't forget ORM level link between models - a relation. Flask-Admin will use this link to display related model(s). And no, you don't need to do fancy stuff or add backrefs to make it work. – Joes Apr 25 '13 at 20:17

score 4 · Answer 3 · answered Aug 23 '19 at 17:44

Here is an all-inclusive solution that requires no manual maintenance.

from sqlalchemy import inspect

class ChildView(ModelView):
    column_display_pk = True # optional, but I like to see the IDs in the list
    column_hide_backrefs = False
    column_list = [c_attr.key for c_attr in inspect(Child).mapper.column_attrs]


admin.add_view(ChildView(Child, db.session))

score 2 · Answer 4 · edited Sep 25 '19 at 23:24

For what it is worth, none of the solutions listed here worked for me. I was facing the issue where foreign keys were not showing up in Flask-Admin.

This is what worked for them to show up:

class CustomModelViewName(ModelView):
    can_delete = True
    column_hide_backrefs = False
    column_list = ["column_name", "column_name", "etc", "etc", "etc"]
    column_searchable_list = ["column_name"]

flask-admin not showing foreignkey columns

4 Answers4

Linked