flask框架学习笔记——SQLAlchemy外键约束

from flask import Flask
import config
from flask_sqlalchemy import SQLAlchemy

app = Flask (name)
app.config.from_object(config)
db=SQLAlchemy(app)
class User(db.Model):
tablename=‘user’
id=db.Column(db.Integer,primary_key=True,autoincrement=True)
username=db.Column(db.String(100),nullable=False)
class Article(db.Model):
tablename=‘article’
id=db.Column(db.Integer,primary_key=True,autoincrement=True)
title=db.Column(db.String(100),nullable=False)
content=db.Column(db.Text,nullable=False)
author_id=db.Column(db.Integer,db.ForeignKey(‘user.id’))
author=db.relationship(‘User’,backref=db.backref(‘articles’))
#运行该主文件即创建两张表
db.create_all()

@app.route (’/’)
def index():
#发布一篇文章首先会依赖用户，