def mainDeleteLessons(self):
try:
d = Delete_Tags_Attributes_Lessons()
d.deleteLesson()
wait = WebDriverWait(driver, 60)
wait.until(
EC.visibility_of_element_located(
(By.XPATH, "//tr[1]/td[4]/button[.='Delete']")))
ele = driver.find_elements_by_xpath(
"//tbody/tr/td[4]/button[.='Delete']")
count = len(ele)
for count in range(0, count):
d.deleteItLesson()
driver.refresh()
wait.until(
EC.element_to_be_clickable(
(By.XPATH, "//tr[1]/td[4]/button[.='Delete']")))
print "All Lessons are deleted"
finally:
book = xlrd.open_workbook(os.path.join('TestData.xlsx'))
second_sheet = book.sheet_by_name('Login_Credentials')
cell = second_sheet.cell(1, 1)
url = cell.value
driver.get(url)
def mainDeletetag(self):
try:
d = Delete_Tags_Attributes_Lessons()
wait = WebDriverWait(driver, 80)
wait.until(
EC.visibility_of_element_located((
By.XPATH,
"html/body/div/div/div[3]/div[1]/div/nav/div/div[2]/div[6]/a"
)))
driver.find_element_by_xpath(
"html/body/div/div/div[3]/div[1]/div/nav/div/div[2]/div[6]/a"
).click()
print "Clicked on admin icon"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
"html/body/div/div/div[3]/div[1]/div/nav/div/div[2]/div[6]"
)))
driver.find_element_by_xpath(
"html/body/div/div/div[3]/div[1]/div/nav/div/div[2]/div[6]"
).click()
print "Clicked on Admin"
driver.find_element_by_xpath(
"html/body/div/div/div[3]/div[1]/div/nav/div/div[2]/div[6]/div/ul/li[5]"
).click()
print "Clicked on Tag"
time.sleep(5)
count = driver.find_element_by_xpath(
"//*[@id='content']/div/div[3]/div[2]/div/div/section[2]/ul/li[1]/span"
).text
print count
if count == '0':
print "No Tags to delete"
else:
wait.until(
EC.visibility_of_element_located(
(By.XPATH, "//li[@class='u-inline-block']/a")))
ele = driver.find_elements_by_xpath(
"//li[@class='u-inline-block']/a")
count = len(ele)
wait.until(
EC.visibility_of_element_located((
By.XPATH,
"html/body/div/div/div[3]/div[2]/div/div/section[2]/div/ul/li[1]/a"
)))
print "Tag Page Loaded"
for count in range(0, count):
d.delete_Tag()
print "All Tags are deleted"
finally:
book = xlrd.open_workbook(os.path.join('TestData.xlsx'))
second_sheet = book.sheet_by_name('Login_Credentials')
cell = second_sheet.cell(1, 1)
url = cell.value
driver.get(url)
def mainDelete_attribute(self):
try:
d = Delete_Tags_Attributes_Lessons()
wait = WebDriverWait(driver, 60)
wait.until(
EC.visibility_of_element_located((
By.XPATH,
"html/body/div/div/div[3]/div[1]/div/nav/div/div[2]/div[6]/a"
)))
driver.find_element_by_xpath(
"html/body/div/div/div[3]/div[1]/div/nav/div/div[2]/div[6]/a"
).click()
print "Clicked on admin icon"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
"html/body/div/div/div[3]/div[1]/div/nav/div/div[2]/div[6]"
)))
driver.find_element_by_xpath(
"html/body/div/div/div[3]/div[1]/div/nav/div/div[2]/div[6]"
).click()
print "Clicked on Admin"
driver.find_element_by_xpath(
"html/body/div/div/div[3]/div[1]/div/nav/div/div[2]/div[6]/div/ul/li[1]"
).click()
print "Clicked on User Attribute"
driver.find_element_by_xpath(
"html/body/div/div/div[3]/div[1]/div/nav/div/div[2]/div[6]/div/ul/li[4]"
).click()
print "User attribute Page Loaded"
count = driver.find_element_by_xpath(
"//*[@id='content']/div/div[3]/div[2]/div/div/ul/li[1]/span"
).text
print count
if count == '0':
print "No Attributes to delete"
else:
wait.until(
EC.visibility_of_element_located((
By.XPATH,
"html/body/div/div/div[3]/div[2]/div/div/div/div[2]/div/table/tbody/tr[1]/td[5]/button"
)))
print "Deleting all attributes"
ele = driver.find_elements_by_xpath("//tbody/tr/td[5]/button")
count = len(ele)
for count in range(0, count):
d.deleteAttribute()
print "All Attributes are deleted"
finally:
book = xlrd.open_workbook(os.path.join('TestData.xlsx'))
second_sheet = book.sheet_by_name('Login_Credentials')
cell = second_sheet.cell(1, 1)
url = cell.value
driver.get(url)
def mainDelete(self):
try:
d = DeleteLesson()
print "\n\nDeleting all lessons.........."
wait = WebDriverWait(driver, 60)
wait.until(
EC.visibility_of_element_located(
(By.XPATH, "//a[@href='/create/lessons']")))
print "Clicking on Lessons button from side menu"
driver.find_element_by_xpath(
"//a[@href='/create/lessons']").click()
wait = WebDriverWait(driver, 60)
wait.until(
EC.visibility_of_element_located(
(By.XPATH,
"//tbody/tr/td[.='Published']/../td[4]/button[3]")))
ele = driver.find_elements_by_xpath(
"//tbody/tr/td[.='Published']/../td[4]/button[3]")
print "Deleting Lesson"
count = len(ele)
for count in range(0, count):
d.deleteIt()
print "All Elements are deleted"
except Exception as e:
traceback.print_exc()
print(e)
raise Exception
finally:
book = xlrd.open_workbook(os.path.join('TestData.xlsx'))
second_sheet = book.sheet_by_name('Login_Credentials')
cell = second_sheet.cell(1, 1)
url = cell.value
driver.get(url)
def lessonExplainAConcepts(self, exNumberOfCards):
wait = WebDriverWait(driver, 60)
wait.until(
EC.visibility_of_element_located(
(By.XPATH, "//a[@href='/create/lessons']")))
print "Clicking on Lessons button from side menu"
driver.find_element_by_xpath("//a[@href='/create/lessons']").click()
wait.until(
EC.visibility_of_element_located(
(By.XPATH,
".//*[@id='content']/div/div[3]/div[2]/div/header/div/button"
)))
print "Clicking on Create Lesson button from lessons page"
driver.find_element_by_xpath(
".//*[@id='content']/div/div[3]/div[2]/div/header/div/button"
).click()
# Going to verify EXPLAIN A CONCEPT Template
print "Going to verify the display of EXPLAIN A CONCEPT Teamplate"
wait.until(
EC.visibility_of_element_located(
(By.XPATH, "html/body/div[2]/div/div/div[2]/div[3]/div/div")))
explainACoceptLocator = driver.find_element_by_xpath(
"html/body/div[2]/div/div/div[2]/div[3]")
if (explainACoceptLocator.is_displayed()
and explainACoceptLocator.text == "EXPLAIN A CONCEPT"):
print "The EXPLAIN A CONCEPT Template is displaying in Create a new lesson pop up"
else:
print "Failed to find the EXPLAIN A CONCEPT Template in Create a new lesson pop up"
raise Exception
# Going to Click on EXPLAIN A CONCEPT Template
print "Clicking on EXPLAIN A CONCEPT Template"
driver.find_element_by_xpath(
"html/body/div[2]/div/div/div[2]/div[3]/div/div").click()
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/h1/textarea"
)))
# Going to check for the count of displayed lesson cards
cardsDisplayed = driver.find_elements_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[1]/div/div"
)
actualNumberOfCards = len(cardsDisplayed)
if (actualNumberOfCards == exNumberOfCards):
print "The cards count is displaying as expected" + " " + str(
exNumberOfCards)
else:
print "Failed to find the card count as expected"
raise Exception
# Going to verify the title card content
print "Going to verify the title card content"
book = xlrd.open_workbook(os.path.join('TestData.xlsx'))
first_sheet = book.sheet_by_name('MultiCardLesson')
cell1 = first_sheet.cell(21, 0)
exTitleCardContent = cell1.value
actualTitleCardContent = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/h1/textarea"
).text
if (exTitleCardContent == actualTitleCardContent):
print "The title card label is displaying as expected" + " " + '"' + exTitleCardContent + '"'
else:
print "Failed to find the expected label in title card"
raise Exception
# Going to clear the Title present in the title card
print "Going to clear the lesson title"
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/h1/textarea"
).click()
for i in range(55):
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/h1/textarea"
).send_keys(Keys.BACKSPACE)
print "Entering the title for lesson"
cell32 = first_sheet.cell(30, 0)
title = cell32.value
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/h1/textarea"
).send_keys(title)
# Clicking on Second card
print "Clicking on Second card"
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[1]/div/div[2]"
).click()
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div"
)))
# Going to verify the content in Second card
print "Going to verify the content in second card"
cell2 = first_sheet.cell(21, 1)
exFirstCardContent1 = cell2.value
cell3 = first_sheet.cell(21, 2)
exFirstCardContent2 = cell3.value
cell4 = first_sheet.cell(21, 3)
exFirstCardContent3 = cell4.value
cell5 = first_sheet.cell(21, 4)
exFirstCardContent4 = cell5.value
cell6 = first_sheet.cell(21, 5)
exFirstCardContent5 = cell6.value
cell7 = first_sheet.cell(21, 6)
exFirstCardContent6 = cell7.value
actualFirstCardContent1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span/span"
).text
actualFirstCardContent2 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span[1]/span/span"
).text
actualFirstCardContent3 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span[2]/span/span"
).text
actualFirstCardContent4 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span[4]/span[1]/span"
).text
actualFirstCardContent5 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span[4]/span[2]/span"
).text
actualFirstCardContent6 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[5]/div/span/span/span"
).text
if (exFirstCardContent1 == exFirstCardContent1):
if (exFirstCardContent2 == exFirstCardContent2):
if (exFirstCardContent3 == exFirstCardContent3):
if (exFirstCardContent4 == exFirstCardContent4):
if (exFirstCardContent5 == exFirstCardContent5):
if (exFirstCardContent6 == exFirstCardContent6):
print "The second card content is displaying as expected"
else:
print "Failed to find the expected content in second card"
raise Exception
# Clicking on > icon
print "Clicking on > arrow for Third card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[3]/div"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[3]/div"
).click()
# Clicking on Third card
print "Clicking on Third card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[3]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[3]/div/div[1]"
).click()
# Going to verify the content in Third card
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div"
)))
print "Going to verify the content in Third card"
cell8 = first_sheet.cell(22, 0)
exSecondCardContent1 = cell8.value
actualSecondCardContent1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[1]/span"
).text
cell9 = first_sheet.cell(22, 1)
exSecondCardContent2 = cell9.value
actualSecondCardContent2 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[2]/span"
).text
cell10 = first_sheet.cell(22, 2)
exSecondCardContent3 = cell10.value
actualSecondCardContent3 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span/span/span"
).text
cell11 = first_sheet.cell(22, 3)
exSecondCardContent4 = cell11.value
actualSecondCardContent4 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[4]/div/span/span/span"
).text
if (exSecondCardContent1 == actualSecondCardContent1):
if (exSecondCardContent2 == actualSecondCardContent2):
if (exSecondCardContent3 == actualSecondCardContent3):
if (exSecondCardContent4 == actualSecondCardContent4):
print "The Third card content is displaying as expected"
else:
print "Failed to find the expected content in Third card"
raise Exception
# Clicking on < icon
print "Clicking on < arrow for Fourth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[1]/div"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[1]/div"
).click()
# Clicking on Fourth card
print "Clicking on Fourth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[4]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[4]/div/div[1]"
).click()
# Going to verify the content in Fourth card card
print "Going to verify the content in Fourth card"
cell12 = first_sheet.cell(23, 0)
exThirdCardContent = cell12.value
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div/div/span/span/span"
)))
actualThirdCardContent = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div/div/span/span/span"
).text
if (exThirdCardContent in actualThirdCardContent):
print "The Fourth card content is displaying as expected"
else:
print "Failed to find the expected content in Fourth card"
raise Exception
# Going to click on Fifth card
print "Clicking on Fifth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[5]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[5]/div/div[1]"
).click()
# Verifying Fifth card labels
print "Going to verify the content in Fifth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div"
)))
cell13 = first_sheet.cell(24, 0)
exFourthCardContent1 = cell13.value
cell14 = first_sheet.cell(24, 1)
exFourthCardContent2 = cell14.value
cell15 = first_sheet.cell(24, 2)
exFourthCardContent3 = cell15.value
cell16 = first_sheet.cell(24, 3)
exFourthCardContent4 = cell16.value
cell17 = first_sheet.cell(24, 4)
exFourthCardContent5 = cell17.value
actualFourthCardContent1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[1]/span"
).text
actualFourthCardContent2 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[2]/span"
).text
actualFourthCardContent3 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[3]/span"
).text
actualFourthCardContent4 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span"
).text
actualFourthCardContent5 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[4]/div/span/span/span"
).text
if (exFourthCardContent1 == actualFourthCardContent1):
if (exFourthCardContent2 == actualFourthCardContent2):
if (exFourthCardContent3 == actualFourthCardContent3):
if (exFourthCardContent4 == actualFourthCardContent4):
if (exFourthCardContent5 == actualFourthCardContent5):
print "The Fifth card content is displaying as expected"
else:
print "Failed to find the expected content in Fifth card"
raise Exception
# Going to click on Sixth card
print "Clicking on Sixth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[6]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[6]/div/div[1]"
).click()
# Verifying Sixth card labels
print "Going to verify the content in Sixth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div/div/span/span/span"
)))
actualFifthCradContent = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div/div/span/span/span"
).text
cell18 = first_sheet.cell(25, 0)
exFifthCardContent = cell18.value
if (exFifthCardContent in actualFifthCradContent):
print "The Sixth card content is displaying as expected"
else:
print "Failed to find the expected content in Sixth card"
raise Exception
# Going to click on Seventh card
print "Clicking on Seventh card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[7]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[7]/div/div[1]"
).click()
# Verifying the content in Seventh card
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div"
)))
cell19 = first_sheet.cell(26, 0)
exSixthCardContent1 = cell19.value
cell20 = first_sheet.cell(26, 1)
exSixthCardContent2 = cell20.value
cell21 = first_sheet.cell(26, 2)
exSixthCardContent3 = cell21.value
actualSixthCradContent1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span/span"
).text
actualSixthCradContent2 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span/span/span"
).text
actualSixthCradContent3 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[4]/div/span/span/span"
).text
if (exSixthCardContent1 == actualSixthCradContent1):
if (exSixthCardContent2 == actualSixthCradContent2):
if (exSixthCardContent3 == actualSixthCradContent3):
print "The Seventh card content is displaying as expected"
else:
print "Failed to find the expected content in Seventh card"
raise Exception
print "Clicking on > icon"
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div"
).click()
# Going to Click on Eightth card
print "Clicking on Eightth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[8]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[8]/div/div[1]"
).click()
# Going to verify the content in Eightth card
print "Going to verify the content in Eightth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div/div/span/span/span"
)))
cell22 = first_sheet.cell(27, 0)
exSeventhCardContent1 = cell22.value
actualSeventhCradContent1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div/div/span/span/span"
).text
if (exSeventhCardContent1 in actualSeventhCradContent1):
print "The Eightth card content is displaying as expected"
else:
print "Failed to find the expected content in Eightth card"
raise Exception
# Clicking on Nineth card
print "Clicking on Nineth card"
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[9]/div/div[1]"
).click()
# Going to verify the content in Nineth card
print "Going to verify the content in Nineth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div"
)))
cell23 = first_sheet.cell(28, 0)
exEigtthCardContent1 = cell23.value
cell24 = first_sheet.cell(28, 1)
exEigtthCardContent2 = cell24.value
cell25 = first_sheet.cell(28, 2)
exEigtthCardContent3 = cell25.value
cell26 = first_sheet.cell(28, 3)
exEigtthCardContent4 = cell26.value
cell27 = first_sheet.cell(28, 4)
exEigtthCardContent5 = cell27.value
cell28 = first_sheet.cell(28, 5)
exEigtthCardContent6 = cell28.value
actualEigtthCradContent1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[1]/span"
).text
actualEigtthCradContent2 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[2]/span"
).text
actualEigtthCradContent3 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[3]/span"
).text
actualEigtthCradContent4 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span/span/span"
).text
actualEigtthCradContent5 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[4]/div/span/span/span"
).text
actualEigtthCradContent6 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[6]/div/span/span/span"
).text
if (exEigtthCardContent1 == actualEigtthCradContent1):
if (exEigtthCardContent2 == actualEigtthCradContent2):
if (exEigtthCardContent3 == actualEigtthCradContent3):
if (exEigtthCardContent4 == actualEigtthCradContent4):
if (exEigtthCardContent5 == actualEigtthCradContent5):
if (exEigtthCardContent6 ==
actualEigtthCradContent6):
print "The Nineth card content is displaying as expected"
else:
print "Failed to find the expected content in Nineth card"
raise Exception
# Clicking on Ten th card
print "Clicking on Ten th card "
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[10]/div/div[1]"
).click()
wait.until(
EC.visibility_of_element_located(
(By.XPATH,
"//span[@class='lesson-editor-status' and .='Saving...']")))
wait.until(
EC.visibility_of_element_located(
(By.XPATH,
"//span[@class='lesson-editor-status' and .='Saved']")))
# Going to verify the content in Ten th card
print "Going to verify the content in Tenth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/p/textarea"
)))
cell29 = first_sheet.cell(29, 0)
exNinethCardContent1 = cell29.value
cell30 = first_sheet.cell(29, 1)
exNinethCardContent2 = cell30.value
cell31 = first_sheet.cell(29, 2)
exNinethCardContent3 = cell31.value
actualNinethCradContent1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/p/textarea"
).get_attribute("placeholder")
actualNinethCradContent2 = driver.find_element_by_xpath(
".//*[@id='question-answer-input-0']").get_attribute("placeholder")
actualNinethCradContent3 = driver.find_element_by_xpath(
".//*[@id='question-answer-input-1']").get_attribute("placeholder")
plusIconLocator = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div[3]/div/div[1]/div/span"
)
if (exNinethCardContent1 == actualNinethCradContent1
and plusIconLocator.is_displayed()):
if (exNinethCardContent2 == actualNinethCradContent2):
if (exNinethCardContent3 == actualNinethCradContent3):
print "The Tenth card content is displaying as expected"
else:
print "Failed to find the expected content in Tenth card"
raise Exception
wait.until(
EC.visibility_of_element_located(
(By.XPATH, ".//*[@id='question-answer-input-0']")))
print "Entering question"
cell33 = first_sheet.cell(1, 2)
questionCard = cell33.value
ele = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/p/textarea"
)
ele.send_keys(questionCard)
print "Entering first answer"
cell34 = first_sheet.cell(1, 3)
ans1 = cell34.value
driver.find_element_by_xpath(
".//*[@id='question-answer-input-0']").send_keys(ans1)
print "Entering Second answer"
cell35 = first_sheet.cell(1, 4)
ans2 = cell35.value
driver.find_element_by_xpath(
".//*[@id='question-answer-input-1']").send_keys(ans2)
wait.until(
EC.visibility_of_element_located(
(By.XPATH,
"//span[@class='lesson-editor-status' and .='Saving...']")))
wait.until(
EC.visibility_of_element_located(
(By.XPATH,
"//span[@class='lesson-editor-status' and .='Saved']")))
def introduceATopic(self):
wait = WebDriverWait(driver, 60)
wait.until(
EC.visibility_of_element_located(
(By.XPATH, "//a[@href='/create/lessons']")))
print "Clicking on Lessons button from side menu"
driver.find_element_by_xpath("//a[@href='/create/lessons']").click()
wait = WebDriverWait(driver, 60)
wait.until(
EC.visibility_of_element_located(
(By.XPATH,
".//*[@id='content']/div/div[3]/div[2]/div/header/div/button"
)))
print "Clicking on Create Lesson button from lessons page"
driver.find_element_by_xpath(
".//*[@id='content']/div/div[3]/div[2]/div/header/div/button"
).click()
print "Going to verify the display of INTRODUCE A TOPIC Teamplate"
book = xlrd.open_workbook(os.path.join('TestData.xlsx'))
first_sheet = book.sheet_by_name('MultiCardLesson')
cell1 = first_sheet.cell(44, 0)
exTemplateNameIntroduceATopic = cell1.value
wait.until(
EC.visibility_of_element_located(
(By.XPATH, "html/body/div[2]/div/div/div[2]/div[5]/div/div")))
introduceATopiclLocator = driver.find_element_by_xpath(
"html/body/div[2]/div/div/div[2]/div[5]/h4")
if (introduceATopiclLocator.is_displayed() and
introduceATopiclLocator.text == exTemplateNameIntroduceATopic):
print "The INTRODUCE A TOPIC Template is displaying in Create a new lesson pop up"
else:
print "Failed to find the INTRODUCE A TOPIC Template in Create a new lesson pop up"
raise Exception
# Clicking on Introduce a topic template
print "Clicking on INTRODUCE A TOPIC template"
driver.find_element_by_xpath(
"html/body/div[2]/div/div/div[2]/div[5]/div/div").click()
# Going to verify the number of cards displayed for the template INTRODUCE A TOPIC
print "Going to verify the number of cards displayed for the template INTRODUCE A TOPIC"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div/div/div"
)))
cardsDisplayedIntroduceATopic = driver.find_elements_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div/div/div"
)
actualNumberOfCardsIntroduceATopic = len(cardsDisplayedIntroduceATopic)
cell2 = first_sheet.cell(45, 0)
exNumberOfCardsIntroduceATopic = cell2.value
if (actualNumberOfCardsIntroduceATopic ==
exNumberOfCardsIntroduceATopic):
print "The cards count is displaying as expected" + " " + str(
exNumberOfCardsIntroduceATopic)
else:
print "Failed to find the card count as expected"
raise Exception
# Going to verify the title card content
print "Going to verify the title card content"
cell3 = first_sheet.cell(45, 1)
exTitleCardContentIntroduceATopic = cell3.value
actualTitleCardContentIntroduceATopic = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/h1/textarea"
).text
if (exTitleCardContentIntroduceATopic ==
actualTitleCardContentIntroduceATopic):
print "The title card label is displaying as expected" + " " + '"' + exTitleCardContentIntroduceATopic + '"'
else:
print "Failed to find the expected label in title card"
raise Exception
# Going to clear the Title present in the title card
print "Going to clear the lesson title"
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/h1/textarea"
).clear()
print "Entering the title for lesson"
cell4 = first_sheet.cell(45, 2)
titleIntroduceATopic = cell4.value
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/h1/textarea"
).send_keys(titleIntroduceATopic)
print "Clicking on second card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div/div/div[2]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div/div/div[2]/div/div[1]"
).click()
print "Going to verify the content in second card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div"
)))
cell5 = first_sheet.cell(45, 3)
exSecondCardContentIntroduceATopic1 = cell5.value
actualSecondCardContentIntroduceATopic1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span/span"
).text
cell6 = first_sheet.cell(45, 4)
exSecondCardContentIntroduceATopic2 = cell6.value
actualSecondCardContentIntroduceATopic2 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span[1]/span/span"
).text
cell7 = first_sheet.cell(45, 5)
exSecondCardContentIntroduceATopic3 = cell7.value
actualSecondCardContentIntroduceATopic3 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span[5]/span/span"
).text
cell8 = first_sheet.cell(45, 6)
exSecondCardContentIntroduceATopic4 = cell8.value
actualSecondCardContentIntroduceATopic4 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span[7]/span[1]/span"
).text
cell9 = first_sheet.cell(45, 7)
exSecondCardContentIntroduceATopic5 = cell9.value
actualSecondCardContentIntroduceATopic5 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span[7]/span[2]/span"
).text
cell10 = first_sheet.cell(45, 8)
exSecondCardContentIntroduceATopic6 = cell10.value
actualSecondCardContentIntroduceATopic6 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[5]/div/span"
).text
if (exSecondCardContentIntroduceATopic1 ==
actualSecondCardContentIntroduceATopic1):
if (exSecondCardContentIntroduceATopic2 ==
actualSecondCardContentIntroduceATopic2):
if (exSecondCardContentIntroduceATopic3 ==
actualSecondCardContentIntroduceATopic3):
if (exSecondCardContentIntroduceATopic4 ==
actualSecondCardContentIntroduceATopic4):
if (exSecondCardContentIntroduceATopic5 ==
actualSecondCardContentIntroduceATopic5):
if (exSecondCardContentIntroduceATopic6 ==
actualSecondCardContentIntroduceATopic6):
print "Successfully verified the content in second card"
else:
print "Failed to verify the content in second card"
raise Exception
print "Clicking on Third card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[3]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[3]/div/div[1]"
).click()
print "Going to verify the contents in Third card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div"
)))
cell11 = first_sheet.cell(46, 0)
exThirdCardContentIntroduceATopic1 = cell11.value
actualThirdCardContentIntroduceATopic1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span/span"
).text
cell12 = first_sheet.cell(46, 1)
exThirdCardContentIntroduceATopic2 = cell12.value
actualThirdCardContentIntroduceATopic2 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span/span[1]/span"
).text
cell13 = first_sheet.cell(46, 2)
exThirdCardContentIntroduceATopic3 = cell13.value
actualThirdCardContentIntroduceATopic3 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span/span[2]/span"
).text
cell14 = first_sheet.cell(46, 3)
exThirdCardContentIntroduceATopic4 = cell14.value
actualThirdCardContentIntroduceATopic4 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span/span[3]/span"
).text
cell15 = first_sheet.cell(46, 4)
exThirdCardContentIntroduceATopic5 = cell15.value
actualThirdCardContentIntroduceATopic5 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[5]/div/span/span/span"
).text
cell16 = first_sheet.cell(46, 5)
exThirdCardContentIntroduceATopic6 = cell16.value
actualThirdCardContentIntroduceATopic6 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[6]/div/span/span[1]/span"
).text
cell17 = first_sheet.cell(46, 6)
exThirdCardContentIntroduceATopic7 = cell17.value
actualThirdCardContentIntroduceATopic7 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[6]/div/span/span[2]/span"
).text
cell18 = first_sheet.cell(46, 7)
exThirdCardContentIntroduceATopic8 = cell18.value
actualThirdCardContentIntroduceATopic8 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[6]/div/span/span[3]/span"
).text
if (exThirdCardContentIntroduceATopic1 ==
actualThirdCardContentIntroduceATopic1):
if (exThirdCardContentIntroduceATopic2 ==
actualThirdCardContentIntroduceATopic2):
if (exThirdCardContentIntroduceATopic3 ==
actualThirdCardContentIntroduceATopic3):
if (exThirdCardContentIntroduceATopic4 ==
actualThirdCardContentIntroduceATopic4):
if (exThirdCardContentIntroduceATopic5 ==
actualThirdCardContentIntroduceATopic5):
if (exThirdCardContentIntroduceATopic6 ==
actualThirdCardContentIntroduceATopic6):
if (exThirdCardContentIntroduceATopic7 ==
actualThirdCardContentIntroduceATopic7
):
if (exThirdCardContentIntroduceATopic8 ==
actualThirdCardContentIntroduceATopic8
):
print "Successfully verified the content in Third card"
else:
print "Failed to verify the content in Third card"
raise Exception
print "Clicking on Fourth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[4]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[4]/div/div[1]"
).click()
print "Going to verify the content in Fourth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div"
)))
cell19 = first_sheet.cell(47, 0)
exFourthCardContentIntroduceATopic1 = cell19.value
actualFourthCardContentIntroduceATopic1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span/span"
).text
cell20 = first_sheet.cell(47, 1)
exFourthCardContentIntroduceATopic2 = cell20.value
actualFourthCardContentIntroduceATopic2 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[2]/div/span/span/span"
).text
if (exFourthCardContentIntroduceATopic1 ==
actualFourthCardContentIntroduceATopic1):
if (exFourthCardContentIntroduceATopic2 ==
actualFourthCardContentIntroduceATopic2):
print "Successfully verified the content in fourth card"
else:
print "Failed to verify the content in Fourth card"
raise Exception
print "Clicking on Fifth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[5]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[5]/div/div[1]"
).click()
print "Going to verify the content in Fifth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div"
)))
cell21 = first_sheet.cell(48, 0)
exFifthCardContentIntroduceATopic1 = cell21.value
actualFifthCardContentIntroduceATopic1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[1]/span"
).text
cell22 = first_sheet.cell(48, 1)
exFifthCardContentIntroduceATopic2 = cell22.value
actualFifthCardContentIntroduceATopic2 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[3]/span"
).text
cell23 = first_sheet.cell(48, 2)
exFifthCardContentIntroduceATopic3 = cell23.value
actualFifthCardContentIntroduceATopic3 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[4]/span"
).text
cell24 = first_sheet.cell(48, 3)
exFifthCardContentIntroduceATopic4 = cell24.value
actualFifthCardContentIntroduceATopic4 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[5]/span"
).text
cell25 = first_sheet.cell(48, 4)
exFifthCardContentIntroduceATopic5 = cell25.value
actualFifthCardContentIntroduceATopic5 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span/span/span"
).text
cell26 = first_sheet.cell(48, 5)
exFifthCardContentIntroduceATopic6 = cell26.value
actualFifthCardContentIntroduceATopic6 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[4]/div/span/span/span"
).text
if (exFifthCardContentIntroduceATopic1 ==
actualFifthCardContentIntroduceATopic1):
if (exFifthCardContentIntroduceATopic2 ==
actualFifthCardContentIntroduceATopic2):
if (exFifthCardContentIntroduceATopic3 ==
actualFifthCardContentIntroduceATopic3):
if (exFifthCardContentIntroduceATopic4 ==
actualFifthCardContentIntroduceATopic4):
if (exFifthCardContentIntroduceATopic5 ==
actualFifthCardContentIntroduceATopic5):
if (exFifthCardContentIntroduceATopic6 ==
actualFifthCardContentIntroduceATopic6):
print "Successfully verified the content in Fifth card"
else:
print "Failed to verify the content in Fifth card"
raise Exception
print "Clicking on Sixth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[6]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[6]/div/div[1]"
).click()
print "Going to verify the content in Sixth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div"
)))
cell27 = first_sheet.cell(49, 0)
exSixthCardContentIntroduceATopic1 = cell27.value
actualSixthCardContentIntroduceATopic1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span/span"
).text
cell28 = first_sheet.cell(49, 1)
exSixthCardContentIntroduceATopic2 = cell28.value
actualSixthCardContentIntroduceATopic2 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span/span[1]/span"
).text
cell29 = first_sheet.cell(49, 2)
exSixthCardContentIntroduceATopic3 = cell29.value
actualSixthCardContentIntroduceATopic3 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span/span[2]/span"
).text
cell30 = first_sheet.cell(49, 3)
exSixthCardContentIntroduceATopic4 = cell30.value
actualSixthCardContentIntroduceATopic4 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span/span[3]/span"
).text
if (exSixthCardContentIntroduceATopic1
in actualSixthCardContentIntroduceATopic1):
if (exSixthCardContentIntroduceATopic2 ==
actualSixthCardContentIntroduceATopic2):
if (exSixthCardContentIntroduceATopic3 ==
actualSixthCardContentIntroduceATopic3):
if (exSixthCardContentIntroduceATopic4 ==
actualSixthCardContentIntroduceATopic4):
print "Successfully verified the content in Sixth card"
else:
print "Failed to verify the content in Sixth card"
raise Exception
print "Clicking on Seventh card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[7]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[7]/div/div[1]"
).click()
print "Going to verify the content in Seventh card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div"
)))
cell31 = first_sheet.cell(50, 0)
exSeventhCardContentIntroduceATopic1 = cell31.value
actualSeventhCardContentIntroduceATopic1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span/span"
).text
cell32 = first_sheet.cell(50, 1)
exSeventhCardContentIntroduceATopic2 = cell32.value
actualSeventhCardContentIntroduceATopic2 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[2]/div/span/span/span"
).text
if (exSeventhCardContentIntroduceATopic1 ==
actualSeventhCardContentIntroduceATopic1):
if (exSeventhCardContentIntroduceATopic2 ==
actualSeventhCardContentIntroduceATopic2):
print "Successfully verified the Seventh card content"
else:
print "Failed to verify Seventh card content"
raise Exception
print "Clicking on Eight th card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[8]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[8]/div/div[1]"
).click()
print "Going to verify the content in Eight th card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div"
)))
cell33 = first_sheet.cell(51, 0)
exEightthCardContentIntroduceATopic1 = cell33.value
actualEightthCardContentIntroduceATopic1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[1]/span"
).text
cell34 = first_sheet.cell(51, 1)
exEightthCardContentIntroduceATopic2 = cell34.value
actualEightthCardContentIntroduceATopic2 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[2]/span"
).text
cell35 = first_sheet.cell(51, 2)
exEightthCardContentIntroduceATopic3 = cell35.value
actualEightthCardContentIntroduceATopic3 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[3]/span"
).text
cell36 = first_sheet.cell(51, 3)
exEightthCardContentIntroduceATopic4 = cell36.value
actualEightthCardContentIntroduceATopic4 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span/span/span"
).text
cell37 = first_sheet.cell(51, 4)
exEightthCardContentIntroduceATopic5 = cell37.value
actualEightthCardContentIntroduceATopic5 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[4]/div/span/span/span"
).text
if (exEightthCardContentIntroduceATopic1 ==
actualEightthCardContentIntroduceATopic1):
if (exEightthCardContentIntroduceATopic2 ==
actualEightthCardContentIntroduceATopic2):
if (exEightthCardContentIntroduceATopic3 ==
actualEightthCardContentIntroduceATopic3):
if (exEightthCardContentIntroduceATopic4 ==
actualEightthCardContentIntroduceATopic4):
if (exEightthCardContentIntroduceATopic5 ==
actualEightthCardContentIntroduceATopic5):
print "Successfully verified the content in Eight th card"
else:
print "Failed to verify the content in Eight th card"
raise Exception
print "Clicking on Nineth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[9]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[9]/div/div[1]"
).click()
print "Going to verify the content in Nineth card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div"
)))
cell38 = first_sheet.cell(52, 0)
exNinethCardContentIntroduceATopic1 = cell38.value
actualNinethCardContentIntroduceATopic1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span/span"
).text
cell39 = first_sheet.cell(52, 1)
exNinethCardContentIntroduceATopic2 = cell39.value
actualNinethCardContentIntroduceATopic2 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[2]/div/span/span/span"
).text
if (exNinethCardContentIntroduceATopic1 ==
actualNinethCardContentIntroduceATopic1):
if (exNinethCardContentIntroduceATopic2 ==
actualNinethCardContentIntroduceATopic2):
print "Successfully verified the content in Nine th card"
else:
print "Failed to verify the content in Nine th card"
raise Exception
print "Clicking on Ten th card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[10]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[10]/div/div[1]"
).click()
print "Going to verify the content in Ten th card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div"
)))
cell40 = first_sheet.cell(53, 0)
exTenthCardContentIntroduceATopic1 = cell40.value
actualTenthCardContentIntroduceATopic1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[1]/span"
).text
cell41 = first_sheet.cell(53, 1)
exTenthCardContentIntroduceATopic2 = cell41.value
actualTenthCardContentIntroduceATopic2 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[2]/span"
).text
cell42 = first_sheet.cell(53, 2)
exTenthCardContentIntroduceATopic3 = cell42.value
actualTenthCardContentIntroduceATopic3 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span"
).text
cell43 = first_sheet.cell(53, 2)
exTenthCardContentIntroduceATopic4 = cell43.value
actualTenthCardContentIntroduceATopic4 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[4]/div/span/span/span"
).text
if (exTenthCardContentIntroduceATopic1 ==
actualTenthCardContentIntroduceATopic1):
if (exTenthCardContentIntroduceATopic2 ==
actualTenthCardContentIntroduceATopic2):
if (exTenthCardContentIntroduceATopic3 ==
actualTenthCardContentIntroduceATopic3):
if (exTenthCardContentIntroduceATopic4 ==
actualTenthCardContentIntroduceATopic4):
print "Successfully verified the content in Ten th card"
else:
print "Failed to verify the content in Ten th card"
raise Exception
print "Clicking on Eleven th card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[11]/div/div[1]"
)))
driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[11]/div/div[1]"
).click()
print "Going to verify the content in Eleventh card"
wait.until(
EC.visibility_of_element_located((
By.XPATH,
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/p/textarea"
)))
cell44 = first_sheet.cell(54, 0)
exEleventhCardIntroduceATopicContent1 = cell44.value
cell45 = first_sheet.cell(54, 1)
exEleventhCardIntroduceATopicContent2 = cell45.value
cell46 = first_sheet.cell(54, 2)
exEleventhCardIntroduceATopicContent3 = cell46.value
actualEleventhCardIntroduceATopic1 = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/p/textarea"
).get_attribute("placeholder")
actualEleventhCardIntroduceATopic2 = driver.find_element_by_xpath(
".//*[@id='question-answer-input-0']").get_attribute("placeholder")
actualEleventhCardIntroduceATopic3 = driver.find_element_by_xpath(
".//*[@id='question-answer-input-1']").get_attribute("placeholder")
plusIconLocatorIntroduceATopic = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div[3]/div/div[1]/div/span"
)
if (exEleventhCardIntroduceATopicContent1 ==
actualEleventhCardIntroduceATopic1):
if (exEleventhCardIntroduceATopicContent2 ==
actualEleventhCardIntroduceATopic2):
if (exEleventhCardIntroduceATopicContent3 ==
actualEleventhCardIntroduceATopic3):
if (plusIconLocatorIntroduceATopic.is_displayed()):
print "The Eleventh card content is displaying as expected"
else:
print "Failed to find the expected content in Eleventh card"
raise Exception
wait.until(
EC.visibility_of_element_located(
(By.XPATH, ".//*[@id='question-answer-input-0']")))
print "Entering question"
cell47 = first_sheet.cell(1, 2)
questionCard = cell47.value
ele = driver.find_element_by_xpath(
".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/p/textarea"
)
ele.send_keys(questionCard)
print "Entering first answer"
cell48 = first_sheet.cell(1, 3)
ans1 = cell48.value
driver.find_element_by_xpath(
".//*[@id='question-answer-input-0']").send_keys(ans1)
print "Entering Second answer"
cell49 = first_sheet.cell(1, 4)
ans2 = cell49.value
driver.find_element_by_xpath(
".//*[@id='question-answer-input-1']").send_keys(ans2)
wait.until(
EC.visibility_of_element_located(
(By.XPATH,
"//span[@class='lesson-editor-status' and .='Saving...']")))
wait.until(
EC.visibility_of_element_located(
(By.XPATH,
"//span[@class='lesson-editor-status' and .='Saved']")))
def teachASkills(self):
wait=WebDriverWait(driver, 60)
wait.until(EC.visibility_of_element_located((By.XPATH,"//a[@href='/create/lessons']")))
print "Clicking on Lessons button from side menu"
driver.find_element_by_xpath("//a[@href='/create/lessons']").click()
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div[3]/div[2]/div/header/div/button")))
print "Clicking on Create Lesson button from lessons page"
driver.find_element_by_xpath(".//*[@id='content']/div/div[3]/div[2]/div/header/div/button").click()
print "Going to verify the display of TEACH A SKILL Teamplate"
book=xlrd.open_workbook(os.path.join('TestData.xlsx'))
first_sheet = book.sheet_by_name('MultiCardLesson')
cell1 = first_sheet.cell(32,0)
exTemplateNameTeachASkill = cell1.value
wait.until(EC.visibility_of_element_located((By.XPATH,"html/body/div[2]/div/div/div[2]/div[4]/div/div")))
teachAskillLocator = driver.find_element_by_xpath("html/body/div[2]/div/div/div[2]/div[4]/h4")
if (teachAskillLocator.is_displayed() and teachAskillLocator.text == exTemplateNameTeachASkill):
print "The TEACH A SKILL Template is displaying in Create a new lesson pop up"
else:
print "Failed to find the TEACH A SKILL Template in Create a new lesson pop up"
raise Exception
# Clicking on Teach a skill template
print "Clicking on Teach A Skill template"
driver.find_element_by_xpath("html/body/div[2]/div/div/div[2]/div[4]/div/div").click()
# Going to verify the number of cards displayed for the template TEACH A SKILL
print "Going to verify the number of cards displayed for the template TEACH A SKILL"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[1]/div/div")))
cardsDisplayedTeachASkill=driver.find_elements_by_xpath(".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[1]/div/div")
actualNumberOfCardsTecahASkill = len(cardsDisplayedTeachASkill)
cell2 = first_sheet.cell(33,0)
exNumberOfCardsTeachASkill = cell2.value
if(actualNumberOfCardsTecahASkill == exNumberOfCardsTeachASkill):
print "The cards count is displaying as expected"+" "+str(exNumberOfCardsTeachASkill)
else:
print "Failed to find the card count as expected"
raise Exception
# Going to verify the title card content
print "Going to verify the title card content"
cell3 = first_sheet.cell(33,1)
exTitleCardContentTeachASkill = cell3.value
actualTitleCardContentTeachASkill = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/h1/textarea").text
if (exTitleCardContentTeachASkill == actualTitleCardContentTeachASkill):
print "The title card label is displaying as expected"+" "+'"'+exTitleCardContentTeachASkill+'"'
else:
print "Failed to find the expected label in title card"
raise Exception
# Going to clear the Title present in the title card
print "Going to clear the lesson title"
driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/h1/textarea").clear()
print "Entering the title for lesson"
cell4= first_sheet.cell(33,2)
titleTeachASkill = cell4.value
driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/h1/textarea").send_keys(titleTeachASkill)
# Clicking on Second card
print "Clicking on Second card"
driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[1]/div/div[2]/div/div[1]").click()
# Going to verify the content in second card
print "Going to verify the content in second card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div")))
cell5= first_sheet.cell(33,3)
exSecondCardTeachASkill1 = cell5.value
cell6= first_sheet.cell(33,4)
exSecondCardTeachASkill2 = cell6.value
cell7= first_sheet.cell(33,5)
exSecondCardTeachASkill3 = cell7.value
cell8= first_sheet.cell(33,6)
exSecondCardTeachASkill4 = cell8.value
cell9= first_sheet.cell(33,7)
exSecondCardTeachASkill5 = cell9.value
cell10= first_sheet.cell(33,8)
exSecondCardTeachASkill6 = cell10.value
actualSecondCardTeachASkill1 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span/span").text
actualSecondCardTeachASkill2 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span[1]/span/span").text
actualSecondCardTeachASkill3 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span[2]/span[1]/span").text
actualSecondCardTeachASkill4 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span[2]/span[2]/span").text
actualSecondCardTeachASkill5 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span[2]/span[3]/span").text
actualSecondCardTeachASkill6 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[5]/div/span/span/span").text
if(exSecondCardTeachASkill1 == actualSecondCardTeachASkill1):
if(exSecondCardTeachASkill2 == actualSecondCardTeachASkill2):
if(exSecondCardTeachASkill3 == actualSecondCardTeachASkill3):
if(exSecondCardTeachASkill4 == actualSecondCardTeachASkill4):
if(exSecondCardTeachASkill5 == actualSecondCardTeachASkill5):
if(exSecondCardTeachASkill6 == actualSecondCardTeachASkill6):
print "The second card content is displaying as expected"
else:
print "Failed to find the expected content in second card"
raise Exception
# Clicking on > icon
print "Clicking on > arrow for Third card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div")))
driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div").click()
# Clicking on Third card
print "Clicking on Third card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[3]/div/div[1]")))
driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[3]/div/div[1]").click()
# Going to verify the content in Third card
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div")))
print "Going to verify the content in Third card"
cell11 = first_sheet.cell(34,0)
exThirdCardTeachASkill1 = cell11.value
actualThirdCardTeachASkill1 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span/span").text
cell12 = first_sheet.cell(34,1)
exThirdCardTeachASkill2 = cell12.value
actualThirdCardTeachASkill2 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[2]/div/span/span/span").text
if(exThirdCardTeachASkill1 == actualThirdCardTeachASkill1):
if(exThirdCardTeachASkill2 == actualThirdCardTeachASkill2):
print "The third card content is displaying as expected"
else:
print "Failed to find the expected content in third card"
raise Exception
# Clicking on < icon
print "Clicking on < arrow for Fourth card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[1]")))
driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[1]").click()
# Clicking on Fourth card
print "Clicking on Fourth card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[1]/div/div[4]/div/div[1]")))
driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[1]/div/div[4]/div/div[1]").click()
# Going to verify the content in Fourth card card
print "Going to verify the content in Fourth card"
cell13 = first_sheet.cell(35,0)
exFourthCardTeachASkill1 = cell13.value
actualFourthCardTeachASkill1 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div/div/span/span[1]/span").text
cell14 = first_sheet.cell(35,1)
exFourthCardTeachASkill2 = cell14.value
actualFourthCardTeachASkill2 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div/div/span/span[2]/span").text
cell15 = first_sheet.cell(35,2)
exFourthCardTeachASkill3 = cell15.value
actualFourthCardTeachASkill3 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div/div/span/span[3]/span").text
if(exFourthCardTeachASkill1 == actualFourthCardTeachASkill1):
if(exFourthCardTeachASkill2 == actualFourthCardTeachASkill2):
if(exFourthCardTeachASkill3 == actualFourthCardTeachASkill3):
print "The fourth card content is displaying as expected"
else:
print "Failed to find the expected content in fourth card"
raise Exception
# Going to click on Fifth card
print "Clicking on Fifth card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[5]/div/div[1]")))
driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[5]/div/div[1]").click()
# Going to verify the content in fifth card
print "Going to verify the content in Fifth card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div")))
cell16 = first_sheet.cell(36,0)
exFifthCardTeachASkill1 = cell16.value
actualFifthCardTeachASkill1 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span/span").text
cell17 = first_sheet.cell(36,1)
exFifthCardTeachASkill2 = cell17.value
actualFifthCardTeachASkill2 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[2]/div/span/span/span").text
if(exFifthCardTeachASkill1 == actualFifthCardTeachASkill1):
if(exFifthCardTeachASkill2 == actualFifthCardTeachASkill2):
print "The Fifth card content is displaying as expected"
else:
print "Failed to find the expected content in Fifth card"
raise Exception
# Going to click on Sixth card
print "Clicking on Sixth card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[6]/div/div[1]")))
driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[6]/div/div[1]").click()
# Verifying Sixth card labels
print "Going to verify the content in Sixth card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div")))
cell18 = first_sheet.cell(37,0)
exSixthCardTeachASkill1 = cell18.value
actualSixthCardTeachASkill1 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div/div/span/span[1]/span").text
cell19 = first_sheet.cell(37,1)
exSixthCardTeachASkill2 = cell19.value
actualSixthCardTeachASkill2 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div/div/span/span[2]/span").text
cell20 = first_sheet.cell(37,2)
exSixthCardTeachASkill3 = cell20.value
actualSixthCardTeachASkill3 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div/div/span/span[3]/span").text
if(exSixthCardTeachASkill1 == actualSixthCardTeachASkill1):
if(exSixthCardTeachASkill2 == actualSixthCardTeachASkill2):
if(exSixthCardTeachASkill3 == actualSixthCardTeachASkill3):
print "The Sixth card content is displaying as expected"
else:
print "Failed to find the expected content in Sixth card"
raise Exception
# Going to click on Seventh card
print "Clicking on Seventh card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[7]/div/div[1]")))
driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[7]/div/div[1]").click()
# Verifying the content in Seventh card
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div")))
cell21 = first_sheet.cell(38,0)
exSeventhCardTeachASkill1 = cell21.value
actualSeventhCardTeachASkill1 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span/span").text
cell22 = first_sheet.cell(38,1)
exSeventhCardTeachASkill2 = cell22.value
actualSeventhCardTeachASkill2 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[2]/div/span/span/span").text
if(exSeventhCardTeachASkill1 == actualSeventhCardTeachASkill1):
if(exSeventhCardTeachASkill2 == actualSeventhCardTeachASkill2):
print "The Seventh card content is displaying as expected"
else:
print "Failed to find the expected content in Seventh card"
raise Exception
print "Clicking on Eightth card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[8]/div/div[1]")))
driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[8]/div/div[1]").click()
# Going to verify the content in Eightth card
print "Going to verify the content in Eightth card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div[2]/div/div/div[2]/div/div/div/div")))
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div[1]/div/div/div/div/div[2]/button")))
cell23 = first_sheet.cell(39,0)
exEightthCardTeachASkill1 = cell23.value
actualEightthCardTeachASkill1 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div[2]/div/div/div[2]/div/div/div/div/div[1]/div/span/span/span").text
cell24 = first_sheet.cell(39,1)
exEightthCardTeachASkill2 = cell24.value
actualEightthCardTeachASkill2 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div[2]/div/div/div[2]/div/div/div/div/div[3]/div/span/span[1]/span").text
cell25 = first_sheet.cell(39,2)
exEightthCardTeachASkill3 = cell25.value
actualEightthCardTeachASkill3 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div[2]/div/div/div[2]/div/div/div/div/div[3]/div/span/span[2]/span").text
deleteButtonEightthCard = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div[1]/div/div/div/div/div[2]/button")
actualchangeLabelEightCard = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div[1]/div/div/div/div/div[2]/div/label").text
cell26 = first_sheet.cell(39,3)
exchangeLabelEightCard = cell26.value
if(exEightthCardTeachASkill1 == actualEightthCardTeachASkill1):
if(exEightthCardTeachASkill2 == actualEightthCardTeachASkill2):
if(exEightthCardTeachASkill3 == actualEightthCardTeachASkill3):
if (deleteButtonEightthCard.is_displayed()):
if (actualchangeLabelEightCard == exchangeLabelEightCard):
print "The Eightth card content is displaying as expected"
else:
print "Failed to find the expected content in Eightth card"
raise Exception
# Clicking on Nineth card
print "Clicking on Nineth card"
driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[9]/div/div[1]").click()
# Going to verify the content in Nineth card
print "Going to verify the content in Nineth card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div[2]/div/div/div[2]/div/div/div/div/div")))
cell27 = first_sheet.cell(40,0)
exNinethCardTeachASkill1= cell27.value
actualNinethCardTeachASkill1 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div[2]/div/div/div[2]/div/div/div/div/div[1]/div/span/span/span").text
cell28 = first_sheet.cell(40,1)
exNinethCardTeachASkill2= cell28.value
actualNinethCardTeachASkill2 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div[2]/div/div/div[2]/div/div/div/div/div[3]/div/span/span/span").text
cell29 = first_sheet.cell(40,2)
exNinethCardTeachASkill3= cell29.value
actualNinethCardTeachASkill3 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div[2]/div/div/div[2]/div/div/div/div/div[5]/div/span/span/span").text
deleteButtonNinethCard = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div[1]/div/div/div/div/div[2]/button")
actualchangeLabelNinethCard = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div[1]/div/div/div/div/div[2]/div/label").text
cell30 = first_sheet.cell(40,3)
exchangeLabelNinethCard= cell30.value
if(exNinethCardTeachASkill1 == actualNinethCardTeachASkill1):
if(exNinethCardTeachASkill2 == actualNinethCardTeachASkill2):
if(exNinethCardTeachASkill3 == actualNinethCardTeachASkill3):
if (deleteButtonNinethCard.is_displayed()):
if (actualchangeLabelNinethCard == exchangeLabelNinethCard):
print "The Nineth card content is displaying as expected"
else:
print "Failed to find the expected content in Nineth card"
raise Exception
# Clicking on Ten th card
print "Clicking on Ten th card "
driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[10]/div/div[1]").click()
wait.until(EC.visibility_of_element_located((By.XPATH,"//span[@class='lesson-editor-status' and .='Saving...']")))
wait.until(EC.visibility_of_element_located((By.XPATH,"//span[@class='lesson-editor-status' and .='Saved']")))
# Going to verify the content in Ten th card
print "Going to verify the content in Tenth card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/p/textarea")))
cell31= first_sheet.cell(41,0)
exTenthCardTeachASkillContent1 = cell31.value
cell32= first_sheet.cell(41,1)
exTenthCardTeachASkillContent2 = cell32.value
cell33= first_sheet.cell(41,2)
exTenthCardTeachASkillContent3 = cell33.value
actualTenthCardTeachASkill1 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/p/textarea").get_attribute("placeholder")
actualTenthCardTeachASkill2 = driver.find_element_by_xpath(".//*[@id='question-answer-input-0']").get_attribute("placeholder")
actualTenthCardTeachASkill3= driver.find_element_by_xpath(".//*[@id='question-answer-input-1']").get_attribute("placeholder")
plusIconLocatorTeachASkill = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div[3]/div/div[1]/div/span")
if(exTenthCardTeachASkillContent1 == actualTenthCardTeachASkill1):
if(exTenthCardTeachASkillContent2 == actualTenthCardTeachASkill2):
if(exTenthCardTeachASkillContent3 == actualTenthCardTeachASkill3):
if(plusIconLocatorTeachASkill.is_displayed()):
print "The Tenth card content is displaying as expected"
else:
print "Failed to find the expected content in Tenth card"
raise Exception
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='question-answer-input-0']")))
print "Entering question"
cell34= first_sheet.cell(1,2)
questionCard = cell34.value
ele=driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/p/textarea")
ele.send_keys(questionCard)
print "Entering first answer"
cell35= first_sheet.cell(1,3)
ans1 = cell35.value
driver.find_element_by_xpath(".//*[@id='question-answer-input-0']").send_keys(ans1)
print "Entering Second answer"
cell36= first_sheet.cell(1,4)
ans2 = cell36.value
driver.find_element_by_xpath(".//*[@id='question-answer-input-1']").send_keys(ans2)
wait.until(EC.visibility_of_element_located((By.XPATH,"//span[@class='lesson-editor-status' and .='Saving...']")))
wait.until(EC.visibility_of_element_located((By.XPATH,"//span[@class='lesson-editor-status' and .='Saved']")))
# Clicking on Eleventh th card
print "Clicking on Eleventh card "
driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[11]/div/div[1]").click()
print "Going to verify the content in Eleventh card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div")))
cell37= first_sheet.cell(42,0)
exEleventhCardTeachASkillContent1 = cell37.value
actualEleventhCardTeachASkillContent1 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span/span").text
cell38= first_sheet.cell(42,1)
exEleventhCardTeachASkillContent2 = cell38.value
actualEleventhCardTeachASkillContent2 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[2]/div/span/span/span").text
if(exEleventhCardTeachASkillContent1 == actualEleventhCardTeachASkillContent1):
if(exEleventhCardTeachASkillContent2 == actualEleventhCardTeachASkillContent2):
print "The Eleventh card content is displaying as expected"
else:
print "Failed to find the expected content in Eleventh card"
raise Exception
# Clicking on Twelve th card
print "Clicking on Twelve th card "
driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[3]/div[2]/div[1]/div/div[2]/div/div[12]/div/div[1]").click()
print "Going to verify the content in Twelve th card"
wait.until(EC.visibility_of_element_located((By.XPATH,".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div")))
cell39= first_sheet.cell(43,0)
exTwelvethCardTeachASkillContent1 = cell39.value
actualTwelvethCardTeachASkillContent1 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[1]/span").text
cell40= first_sheet.cell(43,1)
exTwelvethCardTeachASkillContent2= cell40.value
actualTwelvethCardTeachASkillContent2 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[2]/span").text
cell41= first_sheet.cell(43,2)
exTwelvethCardTeachASkillContent3 = cell41.value
actualTwelevethCardTeachASkillContent3 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[1]/div/span/span[3]/span").text
cell42= first_sheet.cell(43,3)
exEleventhCardTeachASkillContent4 = cell42.value
actualEleventhCardTeachASkillContent4 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[3]/div/span/span/span").text
cell43= first_sheet.cell(43,4)
exEleventhCardTeachASkillContent5 = cell43.value
actualEleventhCardTeachASkillContent5 = driver.find_element_by_xpath(".//*[@id='content']/div/div/div[3]/div[1]/div/div[2]/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div[4]/div/span/span/span").text
if(exTwelvethCardTeachASkillContent1 == actualTwelvethCardTeachASkillContent1):
if(exTwelvethCardTeachASkillContent2 == actualTwelvethCardTeachASkillContent2):
if(exTwelvethCardTeachASkillContent3 == actualTwelevethCardTeachASkillContent3):
if(exEleventhCardTeachASkillContent4 == actualEleventhCardTeachASkillContent4):
if(exEleventhCardTeachASkillContent5 == actualEleventhCardTeachASkillContent5):
print "The Twelve th card content is displaying as expected"
else:
print "Failed to find the expected content in Twelveth card"
raise Exception