Easy Going

xml to json (python>2.6)

• 定义转换方法

from collections import defaultdict

def etree_to_dict(t):
    d = {t.tag: {} if t.attrib else None}
    children = list(t)
    if children:
        dd = defaultdict(list)
        for dc in map(etree_to_dict, children):
            for k, v in dc.items():
                dd[k].append(v)
        d = {t.tag: {k:v[0] if len(v) == 1 else v for k, v in dd.items()}}
    if t.attrib:
        d[t.tag].update(('@' + k, v) for k, v in t.attrib.items())
    if t.text:
        text = t.text.strip()
        if children or t.attrib:
            if text:
              d[t.tag]['#text'] = text
        else:
            d[t.tag] = text
    return d

• 使用

from xml.etree import cElementTree as ET
e = ET.XML('''
<root>
  <e />
  <e>text</e>
  <e name="value" />
  <e name="value">text</e>
  <e> <a>text</a> <b>text</b> </e>
  <e> <a>text</a> <a>text</a> </e>
  <e> text <a>text</a> </e>
</root>
''')

from pprint import pprint
pprint(etree_to_dict(e))

• 输出

{'root': {'e': [None,
                'text',
                {'@name': 'value'},
                {'#text': 'text', '@name': 'value'},
                {'a': 'text', 'b': 'text'},
                {'a': ['text', 'text']},
                {'#text': 'text', 'a': 'text'}]}}

json to xml (python>2.6)

• 定义转换方法

try:
  basestring
except NameError:  # python3
  basestring = str

def dict_to_etree(d):
    def _to_etree(d, root):
        if not d:
            pass
        elif isinstance(d, basestring):
            root.text = d
        elif isinstance(d, dict):
            for k,v in d.items():
                assert isinstance(k, basestring)
                if k.startswith('#'):
                    assert k == '#text' and isinstance(v, basestring)
                    root.text = v
                elif k.startswith('@'):
                    assert isinstance(v, basestring)
                    root.set(k[1:], v)
                elif isinstance(v, list):
                    for e in v:
                        _to_etree(e, ET.SubElement(root, k))
                else:
                    _to_etree(v, ET.SubElement(root, k))
        else:
            raise TypeError('invalid type: ' + str(type(d)))
    assert isinstance(d, dict) and len(d) == 1
    tag, body = next(iter(d.items()))
    node = ET.Element(tag)
    _to_etree(body, node)
    return ET.tostring(node)

pprint(dict_to_etree(d))

xml to json (python>2.6, kv in json order by xml)

• 定义转换方法

def etree_to_ordereddict(t):
	d = OrderedDict()
	d[t.tag] = OrderedDict() if t.attrib else None
	children = list(t)
	if children:
	    dd = OrderedDict()
	    for dc in map(etree_to_ordereddict, children):
	        for k, v in dc.iteritems():
	            if k not in dd:
	                dd[k] = list()
	            dd[k].append(v)
	    d = OrderedDict()
	    d[t.tag] = OrderedDict()
	    for k, v in dd.iteritems():
	        if len(v) == 1:
	            d[t.tag][k] = v[0]
	        else:
	            d[t.tag][k] = v
	if t.attrib:
	    d[t.tag].update(('@' + k, v) for k, v in t.attrib.iteritems())
	if t.text:
	    text = t.text.strip()
	    if children or t.attrib:
	        if text:
	            d[t.tag]['#text'] = text
	    else:
	        d[t.tag] = text
	return d