Insert

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
import config

app = Flask(__name__)
app.config.from_object(config)
db = SQLAlchemy(app=app)

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)

db.create_all()

@app.route('/')
def index():
    # 模型实例化并填充数据
    article1 = Article(title='a', content='a1')
    # 将数据对象添加进数据库会话中
    db.session.add(article1)
    # 提交数据
    db.session.commit()
    return 'Index.'

if __name__ == '__main__':
    app.run()