mysql数据库存储图片路径

import os
from flask import Flask, request, redirect, url_for

app = Flask(__name__)
UPLOAD_FOLDER = 'static/images'

@app.route('/upload', methods=['POST'])
def upload_file():
    if 'file' not in request.files:
        return redirect(request.url)
    file = request.files['file']
    if file.filename == '':
        return redirect(request.url)
    if file:
        filename = secure_filename(file.filename)
        file_path = os.path.join(app.config['UPLOAD_FOLDER'], filename)
        file.save(file_path)
        # 存储路径到数据库
        save_path_to_db(file_path)
        return 'File successfully uploaded'

def save_path_to_db(file_path):
    # 假设使用SQLAlchemy连接数据库
    from sqlalchemy import create_engine, Column, Integer, String
    from sqlalchemy.ext.declarative import declarative_base
    from sqlalchemy.orm import sessionmaker

    Base = declarative_base()
    class Image(Base):
        __tablename__ = 'images'
        id = Column(Integer, primary_key=True)
        path = Column(String)

    engine = create_engine('sqlite:///example.db')
    Base.metadata.create_all(engine)
    Session = sessionmaker(bind=engine)
    session = Session()
    new_image = Image(path=file_path)
    session.add(new_image)
    session.commit()

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