#!/usr/bin/env python
import json
import sys


if len(sys.argv) > 1:
    filename = sys.argv[1]
else:
    filename = './result.json'

def get_key(item):
    ds = item[0].split('_')
    no = int(ds[1]) * 10000 + int(ds[2]) * 100 + int(ds[3])
    ro = ds[0]
    return '%d-%s' % (no, ro)

result = json.load(open(filename, 'r'))
o = open('./result.csv', 'w')
o.write('Case,Status,Started,Stopped,Reason\n')
for k, v in sorted(result.items(), key=get_key):
    o.write('%s,%s,%s,%s,%s\n' % (k, (v['passed'] and 'Pass') or 'Fail', v['started'], v['stopped'], (v['error'] or '').replace('\n', ' ')))