in cosmos/scripts/converting_log_to_csv.py [0:0]
def main():
if len(sys.argv) == 1:
raise Exception("Input log file name not provided. Syntax = 'python converting_log_to_csv.py <FileLocation>'")
path = sys.argv[1]
input_file = open(path, 'r')
lines = input_file.readlines()
filename = os.path.basename(path)
filename_withoutextention = os.path.splitext(filename)[0]
# create the csv writer
output_csv = open(filename_withoutextention + ".csv", 'w', newline='')
writer = csv.writer(output_csv)
header = ['Date', 'Time', 'Operation', 'RPS', 'Count', 'MAX(microsecond)', 'MIN(microsecond)', 'AVG(microsecond)',
'P90(microsecond)', 'P99(microsecond)', 'P999(microsecond)', 'P9999(microsecond)']
writer.writerow(header)
# Strips the newline character
for line in lines:
line = line.strip()
if not "current ops/sec" in line:
continue
array_after_split = line.strip().split('[')
for i in range(len(array_after_split)):
if i == len(array_after_split) - 1:
break
else:
newline = array_after_split[0] + array_after_split[i + 1]
parse_line_for_formatting(newline, writer)
output_csv.close()
print("Successfully created "+output_csv.name)