在Flask站点上的SQL中插入多个条目

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = '数据库连接地址'
db = SQLAlchemy(app)

class Item(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100))

@app.route('/')
def insert_items():
    items = [
        Item(name='item1'),
        Item(name='item2'),
        Item(name='item3')
    ]
    db.session.add_all(items)
    db.session.commit()
    return 'Items inserted successfully.'

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