flask-sqlalchemy 关系表简单操作

from flask import Flask from flask.ext.sqlalchemy import SQLAlchemy from flask.ext.migrate import Migrate, MigrateCommand from flask.ext.script import Manager app = Flask(__name__) app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///test.db' db = SQLAlchemy(app) migrate = Migrate(app, db) manager = Manager(app) manager.add_command('db', MigrateCommand) class Post(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(80)) category_id = db.Column(db.Integer, db.ForeignKey('category.id')) category = db.relationship('Category', backref=db.backref('posts', lazy='dynamic')) class Category(db.Model): id = db.Column(db.Integer, primary_key=True) password = db.Column(db.String(50)) @manager.command def run(): app.debug = True app.run() if