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)