Python get_sheet_test Examples

Example #1

File: Equipment_tests.py Project: JoelCapitao/NetScriptGen

 def setUp(self):
     array_test, list_test = 'arrayParsing_test', 'listParsing_test'
     text_test, global_test = 'textParsing_test', 'global_test'
     array_error_test, array_error_test2 = 'arrayParsing_error_test', 'arrayParsing_error2_test'
     my_template = "{{hostname}}\n{{VLAN_error}}\n{{VLAN_error2}}\n{{VLAN}}\n{{VLAN!((VLAN!104:Name)):Gateway}}"
     self.workbook = dict()
     self.workbook['VLAN'] = ArrayParsing(get_sheet_test(array_test + '.xlsx'))
     self.workbook['VLAN_error'] = ArrayParsing(get_sheet_test(array_error_test + '.xlsx'))
     self.workbook['VLAN_error2'] = ArrayParsing(get_sheet_test(array_error_test2 + '.xlsx'))
     self.workbook[list_test] = ListParsing(get_sheet_test(list_test + '.xlsx'))
     self.workbook[text_test] = TextParsing(get_sheet_test(text_test + '.xlsx'))
     self.workbook['Global'] = ArrayParsing(get_sheet_test(global_test + '.xlsx'))
     self.equipment = Equipment('HOST1', my_template, self.workbook)
     self.equipment.unresolved = 1
     self.equipment.resolved = 2

Example #2

 def setUp(self):
     array_test, list_test = 'arrayParsing_test', 'listParsing_test'
     text_test, global_test = 'textParsing_test', 'global_test'
     array_error_test, array_error_test2 = 'arrayParsing_error_test', 'arrayParsing_error2_test'
     my_template = "{{hostname}}\n{{VLAN_error}}\n{{VLAN_error2}}\n{{VLAN}}\n{{VLAN!((VLAN!104:Name)):Gateway}}"
     self.workbook = dict()
     self.workbook['VLAN'] = ArrayParsing(
         get_sheet_test(array_test + '.xlsx'))
     self.workbook['VLAN_error'] = ArrayParsing(
         get_sheet_test(array_error_test + '.xlsx'))
     self.workbook['VLAN_error2'] = ArrayParsing(
         get_sheet_test(array_error_test2 + '.xlsx'))
     self.workbook[list_test] = ListParsing(
         get_sheet_test(list_test + '.xlsx'))
     self.workbook[text_test] = TextParsing(
         get_sheet_test(text_test + '.xlsx'))
     self.workbook['Global'] = ArrayParsing(
         get_sheet_test(global_test + '.xlsx'))
     self.equipment = Equipment('HOST1', my_template, self.workbook)
     self.equipment.unresolved = 1
     self.equipment.resolved = 2

Example #3

 def setUp(self):
     self.sheet = ArrayParsing(get_sheet_test('arrayParsing_test.xlsx'))

Example #4

File: ArrayParsing_tests.py Project: JoelCapitao/NetScriptGen

 def setUp(self):
     self.sheet = ArrayParsing(get_sheet_test('arrayParsing_test.xlsx'))

Example #5

 def setUp(self):
     self.sheet = ListParsing(get_sheet_test('listParsing_test.xlsx'))

Example #6

File: TextParsing_tests.py Project: JoelCapitao/NetScriptGen

 def setUp(self):
     self.sheet = TextParsing(get_sheet_test('textParsing_test.xlsx'))

Example #7

 def setUp(self):
     self.interface = Interface(get_sheet_test('interface_test.xlsx'))

Example #8

 def setUp(self):
     self.sheet = TextParsing(get_sheet_test('textParsing_test.xlsx'))

Example #9

File: ListParsing_tests.py Project: JoelCapitao/NetScriptGen

 def setUp(self):
     self.sheet = ListParsing(get_sheet_test("listParsing_test.xlsx"))

Example #10

File: Interface_tests.py Project: JoelCapitao/NetScriptGen

 def setUp(self):
     self.interface = Interface(get_sheet_test('interface_test.xlsx'))