class Test_TC002_Login:
baseURL = ReadConfig.getApplicationURL()
path = ".//testData//LoginData.xlsx"
logger = LogGen.loggen()
lst_status = []
exp = None
@pytest.mark.regression
def test_loginPageTitle_ddt(self, setup):
self.logger.info(
"******* Starting Test Login Page DDT Test **********")
self.logger.info(
"******* Starting Test 002 DDT LoginPage Title Test **********")
self.driver = setup
self.driver.maximize_window()
self.driver.get(self.baseURL)
self.lp = LoginPage(self.driver)
self.rows = ExcelUtils.getRowCount(self.path, 'Sheet1')
print('Number of Rows: ', self.rows)
for r in range(2, self.rows + 1):
self.user = ExcelUtils.readData(self.path, 'Sheet1', r, 1)
self.password = ExcelUtils.readData(self.path, 'Sheet1', r, 2)
self.status = ExcelUtils.readData(self.path, 'Sheet1', r, 3)
self.lp.setUsername(self.user)
self.lp.setPassword(self.password)
self.lp.clickLogin()
time.sleep(5)
act_title = self.driver.title
if act_title == 'Dashboard / nopCommerce administration':
if self.status == 'Pass':
self.logger.info("*** Passed ***")
self.lp.clickLogout()
self.lst_status.append("Pass")
elif self.status == 'Fail':
self.logger.info("*** Failed ***")
self.lp.clickLogout()
self.lst_status.append("Fail")
elif act_title != 'Dashboard / nopCommerce administration':
if self.status == 'Pass':
self.logger.info("*** Failed ***")
self.lst_status.append("Fail")
elif self.status == 'Fail':
self.logger.info("*** Passed ***")
self.lst_status.append("Pass")
if "Fail" not in self.lst_status:
self.logger.info("***** Login DDT Passed *****")
self.driver.close()
assert True
else:
self.logger.info("***** Login DDT Failed *****")
self.driver.close()
assert False
self.logger.info("******* Ending Test Login Page DDT Test **********")
self.logger.info(
"******* Completed Test 002 DDT LoginPage Title Test **********")
class Test_002_DDT_Login:
baseURL = ReadConfig.getApplicationURL()
path = ".//TestData//LoginData.xlsx"
logger = LogGen.loggen()
def test_login_ddt(self, setup):
self.logger.info("************** Test_002_DDT_Login ******************")
self.logger.info("************** Verifying Login Test DDT ************** ")
self.driver = setup
self.driver.get(self.baseURL)
self.lp = LoginPage(self.driver)
self.rows = XlUtils.get_row_count(self.path, "Sheet1")
print("No of rows in excel file: ", self.rows)
list_status = []
for r in range(2, self.rows + 1):
self.user = XlUtils.read_data(self.path, 'Sheet1', r, 1)
self.password = XlUtils.read_data(self.path, 'Sheet1', r, 2)
self.exp = XlUtils.read_data(self.path, 'Sheet1', r, 3)
self.lp.setUserName(self.user)
self.lp.setPassword(self.password)
self.lp.clickLogin()
time.sleep(5)
actual_title = self.driver.title
expected_title = "Dashboard / nopCommerce administration"
if actual_title == expected_title:
if self.exp == "Pass":
self.logger.info("***** Passed *****")
self.lp.clickLogout()
list_status.append("Pass")
elif self.exp == "Fail":
self.logger.info("***** Failed *****")
self.lp.clickLogout()
list_status.append("Fail")
elif actual_title != expected_title:
if self.exp == "Pass":
self.logger.info("***** Failed *****")
list_status.append("Fail")
elif self.exp == "Fail":
self.logger.info("***** Passed *****")
list_status.append("Pass")
if "Fail" not in list_status:
self.logger.info("***************** Login DDT test is Passed *****************")
self.driver.close()
assert True
else:
self.logger.info("***************** Login DDT test is Failed *****************")
self.driver.save_screenshot(".\\Screenshots\\" + "test_login_ddt.png")
self.driver.close()
assert False
print(list_status)
self.logger.error("***************** End of Login DDT Test ****************")
self.logger.error("***************** Completed Test_002_DDT_Login ****************")
class Test_case_002_ddt_Login:
base_url = Readconfig.get_application_url()
path = ".//TestData/LoginData.xlsx"
logger = LogGen.loggen()
def test_login(self, setup):
self.logger.info("**** Test case 002 DDT Login ****")
self.logger.info("**** verifying test login ****")
self.driver = setup
self.driver.get(self.base_url)
self.lp = LoginPage(self.driver)
#must obtain data from .xlsx
self.rows = XLUtils.get_row_count(self.path, "Hoja 1")
print("Number of rows in the Excel: ", self.rows)
list_status = []
for r in range(2, self.rows + 1):
self.user = XLUtils.read_data(self.path, 'Hoja 1', r, 1)
self.password = XLUtils.read_data(self.path, 'Hoja 1', r, 2)
self.exp = XLUtils.read_data(self.path, 'Hoja 1', r, 3)
self.lp.setUsername(self.user)
self.lp.setPassword(self.password)
self.lp.clickLogin()
time.sleep(5)
actual_title = self.driver.title
expected_title = "Dashboard / nopCommerce administration"
if actual_title == expected_title:
if self.exp == "Pass":
self.logger.info("*** PASSED ***")
self.lp.clickLogout()
list_status.append("Pass")
elif self.exp == "Fail":
self.logger.info("*** FAILED ***")
self.lp.clickLogout()
list_status.append("Fail")
elif actual_title != expected_title:
if self.exp == "Pass":
self.logger.info("*** FAILED ***")
list_status.append("Fail")
elif self.exp == "Fail":
self.logger.info("*** PASSED ***")
list_status.append("Pass")
if "Fail" not in list_status:
self.logger.info("**** LOGIN DDT TEST PASSED")
self.driver.close()
assert True
else:
self.logger.info("**** LOGIN DDT TEST FAILED")
self.driver.close()
assert False
self.logger.info("**** END OF Test case 002 DDT Login ****")
self.logger.info("**** Test case 002 DDT Login COMPLETED ****")
class Test_002_DDT_Login():
baseURL = ReadConfig.getApplicationURL()
path = "TestData/LoginData.xlsx"
logger = LogGen.loggen() # Logger
@pytest.mark.regression
def test_login_ddt(self,setup):
self.logger.info("******* Starting Test_002_DDT_Login Test **********")
self.logger.info("******* Starting Login DDT Test **********")
self.driver = setup
self.driver.get(self.baseURL)
self.driver.maximize_window()
self.lp = LoginPage(self.driver)
self.rows = XLUtils.getRowCount(self.path, 'Sheet1')
print('Number of rows...',self.rows)
lst_status=[]
for r in range(2,self.rows+1):
self.user=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.lp.setUserName(self.user)
self.lp.setPassword(self.password)
self.lp.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.lp.clickLogout()
lst_status.append("Pass")
elif self.exp=='Fail':
self.logger.info("**** failed ****")
self.lp.clickLogout()
lst_status.append("Fail")
elif act_title!=exp_title:
if self.exp == 'Pass':
self.logger.info("**** failed ****")
lst_status.append("Fail")
elif self.exp == 'Fail':
self.logger.info("**** passed ****")
lst_status.append("Pass")
print(lst_status)
if "Fail" not in lst_status:
self.logger.info("******* DDT Login test passed **********")
self.driver.close()
assert True
else:
self.logger.error("******* DDT Login test failed **********")
self.driver.close()
assert False
self.logger.info("******* End of Login DDT Test **********")
self.logger.info("**************** Completed TC_LoginDDT_002 ************* ")
class Test_002_DDT_Login:
baseURL = ReadConfig.getApplicationURL()
path = ".//TestData/LoginData.xlsx"
logger = LogGen.loggen()
@pytest.mark.regression
def test_login_ddt(self,setup):
self.logger.info("******* Test_002_DDT_Login*****")
self.logger.info("****Started Login DDT Test****")
self.driver = setup
self.driver.get(self.baseURL)
self.lp = LoginPage(self.driver)
self.rows = XLUtils.getRowCount(self.path, 'Sheet1')
print("number of Rows i a Excel: ", self.rows)
lst_status=[] #Empty list Variable
for r in range(2, self.rows+1):
self.user = 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.lp.setUserName(self.user)
self.lp.setPassword(self.password)
self.lp.clickLogin()
time.sleep(5)
act_title = self.driver.title
exp_title = "Dashboard - FleetCart Admin"
if act_title == exp_title:
if self.exp == "Pass":
self.logger.info("****Pass***")
self.lp.clickLogout()
lst_status.append("Pass")
elif self.exp=="Fail":
self.logger.info("**** failed ****")
self.lp.clickLogout()
lst_status.append("Fail")
elif act_title != exp_title:
if self.exp == 'Pass':
self.logger.info("**** failed ****")
lst_status.append("Fail")
elif self.exp == 'Fail':
self.logger.info("**** passed ****")
lst_status.append("Pass")
if "Fail" not in lst_status:
self.logger.info("******* DDT Login test passed **********")
self.driver.close()
assert True
else:
self.logger.error("******* DDT Login test failed **********")
self.driver.close()
assert False
self.logger.info("******* End of Login DDT Test **********")
self.logger.info("**************** Completed TC_LoginDDT_002 ************* ");
class Test_002_DDT_Login:
baseURL = ReadConfig.getApplicationURL()
path = ".//TestData/LoginData.xlsx"
logger = LogGen.loggen()
@pytest.mark.regression
def test_login_ddt(self, setup):
self.logger.info(" ************* Test__002__DDT__Login*********** ")
self.logger.info(" ******************** Veryfying after login ddt test title *************** ")
self.driver = setup
self.driver.get(self.baseURL)
self.lp = LoginPage(self.driver)
self.rows = XLUtils.getRowCount(self.path, 'Sheet1')
print("Number of rows in excel file:", self.rows)
lst_status = [] #empty list variable
for r in range(2, self.rows+1):
self.user = 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.lp.setUserName(self.user)
self.lp.setPassword(self.password)
self.lp.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.lp.clickLogout()
lst_status.append("Pass")
elif self.exp == "Fail":
self.logger.info(" ****** Failed *******")
self.lp.clickLogout()
lst_status.append("Fail")
elif act_title != exp_title:
if self.exp == 'Pass':
self.logger.info(" ***** Failed ****** ")
lst_status.append("Fail")
elif self.exp == "Fail":
self.logger.info("******* Passed *******")
lst_status.append("Pass")
if "Fail" not in lst_status:
self.logger.info("****** Login DDT test passed ********")
self.driver.close()
assert True
else:
self.logger.info("**** Login DDT test failed ******")
self.driver.close()
assert False
self.logger.info(" ********* End of Login DDT Test *********")
self.logger.info(" ******************* Completed TC_LOGINDDT_002 Test ********")
class Test_002_DDT_Login:
baseURL = ReadConfig.getApplicationURL()
dataPath = ".//TestData/LoginData.xlsx"
logger = LogGen.loggen()
@pytest.mark.regression
def test_login(self, setup):
self.logger.info("************** Test_002_DDT_Login **************")
self.logger.info("************** Verifying test_login **************")
self.driver = setup
self.driver.get(self.baseURL)
self.lp = LoginPage(self.driver)
self.numOfTests = XLUtils.gerRowCount(self.dataPath, "Sheet1")
test_status_lst = []
for data in range(2,self.numOfTests+1):
self.user = XLUtils.readData(self.dataPath, "Sheet1", data, 1)
self.pwd = XLUtils.readData(self.dataPath, "Sheet1", data, 2)
self.exp = XLUtils.readData(self.dataPath, "Sheet1", data, 3)
self.lp.setUsername(self.user)
self.lp.setPassword(self.pwd)
self.lp.clickLogin()
time.sleep(5)
act_title = self.driver.title
exp_title = "Dashboard / nopCommerce administration"
print("Data %: % %", data, self.user, self.pwd)
if act_title == exp_title:
if self.exp == "Pass":
self.logger.info("*** PASSED ***")
test_status_lst.append("Pass")
self.lp.clickLogout()
elif self.exp == "Fail":
self.logger.info("*** FAILED ***")
test_status_lst.append("Fail")
self.lp.clickLogout()
if act_title != exp_title:
if self.exp == "Pass":
self.logger.info("*** FAILED ***")
test_status_lst.append("Fail")
elif self.exp == "Pass":
self.logger.info("*** PASSED ***")
test_status_lst.append("Pass")
if "Fail" not in test_status_lst:
self.logger.info("DDT Test is Pass")
self.driver.close()
assert True
else:
self.logger.info("DDT Test is Fail")
self.driver.close()
assert False
self.logger.info(" ********** End of Login DDT Test **********")
self.logger.info(" *************** Completed TC_LoginDDT_002 **************")
class Test_002_DDT_Login:
baseURL = ReadConfig.getApplicationURL()
path = ".//TestData/LoginData.xlsx"
logger = LogGen.loggen()
@pytest.mark.regression
def test_ddt_Login(self, setup):
self.logger.info("***********test_ddt_Login***********")
self.logger.info("***********Verifying The Login Test***********")
self.driver = setup
self.driver.get(self.baseURL)
self.lp = LoginPage(self.driver)
self.rows = XLUtils.getRowCount(self.path, "Sheet1")
print("No of Rows in Excel : ", self.rows)
lst_status = []
for r in range(2, self.rows + 1):
self.user = 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.lp.setUsername(self.user)
self.lp.setPassword(self.password)
self.lp.clickLogin()
time.sleep(10)
act_title = self.driver.title
exp_title = "Dashboard / nopCommerce administration"
if act_title == exp_title:
if self.exp == "Pass":
self.logger.info("************Login Test Passed**********")
lst_status.append("Pass")
print(lst_status)
self.lp.clickLogout()
assert True
elif self.exp == "Fail":
self.logger.info("************Login Test Failed**********")
lst_status.append("Fail")
print(lst_status)
self.lp.clickLogout()
assert False
elif act_title != exp_title:
if self.exp == "Fail":
self.logger.info("************Login Test Passed**********")
lst_status.append("Pass")
print(lst_status)
assert True
elif self.exp == "Pass":
self.logger.info("************Login Test Failed**********")
lst_status.append("Fail")
print(lst_status)
assert False
if "Fail" not in lst_status:
self.logger.info("*********Login DDT Test Passed*********")
self.driver.close()
assert True
else:
self.logger.info("*********Login DDT Test Failed*********")
self.driver.close()
assert False
self.logger.info("**************End of Login Test*****************")
class Test_002_Login:
baseURL = ReadConfig.getApplicationURL()
logger = LogGen.loggen()
path = ".\\TestData\\LoginData.xlsx"
lst_status = []
@pytest.mark.regression
def test_login(self,setup):
self.driver = setup
self.driver.get(self.baseURL)
self.lp = LoginPage(self.driver)
self.rows= ExcelUtils.getRowCount(self.path, 'Sheet1')
self.logger.info("************TEST_002_Login_DDT************")
self.logger.info("*****Verifying Login using DDT*****")
for r in range(2,self.rows+1):
self.user = ExcelUtils.readData(self.path,'Sheet1',r,1)
self.password = ExcelUtils.readData(self.path,'Sheet1',r,2)
self.exp = ExcelUtils.readData(self.path,'Sheet1',r,3)
self.lp.setUserName(self.user)
self.lp.setPassword(self.password)
self.lp.clickLogin()
time.sleep(4)
act_title = self.driver.title
exp_title = "Dashboard / nopCommerce administration"
if act_title == exp_title:
if self.exp == "Pass":
self.logger.info("*****Passed*****")
self.lp.clickLogout()
self.lst_status.append("Pass")
elif self.exp == "Fail":
self.logger.info("*****Failed*****")
self.lp.clickLogout()
self.lst_status.append("Fail")
elif act_title != exp_title:
if self.exp == "Pass":
self.logger.info("*****Failed*****")
self.lst_status.append("Fail")
elif self.exp == "Fail":
self.logger.info("*****Passed*****")
self.lst_status.append("Pass")
if "Fail" not in self.lst_status:
self.logger.info("***** Login DDT test passed *****")
self.driver.close()
assert True
else:
self.logger.info("***** Login DDT test failed *****")
self.driver.close()
assert False
self.logger.info("*********** Completed TEST_002_Login_DDT ***********")
self.logger.info("#### End of TEST_002_Login_DDT ####")
class Test_002_DDT_Login:
path = ".//TestData/LoginData.xlsx"
baseURL = ReadConfig.get_url()
@pytest.mark.regression
def test_login(self, setup):
logger.info("********** Test_002_DDT_Login **********")
logger.info("********** Verifying login test **********")
self.driver = setup
self.driver.get(self.baseURL)
self.login_page = LoginPage(self.driver)
self.rows = excelUtils.getRowCount(self.path, "Sheet1")
print(f"Number of rows {self.rows}")
status = []
for r in range(2, self.rows + 1):
self.username = excelUtils.readData(self.path, 'Sheet1', r, 1)
self.password = excelUtils.readData(self.path, 'Sheet1', r, 2)
self.expected = excelUtils.readData(self.path, 'Sheet1', r, 3)
self.login_page.setUserName(self.username)
self.login_page.setPassword(self.password)
self.login_page.clickLogin()
time.sleep(5)
actual_title = self.driver.title
expected_title = "Dashboard / nopCommerce administration"
if actual_title == expected_title:
if self.expected == 'pass':
logger.info('********** Login test passed **********')
self.login_page.clickLogout()
status.append("pass")
elif self.expected == 'fail':
logger.info('********** Login test failed **********')
self.login_page.clickLogout()
status.append("fail")
elif actual_title != expected_title:
if self.expected == 'pass':
logger.info('********** Login test failed **********')
status.append("fail")
elif self.expected == 'fail':
logger.info('********** Login test passed **********')
status.append("pass")
if "fail" not in status:
logger.info('********** Login DDT test passed **********')
self.driver.close()
assert True
else:
logger.info('********** Login DDT test failed **********')
self.driver.close()
assert False
logger.info('********** End of Login DDT test **********')
class Test_002_ddt_login:
baseUrl = ReadConfig.getApplicationURL()
path = "C:\\Users\\rvanacharla\\workspace_python\\ecom\\TestData\\LoginData.xlsx"
logger = LogGen.loggen()
@pytest.mark.regression
def test_login_DDT(self, setUp):
self.logger.info(
"*********************Test_Login_2_DDT**********************************"
)
self.logger.info(
"*********************Verifying_Home_Page_Title**********************************"
)
self.driver = setUp
self.driver.get(self.baseUrl)
self.lp = LoginPage(self.driver)
self.rows = XLUtils.getRowCount(self.path, 'Sheet1')
print("print Number of rows in Excel file is :", self.rows)
for r in range(2, self.rows + 1):
self.username = XLUtils.readData(self.path, 'Sheet1', r, 1)
self.password = XLUtils.readData(self.path, 'Sheet1', r, 2)
self.result = XLUtils.readData(self.path, 'Sheet1', r, 3)
self.lp.setUserName(self.username)
self.lp.setPassword(self.password)
self.lp.clickLogin()
act_titile = self.driver.title
exp_title = "Dashboard / nopCommerce administration"
if act_titile == exp_title:
if self.result == "pass":
self.logger.info(
"*********************HomePage_Title_Test_Passed********************************"
)
self.lp.clickLogout()
elif self.result == "fail":
self.logger.info(
"*********************HomePage_Title_Test_Failed********************************"
)
self.lp.clickLogout()
elif act_titile != exp_title:
if self.result == "pass":
self.logger.info(
"*********************HomePage_Title_Test_Failed********************************"
)
elif self.result == "fail":
self.logger.info(
"*********************HomePage_Title_Test_Passed********************************"
)
self.logger.info("*******End of DTT Test Cases********")
self.logger.info("**********Completion of Test_Login_2_DDT******")
class Test_OO2_DDT_Login:
baseURL = ReadConfig.readApplicationURL()
message_error = ReadConfig.readErrorMessage()
xml_path = "C:\\Users\\okeyb\\Documents\\Pycharm\\SeleniumFramework\\TestData\\TestData.xml"
logger = LogGeneration.loggen()
def test_login(self, setup):
self.logger.info(
"******************** Test_OO2_DDT_Login ********************")
self.logger.info(
"******************** Verifying Login DDT Test ********************"
)
self.driver = setup
self.driver.get(self.baseURL)
self.lp = LoginPage(self.driver)
list_status = []
expected_output = []
login_data_values = ReadXML.readXMLFile(self.xml_path)
for credentials in login_data_values:
self.username = credentials.get("username")
self.password = credentials.get("password")
self.output = credentials.get("output")
expected_output.append(self.output)
self.lp.setUserName(self.username)
self.lp.setPassword(self.password)
self.lp.clickLogin()
time.sleep(5)
actual_title = self.driver.title
expected_title = "Dashboard / nopCommerce administration"
if actual_title == expected_title:
self.logger.info(
"******************** Login test Passed ********************"
)
self.lp.clickLogout()
list_status.append("Pass")
elif self.lp.getErrorMessage() == self.message_error:
self.logger.info(
"******************** Invalid Login test Passed ********************"
)
list_status.append("Fail")
# if "Fail" not in list_status:
# self.logger.info("********** Data Driven Test Passed **********")
# self.driver.close()
# assert True
# else:
# self.logger.info("********** Data Driven Test Failed **********")
# self.driver.close()
# assert False
self.logger.info("********** End of Data Driven Test **********")
class Test_002_DDT_Login:
baseURL = ReadConfig.getApplicationURL()
path = ".\\TestData\\LoginData.xlsx"
log = LogGen.loggen()
@pytest.mark.regression
def test_Login_ddt(self, setup):
self.log.info("**********Test_002_DDT_Login****************")
self.log.info("************Verifying Login DDT test*************")
self.driver = setup
self.driver.get(self.baseURL)
self.lp = LoginPage(self.driver)
self.rows = ExcelUtils.getRowCount(self.path, 'Sheet1')
print("No. of rows in excel file are: ", self.rows)
lst_status = []
for r in range(2, self.rows + 1):
self.user = ExcelUtils.readData(self.path, 'Sheet1', r, 1)
self.password = ExcelUtils.readData(self.path, 'Sheet1', r, 2)
self.exp = ExcelUtils.readData(self.path, 'Sheet1', r, 3)
self.lp.setUserName(self.user)
self.lp.setPassword(self.password)
self.lp.clickLogin()
time.sleep(5)
actual_title = self.driver.title
exp_title = "Dashboard / nopCommerce administration"
if actual_title == exp_title:
if self.exp == "Pass":
self.log.info("********passed*************")
self.lp.clickLogout()
lst_status.append("Pass")
elif self.exp == "Fail":
self.log.info("**********Failed***********")
self.lp.clickLogout()
lst_status.append("Fail")
elif actual_title != exp_title:
if self.exp == "Pass":
self.log.info("********Failed*************")
lst_status.append("Fail")
elif self.exp == "Fail":
self.log.info("**********Passed***********")
lst_status.append("Pass")
if 'Fail' not in lst_status:
self.log.info("*********Login DDT Test is passed**********")
self.driver.close()
assert True
else:
self.log.info("*********Login DDT Test is failed**********")
self.driver.close()
assert False
self.log.info("*********End of Login DDT Test**********")
self.log.info(
"*********Completed Test_002_DDT_Login test case**********")
def test_login(self):
lp = LoginPage(self.driver)
lp.setUserName(self.username)
lp.setPassword(self.password)
lp.clickLogin()
time.sleep(5)
self.assertEqual('Dashboard / nopCommerce administration',
self.driver.title, 'Webpage title is not matching')
lp.clickLogout()
time.sleep(5)
class Test_002_DDT_Login():
baseURL = ReadConfig.getApplicationURL()
path = "./testData/LoginData.xlsx"
logger = LogGen.loggen() # Logger
@pytest.fixture(autouse=True)
def classSetup(self,oneTimeSetup):
self.driver=self.value
self.ts = TestStatus()
@pytest.mark.regression
def test_login_ddt(self):
self.rows = XLUtils.getRowCount(self.path, 'Sheet1')
self.logger.info("******* Starting Test_002_DDT_Login Test **********")
self.logger.info("******* Starting Login DDT Test **********")
self.driver.get(self.baseURL)
self.driver.maximize_window()
self.lp = LoginPage(self.driver)
self.logger.info("******* Reading data from excel **********")
for r in range(2,self.rows+1):
self.user=XLUtils.readData(self.path,'Sheet1',r,1)
self.password = XLUtils.readData(self.path, 'Sheet1', r, 2)
self.status = XLUtils.readData(self.path, 'Sheet1', r, 3)
self.lp.setUserName(self.user)
self.lp.setPassword(self.password)
self.lp.clickLogin()
time.sleep(5)
if self.status == "True":
if self.driver.title=="Dashboard / nopCommerce administration":
self.logger.info("Login Test Passed")
self.ts.mark("Pass", "Login Test Passed")
self.lp.clickLogout()
else:
self.ts.mark("Fail", "Login Test Failed")
self.logger.info("Login Test Failed")
elif self.status == "False":
if self.driver.title!="Dashboard / nopCommerce administration":
self.ts.mark("Pass", "Login Test Passed")
self.logger.info("Login Test Passed")
else:
self.ts.mark("Fail", "Login Test Failed")
self.logger.info("Login Test Failed")
self.lp.clickLogout()
self.ts.markFinal("test_login_ddt", "Pass", "Login was successful")
self.logger.info("******* Ending Login DDT Test **********")
self.driver.close()
class Test_001_Login:
baseURL = ReadConfig.getApplicationURL()
username = ReadConfig.getUsername()
password = ReadConfig.getPassword()
logs = LogGen.loggen()
def test_log(self):
logs = LogGen.loggen()
print(self.logs)
self.logs.info("***** Test_001_Login *****")
def test_homePageTitle(self, setup):
self.logs.info("***** Test_001_Login *****")
self.logs.info("***** Verifying Home Page title *****")
self.driver = setup
self.driver.get(self.baseURL)
act_title = self.driver.title
if act_title == "Your store. Login":
assert True
self.logs.info("***** Home Page title test is passed *****")
self.driver.close()
else:
self.driver.save_screenshot(".\\Screenshots\\" +
"test_homePageTitle.png")
self.logs.error("***** Home Page title test is failed *****")
self.driver.close()
assert False
def test_login(self, setup):
self.logs.info("***** Test_001_Login *****")
self.logs.info("***** Verifying Login test *****")
self.driver = setup
self.driver.get(self.baseURL)
self.lp = LoginPage(self.driver)
self.lp.setUsername(self.username)
self.lp.setPassword(self.password)
self.lp.clickLogin()
act_title = self.driver.title
self.lp.clickLogout()
if act_title == "Dashboard / nopCommerce administration":
assert True
self.logs.info("***** Login test is passed *****")
self.driver.close()
else:
self.driver.save_screenshot(".\\Screenshots\\" + "test_login.png")
self.driver.close()
assert False
self.logs.error("***** Login test is failed *****")
class Test_002_DDT_Login():
baseURL = ReadConfig.getApplicationURL()
path = "C://Users//user//PycharmProjects//Complete Project//TestData/LoginData.xlsx"
@pytest.mark.regression
def test_login_ddt(self,setup):
self.driver = setup
self.driver.get(self.baseURL)
self.driver.maximize_window()
self.lp = LoginPage(self.driver)
self.rows = XLUtils.getRowCount(self.path, 'Sheet1')
print('Number of rows...',self.rows)
lst_status=[]
for r in range(2,self.rows+1):
self.user=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.lp.setUserName(self.user)
self.lp.setPassword(self.password)
self.lp.clickLogin()
time.sleep(5)
act_title=self.driver.title
exp_title="Dashboard / nopCommerce administration"
if act_title==exp_title:
if self.exp=='Pass':
self.lp.clickLogout();
lst_status.append("Pass")
elif self.exp=='Fail':
self.lp.clickLogout();
lst_status.append("Fail")
elif act_title!=exp_title:
if self.exp == 'Pass':
lst_status.append("Fail")
elif self.exp == 'Fail':
lst_status.append("Pass")
print(lst_status)
if "Fail" not in lst_status:
self.driver.close()
assert True
else:
self.driver.close()
assert False
class Test001_ddt_Login:
BaseUrl = ReadConf.get_BaseUrl()
path = './/testData/logindata.xlsx'
xlutil = XLUtils(path)
row_count = xlutil.get_row_count()
column_count = xlutil.get_column_count()
logger = CustomLogger.custom_logger()
@pytest.mark.regression
def test_login_ddt(self, set_up):
self.driver = set_up
self.driver.get(self.BaseUrl)
self.log = LoginPage(self.driver)
list1 = []
for row in range(2, self.row_count + 1):
expected_result = self.xlutil.read_data(row, 3)
self.log.setUserName(self.xlutil.read_data(row, 1))
self.log.setPassword(self.xlutil.read_data(row, 2))
self.log.clickLogin()
actual_title = self.driver.title
if actual_title == 'Dashboard / nopCommerce administration':
if expected_result == 'pass':
list1.append('pass')
self.log.clickLogout()
self.logger.info('**pass**')
elif expected_result == 'fail':
list1.append('fail')
self.log.clickLogout()
self.logger.info('**fail**')
else:
if expected_result == 'pass':
list1.append('fail')
self.logger.info('**fail**')
elif expected_result == 'fail':
list1.append('pass')
self.logger.info('**pass**')
if 'fail' in list1:
self.logger.info('**** Login DDt test Failed ****')
self.driver.close()
assert False
else:
self.logger.info('**** Login DDt test Passed ****')
self.driver.close()
assert True
class Test_003_DDT_Login(unittest.TestCase):
baseURL = ReadConfig.getApplicationURL()
@pytest.fixture(autouse=True)
def classSetup(self, oneTimeSetup):
self.driver = self.value
self.logger = LogGen.logger # Logger
self.ts = TestStatus()
testdata = [('*****@*****.**', 'admin', 'True'),
('[email protected] ', 'adm', 'False'),
('*****@*****.**', 'admin', 'False'),
('*****@*****.**', 'adm', 'False')]
@pytest.mark.parametrize("user,password,status", testdata)
def test_login_ddt2(self, user, password, status):
self.logger.info("******* Starting Login Test **********")
self.driver.get(self.baseURL)
self.lp = LoginPage(self.driver)
self.lp.setUserName(user)
self.lp.setPassword(password)
self.lp.clickLogin()
time.sleep(5)
if status == "True":
if self.driver.title == "Dashboard / nopCommerce administration":
self.logger.info("Login Test Passed")
self.ts.mark("Pass", "Login Test Passed")
self.lp.clickLogout()
else:
self.ts.mark("Fail", "Login Test Failed")
self.logger.info("Login Test Failed")
elif status == "False":
if self.driver.title != "Dashboard / nopCommerce administration":
self.ts.mark("Pass", "Login Test Passed")
self.logger.info("Login Test Passed")
else:
self.ts.mark("Fail", "Login Test Failed")
self.logger.info("Login Test Failed")
self.lp.clickLogout()
self.ts.markFinal("test_login_ddt2", "Pass", "Login was successful")
self.logger.info("******* Ending Login Test **********")
self.driver.quit()
class Test_001_Login:
baseURL = ReadConfig.getApplicationURL()
username = ReadConfig.getUseremail()
password = ReadConfig.getPassword()
@pytest.mark.regression
def test_homePageTitle(self,setup):
self.driver = setup
self.driver.get(self.baseURL)
act_title=self.driver.title
if act_title=="Your store. Login":
self.driver.close()
assert True
else:
self.driver.save_screenshot(".\\Screenshots\\"+"test_homePageTitle.png")
self.driver.close()
assert False
@pytest.mark.sanity
@pytest.mark.regression
def test_login(self,setup):
self.driver = setup
self.driver.get(self.baseURL)
self.lp=LoginPage(self.driver)
self.lp.setUserName(self.username)
self.lp.setPassword(self.password)
self.lp.clickLogin()
act_title=self.driver.title
if act_title=="Dashboard / nopCommerce administration":
self.lp.clickLogout()
self.driver.close()
assert True
else:
self.driver.save_screenshot(".\\Screenshots\\" + "test_homePageTitle.png")
self.driver.close()
assert False
class Test_002_DDT_Login:
baseURL = ReadConfig.getApplicationURL()
path = ".//TestData/LoginData.xlsx"
logger = LogGen.loggen()
@pytest.mark.regression
def test_login_ddt(self, setup):
self.logger.info("-------- Test_002_DDT_Login --------")
self.logger.info("-------- Verifying Login DDT test ---------")
self.driver = setup
self.driver.get(self.baseURL)
self.lp = LoginPage(self.driver)
self.rows = XLUtils.getRowCount(self.path, 'Sheet1')
print("Number of Rows in the Excel", self.rows)
lst_status = [] # empty list variable
for r in range(2, self.rows + 1):
self.user = 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.logger.info(r)
#self.logger.info(self.user)
#self.logger.info(self.password)
#self.logger.info(self.exp)
self.lp.setUserName(self.user)
self.lp.setPassword(self.password)
self.lp.clickLogin()
time.sleep(5)
act_title = self.driver.title
#self.logger.info(act_title)
exp_title = "Dashboard / nopCommerce administration"
if act_title == exp_title:
if self.exp == "Pass":
self.logger.info("*** Passed ***")
self.lp.clickLogout()
lst_status.append("Pass")
elif self.exp == "Fail":
self.logger.info("*** Failed ***")
self.lp.clickLogout()
lst_status.append("Fail")
elif act_title != exp_title: # can also be if statement
if self.exp == "Pass":
self.logger.info("*** Failed ***")
lst_status.append("Fail")
elif self.exp == "Fail":
self.logger.info("*** Passed1 ***")
lst_status.append("Pass")
self.logger.info(lst_status)
if "Fail" not in lst_status:
self.logger.info("*** Login DDT test passed ***")
self.driver.close()
assert True
else:
self.logger.info("*** Login DDT test failed ***")
self.driver.close()
assert False
self.logger.info("-------- End of Test_002_DDT_Login --------")
self.logger.info("-------- Completed Login DDT test ---------")
class Test_002_DDT_Login:
baseURL = ReadConfig.getApplicationURL() # URL정보를 가져옴
path = '.\\testData\\LoginData.xlsx' # Test Data 파일 경로
logger = LogGen.loggen() # 로그 생성을 위한 인스턴스
@pytest.mark.regression
def test_login_ddt(self, setup):
self.logger.info("********** Test_002_DDT_Login **********")
self.logger.info("********** verifying login DDT test **********")
self.driver = setup
self.driver.get(self.baseURL)
self.driver.maximize_window()
self.lp = LoginPage(self.driver)
# Test data 의 행 숫자를 가져옴
self.rows = ExcelUtils.getRowCount(self.path, 'Sheet1')
print("Number of rows in Excel:", self.rows)
# PASS/FAIL 정보를 넣어줄 빈 리스트 생성
lst_status = []
for r in range(2, self.rows + 1):
# Test data에서 엑셀 셀값을 가져옴
self.user = ExcelUtils.readData(self.path, 'Sheet1', r, 1)
self.password = ExcelUtils.readData(self.path, 'Sheet1', r, 2)
self.exp = ExcelUtils.readData(self.path, 'Sheet1', r, 3)
self.driver.get(self.baseURL)
self.lp.setUserName(self.user)
self.lp.setPassword(self.password)
self.lp.clickLogin()
time.sleep(5)
act_title = self.driver.title
exp_title = "SK open API"
if act_title == exp_title:
if self.exp == "Pass":
self.logger.info("********** Passed")
self.lp.clickLogout()
lst_status.append("Pass")
elif self.exp == "Fail":
self.logger.info("********** Failed")
self.lp.clickLogout()
lst_status.append("Fail")
elif act_title != exp_title:
if self.exp == "Pass":
self.logger.info("********** Failed")
lst_status.append("Fail")
elif self.exp == "Fail":
self.logger.info("********** Passed")
lst_status.append("Pass")
if "Fail" not in lst_status:
self.logger.info("********** Login DDT Test Passed **********")
self.driver.close()
assert True
else:
self.logger.info("********** Login DDT Test Failed **********")
self.driver.close()
assert False
self.logger.info("********** End of Login DDT Test **********")
self.logger.info("********** Completed TC_LoginDDT_002 **********")
class Test_0002_login_DDT:
baseUrl = ReadConfig.getAppUrl()
path = ".\\TestData\\LoginData.xlsx"
logger = LogGen.loggen()
@pytest.mark.regression
def test_login(self, setup):
self.logger.info("********* Login_002 DDT test starts *********")
self.logger.info("************** Verifying Login test DDT *************")
self.driver = setup
self.driver.get(self.baseUrl)
self.lp = LoginPage(self.driver)
list_status=[]
self.rows = XLUtil.getRowCount(self.path, 'Sheet1')
print(" total number of rows", self.rows)
for r in range(2, self.rows+1):
self.username = XLUtil.readData(self.path, 'Sheet1', r, 1)
self.password = XLUtil.readData(self.path, 'Sheet1', r, 2)
self.exp = XLUtil.readData(self.path, 'Sheet1', r, 3)
self.lp.setUserName(self.username)
self.lp.setPassword(self.password)
self.lp.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("****** Test Step Passed******")
self.lp.clickLogout()
list_status.append("Pass")
elif self.exp=="Fail":
self.logger.info("****** Test Step Failed******")
# self.lp.clickLogout()
list_status.append("Fail")
elif act_title!=exp_title:
if self.exp=="Pass":
self.logger.info("****** Test Step Failed ******")
# self.lp.clickLogout()
list_status.append("Fail")
elif self.exp=="Fail":
self.logger.info("****** Test Step Passed ******")
# self.lp.clickLogout()
list_status.append("Pass")
# print(list_status)
if "Fail" not in list_status:
self.logger.info("******* Login DDT test passed ******")
self.driver.close()
assert True
else:
self.logger.info("******* Login DDT test failed ******")
self.driver.close()
assert False
self.logger.info("********* End of Login_002 DDT test *********")
class Test_002_DDT_Login:
baseURL= ReadConfig.getApplicationURL()
path=".//TestData//LoginData.xlsx"
logger=LogGen.loggen()
@pytest.mark.regression
def test_login_ddt(self,setup):
self.logger.info("************* Test_002_DDT_Login Started *******")
self.logger.info("************* Verifying test_login_ddt Test Case *******")
self.driver=setup
self.driver.get(self.baseURL)
self.lp=LoginPage(self.driver)
self.rows=XLUtils.getRowCount(self.path,'Sheet1')
self.logger.info("The row counts is %s",self.rows)
list_status=[] # Empty list variable
for r in range (2,self.rows+1):
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.logger.info('username is %s',self.username)
self.logger.info('password is %s',self.password)
self.logger.info('expected result is %s',self.exp)
time.sleep(5)
self.lp.setUserName(self.username)
self.lp.setPassword(self.password)
self.lp.clickLogin()
time.sleep(5)
actual_title=self.driver.title
exp_title="Salesforce - Unlimited Edition"
if actual_title==exp_title:
self.logger.info("************* Login Is successful due to Correct credentials *******")
if self.exp=="Pass":
self.logger.info("*******Test Data sheet expected given as Pass So the test also passed *******")
self.lp.clickLogout()
list_status.append("Pass")
elif self.exp=="Fail":
self.logger.info("************* Test Data sheet expected given as Fail rather than Pass *******")
self.lp.clickLogout()
list_status.append("Fail")
elif actual_title != exp_title:
self.logger.info("************* Login Failed due to incorrect credentials *******")
if self.exp=="Pass":
self.logger.info("************* Test Data sheet expected given as Pass rather than Fail *******")
list_status.append("Fail")
elif self.exp=="Fail":
self.logger.info("****** Test Data sheet expected given as Fail So the test also passed *******")
list_status.append("Pass")
self.logger.info("The status in the list are: ")
for item in list_status:
self.logger.info(item)
if "Fail" not in list_status:
self.logger.info("*** Login DDT test is passed ***")
assert True
else:
self.logger.info("*** Login DDT test is Failed ***")
assert False
self.logger.info("*** End of Verifying test_login_ddt ***")
self.logger.info("*** Completed Test_002_DDT_Login ***")
class Test_001_Login:
baseURL = ReadConfig.getApplicationURL()
username = ReadConfig.getUseremail()
password = ReadConfig.getPassword()
### Calling the loggen method from LogGen Class ####
logger = LogGen.loggen()
##### 1) test_homePageTitle ######
def test_homePageTitle(self, setup):
self.logger.info("*************** Test_001_Login *****************")
self.logger.info("****Verify Home page title test ****")
self.driver = setup
self.driver.get(self.baseURL)
act_title = self.driver.title
if act_title == "Login - FleetCart":
assert True
self.driver.close()
self.logger.info(
"*************** HomePageTitle test is passed *****************"
)
else:
self.driver.save_screenshot(".\\Screenshots\\" +
"test_homePageTitle.png")
self.driver.close()
self.logger.info(
"*************** HomePageTitle test is Failed *****************"
)
assert False
######## 2) test_login #########
def test_login(self, setup):
self.logger.info(
"*************** test_login test is passed *****************")
self.driver = setup
self.driver.get(self.baseURL)
### To access the methos in "pageObjects.LoginPage import LoginPage" Class
self.lp = LoginPage(self.driver)
self.lp.loginOneStep(self.username, self.password)
# self.lp.setUserName(self.username)
# self.lp.setPassword(self.password)
# self.lp.clickLogin()
act_title = self.driver.title
if act_title == "Dashboard - FleetCart Admin":
assert True
self.driver.close()
self.logger.info(
"*************** test_login test is passed *****************")
else:
self.driver.save_screenshot(".\\Screenshots\\" + "test_login.png")
self.driver.close()
self.logger.error(
"*************** test_login test is Failed *****************")
assert False
##### 3) test_logout ######
def test_logout(self, setup):
self.logger.info(
"*************** test_logout test is passed *****************")
self.driver = setup
self.driver.get(self.baseURL)
### To access the methos in "pageObjects.LoginPage import LoginPage" Class
self.lp = LoginPage(self.driver)
self.lp.setUserName(self.username)
self.lp.setPassword(self.password)
self.lp.clickLogin()
self.lp.clickLogout()
act_title = self.driver.title
if act_title.strip(
) == "Login - FleetCart": ##Trim\Strip (remove the white space in the Tag)
assert True
self.driver.close()
self.logger.info(
"*************** test_logout test is passed *****************")
else:
self.driver.save_screenshot(".\\Screenshots\\" + "test_logout.png")
self.driver.close()
self.logger.error(
"*************** test_logout test is Failed *****************")
assert False
class Test_001_Login():
baseURL = ReadConfig.getApplicationURL()
logger = LogGen.test_loggen()
path = ".//TestData/TestData.xlsx"
@pytest.mark.regression
def test_login_ddt(self, setup):
self.logger.info(
"********************Test_001_Login***************************")
self.logger.info(
"******************** Verifying test_login_ddt **********************"
)
self.driver = setup
self.driver.get(self.baseURL)
self.login = LoginPage(self.driver)
self.rows = XLUtility.getRowCount(self.path, "Sheet1")
print("no of rows in the excel", self.rows)
test_list = []
for r in range(2, self.rows + 1):
self.username = XLUtility.readData(self.path, "Sheet1", r, 1)
self.password = XLUtility.readData(self.path, "Sheet1", r, 2)
self.exp = XLUtility.readData(self.path, "Sheet1", r, 3)
self.driver.maximize_window()
self.driver.implicitly_wait(5)
self.login.setUserName(self.username)
self.login.setPassword(self.password)
self.login.clickLogin()
self.driver.implicitly_wait(5)
act_title = self.driver.title
if act_title == "Dashboard / nopCommerce administration":
if self.exp == "Pass":
self.logger.info("****PASSED*****")
self.login.clickLogout()
test_list.append("Pass")
elif self.exp == "Fail":
self.logger.info("*****FAILED******")
self.login.clickLogout()
test_list.append("Fail")
elif act_title != "Dashboard / nopCommerce administration":
if self.exp == "Pass":
self.logger.info("******FAILED*********")
test_list.append("Fail")
elif self.exp == "Fail":
self.logger.info("******PASSED*********")
test_list.append("Pass")
if "Fail" not in test_list:
self.logger.info("***********test_login_ddt [PASSED]*************")
self.driver.close()
assert True
else:
self.logger.error(
"***********test_login_ddt [FAILED]*************")
self.driver.close()
assert False
self.logger.info(
"*************** End of test_login_ddt *******************")
class Test_002_DDT_Login:
baseurl = ReadConfig.getAppURL()
path = ".//testData/LoginData.xlsx"
logger = LogGen.loggen()
@pytest.mark.regression
def test_login(self, setup):
self.logger.info("**Test_002_DDT_Login**")
self.logger.info("**Verify The Login DDT function**")
self.driver = setup
self.driver.get(self.baseurl)
self.lp = LoginPage(self.driver)
self.rows = XLUtils.getRowCount(self.path, 'Sheet1')
# List variable to capture to results of the test
lst_status = [] # Empty list variable
for r in range(2, self.rows + 1):
self.username = XLUtils.readData(self.path, 'Sheet1', r, 1)
self.password = XLUtils.readData(self.path, 'Sheet1', r, 2)
self.expected = XLUtils.readData(self.path, 'Sheet1', r, 3)
self.lp.setUserName(self.username)
self.lp.setPassword(self.password)
self.lp.clickLogin()
time.sleep(2)
act_title = self.driver.title
exp_tile = "Dashboard / nopCommerce administration"
if act_title == exp_tile:
if self.expected == "Pass":
self.logger.info("***Test Passed***" + self.username)
self.lp.clickLogout()
lst_status.append("Pass")
elif self.expected == "Fail":
self.logger.error("***Test Failed***" + self.username)
self.lp.clickLogout()
lst_status.append("Fail")
elif act_title != exp_tile:
if self.expected == "Pass":
self.logger.error("***Test Failed***" + self.username)
lst_status.append("Fail")
elif self.expected == "Fail":
self.logger.info("***Test Passed***" + self.username)
lst_status.append("Pass")
if "Fail" not in lst_status:
self.logger.info("***Login DDT Test Passed***")
self.driver.close()
assert True
else:
self.logger.error("***Login DDT Test Failed***")
self.driver.close()
assert False
self.logger.info("***End of DDT Test**")
self.logger.info("***Completed the Test ***")
class Test_003_DDT_Login:
baseURL = ReadConfig.getApplicationURL()
path = ".//TestData//LoginData.xlsx"
logger = LogGen.loggen()
@pytest.mark.sanity
def test_login_ddt(self, setup):
self.logger.info("*************** Started Test_003_DDT_Login test ***********")
self.driver=setup
#self.driver = webdriver.Chrome()
self.driver.get(self.baseURL)
self.driver.maximize_window()
self.lp=LoginPage(self.driver)
self.rows=XLUtils.getRowCount(self.path,'Sheet1')
print('Number of rows....', self.rows)
lst_status=[]
for r in range(2,self.rows+1):
self.username=XLUtils.readData(self.path, 'Sheet1', r,1) # user name
self.password = XLUtils.readData(self.path, 'Sheet1', r, 2) # password
self.exp = XLUtils.readData(self.path, 'Sheet1', r, 3) # expected
self.lp.setUserName(self.username)
self.lp.setPassword(self.password)
self.lp.clickLogin()
time.sleep(3)
act_title=self.driver.title
exp_title="Dashboard / nopCommerce administration"
if act_title==exp_title: # Login Success
if self.exp=='Pass':
self.logger.info('*****Passed*****')
self.lp.clickLogout()
lst_status.append("Pass")
assert True
elif self.exp=='Fail':
self.logger.info('*****Failed*****')
self.lp.clickLogout()
lst_status.append("Failed")
assert False
elif act_title!=exp_title: # Login is NOT Succesful
if self.exp=='Pass':
self.logger.info('*****Failed*****')
lst_status.append("Failed")
elif self.exp=='Fail':
self.logger.info('*****Passed*****')
lst_status.append("Pass")
print(lst_status)
if'Fail' not in lst_status:
self.logger.info("*****DDT Login test Passed*****")
self.driver.close()
assert True
else:
self.logger.error("*****DDT Login test Failed*****")
self.driver.close()
assert False
self.logger.info("*************Finished Test_003_DDT_Login**************")
self.logger.info("**************** Completed TC_LoginDDT_003 ************* ")
class Test_002_DDT_Login:
baseURL = ReadConfig.getApplicationURL()
path = "C:\\Users\\gladi\\PycharmProjects\\SeleniumHybridFrameworkPytest\\TestData\\LoginData.xlsx"
logger = LogGen.loggen()
@pytest.mark.regression
def test_login_ddt(self, setUp):
self.logger.info("********* Test_002_DDT_Login *****************")
self.logger.info("********* Verifying Login DDT test **********")
self.driver = setUp
self.driver.get(self.baseURL)
self.lp = LoginPage(self.driver)
self.rows = XLUtils.getRowCount(self.path, 'Sheet1')
print("Number of rows in Excel:",self.rows)
list_status = [] # Empty list variable
for r in range(2, self.rows+1):
self.user = XLUtils.readData(self.path,'Sheet1',r,1)
self.psword = XLUtils.readData(self.path, 'Sheet1',r,2)
self.expected = XLUtils.readData(self.path, 'Sheet1', r, 3)
self.lp.setUserName(self.user)
self.lp.setPassword(self.psword)
self.lp.clickLogin()
time.sleep(5)
act_title = self.driver.title
print(act_title)
exp_title = "Dashboard / nopCommerce administration"
if act_title == exp_title:
if self.expected == "Pass":
self.logger.info("********Passed************")
self.lp.clickLogout()
list_status.append("Pass")
elif self.expected == "Fail":
self.logger.info("*******Failed*******")
self.lp.clickLogout()
list_status.append("Fail")
elif act_title != exp_title:
if self.expected == "Pass":
self.logger.info("***Failed********")
list_status.append("Fail")
elif self.expected == "Fail":
self.logger.info("*************Passed**********")
list_status.append("Pass")
if "Fail" not in list_status:
self.logger.info("****Login DDT test passed*******")
self.driver.close()
assert True
else:
self.logger.info("*****Login DDT test failed**********")
self.driver.close()
assert False
self.logger.info("***********End of Login DDT Test**********")
self.logger.info("*********** Completed TC_Login_DDT_002 ***********")
class Test_001_Login:
baseURL = ReadConfig.getApplicationURL()
username = ReadConfig.getUsername()
password = ReadConfig.getPassword()
logger = LogGen.loggen()
def test_homePageTitle(self, setup):
self.driver = setup
self.logger.info("**********Starting Test_001_Login**********")
self.logger.info("********** WebTitle Test Started ***********")
self.logger.info("***** Launching Browser *****")
self.driver.get(self.baseURL)
self.driver.maximize_window()
self.logger.info("***** Checking the Title of the WebPage *****")
act_title = self.driver.title
if act_title == "OrangeHRM":
self.logger.info(
"***** Congrats!! Title is matching, Closing Browser *****")
self.driver.close()
assert True
else:
self.driver.save_screenshot(
"C:\\Users\\Salim\\eclipse-workspace\\orangeHRM\\Screenshots\\"
+ "test_homePageTitle.png")
self.logger.info(
"***** OOPS!! Title is not matching, Closing Browser *****")
self.driver.close()
assert False
def test_login(self, setup):
self.driver = setup
self.logger.info(
"************ Opening OrangeHRM Application ************")
self.driver.get(self.baseURL)
self.driver.maximize_window()
self.logger.info("***** Checking the Login Functionality *****")
self.lp = LoginPage(self.driver)
time.sleep(2)
self.logger.info("***** Entering UserName *****")
self.lp.setUserName(self.username)
self.logger.info("***** Entering Password *****")
self.lp.setPassword(self.password)
self.logger.info("***** Clicking on Login Button *****")
self.lp.clickLogin()
act_url = self.driver.current_url
if act_url == "https://opensource-demo.orangehrmlive.com/index.php/dashboard":
self.logger.info("***** Logged in Successfully *****")
self.lp.clickLogout()
self.logger.info("***** Closing Browser *****")
self.driver.close()
assert True
else:
self.driver.save_screenshot(
"C:\\Users\\Salim\\eclipse-workspace\\orangeHRM\\Screenshots\\"
+ "LoginFailed.png")
self.logger.info(
"***** Login Failed, Please check the Screenshots Folder *****"
)
self.driver.close()
self.logger.info("***** Closing Browser *****")
assert False
