class Test_002_DDT_Login:
baseURL = ReadConfig.getApplicationURL()
path = ".//TestData/DDT.xlsx"
logger = logGen.loggen()
def test_DDT_Login(self, setup):
self.logger.info("*************Test_002_DDT_Login**************")
self.logger.info("*************test_DDTLogin**************")
self.row = XLUtils.getRowCount(self.path, "Sheet1")
lst_status = []
for r in range(2, self.row + 1):
self.driver = setup
self.driver.get(self.baseURL)
self.username = XLUtils.readData(self.path, 'Sheet1', r, 1)
self.password = XLUtils.readData(self.path, 'Sheet1', r, 2)
self.exp = XLUtils.readData(self.path, 'Sheet1', r, 3)
self.login = LoginPage(self.driver)
self.login.set_username(self.username)
self.login.set_password(self.password)
self.login.clickLogin()
time.sleep(5)
act_title = self.driver.title
exp_title = "Dashboard / nopCommerce administration"
if act_title == exp_title:
if self.exp == 'Pass':
self.logger.info("*************Passed***********")
#self.login.clicklogout()
lst_status.append("Pass")
elif self.exp == 'Fail':
self.logger.info("***************Failed***********")
#self.login.clicklogout()
lst_status.append("Fail")
self.login.clicklogout()
elif act_title != exp_title:
if self.exp == 'Pass':
self.logger.info("*************Failed***********")
#self.login.clicklogout()
lst_status.append("Fail")
elif self.exp == 'Fail':
self.logger.info("***************Passed***********")
#self.login.clicklogout()
lst_status.append("Pass")
if "Fail" not in lst_status:
self.logger.info("***************Login_DDT_TC_Passed*************")
assert True
self.driver.close()
else:
self.logger.info("***************Login_DDT_TC_failed*************")
self.driver.close()
assert False
self.logger.info("***********End of DDT Login*********")
self.logger.info(
"***********Completed Test_002_DDT_Login***************")
class Test_001_Login:
# base_url = ReadConfig.getApplicationUrl()
file_path = ".//TestData/LoginData.xlsx"
logger = LogGen.loggen()
def test_login(self, setup):
self.logger.info('****Verify login page******')
# self.driver = setup
# self.driver.get(self.base_url)
self.rowcount = XLUtils.getRowCount(self.file_path, 'Sheet1')
print('RowCount====', self.rowcount)
lp_status = []
for r in range(2, self.rowcount):
base_url = ReadConfig.getApplicationUrl()
self.driver = setup
self.driver.get(base_url)
user = XLUtils.readData(self.file_path, 'Sheet1', r, 1)
pwd = XLUtils.readData(self.file_path, 'Sheet1', r, 2)
result = XLUtils.readData(self.file_path, 'Sheet1', r, 3)
self.lp = LoginPage(self.driver)
self.lp.setusername(user)
self.lp.setpassword(pwd)
self.lp.clicklogin()
time.sleep(5)
act_title = self.driver.title
if act_title == "Dashboard / nopCommerce administration":
if result == 'Pass':
# self.logger.info('*****Login DDT verification passed*****')
self.lp.clicklogout()
lp_status.append("passed")
self.driver.close()
elif self.result == 'Fail':
# self.logger.info('*****Login DDT verification failed*****')
self.lp.clicklogout()
lp_status.append('failed')
self.driver.close()
elif act_title != "Dashboard / nopCommerce administration":
if self.result == 'Pass':
# self.logger.info('*****Login DDT verification passed*****')
self.lp.clicklogout()
lp_status.append("failed")
self.driver.close()
elif self.result == 'Fail':
# self.logger.info('*****Login DDT verification passed*****')
self.lp.clicklogout()
lp_status.append('passed')
self.driver.close()
if 'failed' not in lp_status:
# self.logger.info("Login DDT testcase Pass")
# self.driver.close()
assert True
else:
# self.logger.info("Login DDT testcase Fail")
# self.driver.close()
assert False
print('List Status===', lp_status)
self.logger.info('******END OF DDT TESTCASE*******')
