Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Flask-Admin-SQLAlchemy one-to-one, one-to-many between two tables
# -*- coding: utf-8 -*-
# Many thanks to
# This code under "I don't care" license
# Take it, use it, learn from it, make it better.
# Start this from cmd or shell or whatever
# Go to favourite browser and type localhost:5000/admin
import sys
from flask import Flask
from flask.ext.sqlalchemy import SQLAlchemy
from flask.ext.admin import Admin
from flask.ext.admin.contrib.sqla import ModelView
app = Flask(__name__)
app.config['SECRET_KEY'] = '123456790'
# Create in-memory database
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///test.sqlite'
# Set echo for debug purposes
app.config['SQLALCHEMY_ECHO'] = True
# Create db instance
db = SQLAlchemy(app)
# Create admin instance
admin = Admin(app)
class Product(db.Model):
__tablename__ = 'product'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.Unicode(200), nullable=False)
# cover image foreign key
# use_alter=True along with name='' adds this foreign key after Image has been created to avoid circular dependency
cover_id = db.Column(db.Integer, db.ForeignKey('', use_alter=True, name='fk_product_cover_id'))
# cover image one-to-one relationship
# set post_update=True to avoid circular dependency during
cover = db.relationship('Image', foreign_keys=cover_id, post_update=True)
class Image(db.Model):
__tablename__ = 'image'
id = db.Column(db.Integer, primary_key=True)
path = db.Column(db.String(200), nullable=False)
product_id = db.Column(db.Integer, db.ForeignKey(
# product gallery many-to-one
product = db.relationship(Product, foreign_keys=product_id, backref='images')
# nothing special was need in Image, all circular dependencies were solved in Product
# Need to implement custom Image list
class ProductView(ModelView):
def __init__(self, session, **kwargs):
super(ProductView, self).__init__(Product, session,**kwargs)
class ImageView(ModelView):
def __init__(self, session, **kwargs):
super(ImageView, self).__init__(Image, session,**kwargs)
if __name__ == '__main__':
# Create tables
# Run in debug mode
app.debug = True
# Go!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.