from selenium import webdriver
import time
import openpyxl
from openpyxl.styles import PatternFill, Alignment, Border, Side
x = 7
wb = openpyxl.load_workbook("C:\Knolyx\Tesst\coursecreator.xlsx")
ws = wb.active
while True:
    print('{:^110}'.format('********************************'))
    print('{:^110}'.format('HELLO QA.KNOLYX.COM'))
    print('{:^110}'.format('CREATE AUTOMATIC COURSES & Resources TEST'))
    print('{:^110}'.format('POWERED BY VALENTIN'))
    print('{:^110}'.format('********************************'))
    cr = input("What you want to create (COURSES or RESOURCES): ").upper()
    if cr == "COURSES":
        username = input("Insert VALID username: ")
        password = input("Insert VALID password: ")
        coursename = input("Insert course name: ")
        driver = webdriver.Chrome(executable_path="C:\Valentin\chromedriver.exe")
        driver.set_page_load_timeout(30)
        driver.get("https://qa.knolyx.com")
        driver.maximize_window()
        driver.find_element_by_name("j_username").send_keys(username)
        driver.find_element_by_name("j_password").send_keys(password)
        driver.find_element_by_class_name("Button_Text").click()
        time.sleep(1)
        driver.find_element_by_link_text("Courses").click()
        time.sleep(1)
        driver.find_element_by_css_selector(".PageTitle_Actions").click()
        title1 = driver.title
        driver.find_element_by_class_name("Input").send_keys(coursename)
        driver.find_element_by_xpath("/html/body/div[2]/div/div[2]/div/form/div[4]/div[2]/button[2]").click()
        title2 = driver.title
        time.sleep(2)
        if title1 == title1:
            ws = wb.active
            ws['A' + str(x)] = "PASS (WITHOUT NAME)"
            ws['C' + str(x)] = "The course was not created"
            ws['A' + str(x)].fill = PatternFill(start_color='c0392b', end_color='c0392b', fill_type="solid")
            ws['A' + str(x)].alignment = Alignment(vertical="center", horizontal="center")
            ws['C' + str(x)].alignment = Alignment(vertical="center", horizontal="center")
            ws['C' + str(x)].border = Border(left=Side(style='thin'),
                                             right=Side(style='thin'),
                                             top=Side(style='thin'),
                                             bottom=Side(style='thin'))
            ws.row_dimensions[x].height = 80
            ws.row_dimensions[x].width = 40
        elif coursename in driver.title():
            ws = wb.active
            ws['A' + str(x)] = "PASS (WITH NAME)"
            ws['C' + str(x)] = "The course was created"
            ws['A' + str(x)].fill = PatternFill(start_color='c0392b', end_color='c0392b', fill_type="solid")
            ws['A' + str(x)].alignment = Alignment(vertical="center", horizontal="center")
            ws['C' + str(x)].alignment = Alignment(vertical="center", horizontal="center")
            ws['C' + str(x)].border = Border(left=Side(style='thin'),
                                             right=Side(style='thin'),
                                             top=Side(style='thin'),
                                             bottom=Side(style='thin'))
            ws.row_dimensions[x].height = 80
            ws.row_dimensions[x].width = 40
		else:
            ws = wb.active
            ws['A' + str(x)] = "FAIL"
            ws['C' + str(x)] = "Not working"
            ws['A' + str(x)].fill = PatternFill(start_color='c0392b', end_color='c0392b', fill_type="solid")
            ws['A' + str(x)].alignment = Alignment(vertical="center", horizontal="center")
            ws['C' + str(x)].alignment = Alignment(vertical="center", horizontal="center")
            ws['C' + str(x)].border = Border(left=Side(style='thin'),
                                             right=Side(style='thin'),
                                             top=Side(style='thin'),
                                             bottom=Side(style='thin'))
            ws.row_dimensions[x].height = 80
            ws.row_dimensions[x].width = 40