def test_equal(self): for x in data: dvigalec = Lifter.make_lifter(x["Ime"], x["Poteg"], x["Sunek"]) # for every x in data got from Sheet 1, creates a dvigalec based on three characteristics "Ime", "Poteg", "Sunek" lifterList.append(dvigalec) # opens Chrome browser and gets the path to MojaSpletnaStran.html file where you downloaded it browser = webdriver.Chrome() current_dir = os.getcwd() browser.get(current_dir + "\\MojaSpletnaStran.html") # finds elements in html file based on ID elem_name = browser.find_element_by_id("Ime") elem_poteg = browser.find_element_by_id("Poteg") elem_sunek = browser.find_element_by_id("Sunek") # for every l in lifterList array of dvigalec, sends keys from data to certain element ID and at the end clicks a button on html page for l in lifterList: elem_name.send_keys(l.name) elem_poteg.send_keys(l.snatch) elem_sunek.send_keys(l.cj) browser.find_element_by_class_name('buttonDodaj').click() # Test for comparrison between Excell sheet and output table on HTML webpage elem_table_rows = browser.find_elements_by_class_name('tr') # defining array of strings with values same as elements by class name tr keys = ["Ime", "Poteg", "Sunek", "Biatlon"] indexE = 1 # indexE = 1 as long as it is shorter then the length of elem table rows which is in our case 8 (lifters) and we start at 1 cuz that's the position of the first lifter while indexE < len(elem_table_rows): # splits the text by the empty string so that we have 3 values of name, snatch, cj lifter_array = elem_table_rows[indexE].text.split(' ') indexL = 0 while indexL < len(lifter_array)-1 : #compares if the a is equal to b on a lifter array which is on the site and with the data extracted from googledrive sheet 1, finds them by the keys we selected self.assertEqual(lifter_array[indexL], str(data[indexE-1][keys[indexL]]))# {["Ime":"Luka", "Poteg": "110", ....], ["Ime": "Jure", ....]} # this whole commented section is the alternative path to compare if the inserted data on html is equal to data in excell document. # if lifter_array[indexL] != str(data[indexE-1][keys[indexL]]): # print('Error!') # else: # print(lifter_array[indexL] + ": OK") indexL += 1 indexE += 1 print("Konec!")