class Test002LoginTestDDT: logger = Logger.get_logger() @pytest.mark.regression @pytest.mark.parametrize("user, pwd, expected", excel_utility.load_excel_data(ConfigParser.get_test_data_file_path(), 'login_data_sheet')) def test_login_ddt(self,setup, user, pwd, expected): self.logger.info("**************" + Test002LoginTestDDT.__name__ + "*************") self.logger.info("************** Verify Home Page title *************") self.login_page = LoginPage(setup) self.logger.info(f"Username : {user}") self.logger.info(f"password : {pwd}") self.logger.info(f"expected : {expected}") status_list = list() self.login_page.set_username(user) self.login_page.set_password(pwd) self.login_page.click_login() time.sleep(5) title = self.login_page.get_login_page_title() exp_title = "Dashboard / nopCommerce administration" if title == exp_title: if expected == 'pass': self.logger.info("*********passed***********") self.login_page.click_logout() status_list.append("pass") elif expected == 'fail': self.logger.info("*******failed*********") self.login_page.click_logout() status_list.append("fail") elif title != exp_title: if expected == 'fail': self.logger.info("*********passed***********") status_list.append("pass") elif expected == 'pass': self.logger.info("*********failed***********") status_list.append("fail") if 'fail' not in status_list: self.logger.info("********* Login DDT is passed***********") assert True else: self.logger.info("********* Login DDT is failed***********") assert False self.logger.info("************** Completed " + Test002LoginTestDDT.__name__ + "*************")