flask备份数据到mysql数据库

pip install Flask
pip install mysql-connector-python

from flask import Flask
import mysql.connector

app = Flask(__name__)

app.config['MYSQL_HOST'] = 'localhost'  # MySQL服务器地址
app.config['MYSQL_USER'] = 'username'  # MySQL用户名
app.config['MYSQL_PASSWORD'] = 'password'  # MySQL密码
app.config['MYSQL_DB'] = 'database'  # 数据库名

def backup_data(data):
    try:
        # 建立数据库连接
        conn = mysql.connector.connect(
            host=app.config['MYSQL_HOST'],
            user=app.config['MYSQL_USER'],
            password=app.config['MYSQL_PASSWORD'],
            database=app.config['MYSQL_DB']
        )
        cursor = conn.cursor()
        
        # 执行插入操作
        query = "INSERT INTO tablename (column1, column2) VALUES (%s, %s)"  # 替换为实际的表名和列名
        cursor.execute(query, (data['column1'], data['column2']))  # 替换为实际的数据
        
        # 提交事务并关闭连接
        conn.commit()
        cursor.close()
        conn.close()
        
        return '数据备份成功'
    
    except Exception as e:
        return '数据备份失败：' + str(e)

@app.route('/backup', methods=['POST'])
def handle_backup():
    data = request.json  # 假设数据以JSON格式发送过来
    result = backup_data(data)
    return result

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