用Flask-SQLAlchemy把Model定義獨立到models.py

https://stackoverflow.com/questions/9692962/flask-sqlalchemy-import-context-issue/9695045#9695045

models.py
=====

from flask_sqlalchemy import SQLAlchemy

from datetime import datetime

db = SQLAlchemy()

class User(db.Model):

id = db.Column(db.Integer, primary_key=True)

username = db.Column(db.String(80), unique=True, nullable=False)

email = db.Column(db.String(120), unique=True, nullable=False)

def __repr__(self):

return '%r>' % self.username

class Post(db.Model):

id = db.Column(db.Integer, primary_key=True)

title = db.Column(db.String(80), nullable=False)

body = db.Column(db.Text, nullable=False)

json = db.Column(db.JSON)

pub_date = db.Column(db.DateTime, nullable=False,

default=datetime.utcnow)

category_id = db.Column(db.Integer, db.ForeignKey('category.id'),

nullable=False)

category = db.relationship('Category',

backref=db.backref('posts', lazy=True))

def __repr__(self):

return '%r>' % self.title

class Category(db.Model):

id = db.Column(db.Integer, primary_key=True)

name = db.Column(db.String(50), nullable=False)

def __repr__(self):

return '%r>' % self.name

app.py
======

from flask import Flask

# from flask_sqlalchemy import SQLAlchemy

from flask_admin import Admin

from flask_admin.contrib.sqla import ModelView

from models import db, User, Post, Category

app = Flask(__name__)

#app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////tmp/test.db'

app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql:///jack'

app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False

# db = SQLAlchemy(app)

db.init_app(app)

admin = Admin(app, name='flask-sql', template_mode='bootstrap3')

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

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

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