from StringIO import StringIO

def CSVformat(values):
    if not values:
        return ''
    keys = sorted([key for key in values[0].keys()
                   if key != 'result'])
    keys.append('result')
    
    buffer = StringIO()
    if len(keys) > 1:
        print >> buffer, ','.join(keys)
    for value in values:
        print >> buffer, ','.join([str(value[key])
                                   for key in keys])
    return buffer.getvalue()

def JSONformat(values):
    import simplejson
    return simplejson.dumps({'values': values})