OLD | NEW |
1 import csv | 1 import csv |
2 import os | 2 import os |
3 | 3 |
4 | 4 |
5 def write_results_dict_to_csv(results_dict, location, filename=None): | 5 def write_results_dict_to_csv(results_dict, location, filename=None): |
6 """ | 6 """ |
7 Eg: | 7 Eg: |
8 [{'result': [{'50thpercentile': 1225.0, '99thpercentile': 15324.0, | 8 [{'result': [{'50thpercentile': 1225.0, '99thpercentile': 15324.0, |
9 'maximum_latency': 419596.0}, {'50thpercentile': 1055.0, | 9 'maximum_latency': 419596.0}, {'50thpercentile': 1055.0, |
10 '99thpercentile': 10907.0, 'maximum_latency': 234300.0}], | 10 '99thpercentile': 10907.0, 'maximum_latency': 234300.0}], |
11 'key': 8, 'label': 'thread count'}, | 11 'key': 8, 'label': 'thread count'}, |
12 {'result': [{'50thpercentile': 1458.0, '99thpercentile': 13825.0, | 12 {'result': [{'50thpercentile': 1458.0, '99thpercentile': 13825.0, |
13 'maximum_latency': 263042.0}, {'50thpercentile': 1388.0, '99thpercentile': | 13 'maximum_latency': 263042.0}, {'50thpercentile': 1388.0, '99thpercentile': |
14 12843.0, 'maximum_latency': 189399.0}], 'key': 16, 'label': 'thread count' | 14 12843.0, 'maximum_latency': 189399.0}], 'key': 16, 'label': 'thread count' |
15 }] | 15 }] |
16 :param results_dict: | 16 :param results_dict: |
17 :param location: | 17 :param location: |
18 :param filename: | 18 :param filename: |
19 :return: | 19 :return: |
20 """ | 20 """ |
21 with open(os.path.join(location, filename), 'w') as csvfile: | 21 with open(os.path.join(location, filename), 'w') as csvfile: |
22 # Create the headings here, and then write things to the rows | 22 # Create the headings here, and then write things to the rows |
23 fieldnames = [ | 23 fieldnames = [ |
24 'key', | 24 'key', '50thpercentile(us)', '99thpercentile(us)', |
25 '50thpercentile(us)', | 25 'max_latency(us)', 'overall_runtime(us)' |
26 '99thpercentile(us)', | |
27 'max_latency(us)', | |
28 'overall_runtime(us)' | |
29 ] | 26 ] |
30 writer = csv.DictWriter(csvfile, fieldnames=fieldnames) | 27 writer = csv.DictWriter(csvfile, fieldnames=fieldnames) |
31 writer.writeheader() | 28 writer.writeheader() |
32 for results in results_dict: | 29 for results in results_dict: |
33 curr_key = results['key'] | 30 curr_key = results['key'] |
34 for key_result in results['result']: | 31 for key_result in results['result']: |
35 writer.writerow({ | 32 writer.writerow({ |
36 'key': curr_key, | 33 'key': |
37 '50thpercentile(us)': key_result['50thpercentile'], | 34 curr_key, |
38 '99thpercentile(us)': key_result['99thpercentile'], | 35 '50thpercentile(us)': |
39 'max_latency(us)': key_result['maximum_latency'], | 36 key_result['50thpercentile'], |
40 'overall_runtime(us)': key_result['overall_runtime'] | 37 '99thpercentile(us)': |
41 }) | 38 key_result['99thpercentile'], |
| 39 'max_latency(us)': |
| 40 key_result['maximum_latency'], |
| 41 'overall_runtime(us)': |
| 42 key_result['overall_runtime'] |
| 43 }) |
OLD | NEW |