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 lessonWithQuestionAnswerCard(self): book = xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('TrackCreate') cell1 = first_sheet.cell(6, 1) lessonname = cell1.value cell2 = first_sheet.cell(7, 1) question = cell2.value cell3 = first_sheet.cell(8, 1) ans1 = cell3.value cell4 = first_sheet.cell(9, 1) ans2 = cell4.value cell5 = first_sheet.cell(10, 1) ans3 = cell5.value try: que = LessonCreateQuestion() que.createLesson(lessonname, question, ans1, ans2, ans3) finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1, 1) url = cell.value driver.get(url)
def lessonEditMain(self): try: obj1 = LessonEdit() obj1.editCreatedLesson() obj1.lessonWithTextCardforedit() obj1.addQuestionCardforedit() obj1.addImageCardforedit(600) obj1.addVideoCardforedit(600) obj1.addDocumentCardforedit(600) obj1.publishLessonedit() obj1.clickEdit() print "TEST CASE EXECUTION SUCCESSFULLY COMPLETED" except Exception as e: traceback.print_exc() print (e) raise Exception finally: #print "clicking on Home" book=xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('Login_Credentials') #print("Fetching the Attribute Name from Excel Sheet\n") # read a cell cell = first_sheet.cell(1,1) HomeURL = cell.value #print HomeURL driver.get(HomeURL)
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 campaignsPageDisplayMain(self): book = xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('CreateCampaigns') cell1 = first_sheet.cell(1, 1) actualPageHeaderText = cell1.value cell2 = first_sheet.cell(2, 1) actualTextBelowHeader = cell2.value cell3 = first_sheet.cell(3, 1) actualCreateCampaignButtonText = cell3.value cell3 = first_sheet.cell(4, 1) actualGridText = cell3.value cell3 = first_sheet.cell(5, 1) actualTitleCol = cell3.value cell3 = first_sheet.cell(6, 1) actualDurationCol = cell3.value cell3 = first_sheet.cell(7, 1) actualupdatedByCol = cell3.value cell3 = first_sheet.cell(8, 1) actualactionsCol = cell3.value cell3 = first_sheet.cell(9, 1) actualEditLinkText = cell3.value cell3 = first_sheet.cell(10, 1) actualduplicateLinkText = cell3.value cell3 = first_sheet.cell(11, 1) actualassignLinkText = cell3.value try: camp = CampaignPageDisplay() camp.campaignPage(actualPageHeaderText, actualTextBelowHeader, actualCreateCampaignButtonText, actualGridText, actualTitleCol, actualDurationCol, actualupdatedByCol, actualactionsCol, actualEditLinkText, actualduplicateLinkText, actualassignLinkText) print "\n----Execution Completed----\n" except Exception as e: traceback.print_exc() print(e) raise Exception finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1, 1) url = cell.value driver.get(url)
def createCampaignWithAllCardsTwoTimeLesson(self): book=xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('CreateCampaigns') #Campaign Data cell1 = first_sheet.cell(69,1) campaignTitle = cell1.value cell1 = first_sheet.cell(56,1) campDescription = cell1.value cell1 = first_sheet.cell(71,1) actualSuccessMessage = cell1.value cell1 = first_sheet.cell(70,1) lessonName = cell1.value cell1 = first_sheet.cell(60,1) textCard = cell1.value cell1 = first_sheet.cell(61,1) Imagefilepath1 = cell1.value cell1 = first_sheet.cell(62,1) videoPath = cell1.value cell1 = first_sheet.cell(63,1) timeToUploadVideo = cell1.value cell1 = first_sheet.cell(64,1) documentPath = cell1.value cell1 = first_sheet.cell(65,1) questionCard = cell1.value cell1 = first_sheet.cell(66,1) ans1 = cell1.value cell1 = first_sheet.cell(67,1) ans2 = cell1.value try: print "\n\n----This Test case creates campaigns with all lesson cards Two times----\n\n" newobj=CreateCampaignForAllCardsTwoTime() newobj.allCardsTwoTime(lessonName, textCard, Imagefilepath1, videoPath, timeToUploadVideo, documentPath, questionCard, ans1, ans2) newobj.createCampaignLessonAllCardsTwoTimes(campaignTitle, campDescription, lessonName, actualSuccessMessage) except Exception as e: traceback.print_exc() print (e) raise Exception finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1,1) url = cell.value driver.get(url)
def lessonWithTextImageQuestionCard(self): book = xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('TrackCreate') #Track Data cell1 = first_sheet.cell(43, 1) titleOfTrack = cell1.value cell2 = first_sheet.cell(44, 1) Imagefilepath = cell2.value cell2 = first_sheet.cell(45, 1) description = cell2.value cell2 = first_sheet.cell(46, 1) tagName = cell2.value cell2 = first_sheet.cell(47, 1) expectedSuccessText = cell2.value # Lesson Data cell2 = first_sheet.cell(43, 3) lessonname = cell2.value cell2 = first_sheet.cell(44, 3) textCard = cell2.value cell2 = first_sheet.cell(45, 3) Imagefilepath1 = cell2.value cell2 = first_sheet.cell(46, 3) questionCard = cell2.value cell3 = first_sheet.cell(47, 3) ans1 = cell3.value cell4 = first_sheet.cell(48, 3) ans2 = cell4.value try: que = TrackWithTxtImgQueLesson() que.createLessonTxtImgQue(lessonname, textCard, Imagefilepath1, questionCard, ans1, ans2) que.createTrackwithTxtImgQue(titleOfTrack, Imagefilepath, description, tagName, lessonname, expectedSuccessText) except Exception as e: traceback.print_exc() print(e) raise Exception finally: 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 trackWithTwoLessonsImgandVid(self): book = xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('TrackCreate') #Track Data cell1 = first_sheet.cell(79, 1) titleOfTrack = cell1.value cell2 = first_sheet.cell(80, 1) Imagefilepath = cell2.value cell2 = first_sheet.cell(81, 1) description = cell2.value cell2 = first_sheet.cell(82, 1) tagName = cell2.value cell2 = first_sheet.cell(83, 1) expectedSuccessText = cell2.value # Lesson Data cell2 = first_sheet.cell(79, 3) lessonNameforImgcard = cell2.value cell2 = first_sheet.cell(80, 3) Imagefilepath1 = cell2.value cell2 = first_sheet.cell(82, 3) lessonNameforVidcard = cell2.value cell2 = first_sheet.cell(83, 3) videoPath = cell2.value cell2 = first_sheet.cell(84, 3) timeToUploadVideo = cell2.value print "\n\nSetting Pre-requisite" print "Creating Two lessons\n" try: tr1 = TrackWithImgLessonVidLesson() tr1.lessonWithImage(lessonNameforImgcard, Imagefilepath1) tr1.lessonWithVideo(lessonNameforVidcard, videoPath, timeToUploadVideo) tr1.createTrackwithImgAndVideoLesson(titleOfTrack, Imagefilepath, description, tagName, lessonNameforImgcard, lessonNameforVidcard, expectedSuccessText) finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1, 1) url = cell.value driver.get(url)
def againuserLogin(self): print "Reading data from excel sheet" book = xlrd.open_workbook(os.path.join('TestData.xlsx')) # print number of sheets print("Number of WorkSheets :") print book.nsheets # print sheet names #print("Name of WorkSheets :") #print book.sheet_names() # get the first worksheet first_sheet = book.sheet_by_name('Login_Credentials') # read a row #print("First Row Data in 1st WorkSheet :") #print first_sheet.row_values(0) print("Fetching the URL, username and password from Excel Sheet\n") # read a cell cell = first_sheet.cell(1, 1) url = cell.value print url cell = first_sheet.cell(3, 1) username = cell.value print username cell = first_sheet.cell(3, 2) password = cell.value print password driver.get(url) element = WebDriverWait(driver, 10).until( EC.presence_of_element_located((By.ID, "password"))) if driver.title == "Grovo": print("Grovo Application URL Opened") else: raise Exception.message print "Grovo Sign-In page is displayed" print "Entering User name" driver.find_element_by_xpath(".//*[@id='username']").send_keys( username) print "Entering Password" element.send_keys(password) element.send_keys(Keys.TAB) print "Clicking on Sign_In button" driver.find_element_by_xpath("//*[@id='submitButton']").click() print "Successfully Loged Into Grovo Application" time.sleep(5)
def createCampaignTextImageQuesLesson(self): book = xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('CreateCampaigns') #Campaign Data cell1 = first_sheet.cell(75, 1) campaignTitle = cell1.value cell1 = first_sheet.cell(76, 1) campDescription = cell1.value cell1 = first_sheet.cell(77, 1) actualSuccessMessage = cell1.value cell1 = first_sheet.cell(85, 1) minPassingScore = cell1.value cell1 = first_sheet.cell(79, 1) lessonName = cell1.value cell1 = first_sheet.cell(80, 1) textCard = cell1.value cell1 = first_sheet.cell(81, 1) Imagefilepath1 = cell1.value cell1 = first_sheet.cell(82, 1) questionCard = cell1.value cell1 = first_sheet.cell(83, 1) ans1 = cell1.value cell1 = first_sheet.cell(84, 1) ans2 = cell1.value try: print "\n\n----This test case creates campaign with----\n1. Text,Image and Question lesson\n" newobj = CreateCampaignForTxtImgQueLesson() newobj.createLessonTxtImgQue(lessonName, textCard, Imagefilepath1, questionCard, ans1, ans2) newobj.createCampaignTxtImgQues(campaignTitle, campDescription, lessonName, actualSuccessMessage, minPassingScore) except Exception as e: traceback.print_exc() print(e) raise Exception finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1, 1) url = cell.value driver.get(url)
def lessonWithVideoDocumentQuestionCard(self): book=xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('TrackCreate') #Track Data cell1 = first_sheet.cell(52,1) titleOfTrack = cell1.value cell2 = first_sheet.cell(53,1) Imagefilepath = cell2.value cell2 = first_sheet.cell(54,1) description = cell2.value cell2 = first_sheet.cell(55,1) tagName = cell2.value cell2 = first_sheet.cell(56,1) expectedSuccessText= cell2.value # Lesson Data cell2 = first_sheet.cell(52,3) lessonname= cell2.value cell2 = first_sheet.cell(53,3) videoPath= cell2.value cell2 = first_sheet.cell(54,3) documentPath= cell2.value cell2 = first_sheet.cell(55,3) questionCard = cell2.value cell3 = first_sheet.cell(56,3) ans1 = cell3.value cell4 = first_sheet.cell(57,3) ans2 = cell4.value cell4 = first_sheet.cell(53,4) timeToUploadVideo = cell4.value try: que=TrackWithVidDocQueLesson() que.createLessonVidDocQue(lessonname, videoPath, documentPath, questionCard, ans1, ans2,timeToUploadVideo) que.createTrackwithVidDocQue(titleOfTrack, Imagefilepath, description, tagName, lessonname, expectedSuccessText) finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1,1) url = cell.value driver.get(url)
def lessonWithDocumentCard(self): book=xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('TrackCreate') cell1 = first_sheet.cell(34,1) titleOfTrack = cell1.value cell2 = first_sheet.cell(35,1) Imagefilepath = cell2.value print "Image file path" print Imagefilepath cell2 = first_sheet.cell(36,1) description = cell2.value cell2 = first_sheet.cell(37,1) tagName = cell2.value cell2 = first_sheet.cell(34,3) lessonname= cell2.value cell2 = first_sheet.cell(38,1) expectedSuccessText= cell2.value cell2 = first_sheet.cell(35,3) documentPath = cell2.value print "Document file path" print documentPath cell2 = first_sheet.cell(36,3) timeToUploaddocument = cell2.value try: doc=TrackWithDocumentLesson() doc.lessonWithDocument(lessonname, documentPath, timeToUploaddocument) doc.createTrackwithDocument(titleOfTrack, Imagefilepath, description, tagName, lessonname, expectedSuccessText) except Exception as e: traceback.print_exc() print (e) raise Exception finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1,1) url = cell.value driver.get(url)
def BasicInformationWithDirectRole(self): try: obj=BasicInformationWithDirectRole_28() obj.userCreationWithDirectRole() obj.Logincreateuser() obj.againuserLogin() 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 mainDeleteAll(self): try: d = Delete_Tags_Attributes_Lessons() d.mainDeletetag() d.mainDelete_attribute() d.mainDeleteLessons() # d.deactivateuser() 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 UpdationOfExcelValues(self): try: update = UpdatingUserDetails() update.mainUpdateExcelWithUserDetails() 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 TrackWithTxtLessonImageLesson(self): book=xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('TrackCreate') #Track Data cell1 = first_sheet.cell(70,1) titleOfTrack = cell1.value cell2 = first_sheet.cell(71,1) Imagefilepath = cell2.value cell2 = first_sheet.cell(72,1) description = cell2.value cell2 = first_sheet.cell(73,1) tagName = cell2.value cell2 = first_sheet.cell(74,1) expectedSuccessText= cell2.value # Lesson Data cell2 = first_sheet.cell(70,3) lessonNameforTextcard= cell2.value cell2 = first_sheet.cell(71,3) textCard= cell2.value cell2 = first_sheet.cell(73,3) lessonNameforImgcard = cell2.value cell2 = first_sheet.cell(74,3) Imagefilepath1= cell2.value print "Setting Pre-requisite" print "Creating Two lessons\n" try: tr1=TrackWithTxtLessonImgLesson() tr1.lessonWithText(lessonNameforTextcard, textCard) tr1.lessonWithImage(lessonNameforImgcard, Imagefilepath1) tr1.createTrackwithTxtAndImgLesson(titleOfTrack, Imagefilepath, description, tagName, lessonNameforTextcard,lessonNameforImgcard, expectedSuccessText) finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1,1) url = cell.value driver.get(url)
def createCampaignWithImageLessonVideoLesson(self): book = xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('CreateCampaigns') #Campaign Data cell1 = first_sheet.cell(132, 1) campaignTitle = cell1.value cell1 = first_sheet.cell(133, 1) campDescription = cell1.value cell1 = first_sheet.cell(134, 1) actualSuccessMessage = cell1.value cell1 = first_sheet.cell(136, 1) lessonName1 = cell1.value cell1 = first_sheet.cell(137, 1) Imagefilepath1 = cell1.value cell1 = first_sheet.cell(138, 1) lessonName2 = cell1.value cell1 = first_sheet.cell(139, 1) videoPath = cell1.value cell1 = first_sheet.cell(140, 1) timeToUploadVideo = cell1.value try: print "\n\n----This test case creates campaign with----\n1. Image lesson\n2. Video lesson\n" newobj = CreateCampaignForImageAndVideoLesson() newobj.lessonWithImage(lessonName1, Imagefilepath1) newobj.lessonWithVideo(lessonName2, videoPath, timeToUploadVideo) newobj.createCampaignImageAndVideoLessons(campaignTitle, campDescription, actualSuccessMessage, lessonName1, lessonName2) except Exception as e: traceback.print_exc() print(e) raise Exception finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1, 1) url = cell.value driver.get(url)
def createCampaignQuestionLesson(self): book = xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('CreateCampaigns') #Campaign Data cell1 = first_sheet.cell(44, 1) campaignTitle = cell1.value cell1 = first_sheet.cell(45, 1) campDescription = cell1.value cell1 = first_sheet.cell(46, 1) actualSuccessMessage = cell1.value cell1 = first_sheet.cell(48, 1) lessonName = cell1.value cell1 = first_sheet.cell(49, 1) questionCard = cell1.value cell1 = first_sheet.cell(50, 1) ans1 = cell1.value cell1 = first_sheet.cell(51, 1) ans2 = cell1.value cell1 = first_sheet.cell(52, 1) numberOfAttempts = cell1.value try: print "\n\n----This test case creates campaign with----\n1. Question lesson\n" newobj = CreateCampaignForQuestionLesson() newobj.lessonWithQuestion(lessonName, questionCard, ans1, ans2) newobj.createCampaignForQuestionLesson(campaignTitle, campDescription, lessonName, actualSuccessMessage, numberOfAttempts) except Exception as e: traceback.print_exc() print(e) raise Exception finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1, 1) url = cell.value driver.get(url)
def lessonWithQuestionAnswerCard(self): book=xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('TrackCreate') cell1 = first_sheet.cell(10,1) titleOfTrack = cell1.value cell2 = first_sheet.cell(11,1) Imagefilepath = cell2.value cell2 = first_sheet.cell(12,1) description = cell2.value cell2 = first_sheet.cell(13,1) tagName = cell2.value cell2 = first_sheet.cell(10,3) lessonname= cell2.value cell2 = first_sheet.cell(14,1) expectedSuccessText= cell2.value cell2 = first_sheet.cell(11,3) question = cell2.value cell3 = first_sheet.cell(12,3) ans1 = cell3.value cell4 = first_sheet.cell(13,3) ans2 = cell4.value try: que=TrackWithQuestionLesson() que.createLesson(lessonname, question,ans1,ans2) que.createTrackwithQuestion(titleOfTrack, Imagefilepath, description, tagName, lessonname, expectedSuccessText) except Exception as e: traceback.print_exc() print (e) raise Exception finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1,1) url = cell.value driver.get(url)
def createTagForLessonTextlesson(self): try : obj2= CreateTagLessonTextLesson() obj2.createLessonTextLessontag() finally: print "clicking on Home" book=xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('Login_Credentials') print("Fetching the Attribute Name from Excel Sheet\n") # read a cell cell = first_sheet.cell(1,1) HomeURL = cell.value print HomeURL driver.get(HomeURL) wait=WebDriverWait(driver, 80) wait.until(EC.visibility_of_element_located((By.ID,"global-header-search"))) print "Home Page Loaded"
def createCampaignWithTextLessonImageLesson(self): book=xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('CreateCampaigns') #Campaign Data cell1 = first_sheet.cell(121,1) campaignTitle = cell1.value cell1 = first_sheet.cell(122,1) campDescription = cell1.value cell1 = first_sheet.cell(123,1) actualSuccessMessage = cell1.value cell1 = first_sheet.cell(125,1) lessonNameForTextLesson = cell1.value cell1 = first_sheet.cell(126,1) textCard = cell1.value cell1 = first_sheet.cell(127,1) lessonNameforImageLesson = cell1.value cell1 = first_sheet.cell(128,1) Imagefilepath1 = cell1.value try: print "\n\n----This test case creates campaign with----\n1. Text lesson\n2. Image lesson\n" newobj=CreateCampaignForTextAndImageLesson() newobj.lessonWithText(lessonNameForTextLesson, textCard) newobj.lessonWithImage(lessonNameforImageLesson, Imagefilepath1) newobj.createCampaignTxtAndImageLessons(campaignTitle, campDescription, actualSuccessMessage, lessonNameForTextLesson, lessonNameforImageLesson) except Exception as e: traceback.print_exc() print (e) raise Exception finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1,1) url = cell.value driver.get(url)
def createdUserDeactivation(self): try: ob = DeactivateUser() ob.userDeactivation() finally: print "clicking on Home" book = xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('Login_Credentials') print("Fetching the Attribute Name from Excel Sheet\n") # read a cell cell = first_sheet.cell(1, 1) HomeURL = cell.value print HomeURL driver.get(HomeURL) print "Home Page Loaded"
def createCampaignDocumentLesson(self): book = xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('CreateCampaigns') #Campaign Data cell1 = first_sheet.cell(35, 1) campaignTitle = cell1.value cell1 = first_sheet.cell(36, 1) campDescription = cell1.value cell1 = first_sheet.cell(37, 1) actualSuccessMessage = cell1.value cell1 = first_sheet.cell(39, 1) lessonname = cell1.value cell1 = first_sheet.cell(40, 1) documentPath = cell1.value cell1 = first_sheet.cell(41, 1) timeToUploaddocument = cell1.value cell1 = first_sheet.cell(6, 4) textCard = cell1.value try: print "\n\n----This Test case creates campaigns with Document Card----\n\n" newobj = CreateCampaignForDocumentLesson() newobj.lessonWithDocument(lessonname, documentPath, timeToUploaddocument, textCard) newobj.createCampaignForDocumentLesson(campaignTitle, campDescription, lessonname, actualSuccessMessage) except Exception as e: traceback.print_exc() print(e) raise Exception finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1, 1) url = cell.value driver.get(url)
def createLearnerUserAndValidation(self): try: ob = CreateLearner() ob.creatLearnereuser() ob.createLearnerLogin() ob.againuserLogin() finally: book = xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('Login_Credentials') print("Fetching the Attribute Name from Excel Sheet\n") # read a cell cell = first_sheet.cell(1, 1) HomeURL = cell.value print HomeURL driver.get(HomeURL) print "Home Page Loaded"
def lessonWithTextCard(self): book = xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('LessonCreate') cell1 = first_sheet.cell(1, 1) lessonname = cell1.value cell2 = first_sheet.cell(2, 1) textCardText = cell2.value try: obj1 = LessonCreateText() obj1.lessonWithText(lessonname, textCardText) finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1, 1) url = cell.value driver.get(url)
def lessonWithImageUploadCard(self): book=xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('LessonCreate') cell1 = first_sheet.cell(14,1) lessonname = cell1.value cell2 = first_sheet.cell(15,1) imagefilepath = cell2.value try: img=LessonCreateImage() img.lessonWithImage(lessonname, imagefilepath) finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1,1) url = cell.value driver.get(url)
def lessonWithImageCard(self): book=xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('TrackCreate') cell1 = first_sheet.cell(18,1) titleOfTrack = cell1.value cell2 = first_sheet.cell(19,1) Imagefilepath = cell2.value cell2 = first_sheet.cell(20,1) description = cell2.value cell2 = first_sheet.cell(21,1) tagName = cell2.value cell2 = first_sheet.cell(18,3) lessonname= cell2.value cell2 = first_sheet.cell(22,1) expectedSuccessText= cell2.value cell2 = first_sheet.cell(19,3) ImagefilepathforLesson = cell2.value try: img=TrackWithImageLesson() img.lessonWithImage(lessonname, ImagefilepathforLesson) img.createTrackwithImage(titleOfTrack, Imagefilepath, description, tagName, lessonname, expectedSuccessText) except Exception as e: traceback.print_exc() print (e) raise Exception finally: second_sheet = book.sheet_by_name('Login_Credentials') cell = second_sheet.cell(1,1) url = cell.value driver.get(url)
def teachASkillMain(self): try: obj1 = TeachASkill() obj1.teachASkills() obj1.publishLesson() print "TEST CASE EXECUTION SUCCESSFULLY COMPLETED" except Exception as e: traceback.print_exc() print (e) raise Exception finally: #print "clicking on Home" book=xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('Login_Credentials') #print("Fetching the Attribute Name from Excel Sheet\n") # read a cell cell = first_sheet.cell(1,1) HomeURL = cell.value #print HomeURL driver.get(HomeURL)
def createUserReferenceAttributeWithoutRequiredField(self): try: ob = UserAttributeUserReferenceWithoutReq() ob.createUserReferenceAttributewithoutReq() finally: print "clicking on Home" book = xlrd.open_workbook(os.path.join('TestData.xlsx')) first_sheet = book.sheet_by_name('Login_Credentials') print("Fetching the Attribute Name from Excel Sheet\n") # read a cell cell = first_sheet.cell(1, 1) HomeURL = cell.value print HomeURL driver.get(HomeURL) wait = WebDriverWait(driver, 80) wait.until( EC.visibility_of_element_located( (By.ID, "global-header-search"))) print "Home Page Loaded"