python 服务端接收客户端传过来的json数据并插入到Oracle

# -*- coding: utf-8 -*- 
import logging
from flask import Flask, request, jsonify
import time
from utils.databaseUtil import Database
from datetime import datetime


app = Flask(__name__)


# 接收JSON数据并保存到Oracle
@app.route('/save_data', methods=['POST'])
def save_data():
    start_time = datetime.now().strftime('%Y-%m-%d %H:%M:%S')  # 开始时间

    if request.is_json:
        data = request.get_json()

        omsbi = Database(
            "Oracle",
            "IP:1521",
            "test",
            "账号",
            "密码"
        )
        omsbi.connect()

        data_to_insert = [(item['s1'], item['s2'], item['s3'], item['s4'], item['s5']) for item in data]
        omsbi.execute_many("INSERT INTO temp1 (s1, s2, s3, s4, s5) VALUES (:1, :2, :3, :4, :5)", data_to_insert)

        end_time = datetime.now().strftime('%Y-%m-%d %H:%M:%S')  # 结束时间
        elapsed_time = time.time() - time.mktime(datetime.strptime(start_time, '%Y-%m-%d %H:%M:%S').timetuple())  # 时间差
        logging.basicConfig(filename='app.log', level=logging.INFO, format='%(asctime)s - %(message)s')
        logging.info(f"请求开始时间: {start_time}, 请求结束时间: {end_time}, 耗时: {elapsed_time}秒")
        print(f"请求开始时间: {start_time}, 请求结束时间: {end_time}, 耗时: {elapsed_time}秒")

        return jsonify({"status": "success", "message": "success"}), 201
    else:
        return jsonify({"status": "error", "message": "Request must be JSON"}), 400


if __name__ == '__main__':
    app.run(debug=True)
    # app.run(debug=True, ssl_context=('path/to/certificate.crt', 'path/to/private.key'))