import XLUtils
from selenium import webdriver

driver = webdriver.Chrome(executable_path="D:\\driver\chromedriver.exe")
driver.implicitly_wait(10)

driver.get("https://login.nstu.ru/ssoservice/XUI/#login/&goto=http%3A%2F%2Fciu.nstu.ru%2Fstudent_study%2F")
#driver.maximize_window()

path = "D://Data1.xlsx"


rows = XLUtils.getRowCount(path, 'Лист1')


for r in range(2, rows+1):
    username = XLUtils.readData(path, "Лист1", r, 1)
    password = XLUtils.readData(path, "Лист1", r, 2)

    driver.find_element_by_css_selector("input[type='text']").send_keys(username)
    driver.find_element_by_css_selector("input[type='password']").send_keys(password)

    driver.find_element_by_name("callback_2").click()


    if driver.find_element_by_css_selector("a.top_menu_link").is_displayed():
        print("test is passed")
        driver.find_element_by_css_selector("a[href='/student_study/logout']").click()
        driver.find_element_by_css_selector('div.action-pseudo-link.gray-text.bold').click()
        #driver.find_element_by_css_selector("a[href='ciu.nstu.ru/student_study']").click()
        driver.get("https://login.nstu.ru/ssoservice/XUI/#login/&goto=http%3A%2F%2Fciu.nstu.ru%2Fstudent_study%2F")
        XLUtils.writeData(path, "Лист1", r, 3, "test passed")

    else:
        print("test failed")
        XLUtils.writeData(path, "Лист1", r, 3, "test failed")
        driver.quit()