# -*- coding: utf-8 -*-
"""
JSON 2 HTML Converter
=====================

(c) Varun Malhotra 2013
Source Code: https://github.com/softvar/json2html


Contributors:
-------------
1. Michel Müller (@muellermichel), https://github.com/softvar/json2html/pull/2
2. Daniel Lekic (@lekic), https://github.com/softvar/json2html/pull/17

LICENSE: MIT
--------
"""
import sys
if sys.version_info[:2] < (2, 7):
 from ordereddict import OrderedDict
 import simplejson as json_parser
else:
 from collections import OrderedDict
 import json as json_parser
if sys.version_info[:2] < (3, 0):
 from cgi import escape as html_escape
 text = unicode
 text_types = (unicode, str)
else:
 from html import escape as html_escape
 text = str
 text_types = (str,)
class Json2Html:
 def convert(self, json="", table_attributes='border="1"', clubbing='simple', encode=False, escape=True):
 """
 Convert JSON to HTML Table format
 """
 if clubbing not in ['none','simple','forced']:
 raise ValueError('Clubbing must be one of ["none","simple","forced"]')
 # table attributes such as class, id, data-attr-*, etc.
 # eg: table_attributes = 'class = "table table-bordered sortable"'
 self.table_init_markup = "<table %s>" % table_attributes
 self.clubbing = clubbing
 self.escape = escape
 json_input = None
 if not json:
 json_input = {}
 elif type(json) in text_types:
 try:
 json_input = json_parser.loads(json, object_pairs_hook=OrderedDict)
 except ValueError as e:
 #so the string passed here is actually not a json string
 # - let's analyze whether we want to pass on the error or use the string as-is as a text node
 if u"Expecting property name" in text(e):
 #if this specific json loads error is raised, then the user probably actually wanted to pass json, but made a mistake
 raise e
 json_input = json
 else:
 json_input = json
 converted = self.convert_json_node(json_input)
 if encode:
 return converted.encode('ascii', 'xmlcharrefreplace')
 return converted
 def column_headers_from_list_of_dicts(self, json_input):
 """
 This method is required to implement clubbing.
 It tries to come up with column headers for your input
 """
 if not json_input \
 or not hasattr(json_input, '__getitem__') \
 or not hasattr(json_input[0], 'keys'):
 return None
 column_headers = json_input[0].keys()
 for entry in json_input:
 if not hasattr(entry, 'keys') \
 or not hasattr(entry, '__iter__') \
 or len(entry.keys()) != len(column_headers):
 return None
 for header in column_headers:
 if header not in entry:
 return None
 return column_headers
 
 def forced_column_headers_from_list_of_dicts(self, json_input):
 """
 This method is required to implement clubbing.
 It tries to come up with column headers for your input
 """
 if not json_input \
 or not hasattr(json_input, '__getitem__') \
 or not hasattr(json_input[0], 'keys'):
 return None
 column_headers = []
 for i in json_input:
 column_headers = column_headers+list(i.keys())
 column_headers = set(column_headers)
 return column_headers
 def convert_json_node(self, json_input):
 """
 Dispatch JSON input according to the outermost type and process it
 to generate the super awesome HTML format.
 We try to adhere to duck typing such that users can just pass all kinds
 of funky objects to json2html that *behave* like dicts and lists and other
 basic JSON types.
 """
 if type(json_input) in text_types:
 if self.escape:
 return html_escape(text(json_input))
 else:
 return text(json_input)
 if hasattr(json_input, 'items'):
 return self.convert_object(json_input)
 if hasattr(json_input, '__iter__') and hasattr(json_input, '__getitem__'):
 return self.convert_list(json_input)
 return text(json_input)
 def convert_list(self, list_input):
 """
 Iterate over the JSON list and process it
 to generate either an HTML table or a HTML list, depending on what's inside.
 If suppose some key has array of objects and all the keys are same,
 instead of creating a new row for each such entry,
 club such values, thus it makes more sense and more readable table.

 @example:
 jsonObject = {
 "sampleData": [
 {"a":1, "b":2, "c":3},
 {"a":5, "b":6, "c":7}
 ]
 }
 OUTPUT:
 _____________________________
 | | | | |
 | | a | c | b |
 | sampleData |---|---|---|
 | | 1 | 3 | 2 |
 | | 5 | 7 | 6 |
 -----------------------------

 @contributed by: @muellermichel
 """
 if not list_input:
 return ""
 converted_output = ""
 column_headers = None
 if self.clubbing == 'simple':
 column_headers = self.column_headers_from_list_of_dicts(list_input)
 elif self.clubbing == 'forced':
 column_headers = self.forced_column_headers_from_list_of_dicts(list_input)
 if column_headers is not None:
 converted_output += self.table_init_markup
 converted_output += '<thead>'
 converted_output += '<tr><th>' + '</th><th>'.join(column_headers) + '</th></tr>'
 converted_output += '</thead>'
 converted_output += '<tbody>'
 for list_entry in list_input:
 converted_output += '<tr><td>'
 converted_output += '</td><td>'.join([self.convert_json_node(list_entry[column_header]) for column_header in
 column_headers if column_header in list_entry.keys()])
 converted_output += '</td></tr>'
 converted_output += '</tbody>'
 converted_output += '</table>'
 return converted_output
 #so you don't want or need clubbing eh? This makes @muellermichel very sad... ;(
 #alright, let's fall back to a basic list here...
 converted_output = '<ul><li>'
 converted_output += '</li><li>'.join([self.convert_json_node(child) for child in list_input])
 converted_output += '</li></ul>'
 return converted_output
 def convert_object(self, json_input):
 """
 Iterate over the JSON object and process it
 to generate the super awesome HTML Table format
 """
 if not json_input:
 return "" #avoid empty tables
 converted_output = self.table_init_markup + "<tr>"
 converted_output += "</tr><tr>".join([
 "<th>%s</th><td>%s</td>" %(
 self.convert_json_node(k),
 self.convert_json_node(v)
 )
 for k, v in json_input.items()
 ])
 converted_output += '</tr></table>'
 return converted_output
json2html = Json2Html()
if __name__ == "__main__":
 _json = [{'id': 126,
 'name': 'externalEnrollmentId',
 'order': 1,
 'isRequired': True,
 'fieldType': 'alphanumeric',
 'size': 50,
 'importTypeId': 23,
 'description': 'Something goes in here',
 'values': []},
 {'id': 127,
 'name': 'externalClassSubjectId',
 'order': 2,
 'isRequired': True,
 'fieldType': 'alphanumeric',
 'size': 50,
 'importTypeId': 23,
 'description': 'Something goes in here',
 'values': []},
 {'id': 128,
 'name': 'externalCurriculumId',
 'order': 3,
 'isRequired': True,
 'fieldType': 'alphanumeric',
 'size': 50,
 'importTypeId': 23,
 'description': 'Something goes in here',
 'values': []},
 {'id': 129,
 'name': 'externalPeriodId',
 'order': 4,
 'isRequired': False,
 'fieldType': 'alphanumeric',
 'size': 50,
 'importTypeId': 23,
 'description': 'Something goes in here',
 'values': []},
 {'id': 130,
 'name': 'startDate',
 'order': 5,
 'isRequired': False,
 'fieldType': 'date',
 'size': None,
 'importTypeId': 23,
 'description': 'Something goes in here',
 'values': []},
 {'id': 131,
 'name': 'endDate',
 'order': 6,
 'isRequired': False,
 'fieldType': 'date',
 'size': None,
 'importTypeId': 23,
 'description': 'Something goes in here',
 'values': []},
 {'id': 132,
 'name': 'externalEnrollmentClassSubjectStatusId',
 'order': 7,
 'isRequired': True,
 'fieldType': 'alphanumeric',
 'size': 50,
 'importTypeId': 23,
 'description': 'Something goes in here',
 'values': []},
 {'id': 133,
 'name': 'externalEnrollmentTypeId',
 'order': 8,
 'isRequired': False,
 'fieldType': 'alphanumeric',
 'size': 50,
 'importTypeId': 23,
 'description': 'Something goes in here',
 'values': []},
 {'name': 'ext.info.tags',
 'fieldType': 'array-alphanumeric',
 'size': 50,
 'isRequired': False,
 'order': 0,
 'values': [],
 'description': 'Something goes in here'}]
 display(HTML(json2html.convert(json = _json, clubbing='none')))
 display(HTML(json2html.convert(json = _json, clubbing='simple')))
 display(HTML(json2html.convert(json = _json, clubbing='forced')))