def test_transform_tabular_data_single_row(self):
xml = """<?xml version="1.0"?>
<table>
<row id="321" employeeId="123">
<field id="customFieldA">123 Value A</field>
</row>
</table>"""
table = {'123': [{'customFieldA': '123 Value A', 'row_id': '321'}]}
self.assertEqual(table, utils.transform_tabular_data(xml))
def test_transform_tabular_data_single_row(self):
xml = """<?xml version="1.0"?>
<table>
<row id="321" employeeId="123">
<field id="customFieldA">123 Value A</field>
</row>
</table>"""
table = {'123': [{'customFieldA': '123 Value A', 'row_id': '321'}]}
self.assertEqual(table, utils.transform_tabular_data(xml))
def test_transform_tabular_data_empty_field(self):
xml = """<?xml version="1.0"?>
<table>
<row id="321" employeeId="123">
<field id="customFieldA">123 Value A</field>
<field id="customFieldC"></field>
</row>
<row id="999" employeeId="321">
<field id="customFieldB">321 Value B</field>
</row>
</table>"""
table = {'123': [{'customFieldA': '123 Value A',
'customFieldC': None,
'row_id': '321'}],
'321': [{'customFieldB': '321 Value B',
'row_id': '999'}]}
self.assertEqual(table, utils.transform_tabular_data(xml))
def test_transform_tabular_data_empty_field(self):
xml = """<?xml version="1.0"?>
<table>
<row id="321" employeeId="123">
<field id="customFieldA">123 Value A</field>
<field id="customFieldC"></field>
</row>
<row id="999" employeeId="321">
<field id="customFieldB">321 Value B</field>
</row>
</table>"""
table = {
'123': [{
'customFieldA': '123 Value A',
'customFieldC': None,
'row_id': '321'
}],
'321': [{
'customFieldB': '321 Value B',
'row_id': '999'
}]
}
self.assertEqual(table, utils.transform_tabular_data(xml))
def test_transform_tabular_data_empty_table(self):
xml = """<?xml version="1.0"?>
<table/>"""
table = {}
self.assertEqual(table, utils.transform_tabular_data(xml))
def test_transform_tabular_data_empty_table(self):
xml = """<?xml version="1.0"?>
<table/>"""
table = {}
self.assertEqual(table, utils.transform_tabular_data(xml))
