Untitled
unknown
plain_text
a year ago
2.6 kB
5
Indexable
Server Side: def get_existing_tests_status_summary(self): query = f"SELECT " \ f"SUM(CASE WHEN {WORKFLOW_COLUMNS['status'][0]} = 'QUEUE' THEN 1 ELSE 0 END) AS queue_result, " \ f"SUM(CASE WHEN {WORKFLOW_COLUMNS['status'][0]} = 'SCHEDULED' THEN 1 ELSE 0 END) AS scheduled_result, " \ f"SUM(CASE WHEN {WORKFLOW_COLUMNS['status'][0]} = 'STARTING' THEN 1 ELSE 0 END) AS starting_result, " \ f"SUM(CASE WHEN {WORKFLOW_COLUMNS['status'][0]} = 'IN_PROGRESS' THEN 1 ELSE 0 END) AS in_progress_result " \ f"FROM {WORKFLOW_TABLE_NAME};" results = self.db.execute_dql_query(query)["results"][0] status_dict = { 'queue': results[0], 'scheduled': results[1], 'starting': results[2], 'in_progress': results[3] } return {'status_statistics': status_dict} I am making calls like: def get_status_statistics(self): status_statistics = self.__result_db_handler.get_existing_tests_status_summary() return status_statistics and status_summary = workflow_initiator.get_status_statistics() return jsonify( { "test-id": start_workflow.perf_workflow_config.test_id, "message": __get_user_message(resource_message), "status_statistics": status_summary, } On the client side click.echo( f"Tests Queue Statistics:\nNumber of tests ahead in QUEUE:{resp.json()['status_statistics']['queue']} \nNumber of tests SCHEDULED:{resp.json()['status_statistics']['scheduled']} \nNumber of tests STARTING:{resp.json()['status_statistics']['starting']} \nNumber of tests IN_PROGRESS:{resp.json()['status_statistics']['in_progress']} \nURL to Grafana Dashboard: https://g-e479d6ef8a.grafana-workspace.us-west-2.amazonaws.com/d/GXuswQq4z/performance-test-results?orgId=1&from=now-5m&to=now&var-internal_workflow_id={resp.json()['test-id']}" ) Which gives me error f"Tests Queue Statistics:\nNumber of tests ahead in QUEUE:{resp.json()['status_statistics']['queue']} \nNumber of tests SCHEDULED:{resp.json()['status_statistics']['scheduled']} \nNumber of tests STARTING:{resp.json()['status_statistics']['starting']} \nNumber of tests IN_PROGRESS:{resp.json()['status_statistics']['in_progress']} \nURL to Grafana Dashboard: https://g-e479d6ef8a.grafana-workspace.us-west-2.amazonaws.com/d/GXuswQq4z/performance-test-results?orgId=1&from=now-5m&to=now&var-internal_workflow_id={resp.json()['test-id']}" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^ KeyError: 'queue'
Editor is loading...
Leave a Comment