class ArrayParsingTests(TestCase): def setUp(self): self.sheet = ArrayParsing(get_sheet_test('arrayParsing_test.xlsx')) def test_get_param_by_index(self): expected = '10.2.2.254' got = self.sheet.get_value_of_var_by_index_and_param('105', 'Gateway') self.assertEqual(expected, got) def test_get_param_by_index2(self): expected = '105' got = self.sheet.get_value_of_var_by_index_and_param('105', 'Vlans ID') self.assertEqual(expected, got) def test_get_param_by_index_failed(self): try: expected = KeyError got = self.sheet.get_value_of_var_by_index_and_param( '101', 'invalid_param') self.assertRaises(expected, got) except KeyError: pass def test_set_param_by_index(self): index_value, param_value, updated_value = '104', 'Gateway', '1.1.1.1' self.sheet.set_value_by_index_and_param(index_value, param_value, updated_value) got = self.sheet.get_value_of_var_by_index_and_param( index_value, param_value) self.assertEqual(updated_value, got) def test_set_param_by_index_failed(self): try: index_value, param_value, updated_value = '000', 'Gateway', '1.1.1.1' expected = KeyError got = self.sheet.set_value_by_index_and_param( index_value, param_value, updated_value) self.assertRaises(expected, got) except KeyError: pass def test_get_all_param_by_index(self): expected = { 'Vlans ID': '105', 'Name': 'VLAN-VOICE-02', 'Subnet': '10.2.2.0', 'Mask': '255.255.255.0', 'Gateway': '10.2.2.254', 'Description': '', 'Subnet_arp': '10.2.2.224', 'Wildcard_arp': '0.0.0.15', 'Template Default': 'Default', 'Template Snooping': 'Snooping', 'Template Inspection': 'Inspection' } got = self.sheet.get_all_param_by_index('105') self.assertDictEqual(expected, got) def test_get_nbr_of_rows(self): expected = 23 got = self.sheet.get_nbr_of_rows() self.assertEqual(expected, got) def test_get_nbr_of_cols(self): expected = 11 got = self.sheet.get_nbr_of_cols() self.assertEqual(expected, got) def test_get_nbr_of_cols_in_row(self): expected = 11 got = self.sheet.get_nbr_of_cols_in_row(0) self.assertEquals(expected, got) def test_get_all_headers(self): expected = [ 'Vlans ID', 'Name', 'Subnet', 'Mask', 'Gateway', 'Description', 'Subnet_arp', 'Wildcard_arp', 'Template Default', 'Template Snooping', 'Template Inspection' ] got = self.sheet.get_all_headers() self.assertListEqual(expected, got) def test_get_all_indexes(self): expected = [ '21', '22', '23', '41', '42', '43', '101', 'test', '103', '104', '105', '106', '107', '108', '109' ] got = self.sheet.get_all_indexes() self.assertListEqual(expected, got) def test_is_duplication_False(self): expected = (False, []) got = self.sheet.is_duplication(self.sheet.get_all_headers()) self.assertEqual(expected, got) def test_is_duplication_True(self): list_of_superheroes = [ 'Superman', 'Superman', 'Superman', 'Batman', 'Batman', 'Ironman', 'Thor' ] expected = (True, ['Superman', 'Batman']) got = self.sheet.is_duplication(list_of_superheroes) self.assertEqual(expected, got) def test_get_row_where_value(self): expected = 11 got = self.sheet.get_row_where_value(105) self.assertEqual(expected, got) def test_get_row_where_value_failed(self): expected = -1 got = self.sheet.get_row_where_value(0000) self.assertEqual(expected, got) def test_delimitation_between_indexes_and_commands(self): expected = 17 got = self.sheet.delimitation_between_indexes_and_commands() self.assertEqual(expected, got) def test_template_content_by_name1(self): expected = '{{Name}} and {{Subnet}} and\n{{Gateway}}' got = self.sheet.template_content_by_name('default') self.assertEqual(expected, got) def test_template_content_by_name2(self): expected = '' got = self.sheet.template_content_by_name('inspection') self.assertEqual(expected, got)
class ArrayParsingTests(TestCase): def setUp(self): self.sheet = ArrayParsing(get_sheet_test('arrayParsing_test.xlsx')) def test_get_param_by_index(self): expected = '10.2.2.254' got = self.sheet.get_value_of_var_by_index_and_param('105', 'Gateway') self.assertEqual(expected, got) def test_get_param_by_index2(self): expected = '105' got = self.sheet.get_value_of_var_by_index_and_param('105', 'Vlans ID') self.assertEqual(expected, got) def test_get_param_by_index_failed(self): try: expected = KeyError got = self.sheet.get_value_of_var_by_index_and_param('101', 'invalid_param') self.assertRaises(expected, got) except KeyError: pass def test_set_param_by_index(self): index_value, param_value, updated_value = '104', 'Gateway', '1.1.1.1' self.sheet.set_value_by_index_and_param(index_value, param_value, updated_value) got = self.sheet.get_value_of_var_by_index_and_param(index_value, param_value) self.assertEqual(updated_value, got) def test_set_param_by_index_failed(self): try: index_value, param_value, updated_value = '000', 'Gateway', '1.1.1.1' expected = KeyError got = self.sheet.set_value_by_index_and_param(index_value, param_value, updated_value) self.assertRaises(expected, got) except KeyError: pass def test_get_all_param_by_index(self): expected = {'Vlans ID': '105', 'Name': 'VLAN-VOICE-02', 'Subnet': '10.2.2.0', 'Mask': '255.255.255.0', 'Gateway': '10.2.2.254', 'Description': '', 'Subnet_arp': '10.2.2.224', 'Wildcard_arp': '0.0.0.15', 'Template Default': 'Default', 'Template Snooping': 'Snooping', 'Template Inspection': 'Inspection'} got = self.sheet.get_all_param_by_index('105') self.assertDictEqual(expected, got) def test_get_nbr_of_rows(self): expected = 23 got = self.sheet.get_nbr_of_rows() self.assertEqual(expected, got) def test_get_nbr_of_cols(self): expected = 11 got = self.sheet.get_nbr_of_cols() self.assertEqual(expected, got) def test_get_nbr_of_cols_in_row(self): expected = 11 got = self.sheet.get_nbr_of_cols_in_row(0) self.assertEquals(expected, got) def test_get_all_headers(self): expected = ['Vlans ID', 'Name', 'Subnet', 'Mask', 'Gateway', 'Description', 'Subnet_arp', 'Wildcard_arp', 'Template Default', 'Template Snooping', 'Template Inspection'] got = self.sheet.get_all_headers() self.assertListEqual(expected, got) def test_get_all_indexes(self): expected = ['21', '22', '23', '41', '42', '43', '101', 'test', '103', '104', '105', '106', '107', '108', '109'] got = self.sheet.get_all_indexes() self.assertListEqual(expected, got) def test_is_duplication_False(self): expected = (False, []) got = self.sheet.is_duplication(self.sheet.get_all_headers()) self.assertEqual(expected, got) def test_is_duplication_True(self): list_of_superheroes = ['Superman', 'Superman', 'Superman', 'Batman', 'Batman', 'Ironman', 'Thor'] expected = (True, ['Superman', 'Batman']) got = self.sheet.is_duplication(list_of_superheroes) self.assertEqual(expected, got) def test_get_row_where_value(self): expected = 11 got = self.sheet.get_row_where_value(105) self.assertEqual(expected, got) def test_get_row_where_value_failed(self): expected = -1 got = self.sheet.get_row_where_value(0000) self.assertEqual(expected, got) def test_delimitation_between_indexes_and_commands(self): expected = 17 got = self.sheet.delimitation_between_indexes_and_commands() self.assertEqual(expected, got) def test_template_content_by_name1(self): expected = '{{Name}} and {{Subnet}} and\n{{Gateway}}' got = self.sheet.template_content_by_name('default') self.assertEqual(expected, got) def test_template_content_by_name2(self): expected = '' got = self.sheet.template_content_by_name('inspection') self.assertEqual(expected, got)