#NEWLINE# def test_generate_default_report_csv( self ) : #NEWLINE# #INDENT# self . scenario . version = '0.2.14' #NEWLINE# self . reporter . read_results ( nth_pctile = 50 , format_numbers = False ) #NEWLINE# csv_text = self . reporter . generate_default_report ( output_csv = True ) #NEWLINE# csv_reader = csv . DictReader ( csv_text . splitlines ( ) ) #NEWLINE# csv_data = list ( csv_reader ) #NEWLINE# self . assertListEqual ( [ { #NEWLINE# #INDENT# 'scenario_name' : 'Reporter Test Scenario - ablkei' , #NEWLINE# 'ssbench_version' : '0.2.14' , #NEWLINE# 'worker_count' : '3' , #NEWLINE# 'concurrency' : '2' , #NEWLINE# 'start_time' : '1970-01-01 00:01:39 UTC' , #NEWLINE# 'stop_time' : '1970-01-01 00:01:46 UTC' , #NEWLINE# 'duration' : '6.800000000000011' , #NEWLINE# 'delete_after' : 'None' , #NEWLINE# 'total_count' : '12' , #NEWLINE# 'total_errors' : '1' , #NEWLINE# 'total_retries' : '7' , #NEWLINE# 'total_retry_rate' : '58.333333' , #NEWLINE# 'total_avg_req_per_s' : '0.229885' , #NEWLINE# 'total_first_all_min' : '0.1' , #NEWLINE# 'total_first_all_max' : '1.2' , #NEWLINE# 'total_first_all_avg' : '0.508333' , #NEWLINE# 'total_first_all_std_dev' : '0.386131' , #NEWLINE# 'total_first_all_50_pctile' : '0.4' , #NEWLINE# 'total_first_all_worst_txid' : 'txID004' , #NEWLINE# 'total_last_all_min' : '0.2' , #NEWLINE# 'total_last_all_max' : '3.0' , #NEWLINE# 'total_last_all_avg' : '1.15825' , #NEWLINE# 'total_last_all_std_dev' : '0.969969' , #NEWLINE# 'total_last_all_50_pctile' : '0.7495' , #NEWLINE# 'total_last_all_worst_txid' : 'txID002' , #NEWLINE# 'total_first_tiny_min' : '0.1' , #NEWLINE# 'total_first_tiny_max' : '1.0' , #NEWLINE# 'total_first_tiny_avg' : '0.45' , #NEWLINE# 'total_first_tiny_std_dev' : '0.377492' , #NEWLINE# 'total_first_tiny_50_pctile' : '0.35' , #NEWLINE# 'total_first_tiny_worst_txid' : 'txID010' , #NEWLINE# 'total_last_tiny_min' : '0.2' , #NEWLINE# 'total_last_tiny_max' : '1.8' , #NEWLINE# 'total_last_tiny_avg' : '0.87475' , #NEWLINE# 'total_last_tiny_std_dev' : '0.580485' , #NEWLINE# 'total_last_tiny_50_pctile' : '0.7495' , #NEWLINE# 'total_last_tiny_worst_txid' : 'txID010' , #NEWLINE# 'total_first_small_min' : '0.2' , #NEWLINE# 'total_first_small_max' : '1.0' , #NEWLINE# 'total_first_small_avg' : '0.566667' , #NEWLINE# 'total_first_small_std_dev' : '0.329983' , #NEWLINE# 'total_first_small_50_pctile' : '0.5' , #NEWLINE# 'total_first_small_worst_txid' : 'txID002' , #NEWLINE# 'total_last_small_min' : '0.5' , #NEWLINE# 'total_last_small_max' : '3.0' , #NEWLINE# 'total_last_small_avg' : '1.433333' , #NEWLINE# 'total_last_small_std_dev' : '1.11455' , #NEWLINE# 'total_last_small_50_pctile' : '0.8' , #NEWLINE# 'total_last_small_worst_txid' : 'txID002' , #NEWLINE# 'total_first_medium_min' : '0.3' , #NEWLINE# 'total_first_medium_max' : '0.8' , #NEWLINE# 'total_first_medium_avg' : '0.55' , #NEWLINE# 'total_first_medium_std_dev' : '0.25' , #NEWLINE# 'total_first_medium_50_pctile' : '0.55' , #NEWLINE# 'total_first_medium_worst_txid' : 'txID006' , #NEWLINE# 'total_last_medium_min' : '0.4' , #NEWLINE# 'total_last_medium_max' : '2.8' , #NEWLINE# 'total_last_medium_avg' : '1.6' , #NEWLINE# 'total_last_medium_std_dev' : '1.2' , #NEWLINE# 'total_last_medium_50_pctile' : '1.6' , #NEWLINE# 'total_last_medium_worst_txid' : 'txID006' , #NEWLINE# 'total_first_large_min' : '0.1' , #NEWLINE# 'total_first_large_max' : '0.2' , #NEWLINE# 'total_first_large_avg' : '0.15' , #NEWLINE# 'total_first_large_std_dev' : '0.05' , #NEWLINE# 'total_first_large_50_pctile' : '0.15' , #NEWLINE# 'total_first_large_worst_txid' : 'txID005' , #NEWLINE# 'total_last_large_min' : '0.3' , #NEWLINE# 'total_last_large_max' : '0.4' , #NEWLINE# 'total_last_large_avg' : '0.35' , #NEWLINE# 'total_last_large_std_dev' : '0.05' , #NEWLINE# 'total_last_large_50_pctile' : '0.35' , #NEWLINE# 'total_last_large_worst_txid' : 'txID007' , #NEWLINE# 'total_first_huge_min' : '1.2' , #NEWLINE# 'total_first_huge_max' : '1.2' , #NEWLINE# 'total_first_huge_avg' : '1.2' , #NEWLINE# 'total_first_huge_std_dev' : '0.0' , #NEWLINE# 'total_first_huge_50_pctile' : '1.2' , #NEWLINE# 'total_first_huge_worst_txid' : 'txID004' , #NEWLINE# 'total_last_huge_min' : '2.2' , #NEWLINE# 'total_last_huge_max' : '2.2' , #NEWLINE# 'total_last_huge_avg' : '2.2' , #NEWLINE# 'total_last_huge_std_dev' : '0.0' , #NEWLINE# 'total_last_huge_50_pctile' : '2.2' , #NEWLINE# 'total_last_huge_worst_txid' : 'txID004' , #NEWLINE# 'create_count' : '3' , #NEWLINE# 'create_errors' : '0' , #NEWLINE# 'create_retries' : '1' , #NEWLINE# 'create_retry_rate' : '33.333333' , #NEWLINE# 'create_avg_req_per_s' : '0.5' , #NEWLINE# 'create_first_all_min' : '0.1' , #NEWLINE# 'create_first_all_max' : '1.2' , #NEWLINE# 'create_first_all_avg' : '0.766667' , #NEWLINE# 'create_first_all_std_dev' : '0.478423' , #NEWLINE# 'create_first_all_50_pctile' : '1.0' , #NEWLINE# 'create_first_all_worst_txid' : 'txID004' , #NEWLINE# 'create_last_all_min' : '0.2' , #NEWLINE# 'create_last_all_max' : '3.0' , #NEWLINE# 'create_last_all_avg' : '1.8' , #NEWLINE# 'create_last_all_std_dev' : '1.177568' , #NEWLINE# 'create_last_all_50_pctile' : '2.2' , #NEWLINE# 'create_last_all_worst_txid' : 'txID002' , #NEWLINE# 'create_first_tiny_min' : '0.1' , #NEWLINE# 'create_first_tiny_max' : '0.1' , #NEWLINE# 'create_first_tiny_avg' : '0.1' , #NEWLINE# 'create_first_tiny_std_dev' : '0.0' , #NEWLINE# 'create_first_tiny_50_pctile' : '0.1' , #NEWLINE# 'create_first_tiny_worst_txid' : 'txID008' , #NEWLINE# 'create_last_tiny_min' : '0.2' , #NEWLINE# 'create_last_tiny_max' : '0.2' , #NEWLINE# 'create_last_tiny_avg' : '0.2' , #NEWLINE# 'create_last_tiny_std_dev' : '0.0' , #NEWLINE# 'create_last_tiny_50_pctile' : '0.2' , #NEWLINE# 'create_last_tiny_worst_txid' : 'txID008' , #NEWLINE# 'create_first_small_min' : '1.0' , #NEWLINE# 'create_first_small_max' : '1.0' , #NEWLINE# 'create_first_small_avg' : '1.0' , #NEWLINE# 'create_first_small_std_dev' : '0.0' , #NEWLINE# 'create_first_small_50_pctile' : '1.0' , #NEWLINE# 'create_first_small_worst_txid' : 'txID002' , #NEWLINE# 'create_last_small_min' : '3.0' , #NEWLINE# 'create_last_small_max' : '3.0' , #NEWLINE# 'create_last_small_avg' : '3.0' , #NEWLINE# 'create_last_small_std_dev' : '0.0' , #NEWLINE# 'create_last_small_50_pctile' : '3.0' , #NEWLINE# 'create_last_small_worst_txid' : 'txID002' , #NEWLINE# 'create_first_huge_min' : '1.2' , #NEWLINE# 'create_first_huge_max' : '1.2' , #NEWLINE# 'create_first_huge_avg' : '1.2' , #NEWLINE# 'create_first_huge_std_dev' : '0.0' , #NEWLINE# 'create_first_huge_50_pctile' : '1.2' , #NEWLINE# 'create_first_huge_worst_txid' : 'txID004' , #NEWLINE# 'create_last_huge_min' : '2.2' , #NEWLINE# 'create_last_huge_max' : '2.2' , #NEWLINE# 'create_last_huge_avg' : '2.2' , #NEWLINE# 'create_last_huge_std_dev' : '0.0' , #NEWLINE# 'create_last_huge_50_pctile' : '2.2' , #NEWLINE# 'create_last_huge_worst_txid' : 'txID004' , #NEWLINE# 'read_count' : '4' , #NEWLINE# 'read_errors' : '0' , #NEWLINE# 'read_retries' : '0' , #NEWLINE# 'read_retry_rate' : '0.000000' , #NEWLINE# 'read_avg_req_per_s' : '0.952381' , #NEWLINE# 'read_first_all_min' : '0.1' , #NEWLINE# 'read_first_all_max' : '1.0' , #NEWLINE# 'read_first_all_avg' : '0.4' , #NEWLINE# 'read_first_all_std_dev' : '0.353553' , #NEWLINE# 'read_first_all_50_pctile' : '0.25' , #NEWLINE# 'read_first_all_worst_txid' : 'txID010' , #NEWLINE# 'read_last_all_min' : '0.4' , #NEWLINE# 'read_last_all_max' : '1.8' , #NEWLINE# 'read_last_all_avg' : '0.875' , #NEWLINE# 'read_last_all_std_dev' : '0.553963' , #NEWLINE# 'read_last_all_50_pctile' : '0.65' , #NEWLINE# 'read_last_all_worst_txid' : 'txID010' , #NEWLINE# 'read_first_tiny_min' : '0.1' , #NEWLINE# 'read_first_tiny_max' : '1.0' , #NEWLINE# 'read_first_tiny_avg' : '0.55' , #NEWLINE# 'read_first_tiny_std_dev' : '0.45' , #NEWLINE# 'read_first_tiny_50_pctile' : '0.55' , #NEWLINE# 'read_first_tiny_worst_txid' : 'txID010' , #NEWLINE# 'read_last_tiny_min' : '0.8' , #NEWLINE# 'read_last_tiny_max' : '1.8' , #NEWLINE# 'read_last_tiny_avg' : '1.3' , #NEWLINE# 'read_last_tiny_std_dev' : '0.5' , #NEWLINE# 'read_last_tiny_50_pctile' : '1.3' , #NEWLINE# 'read_last_tiny_worst_txid' : 'txID010' , #NEWLINE# 'read_first_small_min' : '0.2' , #NEWLINE# 'read_first_small_max' : '0.2' , #NEWLINE# 'read_first_small_avg' : '0.2' , #NEWLINE# 'read_first_small_std_dev' : '0.0' , #NEWLINE# 'read_first_small_50_pctile' : '0.2' , #NEWLINE# 'read_first_small_worst_txid' : 'txID009' , #NEWLINE# 'read_last_small_min' : '0.5' , #NEWLINE# 'read_last_small_max' : '0.5' , #NEWLINE# 'read_last_small_avg' : '0.5' , #NEWLINE# 'read_last_small_std_dev' : '0.0' , #NEWLINE# 'read_last_small_50_pctile' : '0.5' , #NEWLINE# 'read_last_small_worst_txid' : 'txID009' , #NEWLINE# 'read_first_medium_min' : '0.3' , #NEWLINE# 'read_first_medium_max' : '0.3' , #NEWLINE# 'read_first_medium_avg' : '0.3' , #NEWLINE# 'read_first_medium_std_dev' : '0.0' , #NEWLINE# 'read_first_medium_50_pctile' : '0.3' , #NEWLINE# 'read_first_medium_worst_txid' : 'txID012' , #NEWLINE# 'read_last_medium_min' : '0.4' , #NEWLINE# 'read_last_medium_max' : '0.4' , #NEWLINE# 'read_last_medium_avg' : '0.4' , #NEWLINE# 'read_last_medium_std_dev' : '0.0' , #NEWLINE# 'read_last_medium_50_pctile' : '0.4' , #NEWLINE# 'read_last_medium_worst_txid' : 'txID012' , #NEWLINE# 'update_count' : '3' , #NEWLINE# 'update_errors' : '1' , #NEWLINE# 'update_retries' : '6' , #NEWLINE# 'update_retry_rate' : '200.000000' , #NEWLINE# 'update_avg_req_per_s' : '0.057582' , #NEWLINE# 'update_first_all_min' : '0.2' , #NEWLINE# 'update_first_all_max' : '0.8' , #NEWLINE# 'update_first_all_avg' : '0.533333' , #NEWLINE# 'update_first_all_std_dev' : '0.249444' , #NEWLINE# 'update_first_all_50_pctile' : '0.6' , #NEWLINE# 'update_first_all_worst_txid' : 'txID006' , #NEWLINE# 'update_last_all_min' : '0.3' , #NEWLINE# 'update_last_all_max' : '2.8' , #NEWLINE# 'update_last_all_avg' : '1.266333' , #NEWLINE# 'update_last_all_std_dev' : '1.096631' , #NEWLINE# 'update_last_all_50_pctile' : '0.699' , #NEWLINE# 'update_last_all_worst_txid' : 'txID006' , #NEWLINE# 'update_first_tiny_min' : '0.6' , #NEWLINE# 'update_first_tiny_max' : '0.6' , #NEWLINE# 'update_first_tiny_avg' : '0.6' , #NEWLINE# 'update_first_tiny_std_dev' : '0.0' , #NEWLINE# 'update_first_tiny_50_pctile' : '0.6' , #NEWLINE# 'update_first_tiny_worst_txid' : 'txID013' , #NEWLINE# 'update_last_tiny_min' : '0.699' , #NEWLINE# 'update_last_tiny_max' : '0.699' , #NEWLINE# 'update_last_tiny_avg' : '0.699' , #NEWLINE# 'update_last_tiny_std_dev' : '0.0' , #NEWLINE# 'update_last_tiny_50_pctile' : '0.699' , #NEWLINE# 'update_last_tiny_worst_txid' : 'txID013' , #NEWLINE# 'update_first_medium_min' : '0.8' , #NEWLINE# 'update_first_medium_max' : '0.8' , #NEWLINE# 'update_first_medium_avg' : '0.8' , #NEWLINE# 'update_first_medium_std_dev' : '0.0' , #NEWLINE# 'update_first_medium_50_pctile' : '0.8' , #NEWLINE# 'update_first_medium_worst_txid' : 'txID006' , #NEWLINE# 'update_last_medium_min' : '2.8' , #NEWLINE# 'update_last_medium_max' : '2.8' , #NEWLINE# 'update_last_medium_avg' : '2.8' , #NEWLINE# 'update_last_medium_std_dev' : '0.0' , #NEWLINE# 'update_last_medium_50_pctile' : '2.8' , #NEWLINE# 'update_last_medium_worst_txid' : 'txID006' , #NEWLINE# 'update_first_large_min' : '0.2' , #NEWLINE# 'update_first_large_max' : '0.2' , #NEWLINE# 'update_first_large_avg' : '0.2' , #NEWLINE# 'update_first_large_std_dev' : '0.0' , #NEWLINE# 'update_first_large_50_pctile' : '0.2' , #NEWLINE# 'update_first_large_worst_txid' : 'txID005' , #NEWLINE# 'update_last_large_min' : '0.3' , #NEWLINE# 'update_last_large_max' : '0.3' , #NEWLINE# 'update_last_large_avg' : '0.3' , #NEWLINE# 'update_last_large_std_dev' : '0.0' , #NEWLINE# 'update_last_large_50_pctile' : '0.3' , #NEWLINE# 'update_last_large_worst_txid' : 'txID005' , #NEWLINE# 'delete_count' : '2' , #NEWLINE# 'delete_errors' : '0' , #NEWLINE# 'delete_retries' : '0' , #NEWLINE# 'delete_retry_rate' : '0.000000' , #NEWLINE# 'delete_avg_req_per_s' : '2.0' , #NEWLINE# 'delete_first_all_min' : '0.1' , #NEWLINE# 'delete_first_all_max' : '0.5' , #NEWLINE# 'delete_first_all_avg' : '0.3' , #NEWLINE# 'delete_first_all_std_dev' : '0.2' , #NEWLINE# 'delete_first_all_50_pctile' : '0.3' , #NEWLINE# 'delete_first_all_worst_txid' : 'txID011' , #NEWLINE# 'delete_last_all_min' : '0.4' , #NEWLINE# 'delete_last_all_max' : '0.8' , #NEWLINE# 'delete_last_all_avg' : '0.6' , #NEWLINE# 'delete_last_all_std_dev' : '0.2' , #NEWLINE# 'delete_last_all_50_pctile' : '0.6' , #NEWLINE# 'delete_last_all_worst_txid' : 'txID011' , #NEWLINE# 'delete_first_small_min' : '0.5' , #NEWLINE# 'delete_first_small_max' : '0.5' , #NEWLINE# 'delete_first_small_avg' : '0.5' , #NEWLINE# 'delete_first_small_std_dev' : '0.0' , #NEWLINE# 'delete_first_small_50_pctile' : '0.5' , #NEWLINE# 'delete_first_small_worst_txid' : 'txID011' , #NEWLINE# 'delete_last_small_min' : '0.8' , #NEWLINE# 'delete_last_small_max' : '0.8' , #NEWLINE# 'delete_last_small_avg' : '0.8' , #NEWLINE# 'delete_last_small_std_dev' : '0.0' , #NEWLINE# 'delete_last_small_50_pctile' : '0.8' , #NEWLINE# 'delete_last_small_worst_txid' : 'txID011' , #NEWLINE# 'delete_first_large_min' : '0.1' , #NEWLINE# 'delete_first_large_max' : '0.1' , #NEWLINE# 'delete_first_large_avg' : '0.1' , #NEWLINE# 'delete_first_large_std_dev' : '0.0' , #NEWLINE# 'delete_first_large_50_pctile' : '0.1' , #NEWLINE# 'delete_first_large_worst_txid' : 'txID007' , #NEWLINE# 'delete_last_large_min' : '0.4' , #NEWLINE# 'delete_last_large_max' : '0.4' , #NEWLINE# 'delete_last_large_avg' : '0.4' , #NEWLINE# 'delete_last_large_std_dev' : '0.0' , #NEWLINE# 'delete_last_large_50_pctile' : '0.4' , #NEWLINE# 'delete_last_large_worst_txid' : 'txID007' , #NEWLINE# #UNINDENT# } ] , csv_data )