def test_parse_worksheet_with_duplicate_column_names(self):
worksheet = [['Column', 'Another Column', 'Column'], ['A', 'TRUE', '1'], ['B', 'FALSE', '2'], ['C', 'TRUE', '3'], ['D', 'FALSE', '4']]
parsed = parse_worksheet(worksheet)
columns = map(lambda c: c['name'], parsed['columns'])
self.assertEqual('Column', columns[0])
self.assertEqual('Another Column', columns[1])
self.assertEqual('Column1', columns[2])
self.assertEqual('A', parsed['rows'][0]['Column'])
self.assertEqual(True, parsed['rows'][0]['Another Column'])
self.assertEqual(1, parsed['rows'][0]['Column1'])
def test_parse_worksheet_with_duplicate_column_names(self):
worksheet = [['Column', 'Another Column', 'Column'], ['A', 'TRUE', '1'], ['B', 'FALSE', '2'], ['C', 'TRUE', '3'], ['D', 'FALSE', '4']]
parsed = parse_worksheet(worksheet)
columns = map(lambda c: c['name'], parsed['columns'])
self.assertEqual('Column', columns[0])
self.assertEqual('Another Column', columns[1])
self.assertEqual('Column1', columns[2])
self.assertEqual('A', parsed['rows'][0]['Column'])
self.assertEqual(True, parsed['rows'][0]['Another Column'])
self.assertEqual(1, parsed['rows'][0]['Column1'])
def test_parse_worksheet_with_duplicate_column_names(self):
worksheet = [
["Column", "Another Column", "Column"],
["A", "TRUE", "1"],
["B", "FALSE", "2"],
["C", "TRUE", "3"],
["D", "FALSE", "4"],
]
parsed = parse_worksheet(worksheet)
columns = [column["name"] for column in parsed["columns"]]
self.assertEqual("Column", columns[0])
self.assertEqual("Another Column", columns[1])
self.assertEqual("Column1", columns[2])
self.assertEqual("A", parsed["rows"][0]["Column"])
self.assertEqual(True, parsed["rows"][0]["Another Column"])
self.assertEqual(1, parsed["rows"][0]["Column1"])
def test_parse_regular_worksheet(self):
parse_worksheet(regular_worksheet)
def test_parse_only_headers_worksheet(self):
parse_worksheet(only_headers_worksheet)
def test_parse_empty_worksheet(self):
parse_worksheet(empty_worksheet)
def test_parse_regular_worksheet(self):
parse_worksheet(regular_worksheet)
def test_parse_only_headers_worksheet(self):
parse_worksheet(only_headers_worksheet)
def test_parse_empty_worksheet(self):
parse_worksheet(empty_worksheet)
