sqlalchemy向oracle添加数据不成功时改用原生sql语句 配合fastapi

 # 5.update_main 
        elif request_data.type == 'update_main':

            print('='*30)
            print(request_data.TASK_ID)
            item = db.query(Base_log_main).filter(Base_log_main.task_id == int(request_data.TASK_ID)).first()
            print('task_id', item.task_id, )
            print('task_status', item.task_status)
            print('task_error_count', item.task_error_count)
            print('task_run_time', item.run_time)
            print('message', item.task_massage)
            print('process_user', request_data.PROCESS_USER)
            print('type', type(request_data.TASK_ERROR_COUNT))


            item.task_status = request_data.TASK_STATUS
            # item.task_error_count = 33
            run_time = request_data.RUN_TIME
            task_id = int(request_data.TASK_ID)
            task_massage = request_data.TASK_MASSAGE
            task_error_count = int(request_data.TASK_ERROR_COUNT)
            item.process_user = str(request_data.PROCESS_USER)


            print( f"update BASE_LOG_MAIN set  run_time={run_time}, task_error_count={task_error_count}, task_massage='{task_massage}' where task_id={task_id}")


            db.execute(
                f"update BASE_LOG_MAIN set  run_time={run_time}, task_error_count={task_error_count}, task_massage='{task_massage}' where task_id={task_id}")

            db.commit()