report.html

Report generated on 29-Jun-2023 at 01:39:19 by pytest-html v2.1.1

Environment

Packages {"pluggy": "0.13.1", "py": "1.9.0", "pytest": "7.2.2"}
Platform Windows-10-10.0.19041-SP0
Plugins {"allure-pytest": "2.8.18", "datadir": "1.3.1", "html": "2.1.1", "metadata": "1.10.0", "order": "1.1.0", "xdist": "3.2.1"}
Python 3.8.5

Summary

65 tests ran in 5953.68 seconds.

53 passed, 0 skipped, 12 failed, 0 errors, 0 expected failures, 0 unexpected passes

Results

Result Test Duration Links
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[A] 70.07
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x0000024AB70162B0>
value = 'A', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

@pytest.mark.test_details("0000","high","Order and Payment Flow","Pradeep")
@pytest.mark.parametrize("value", certification_program_course_read_csv())
def test_Orders_and_Payment_Flow_certification(self,value,initialize_pages,testdata):

'''
Objective: Make payment and validate the data in Dynamo db and mySql

Step 01: get url
Step 02: click on Enroll Now CTA
Step 03: Make payment
Step 04: Validate the Dynamo db and MySql daya for the payment
'''
url_count = self._count_url_txt_file_subdomain('Orders_and_Payment_Flow_Certification.txt')
logging.info(f"Total URL Present is: {url_count}")

# Step 01: get url
counter = 0
df = pd.read_csv('order_and_payment_certification_prod.csv', on_bad_lines='skip')
data = df[df['id']==value]
url_value = data['url'].values[0]
country_value = data['country'].values[0]
try:
pytest.driver.delete_all_cookies()
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_present(self.pg_orders.locators['common_button_enroll_now_certificaton'],10):
course_data = None
self.pg_orders.click_enroll_now_certification(url_value)
course_data = self._complete_payment(country_value,testdata['payment_type'],testdata['name'],testdata['email_id'],testdata['contact_no'])
logging.info(type(course_data))
time.sleep(5)

logging.info(f"course_data: {course_data}")

# Step 04: Validate the Dynamo db and MySql data for the payment
token_no = pytest.driver.current_url.split('authtoken=')[-1]
logging.info(f"Token No is: {token_no}")
query = f"""SELECT
emailId,contactNumber,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"name"', -1), '";', 1), '"', -1) AS name,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"training_type_txt"', -1), '";', 1), '"', -1) AS training_type_txt,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"display_total_price"', -1), '";', 1), '"', -1) AS display_total_price,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"price"', -1), '";', 1), '"', -1) AS price
FROM ssvc.cart where token = '{token_no}';"""

sql_data = db_helper.get_prod_data(query,testdata['db_type'])
logging.info(f"RAW SQL Data: {sql_data}\n")
# sql_items = self.convert_items_to_json(sql_data)
# logging.info(f"SQL DATA in JSON format: {sql_items}\n")

all_payment_cta = []
for i in course_data[1][1]:
a = (list(i.values())[0])
if 'failed' in list(i.values())[0].lower():
all_payment_cta.append('fail')


message = self.verify_mySQL_data_certification(course_data[0],sql_data,testdata)
if 'successfull' in message[0].lower() and len(all_payment_cta) == 0:
status = 'Success'
else:
status = 'Fail'
filename = 'Report.csv'
course_name = course_data[0]['course_name']
course_type = 'Certification Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,course_data[1][0],course_data[1][1],status]]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

if status == 'Fail':
pytest.fail("Status is Fail")
else:
message = "Enroll Now button is not Appearing"
logging.info(message)
filename = 'Report.csv'
course_name = self.pg_orders.course_name_in_url.get_text()
course_type = 'Certification Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,'','','CTA NOT AVAILABLE']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

except Exception as e:
counter = counter+1
logging.error("Exception occurred", exc_info=True)
filename = 'Report.csv'
course_name = 'NA'
course_type = 'Certification Program'
if course_data == None:
logging.info("If block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'','','','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 1:
logging.info("1st else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[0],'','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 2:
logging.info("2nd else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[1][1],course_data[1][0],'Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)


if counter != 0:
> pytest.fail('Failed')
E Failed: Failed

test_prod\test_orders_and_payment_flow.py:202: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/agile-and-scrum/agile-and-scrum-certification-training INFO  setup:orders_page.py:30 Country Set to: IN ERROR  setup:test_orders_and_payment_flow.py:177 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 119, in test_Orders_and_Payment_Flow_certification self.pg_orders.click_enroll_now_certification(url_value) File "C:\test_repos\pre_sales_test_python\pages_prod\orders_page.py", line 37, in click_enroll_now_certification self.common_button_enroll_now_certificaton.click_button() File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 173, in click_button self.click() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 80, in click self._execute(Command.CLICK_ELEMENT) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 633, in _execute return self._parent.execute(command, params) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webdriver.py", line 321, in execute self.error_handler.check_response(response) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\errorhandler.py", line 242, in check_response raise exception_class(message, screen, stacktrace) selenium.common.exceptions.ElementClickInterceptedException: Message: element click intercepted: Element <a class="btn">...</a> is not clickable at point (769, 349). Other element would receive the click: <iframe title="notification-frame-~5584baa3" name="notification-frame-~5584baa3" id="webklipper-publisher-widget-container-notification-frame" frameborder="0" marginheight="0" marginwidth="0" style="display: block; position: fixed; z-index: 16776272; left: -1000px; top: -1000px; visibility: visible; height: 100%; width: 100%; transform: translate(1000px, 1000px);" data-notification-layout-id="~184fc0b7" data-notification-layout-name="modal" class="gm-added gm-lazy"></iframe> (Session info: chrome=114.0.5735.135) INFO  setup:test_orders_and_payment_flow.py:182 If block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[F] 68.68
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x0000024AB7034040>
value = 'F', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

@pytest.mark.test_details("0000","high","Order and Payment Flow","Pradeep")
@pytest.mark.parametrize("value", certification_program_course_read_csv())
def test_Orders_and_Payment_Flow_certification(self,value,initialize_pages,testdata):

'''
Objective: Make payment and validate the data in Dynamo db and mySql

Step 01: get url
Step 02: click on Enroll Now CTA
Step 03: Make payment
Step 04: Validate the Dynamo db and MySql daya for the payment
'''
url_count = self._count_url_txt_file_subdomain('Orders_and_Payment_Flow_Certification.txt')
logging.info(f"Total URL Present is: {url_count}")

# Step 01: get url
counter = 0
df = pd.read_csv('order_and_payment_certification_prod.csv', on_bad_lines='skip')
data = df[df['id']==value]
url_value = data['url'].values[0]
country_value = data['country'].values[0]
try:
pytest.driver.delete_all_cookies()
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_present(self.pg_orders.locators['common_button_enroll_now_certificaton'],10):
course_data = None
self.pg_orders.click_enroll_now_certification(url_value)
course_data = self._complete_payment(country_value,testdata['payment_type'],testdata['name'],testdata['email_id'],testdata['contact_no'])
logging.info(type(course_data))
time.sleep(5)

logging.info(f"course_data: {course_data}")

# Step 04: Validate the Dynamo db and MySql data for the payment
token_no = pytest.driver.current_url.split('authtoken=')[-1]
logging.info(f"Token No is: {token_no}")
query = f"""SELECT
emailId,contactNumber,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"name"', -1), '";', 1), '"', -1) AS name,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"training_type_txt"', -1), '";', 1), '"', -1) AS training_type_txt,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"display_total_price"', -1), '";', 1), '"', -1) AS display_total_price,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"price"', -1), '";', 1), '"', -1) AS price
FROM ssvc.cart where token = '{token_no}';"""

sql_data = db_helper.get_prod_data(query,testdata['db_type'])
logging.info(f"RAW SQL Data: {sql_data}\n")
# sql_items = self.convert_items_to_json(sql_data)
# logging.info(f"SQL DATA in JSON format: {sql_items}\n")

all_payment_cta = []
for i in course_data[1][1]:
a = (list(i.values())[0])
if 'failed' in list(i.values())[0].lower():
all_payment_cta.append('fail')


message = self.verify_mySQL_data_certification(course_data[0],sql_data,testdata)
if 'successfull' in message[0].lower() and len(all_payment_cta) == 0:
status = 'Success'
else:
status = 'Fail'
filename = 'Report.csv'
course_name = course_data[0]['course_name']
course_type = 'Certification Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,course_data[1][0],course_data[1][1],status]]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

if status == 'Fail':
pytest.fail("Status is Fail")
else:
message = "Enroll Now button is not Appearing"
logging.info(message)
filename = 'Report.csv'
course_name = self.pg_orders.course_name_in_url.get_text()
course_type = 'Certification Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,'','','CTA NOT AVAILABLE']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

except Exception as e:
counter = counter+1
logging.error("Exception occurred", exc_info=True)
filename = 'Report.csv'
course_name = 'NA'
course_type = 'Certification Program'
if course_data == None:
logging.info("If block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'','','','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 1:
logging.info("1st else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[0],'','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 2:
logging.info("2nd else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[1][1],course_data[1][0],'Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)


if counter != 0:
> pytest.fail('Failed')
E Failed: Failed

test_prod\test_orders_and_payment_flow.py:202: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/agile-and-scrum/agile-and-scrum-certification-training INFO  setup:orders_page.py:30 Country Set to: US ERROR  setup:test_orders_and_payment_flow.py:177 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 119, in test_Orders_and_Payment_Flow_certification self.pg_orders.click_enroll_now_certification(url_value) File "C:\test_repos\pre_sales_test_python\pages_prod\orders_page.py", line 37, in click_enroll_now_certification self.common_button_enroll_now_certificaton.click_button() File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 173, in click_button self.click() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 80, in click self._execute(Command.CLICK_ELEMENT) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 633, in _execute return self._parent.execute(command, params) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webdriver.py", line 321, in execute self.error_handler.check_response(response) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\errorhandler.py", line 242, in check_response raise exception_class(message, screen, stacktrace) selenium.common.exceptions.ElementClickInterceptedException: Message: element click intercepted: Element <a class="btn">...</a> is not clickable at point (769, 349). Other element would receive the click: <iframe title="notification-frame-~5584baa3" name="notification-frame-~5584baa3" id="webklipper-publisher-widget-container-notification-frame" frameborder="0" marginheight="0" marginwidth="0" style="display: block; position: fixed; z-index: 16776272; left: -1000px; top: -1000px; visibility: visible; height: 100%; width: 100%; transform: translate(1000px, 1000px);" data-notification-layout-id="~184fc0b7" data-notification-layout-name="modal" class="gm-added gm-lazy"></iframe> (Session info: chrome=114.0.5735.135) INFO  setup:test_orders_and_payment_flow.py:182 If block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[K] 69.47
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x0000024AB7034400>
value = 'K', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

@pytest.mark.test_details("0000","high","Order and Payment Flow","Pradeep")
@pytest.mark.parametrize("value", certification_program_course_read_csv())
def test_Orders_and_Payment_Flow_certification(self,value,initialize_pages,testdata):

'''
Objective: Make payment and validate the data in Dynamo db and mySql

Step 01: get url
Step 02: click on Enroll Now CTA
Step 03: Make payment
Step 04: Validate the Dynamo db and MySql daya for the payment
'''
url_count = self._count_url_txt_file_subdomain('Orders_and_Payment_Flow_Certification.txt')
logging.info(f"Total URL Present is: {url_count}")

# Step 01: get url
counter = 0
df = pd.read_csv('order_and_payment_certification_prod.csv', on_bad_lines='skip')
data = df[df['id']==value]
url_value = data['url'].values[0]
country_value = data['country'].values[0]
try:
pytest.driver.delete_all_cookies()
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_present(self.pg_orders.locators['common_button_enroll_now_certificaton'],10):
course_data = None
self.pg_orders.click_enroll_now_certification(url_value)
course_data = self._complete_payment(country_value,testdata['payment_type'],testdata['name'],testdata['email_id'],testdata['contact_no'])
logging.info(type(course_data))
time.sleep(5)

logging.info(f"course_data: {course_data}")

# Step 04: Validate the Dynamo db and MySql data for the payment
token_no = pytest.driver.current_url.split('authtoken=')[-1]
logging.info(f"Token No is: {token_no}")
query = f"""SELECT
emailId,contactNumber,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"name"', -1), '";', 1), '"', -1) AS name,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"training_type_txt"', -1), '";', 1), '"', -1) AS training_type_txt,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"display_total_price"', -1), '";', 1), '"', -1) AS display_total_price,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"price"', -1), '";', 1), '"', -1) AS price
FROM ssvc.cart where token = '{token_no}';"""

sql_data = db_helper.get_prod_data(query,testdata['db_type'])
logging.info(f"RAW SQL Data: {sql_data}\n")
# sql_items = self.convert_items_to_json(sql_data)
# logging.info(f"SQL DATA in JSON format: {sql_items}\n")

all_payment_cta = []
for i in course_data[1][1]:
a = (list(i.values())[0])
if 'failed' in list(i.values())[0].lower():
all_payment_cta.append('fail')


message = self.verify_mySQL_data_certification(course_data[0],sql_data,testdata)
if 'successfull' in message[0].lower() and len(all_payment_cta) == 0:
status = 'Success'
else:
status = 'Fail'
filename = 'Report.csv'
course_name = course_data[0]['course_name']
course_type = 'Certification Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,course_data[1][0],course_data[1][1],status]]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

if status == 'Fail':
pytest.fail("Status is Fail")
else:
message = "Enroll Now button is not Appearing"
logging.info(message)
filename = 'Report.csv'
course_name = self.pg_orders.course_name_in_url.get_text()
course_type = 'Certification Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,'','','CTA NOT AVAILABLE']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

except Exception as e:
counter = counter+1
logging.error("Exception occurred", exc_info=True)
filename = 'Report.csv'
course_name = 'NA'
course_type = 'Certification Program'
if course_data == None:
logging.info("If block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'','','','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 1:
logging.info("1st else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[0],'','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 2:
logging.info("2nd else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[1][1],course_data[1][0],'Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)


if counter != 0:
> pytest.fail('Failed')
E Failed: Failed

test_prod\test_orders_and_payment_flow.py:202: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/agile-and-scrum/agile-and-scrum-certification-training INFO  setup:orders_page.py:30 Country Set to: GB ERROR  setup:test_orders_and_payment_flow.py:177 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 119, in test_Orders_and_Payment_Flow_certification self.pg_orders.click_enroll_now_certification(url_value) File "C:\test_repos\pre_sales_test_python\pages_prod\orders_page.py", line 37, in click_enroll_now_certification self.common_button_enroll_now_certificaton.click_button() File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 173, in click_button self.click() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 80, in click self._execute(Command.CLICK_ELEMENT) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 633, in _execute return self._parent.execute(command, params) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webdriver.py", line 321, in execute self.error_handler.check_response(response) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\errorhandler.py", line 242, in check_response raise exception_class(message, screen, stacktrace) selenium.common.exceptions.ElementClickInterceptedException: Message: element click intercepted: Element <a class="btn">...</a> is not clickable at point (769, 349). Other element would receive the click: <iframe title="notification-frame-~5584baa3" name="notification-frame-~5584baa3" id="webklipper-publisher-widget-container-notification-frame" frameborder="0" marginheight="0" marginwidth="0" style="display: block; position: fixed; z-index: 16776272; left: -1000px; top: -1000px; visibility: visible; height: 100%; width: 100%; transform: translate(1000px, 1000px);" data-notification-layout-id="~184fc0b7" data-notification-layout-name="modal" class="gm-added gm-lazy"></iframe> (Session info: chrome=114.0.5735.135) INFO  setup:test_orders_and_payment_flow.py:182 If block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[P] 69.77
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x0000024AB70347C0>
value = 'P', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

@pytest.mark.test_details("0000","high","Order and Payment Flow","Pradeep")
@pytest.mark.parametrize("value", certification_program_course_read_csv())
def test_Orders_and_Payment_Flow_certification(self,value,initialize_pages,testdata):

'''
Objective: Make payment and validate the data in Dynamo db and mySql

Step 01: get url
Step 02: click on Enroll Now CTA
Step 03: Make payment
Step 04: Validate the Dynamo db and MySql daya for the payment
'''
url_count = self._count_url_txt_file_subdomain('Orders_and_Payment_Flow_Certification.txt')
logging.info(f"Total URL Present is: {url_count}")

# Step 01: get url
counter = 0
df = pd.read_csv('order_and_payment_certification_prod.csv', on_bad_lines='skip')
data = df[df['id']==value]
url_value = data['url'].values[0]
country_value = data['country'].values[0]
try:
pytest.driver.delete_all_cookies()
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_present(self.pg_orders.locators['common_button_enroll_now_certificaton'],10):
course_data = None
self.pg_orders.click_enroll_now_certification(url_value)
course_data = self._complete_payment(country_value,testdata['payment_type'],testdata['name'],testdata['email_id'],testdata['contact_no'])
logging.info(type(course_data))
time.sleep(5)

logging.info(f"course_data: {course_data}")

# Step 04: Validate the Dynamo db and MySql data for the payment
token_no = pytest.driver.current_url.split('authtoken=')[-1]
logging.info(f"Token No is: {token_no}")
query = f"""SELECT
emailId,contactNumber,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"name"', -1), '";', 1), '"', -1) AS name,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"training_type_txt"', -1), '";', 1), '"', -1) AS training_type_txt,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"display_total_price"', -1), '";', 1), '"', -1) AS display_total_price,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"price"', -1), '";', 1), '"', -1) AS price
FROM ssvc.cart where token = '{token_no}';"""

sql_data = db_helper.get_prod_data(query,testdata['db_type'])
logging.info(f"RAW SQL Data: {sql_data}\n")
# sql_items = self.convert_items_to_json(sql_data)
# logging.info(f"SQL DATA in JSON format: {sql_items}\n")

all_payment_cta = []
for i in course_data[1][1]:
a = (list(i.values())[0])
if 'failed' in list(i.values())[0].lower():
all_payment_cta.append('fail')


message = self.verify_mySQL_data_certification(course_data[0],sql_data,testdata)
if 'successfull' in message[0].lower() and len(all_payment_cta) == 0:
status = 'Success'
else:
status = 'Fail'
filename = 'Report.csv'
course_name = course_data[0]['course_name']
course_type = 'Certification Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,course_data[1][0],course_data[1][1],status]]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

if status == 'Fail':
pytest.fail("Status is Fail")
else:
message = "Enroll Now button is not Appearing"
logging.info(message)
filename = 'Report.csv'
course_name = self.pg_orders.course_name_in_url.get_text()
course_type = 'Certification Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,'','','CTA NOT AVAILABLE']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

except Exception as e:
counter = counter+1
logging.error("Exception occurred", exc_info=True)
filename = 'Report.csv'
course_name = 'NA'
course_type = 'Certification Program'
if course_data == None:
logging.info("If block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'','','','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 1:
logging.info("1st else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[0],'','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 2:
logging.info("2nd else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[1][1],course_data[1][0],'Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)


if counter != 0:
> pytest.fail('Failed')
E Failed: Failed

test_prod\test_orders_and_payment_flow.py:202: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/agile-and-scrum/agile-and-scrum-certification-training INFO  setup:orders_page.py:30 Country Set to: AU ERROR  setup:test_orders_and_payment_flow.py:177 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 119, in test_Orders_and_Payment_Flow_certification self.pg_orders.click_enroll_now_certification(url_value) File "C:\test_repos\pre_sales_test_python\pages_prod\orders_page.py", line 37, in click_enroll_now_certification self.common_button_enroll_now_certificaton.click_button() File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 173, in click_button self.click() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 80, in click self._execute(Command.CLICK_ELEMENT) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 633, in _execute return self._parent.execute(command, params) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webdriver.py", line 321, in execute self.error_handler.check_response(response) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\errorhandler.py", line 242, in check_response raise exception_class(message, screen, stacktrace) selenium.common.exceptions.ElementClickInterceptedException: Message: element click intercepted: Element <a class="btn">...</a> is not clickable at point (769, 349). Other element would receive the click: <iframe title="notification-frame-~5584baa3" name="notification-frame-~5584baa3" id="webklipper-publisher-widget-container-notification-frame" frameborder="0" marginheight="0" marginwidth="0" style="display: block; position: fixed; z-index: 16776272; left: -1000px; top: -1000px; visibility: visible; height: 100%; width: 100%; transform: translate(1000px, 1000px);" data-notification-layout-id="~184fc0b7" data-notification-layout-name="modal" class="gm-added gm-lazy"></iframe> (Session info: chrome=114.0.5735.135) INFO  setup:test_orders_and_payment_flow.py:182 If block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[U] 68.94
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x0000024AB7034B80>
value = 'U', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

@pytest.mark.test_details("0000","high","Order and Payment Flow","Pradeep")
@pytest.mark.parametrize("value", certification_program_course_read_csv())
def test_Orders_and_Payment_Flow_certification(self,value,initialize_pages,testdata):

'''
Objective: Make payment and validate the data in Dynamo db and mySql

Step 01: get url
Step 02: click on Enroll Now CTA
Step 03: Make payment
Step 04: Validate the Dynamo db and MySql daya for the payment
'''
url_count = self._count_url_txt_file_subdomain('Orders_and_Payment_Flow_Certification.txt')
logging.info(f"Total URL Present is: {url_count}")

# Step 01: get url
counter = 0
df = pd.read_csv('order_and_payment_certification_prod.csv', on_bad_lines='skip')
data = df[df['id']==value]
url_value = data['url'].values[0]
country_value = data['country'].values[0]
try:
pytest.driver.delete_all_cookies()
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_present(self.pg_orders.locators['common_button_enroll_now_certificaton'],10):
course_data = None
self.pg_orders.click_enroll_now_certification(url_value)
course_data = self._complete_payment(country_value,testdata['payment_type'],testdata['name'],testdata['email_id'],testdata['contact_no'])
logging.info(type(course_data))
time.sleep(5)

logging.info(f"course_data: {course_data}")

# Step 04: Validate the Dynamo db and MySql data for the payment
token_no = pytest.driver.current_url.split('authtoken=')[-1]
logging.info(f"Token No is: {token_no}")
query = f"""SELECT
emailId,contactNumber,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"name"', -1), '";', 1), '"', -1) AS name,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"training_type_txt"', -1), '";', 1), '"', -1) AS training_type_txt,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"display_total_price"', -1), '";', 1), '"', -1) AS display_total_price,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"price"', -1), '";', 1), '"', -1) AS price
FROM ssvc.cart where token = '{token_no}';"""

sql_data = db_helper.get_prod_data(query,testdata['db_type'])
logging.info(f"RAW SQL Data: {sql_data}\n")
# sql_items = self.convert_items_to_json(sql_data)
# logging.info(f"SQL DATA in JSON format: {sql_items}\n")

all_payment_cta = []
for i in course_data[1][1]:
a = (list(i.values())[0])
if 'failed' in list(i.values())[0].lower():
all_payment_cta.append('fail')


message = self.verify_mySQL_data_certification(course_data[0],sql_data,testdata)
if 'successfull' in message[0].lower() and len(all_payment_cta) == 0:
status = 'Success'
else:
status = 'Fail'
filename = 'Report.csv'
course_name = course_data[0]['course_name']
course_type = 'Certification Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,course_data[1][0],course_data[1][1],status]]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

if status == 'Fail':
pytest.fail("Status is Fail")
else:
message = "Enroll Now button is not Appearing"
logging.info(message)
filename = 'Report.csv'
course_name = self.pg_orders.course_name_in_url.get_text()
course_type = 'Certification Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,'','','CTA NOT AVAILABLE']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

except Exception as e:
counter = counter+1
logging.error("Exception occurred", exc_info=True)
filename = 'Report.csv'
course_name = 'NA'
course_type = 'Certification Program'
if course_data == None:
logging.info("If block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'','','','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 1:
logging.info("1st else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[0],'','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 2:
logging.info("2nd else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[1][1],course_data[1][0],'Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)


if counter != 0:
> pytest.fail('Failed')
E Failed: Failed

test_prod\test_orders_and_payment_flow.py:202: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/agile-and-scrum/agile-and-scrum-certification-training INFO  setup:orders_page.py:30 Country Set to: DE ERROR  setup:test_orders_and_payment_flow.py:177 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 119, in test_Orders_and_Payment_Flow_certification self.pg_orders.click_enroll_now_certification(url_value) File "C:\test_repos\pre_sales_test_python\pages_prod\orders_page.py", line 37, in click_enroll_now_certification self.common_button_enroll_now_certificaton.click_button() File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 173, in click_button self.click() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 80, in click self._execute(Command.CLICK_ELEMENT) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 633, in _execute return self._parent.execute(command, params) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webdriver.py", line 321, in execute self.error_handler.check_response(response) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\errorhandler.py", line 242, in check_response raise exception_class(message, screen, stacktrace) selenium.common.exceptions.ElementClickInterceptedException: Message: element click intercepted: Element <a class="btn">...</a> is not clickable at point (769, 349). Other element would receive the click: <iframe title="notification-frame-~5584baa3" name="notification-frame-~5584baa3" id="webklipper-publisher-widget-container-notification-frame" frameborder="0" marginheight="0" marginwidth="0" style="display: block; position: fixed; z-index: 16776272; left: -1000px; top: -1000px; visibility: visible; height: 100%; width: 100%; transform: translate(1000px, 1000px);" data-notification-layout-id="~184fc0b7" data-notification-layout-name="modal" class="gm-added gm-lazy"></iframe> (Session info: chrome=114.0.5735.135) INFO  setup:test_orders_and_payment_flow.py:182 If block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[Z] 68.88
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x0000024AB7034F40>
value = 'Z', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

@pytest.mark.test_details("0000","high","Order and Payment Flow","Pradeep")
@pytest.mark.parametrize("value", certification_program_course_read_csv())
def test_Orders_and_Payment_Flow_certification(self,value,initialize_pages,testdata):

'''
Objective: Make payment and validate the data in Dynamo db and mySql

Step 01: get url
Step 02: click on Enroll Now CTA
Step 03: Make payment
Step 04: Validate the Dynamo db and MySql daya for the payment
'''
url_count = self._count_url_txt_file_subdomain('Orders_and_Payment_Flow_Certification.txt')
logging.info(f"Total URL Present is: {url_count}")

# Step 01: get url
counter = 0
df = pd.read_csv('order_and_payment_certification_prod.csv', on_bad_lines='skip')
data = df[df['id']==value]
url_value = data['url'].values[0]
country_value = data['country'].values[0]
try:
pytest.driver.delete_all_cookies()
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_present(self.pg_orders.locators['common_button_enroll_now_certificaton'],10):
course_data = None
self.pg_orders.click_enroll_now_certification(url_value)
course_data = self._complete_payment(country_value,testdata['payment_type'],testdata['name'],testdata['email_id'],testdata['contact_no'])
logging.info(type(course_data))
time.sleep(5)

logging.info(f"course_data: {course_data}")

# Step 04: Validate the Dynamo db and MySql data for the payment
token_no = pytest.driver.current_url.split('authtoken=')[-1]
logging.info(f"Token No is: {token_no}")
query = f"""SELECT
emailId,contactNumber,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"name"', -1), '";', 1), '"', -1) AS name,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"training_type_txt"', -1), '";', 1), '"', -1) AS training_type_txt,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"display_total_price"', -1), '";', 1), '"', -1) AS display_total_price,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"price"', -1), '";', 1), '"', -1) AS price
FROM ssvc.cart where token = '{token_no}';"""

sql_data = db_helper.get_prod_data(query,testdata['db_type'])
logging.info(f"RAW SQL Data: {sql_data}\n")
# sql_items = self.convert_items_to_json(sql_data)
# logging.info(f"SQL DATA in JSON format: {sql_items}\n")

all_payment_cta = []
for i in course_data[1][1]:
a = (list(i.values())[0])
if 'failed' in list(i.values())[0].lower():
all_payment_cta.append('fail')


message = self.verify_mySQL_data_certification(course_data[0],sql_data,testdata)
if 'successfull' in message[0].lower() and len(all_payment_cta) == 0:
status = 'Success'
else:
status = 'Fail'
filename = 'Report.csv'
course_name = course_data[0]['course_name']
course_type = 'Certification Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,course_data[1][0],course_data[1][1],status]]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

if status == 'Fail':
pytest.fail("Status is Fail")
else:
message = "Enroll Now button is not Appearing"
logging.info(message)
filename = 'Report.csv'
course_name = self.pg_orders.course_name_in_url.get_text()
course_type = 'Certification Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,'','','CTA NOT AVAILABLE']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

except Exception as e:
counter = counter+1
logging.error("Exception occurred", exc_info=True)
filename = 'Report.csv'
course_name = 'NA'
course_type = 'Certification Program'
if course_data == None:
logging.info("If block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'','','','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 1:
logging.info("1st else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[0],'','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 2:
logging.info("2nd else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[1][1],course_data[1][0],'Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)


if counter != 0:
> pytest.fail('Failed')
E Failed: Failed

test_prod\test_orders_and_payment_flow.py:202: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/agile-and-scrum/agile-and-scrum-certification-training INFO  setup:orders_page.py:30 Country Set to: SG ERROR  setup:test_orders_and_payment_flow.py:177 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 119, in test_Orders_and_Payment_Flow_certification self.pg_orders.click_enroll_now_certification(url_value) File "C:\test_repos\pre_sales_test_python\pages_prod\orders_page.py", line 37, in click_enroll_now_certification self.common_button_enroll_now_certificaton.click_button() File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 173, in click_button self.click() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 80, in click self._execute(Command.CLICK_ELEMENT) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 633, in _execute return self._parent.execute(command, params) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webdriver.py", line 321, in execute self.error_handler.check_response(response) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\errorhandler.py", line 242, in check_response raise exception_class(message, screen, stacktrace) selenium.common.exceptions.ElementClickInterceptedException: Message: element click intercepted: Element <a class="btn">...</a> is not clickable at point (769, 349). Other element would receive the click: <iframe title="notification-frame-~5584baa3" name="notification-frame-~5584baa3" id="webklipper-publisher-widget-container-notification-frame" frameborder="0" marginheight="0" marginwidth="0" style="display: block; position: fixed; z-index: 16776272; left: -1000px; top: -1000px; visibility: visible; height: 100%; width: 100%; transform: translate(1000px, 1000px);" data-notification-layout-id="~184fc0b7" data-notification-layout-name="modal" class="gm-added gm-lazy"></iframe> (Session info: chrome=114.0.5735.135) INFO  setup:test_orders_and_payment_flow.py:182 If block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AE] 69.05
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x0000024AB703F340>
value = 'AE', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

@pytest.mark.test_details("0000","high","Order and Payment Flow","Pradeep")
@pytest.mark.parametrize("value", certification_program_course_read_csv())
def test_Orders_and_Payment_Flow_certification(self,value,initialize_pages,testdata):

'''
Objective: Make payment and validate the data in Dynamo db and mySql

Step 01: get url
Step 02: click on Enroll Now CTA
Step 03: Make payment
Step 04: Validate the Dynamo db and MySql daya for the payment
'''
url_count = self._count_url_txt_file_subdomain('Orders_and_Payment_Flow_Certification.txt')
logging.info(f"Total URL Present is: {url_count}")

# Step 01: get url
counter = 0
df = pd.read_csv('order_and_payment_certification_prod.csv', on_bad_lines='skip')
data = df[df['id']==value]
url_value = data['url'].values[0]
country_value = data['country'].values[0]
try:
pytest.driver.delete_all_cookies()
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_present(self.pg_orders.locators['common_button_enroll_now_certificaton'],10):
course_data = None
self.pg_orders.click_enroll_now_certification(url_value)
course_data = self._complete_payment(country_value,testdata['payment_type'],testdata['name'],testdata['email_id'],testdata['contact_no'])
logging.info(type(course_data))
time.sleep(5)

logging.info(f"course_data: {course_data}")

# Step 04: Validate the Dynamo db and MySql data for the payment
token_no = pytest.driver.current_url.split('authtoken=')[-1]
logging.info(f"Token No is: {token_no}")
query = f"""SELECT
emailId,contactNumber,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"name"', -1), '";', 1), '"', -1) AS name,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"training_type_txt"', -1), '";', 1), '"', -1) AS training_type_txt,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"display_total_price"', -1), '";', 1), '"', -1) AS display_total_price,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"price"', -1), '";', 1), '"', -1) AS price
FROM ssvc.cart where token = '{token_no}';"""

sql_data = db_helper.get_prod_data(query,testdata['db_type'])
logging.info(f"RAW SQL Data: {sql_data}\n")
# sql_items = self.convert_items_to_json(sql_data)
# logging.info(f"SQL DATA in JSON format: {sql_items}\n")

all_payment_cta = []
for i in course_data[1][1]:
a = (list(i.values())[0])
if 'failed' in list(i.values())[0].lower():
all_payment_cta.append('fail')


message = self.verify_mySQL_data_certification(course_data[0],sql_data,testdata)
if 'successfull' in message[0].lower() and len(all_payment_cta) == 0:
status = 'Success'
else:
status = 'Fail'
filename = 'Report.csv'
course_name = course_data[0]['course_name']
course_type = 'Certification Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,course_data[1][0],course_data[1][1],status]]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

if status == 'Fail':
pytest.fail("Status is Fail")
else:
message = "Enroll Now button is not Appearing"
logging.info(message)
filename = 'Report.csv'
course_name = self.pg_orders.course_name_in_url.get_text()
course_type = 'Certification Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,'','','CTA NOT AVAILABLE']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

except Exception as e:
counter = counter+1
logging.error("Exception occurred", exc_info=True)
filename = 'Report.csv'
course_name = 'NA'
course_type = 'Certification Program'
if course_data == None:
logging.info("If block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'','','','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 1:
logging.info("1st else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[0],'','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 2:
logging.info("2nd else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[1][1],course_data[1][0],'Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)


if counter != 0:
> pytest.fail('Failed')
E Failed: Failed

test_prod\test_orders_and_payment_flow.py:202: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/agile-and-scrum/agile-and-scrum-certification-training INFO  setup:orders_page.py:30 Country Set to: AE ERROR  setup:test_orders_and_payment_flow.py:177 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 119, in test_Orders_and_Payment_Flow_certification self.pg_orders.click_enroll_now_certification(url_value) File "C:\test_repos\pre_sales_test_python\pages_prod\orders_page.py", line 37, in click_enroll_now_certification self.common_button_enroll_now_certificaton.click_button() File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 173, in click_button self.click() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 80, in click self._execute(Command.CLICK_ELEMENT) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 633, in _execute return self._parent.execute(command, params) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webdriver.py", line 321, in execute self.error_handler.check_response(response) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\errorhandler.py", line 242, in check_response raise exception_class(message, screen, stacktrace) selenium.common.exceptions.ElementClickInterceptedException: Message: element click intercepted: Element <a class="btn">...</a> is not clickable at point (769, 349). Other element would receive the click: <iframe title="notification-frame-~5584baa3" name="notification-frame-~5584baa3" id="webklipper-publisher-widget-container-notification-frame" frameborder="0" marginheight="0" marginwidth="0" style="display: block; position: fixed; z-index: 16776272; left: -1000px; top: -1000px; visibility: visible; height: 100%; width: 100%; transform: translate(1000px, 1000px);" data-notification-layout-id="~184fc0b7" data-notification-layout-name="modal" class="gm-added gm-lazy"></iframe> (Session info: chrome=114.0.5735.135) INFO  setup:test_orders_and_payment_flow.py:182 If block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[A] 68.36
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowMastersProgram object at 0x0000024AB703FC70>, value = 'A'
initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

@pytest.mark.test_details("0001","high","Order and Payment Flow","Pradeep")
@pytest.mark.parametrize("value", master_program_course_read_csv())
def test_Orders_and_Payment_Flow_masters_program(self,value,initialize_pages,testdata):

'''
Objective: Make payment and validate the data in Dynamo db and mySql

Step 01: get url
Step 02: click on Enroll Now CTA
Step 03: Make payment
Step 04: Validate the Dynamo db and MySql daya for the payment
'''
# self.add_rows_in_csv('Report.csv') this step is commentd to make one CSV file
# self.add_rows_in_csv('Report.csv')
#url_count = self._count_url_txt_file_subdomain('Order_and_Payment_Flow_masters.txt')
#logging.info(f"Total URL Present is: {url_count}")

# Step 01: get url
counter = 0
df = pd.read_csv('order_and_payment_master_prod.csv', on_bad_lines='skip')
data = df[df['id']==value]
url_value = data['url'].values[0]
country_value = data['country'].values[0]
try:
pytest.driver.delete_all_cookies()
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_present(self.pg_orders.locators['btn_enroll_now_masters_program'],10):
course_data = None
self.pg_orders.click_enroll_now_for_masters(url_value)

course_data = self._complete_payment(country_value,testdata['payment_type'],testdata['name'],testdata['email_id'],testdata['contact_no'])
logging.info(type(course_data))
time.sleep(5)

logging.info(f"course_data: {course_data}")

# Step 04: Validate the Dynamo db and MySql data for the payment
token_no = pytest.driver.current_url.split('authtoken=')[-1]
logging.info(f"Token No is: {token_no}")
query = f"""SELECT
emailId,contactNumber,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"name"', -1), '";', 1), '"', -1) AS name,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"training_type_txt"', -1), '";', 1), '"', -1) AS training_type_txt,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"display_total_price"', -1), '";', 1), '"', -1) AS display_total_price,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"price"', -1), '";', 1), '"', -1) AS price
FROM ssvc.cart where token = '{token_no}';"""

sql_data = db_helper.get_prod_data(query,testdata['db_type'])
logging.info(f"RAW SQL Data: {sql_data}\n")
# sql_items = self.convert_items_to_json(sql_data)
# logging.info(f"SQL DATA in JSON format: {sql_items}\n")

all_payment_cta = []
for i in course_data[1][1]:
a = (list(i.values())[0])
if 'failed' in list(i.values())[0].lower():
all_payment_cta.append('fail')

message = self.verify_mySQL_data_masters_program(course_data[0],sql_data,testdata)
if 'successfull' in message[0].lower() and len(all_payment_cta) == 0:
status = 'Success'
else:
status = 'Fail'
filename = 'Report.csv'
course_name = course_data[0]['course_name']
course_type = 'Masters Program'
# course_type = sql_items['training_type_txt']
rows = [[country_value.upper(),course_name,course_type,url_value,message,course_data[1][0],course_data[1][1],status]]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

if status == 'Fail':
pytest.fail("Status is Fail")

else:
message = "Enroll Now button is not Appearing"
logging.info(message)
filename = 'Report.csv'
course_name = self.pg_orders.course_name_in_url.get_text()
course_type = 'Masters Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,'','','CTA NOT AVAILABLE']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

except Exception as e:
counter = counter+1
logging.error("Exception occurred", exc_info=True)
filename = 'Report.csv'
course_name = 'NA'
course_type = 'master Program'
if course_data == None:
logging.info("If block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'','','','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 1:
logging.info("1st else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[0],'','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 2:
logging.info("2nd else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[1][0],course_data[1][0],'Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)


if counter != 0:
> pytest.fail('Failed')
E Failed: Failed

test_prod\test_orders_and_payment_flow.py:537: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training INFO  setup:orders_page.py:30 Country Set to: IN ERROR  setup:test_orders_and_payment_flow.py:512 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 452, in test_Orders_and_Payment_Flow_masters_program self.pg_orders.click_enroll_now_for_masters(url_value) File "C:\test_repos\pre_sales_test_python\pages_prod\orders_page.py", line 158, in click_enroll_now_for_masters self.btn_enroll_now_masters_program.click_button() File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 173, in click_button self.click() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 80, in click self._execute(Command.CLICK_ELEMENT) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 633, in _execute return self._parent.execute(command, params) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webdriver.py", line 321, in execute self.error_handler.check_response(response) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\errorhandler.py", line 242, in check_response raise exception_class(message, screen, stacktrace) selenium.common.exceptions.ElementClickInterceptedException: Message: element click intercepted: Element <button class="btn white-btn">...</button> is not clickable at point (1064, 348). Other element would receive the click: <iframe title="notification-frame-~25142c04a" name="notification-frame-~25142c04a" id="webklipper-publisher-widget-container-notification-frame" frameborder="0" marginheight="0" marginwidth="0" style="display: block; position: fixed; z-index: 16776272; left: -1000px; top: -1000px; visibility: visible; height: 100%; width: 100%; transform: translate(1000px, 1000px);" data-notification-layout-id="~184fc0b7" data-notification-layout-name="modal" class="gm-added gm-lazy"></iframe> (Session info: chrome=114.0.5735.135) INFO  setup:test_orders_and_payment_flow.py:517 If block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[B] 68.15
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowMastersProgram object at 0x0000024AB703FD30>, value = 'B'
initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

@pytest.mark.test_details("0001","high","Order and Payment Flow","Pradeep")
@pytest.mark.parametrize("value", master_program_course_read_csv())
def test_Orders_and_Payment_Flow_masters_program(self,value,initialize_pages,testdata):

'''
Objective: Make payment and validate the data in Dynamo db and mySql

Step 01: get url
Step 02: click on Enroll Now CTA
Step 03: Make payment
Step 04: Validate the Dynamo db and MySql daya for the payment
'''
# self.add_rows_in_csv('Report.csv') this step is commentd to make one CSV file
# self.add_rows_in_csv('Report.csv')
#url_count = self._count_url_txt_file_subdomain('Order_and_Payment_Flow_masters.txt')
#logging.info(f"Total URL Present is: {url_count}")

# Step 01: get url
counter = 0
df = pd.read_csv('order_and_payment_master_prod.csv', on_bad_lines='skip')
data = df[df['id']==value]
url_value = data['url'].values[0]
country_value = data['country'].values[0]
try:
pytest.driver.delete_all_cookies()
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_present(self.pg_orders.locators['btn_enroll_now_masters_program'],10):
course_data = None
self.pg_orders.click_enroll_now_for_masters(url_value)

course_data = self._complete_payment(country_value,testdata['payment_type'],testdata['name'],testdata['email_id'],testdata['contact_no'])
logging.info(type(course_data))
time.sleep(5)

logging.info(f"course_data: {course_data}")

# Step 04: Validate the Dynamo db and MySql data for the payment
token_no = pytest.driver.current_url.split('authtoken=')[-1]
logging.info(f"Token No is: {token_no}")
query = f"""SELECT
emailId,contactNumber,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"name"', -1), '";', 1), '"', -1) AS name,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"training_type_txt"', -1), '";', 1), '"', -1) AS training_type_txt,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"display_total_price"', -1), '";', 1), '"', -1) AS display_total_price,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"price"', -1), '";', 1), '"', -1) AS price
FROM ssvc.cart where token = '{token_no}';"""

sql_data = db_helper.get_prod_data(query,testdata['db_type'])
logging.info(f"RAW SQL Data: {sql_data}\n")
# sql_items = self.convert_items_to_json(sql_data)
# logging.info(f"SQL DATA in JSON format: {sql_items}\n")

all_payment_cta = []
for i in course_data[1][1]:
a = (list(i.values())[0])
if 'failed' in list(i.values())[0].lower():
all_payment_cta.append('fail')

message = self.verify_mySQL_data_masters_program(course_data[0],sql_data,testdata)
if 'successfull' in message[0].lower() and len(all_payment_cta) == 0:
status = 'Success'
else:
status = 'Fail'
filename = 'Report.csv'
course_name = course_data[0]['course_name']
course_type = 'Masters Program'
# course_type = sql_items['training_type_txt']
rows = [[country_value.upper(),course_name,course_type,url_value,message,course_data[1][0],course_data[1][1],status]]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

if status == 'Fail':
pytest.fail("Status is Fail")

else:
message = "Enroll Now button is not Appearing"
logging.info(message)
filename = 'Report.csv'
course_name = self.pg_orders.course_name_in_url.get_text()
course_type = 'Masters Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,'','','CTA NOT AVAILABLE']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

except Exception as e:
counter = counter+1
logging.error("Exception occurred", exc_info=True)
filename = 'Report.csv'
course_name = 'NA'
course_type = 'master Program'
if course_data == None:
logging.info("If block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'','','','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 1:
logging.info("1st else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[0],'','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 2:
logging.info("2nd else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[1][0],course_data[1][0],'Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)


if counter != 0:
> pytest.fail('Failed')
E Failed: Failed

test_prod\test_orders_and_payment_flow.py:537: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/automation-testing-masters-program-certification-training-course INFO  setup:orders_page.py:30 Country Set to: IN ERROR  setup:test_orders_and_payment_flow.py:512 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 452, in test_Orders_and_Payment_Flow_masters_program self.pg_orders.click_enroll_now_for_masters(url_value) File "C:\test_repos\pre_sales_test_python\pages_prod\orders_page.py", line 158, in click_enroll_now_for_masters self.btn_enroll_now_masters_program.click_button() File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 173, in click_button self.click() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 80, in click self._execute(Command.CLICK_ELEMENT) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 633, in _execute return self._parent.execute(command, params) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webdriver.py", line 321, in execute self.error_handler.check_response(response) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\errorhandler.py", line 242, in check_response raise exception_class(message, screen, stacktrace) selenium.common.exceptions.ElementClickInterceptedException: Message: element click intercepted: Element <button class="btn white-btn">...</button> is not clickable at point (1064, 348). Other element would receive the click: <iframe title="notification-frame-~25142c04a" name="notification-frame-~25142c04a" id="webklipper-publisher-widget-container-notification-frame" frameborder="0" marginheight="0" marginwidth="0" style="display: block; position: fixed; z-index: 16776272; left: -1000px; top: -1000px; visibility: visible; height: 100%; width: 100%; transform: translate(1000px, 1000px);" data-notification-layout-id="~184fc0b7" data-notification-layout-name="modal" data-gtm-yt-inspected-6="true" data-gtm-yt-inspected-481802_1062="true" class="gm-added gm-lazy"></iframe> (Session info: chrome=114.0.5735.135) INFO  setup:test_orders_and_payment_flow.py:517 If block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[C] 67.84
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowMastersProgram object at 0x0000024AB703FDF0>, value = 'C'
initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

@pytest.mark.test_details("0001","high","Order and Payment Flow","Pradeep")
@pytest.mark.parametrize("value", master_program_course_read_csv())
def test_Orders_and_Payment_Flow_masters_program(self,value,initialize_pages,testdata):

'''
Objective: Make payment and validate the data in Dynamo db and mySql

Step 01: get url
Step 02: click on Enroll Now CTA
Step 03: Make payment
Step 04: Validate the Dynamo db and MySql daya for the payment
'''
# self.add_rows_in_csv('Report.csv') this step is commentd to make one CSV file
# self.add_rows_in_csv('Report.csv')
#url_count = self._count_url_txt_file_subdomain('Order_and_Payment_Flow_masters.txt')
#logging.info(f"Total URL Present is: {url_count}")

# Step 01: get url
counter = 0
df = pd.read_csv('order_and_payment_master_prod.csv', on_bad_lines='skip')
data = df[df['id']==value]
url_value = data['url'].values[0]
country_value = data['country'].values[0]
try:
pytest.driver.delete_all_cookies()
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_present(self.pg_orders.locators['btn_enroll_now_masters_program'],10):
course_data = None
self.pg_orders.click_enroll_now_for_masters(url_value)

course_data = self._complete_payment(country_value,testdata['payment_type'],testdata['name'],testdata['email_id'],testdata['contact_no'])
logging.info(type(course_data))
time.sleep(5)

logging.info(f"course_data: {course_data}")

# Step 04: Validate the Dynamo db and MySql data for the payment
token_no = pytest.driver.current_url.split('authtoken=')[-1]
logging.info(f"Token No is: {token_no}")
query = f"""SELECT
emailId,contactNumber,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"name"', -1), '";', 1), '"', -1) AS name,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"training_type_txt"', -1), '";', 1), '"', -1) AS training_type_txt,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"display_total_price"', -1), '";', 1), '"', -1) AS display_total_price,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"price"', -1), '";', 1), '"', -1) AS price
FROM ssvc.cart where token = '{token_no}';"""

sql_data = db_helper.get_prod_data(query,testdata['db_type'])
logging.info(f"RAW SQL Data: {sql_data}\n")
# sql_items = self.convert_items_to_json(sql_data)
# logging.info(f"SQL DATA in JSON format: {sql_items}\n")

all_payment_cta = []
for i in course_data[1][1]:
a = (list(i.values())[0])
if 'failed' in list(i.values())[0].lower():
all_payment_cta.append('fail')

message = self.verify_mySQL_data_masters_program(course_data[0],sql_data,testdata)
if 'successfull' in message[0].lower() and len(all_payment_cta) == 0:
status = 'Success'
else:
status = 'Fail'
filename = 'Report.csv'
course_name = course_data[0]['course_name']
course_type = 'Masters Program'
# course_type = sql_items['training_type_txt']
rows = [[country_value.upper(),course_name,course_type,url_value,message,course_data[1][0],course_data[1][1],status]]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

if status == 'Fail':
pytest.fail("Status is Fail")

else:
message = "Enroll Now button is not Appearing"
logging.info(message)
filename = 'Report.csv'
course_name = self.pg_orders.course_name_in_url.get_text()
course_type = 'Masters Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,'','','CTA NOT AVAILABLE']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

except Exception as e:
counter = counter+1
logging.error("Exception occurred", exc_info=True)
filename = 'Report.csv'
course_name = 'NA'
course_type = 'master Program'
if course_data == None:
logging.info("If block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'','','','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 1:
logging.info("1st else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[0],'','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 2:
logging.info("2nd else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[1][0],course_data[1][0],'Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)


if counter != 0:
> pytest.fail('Failed')
E Failed: Failed

test_prod\test_orders_and_payment_flow.py:537: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/ui-ux-design-masters-program-certification-course INFO  setup:orders_page.py:30 Country Set to: IN ERROR  setup:test_orders_and_payment_flow.py:512 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 452, in test_Orders_and_Payment_Flow_masters_program self.pg_orders.click_enroll_now_for_masters(url_value) File "C:\test_repos\pre_sales_test_python\pages_prod\orders_page.py", line 158, in click_enroll_now_for_masters self.btn_enroll_now_masters_program.click_button() File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 173, in click_button self.click() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 80, in click self._execute(Command.CLICK_ELEMENT) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 633, in _execute return self._parent.execute(command, params) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webdriver.py", line 321, in execute self.error_handler.check_response(response) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\errorhandler.py", line 242, in check_response raise exception_class(message, screen, stacktrace) selenium.common.exceptions.ElementClickInterceptedException: Message: element click intercepted: Element <button class="btn white-btn">...</button> is not clickable at point (1064, 348). Other element would receive the click: <iframe title="notification-frame-~25142c04a" name="notification-frame-~25142c04a" id="webklipper-publisher-widget-container-notification-frame" frameborder="0" marginheight="0" marginwidth="0" style="display: block; position: fixed; z-index: 16776272; left: -1000px; top: -1000px; visibility: visible; height: 100%; width: 100%; transform: translate(1000px, 1000px);" data-notification-layout-id="~184fc0b7" data-notification-layout-name="modal" class="gm-added gm-lazy"></iframe> (Session info: chrome=114.0.5735.135) INFO  setup:test_orders_and_payment_flow.py:517 If block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[E] 68.04
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowMastersProgram object at 0x0000024AB703FF70>, value = 'E'
initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

@pytest.mark.test_details("0001","high","Order and Payment Flow","Pradeep")
@pytest.mark.parametrize("value", master_program_course_read_csv())
def test_Orders_and_Payment_Flow_masters_program(self,value,initialize_pages,testdata):

'''
Objective: Make payment and validate the data in Dynamo db and mySql

Step 01: get url
Step 02: click on Enroll Now CTA
Step 03: Make payment
Step 04: Validate the Dynamo db and MySql daya for the payment
'''
# self.add_rows_in_csv('Report.csv') this step is commentd to make one CSV file
# self.add_rows_in_csv('Report.csv')
#url_count = self._count_url_txt_file_subdomain('Order_and_Payment_Flow_masters.txt')
#logging.info(f"Total URL Present is: {url_count}")

# Step 01: get url
counter = 0
df = pd.read_csv('order_and_payment_master_prod.csv', on_bad_lines='skip')
data = df[df['id']==value]
url_value = data['url'].values[0]
country_value = data['country'].values[0]
try:
pytest.driver.delete_all_cookies()
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_present(self.pg_orders.locators['btn_enroll_now_masters_program'],10):
course_data = None
self.pg_orders.click_enroll_now_for_masters(url_value)

course_data = self._complete_payment(country_value,testdata['payment_type'],testdata['name'],testdata['email_id'],testdata['contact_no'])
logging.info(type(course_data))
time.sleep(5)

logging.info(f"course_data: {course_data}")

# Step 04: Validate the Dynamo db and MySql data for the payment
token_no = pytest.driver.current_url.split('authtoken=')[-1]
logging.info(f"Token No is: {token_no}")
query = f"""SELECT
emailId,contactNumber,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"name"', -1), '";', 1), '"', -1) AS name,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"training_type_txt"', -1), '";', 1), '"', -1) AS training_type_txt,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"display_total_price"', -1), '";', 1), '"', -1) AS display_total_price,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"price"', -1), '";', 1), '"', -1) AS price
FROM ssvc.cart where token = '{token_no}';"""

sql_data = db_helper.get_prod_data(query,testdata['db_type'])
logging.info(f"RAW SQL Data: {sql_data}\n")
# sql_items = self.convert_items_to_json(sql_data)
# logging.info(f"SQL DATA in JSON format: {sql_items}\n")

all_payment_cta = []
for i in course_data[1][1]:
a = (list(i.values())[0])
if 'failed' in list(i.values())[0].lower():
all_payment_cta.append('fail')

message = self.verify_mySQL_data_masters_program(course_data[0],sql_data,testdata)
if 'successfull' in message[0].lower() and len(all_payment_cta) == 0:
status = 'Success'
else:
status = 'Fail'
filename = 'Report.csv'
course_name = course_data[0]['course_name']
course_type = 'Masters Program'
# course_type = sql_items['training_type_txt']
rows = [[country_value.upper(),course_name,course_type,url_value,message,course_data[1][0],course_data[1][1],status]]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

if status == 'Fail':
pytest.fail("Status is Fail")

else:
message = "Enroll Now button is not Appearing"
logging.info(message)
filename = 'Report.csv'
course_name = self.pg_orders.course_name_in_url.get_text()
course_type = 'Masters Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,'','','CTA NOT AVAILABLE']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

except Exception as e:
counter = counter+1
logging.error("Exception occurred", exc_info=True)
filename = 'Report.csv'
course_name = 'NA'
course_type = 'master Program'
if course_data == None:
logging.info("If block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'','','','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 1:
logging.info("1st else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[0],'','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 2:
logging.info("2nd else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[1][0],course_data[1][0],'Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)


if counter != 0:
> pytest.fail('Failed')
E Failed: Failed

test_prod\test_orders_and_payment_flow.py:537: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training INFO  setup:orders_page.py:30 Country Set to: US ERROR  setup:test_orders_and_payment_flow.py:512 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 452, in test_Orders_and_Payment_Flow_masters_program self.pg_orders.click_enroll_now_for_masters(url_value) File "C:\test_repos\pre_sales_test_python\pages_prod\orders_page.py", line 158, in click_enroll_now_for_masters self.btn_enroll_now_masters_program.click_button() File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 173, in click_button self.click() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 80, in click self._execute(Command.CLICK_ELEMENT) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 633, in _execute return self._parent.execute(command, params) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webdriver.py", line 321, in execute self.error_handler.check_response(response) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\errorhandler.py", line 242, in check_response raise exception_class(message, screen, stacktrace) selenium.common.exceptions.ElementClickInterceptedException: Message: element click intercepted: Element <button class="btn white-btn">...</button> is not clickable at point (1064, 348). Other element would receive the click: <iframe title="notification-frame-~25142c04a" name="notification-frame-~25142c04a" id="webklipper-publisher-widget-container-notification-frame" frameborder="0" marginheight="0" marginwidth="0" style="display: block; position: fixed; z-index: 16776272; left: -1000px; top: -1000px; visibility: visible; height: 100%; width: 100%; transform: translate(1000px, 1000px);" data-notification-layout-id="~184fc0b7" data-notification-layout-name="modal" class="gm-added gm-lazy"></iframe> (Session info: chrome=114.0.5735.135) INFO  setup:test_orders_and_payment_flow.py:517 If block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[F] 67.94
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowMastersProgram object at 0x0000024AB704F070>, value = 'F'
initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

@pytest.mark.test_details("0001","high","Order and Payment Flow","Pradeep")
@pytest.mark.parametrize("value", master_program_course_read_csv())
def test_Orders_and_Payment_Flow_masters_program(self,value,initialize_pages,testdata):

'''
Objective: Make payment and validate the data in Dynamo db and mySql

Step 01: get url
Step 02: click on Enroll Now CTA
Step 03: Make payment
Step 04: Validate the Dynamo db and MySql daya for the payment
'''
# self.add_rows_in_csv('Report.csv') this step is commentd to make one CSV file
# self.add_rows_in_csv('Report.csv')
#url_count = self._count_url_txt_file_subdomain('Order_and_Payment_Flow_masters.txt')
#logging.info(f"Total URL Present is: {url_count}")

# Step 01: get url
counter = 0
df = pd.read_csv('order_and_payment_master_prod.csv', on_bad_lines='skip')
data = df[df['id']==value]
url_value = data['url'].values[0]
country_value = data['country'].values[0]
try:
pytest.driver.delete_all_cookies()
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_present(self.pg_orders.locators['btn_enroll_now_masters_program'],10):
course_data = None
self.pg_orders.click_enroll_now_for_masters(url_value)

course_data = self._complete_payment(country_value,testdata['payment_type'],testdata['name'],testdata['email_id'],testdata['contact_no'])
logging.info(type(course_data))
time.sleep(5)

logging.info(f"course_data: {course_data}")

# Step 04: Validate the Dynamo db and MySql data for the payment
token_no = pytest.driver.current_url.split('authtoken=')[-1]
logging.info(f"Token No is: {token_no}")
query = f"""SELECT
emailId,contactNumber,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"name"', -1), '";', 1), '"', -1) AS name,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"training_type_txt"', -1), '";', 1), '"', -1) AS training_type_txt,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"display_total_price"', -1), '";', 1), '"', -1) AS display_total_price,
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(items, '"price"', -1), '";', 1), '"', -1) AS price
FROM ssvc.cart where token = '{token_no}';"""

sql_data = db_helper.get_prod_data(query,testdata['db_type'])
logging.info(f"RAW SQL Data: {sql_data}\n")
# sql_items = self.convert_items_to_json(sql_data)
# logging.info(f"SQL DATA in JSON format: {sql_items}\n")

all_payment_cta = []
for i in course_data[1][1]:
a = (list(i.values())[0])
if 'failed' in list(i.values())[0].lower():
all_payment_cta.append('fail')

message = self.verify_mySQL_data_masters_program(course_data[0],sql_data,testdata)
if 'successfull' in message[0].lower() and len(all_payment_cta) == 0:
status = 'Success'
else:
status = 'Fail'
filename = 'Report.csv'
course_name = course_data[0]['course_name']
course_type = 'Masters Program'
# course_type = sql_items['training_type_txt']
rows = [[country_value.upper(),course_name,course_type,url_value,message,course_data[1][0],course_data[1][1],status]]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

if status == 'Fail':
pytest.fail("Status is Fail")

else:
message = "Enroll Now button is not Appearing"
logging.info(message)
filename = 'Report.csv'
course_name = self.pg_orders.course_name_in_url.get_text()
course_type = 'Masters Program'
rows = [[country_value.upper(),course_name,course_type,url_value,message,'','','CTA NOT AVAILABLE']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)

except Exception as e:
counter = counter+1
logging.error("Exception occurred", exc_info=True)
filename = 'Report.csv'
course_name = 'NA'
course_type = 'master Program'
if course_data == None:
logging.info("If block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'','','','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 1:
logging.info("1st else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[0],'','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len(course_data) == 2:
logging.info("2nd else block in Exception")
rows = [[country_value.upper(),course_name,course_type,url_value,'',course_data[1][0],course_data[1][0],'Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)


if counter != 0:
> pytest.fail('Failed')
E Failed: Failed

test_prod\test_orders_and_payment_flow.py:537: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/automation-testing-masters-program-certification-training-course INFO  setup:orders_page.py:30 Country Set to: US ERROR  setup:test_orders_and_payment_flow.py:512 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 452, in test_Orders_and_Payment_Flow_masters_program self.pg_orders.click_enroll_now_for_masters(url_value) File "C:\test_repos\pre_sales_test_python\pages_prod\orders_page.py", line 158, in click_enroll_now_for_masters self.btn_enroll_now_masters_program.click_button() File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 173, in click_button self.click() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 80, in click self._execute(Command.CLICK_ELEMENT) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 633, in _execute return self._parent.execute(command, params) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webdriver.py", line 321, in execute self.error_handler.check_response(response) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\errorhandler.py", line 242, in check_response raise exception_class(message, screen, stacktrace) selenium.common.exceptions.ElementClickInterceptedException: Message: element click intercepted: Element <button class="btn white-btn">...</button> is not clickable at point (1064, 348). Other element would receive the click: <iframe title="notification-frame-~25142c04a" name="notification-frame-~25142c04a" id="webklipper-publisher-widget-container-notification-frame" frameborder="0" marginheight="0" marginwidth="0" style="display: block; position: fixed; z-index: 16776272; left: -1000px; top: -1000px; visibility: visible; height: 100%; width: 100%; transform: translate(1000px, 1000px);" data-notification-layout-id="~184fc0b7" data-notification-layout-name="modal" data-gtm-yt-inspected-6="true" data-gtm-yt-inspected-481802_1062="true" class="gm-added gm-lazy"></iframe> (Session info: chrome=114.0.5735.135) INFO  setup:test_orders_and_payment_flow.py:517 If block in Exception
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[B] 36.78
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: IN INFO  setup:test_orders_and_payment_flow.py:166 Enroll Now button is not Appearing
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[C] 66.05
------------------------------Captured stderr call------------------------------
--- Logging error --- Traceback (most recent call last): File "c:\users\qateam\appdata\local\programs\python\python38\lib\logging\__init__.py", line 1084, in emit stream.write(msg + self.terminator) File "c:\users\qateam\appdata\local\programs\python\python38\lib\encodings\cp1252.py", line 19, in encode return codecs.charmap_encode(input,self.errors,encoding_table)[0] UnicodeEncodeError: 'charmap' codec can't encode character '\u20b9' in position 128: character maps to <undefined> Call stack: File "c:\users\qateam\appdata\local\programs\python\python38\lib\runpy.py", line 194, in _run_module_as_main return _run_code(code, main_globals, None, File "c:\users\qateam\appdata\local\programs\python\python38\lib\runpy.py", line 87, in _run_code exec(code, run_globals) File "C:\Users\qateam\AppData\Local\Programs\Python\Python38\Scripts\pytest.exe\__main__.py", line 7, in <module> sys.exit(console_main()) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\config\__init__.py", line 190, in console_main code = main() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\config\__init__.py", line 167, in main ret: Union[ExitCode, int] = config.hook.pytest_cmdline_main( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 317, in pytest_cmdline_main return wrap_session(config, _main) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 270, in wrap_session session.exitstatus = doit(config, session) or 0 File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 324, in _main config.hook.pytest_runtestloop(session=session) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 349, in pytest_runtestloop item.config.hook.pytest_runtest_protocol(item=item, nextitem=nextitem) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 112, in pytest_runtest_protocol runtestprotocol(item, nextitem=nextitem) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 131, in runtestprotocol reports.append(call_and_report(item, "call", log)) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 220, in call_and_report call = call_runtest_hook(item, when, **kwds) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 259, in call_runtest_hook return CallInfo.from_call( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 339, in from_call result: Optional[TResult] = func() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 260, in <lambda> lambda: ihook(item=item, **kwds), when=when, reraise=reraise File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 167, in pytest_runtest_call item.runtest() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\python.py", line 1789, in runtest self.ihook.pytest_pyfunc_call(pyfuncitem=self) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\python.py", line 195, in pytest_pyfunc_call result = testfunction(**testargs) File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 124, in test_Orders_and_Payment_Flow_certification logging.info(f"course_data: {course_data}") Message: "course_data: ({'course_name': 'CISA®', 'course_type': 'Online Bootcamp', 'base_price': '₹ 174,195.00', 'final_price': '205,550.10'}, (['Credit Card', 'Debit Card', 'Net Banking', 'UPI', 'EMI', 'ShopSe EMI', 'CCAvenue'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'debitcard': 'All option clickable and Payment CTA appearing '}, {'net_banking': 'All option clickable and Payment CTA appearing '}, {'UPI': 'All option clickable and Payment CTA appearing '}, {'EMI': 'All option clickable and Payment CTA appearing '}, {'CCAvenue': 'All option clickable and Payment CTA appearing '}, {'ShopSE EMI': 'All option clickable and Payment CTA appearing '}]))" Arguments: ()
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/cyber-security/cisa-certification-training INFO  setup:orders_page.py:30 Country Set to: IN INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:345 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'CISA®', 'course_type': 'Online Bootcamp', 'base_price': '₹ 174,195.00', 'final_price': '205,550.10'}, (['Credit Card', 'Debit Card', 'Net Banking', 'UPI', 'EMI', 'ShopSe EMI', 'CCAvenue'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'debitcard': 'All option clickable and Payment CTA appearing '}, {'net_banking': 'All option clickable and Payment CTA appearing '}, {'UPI': 'All option clickable and Payment CTA appearing '}, {'EMI': 'All option clickable and Payment CTA appearing '}, {'CCAvenue': 'All option clickable and Payment CTA appearing '}, {'ShopSE EMI': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: d2427cccbf861cdb58f4084e48c61f1d25d0d8900b43a35e0650f65a555cccf5 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+91-123456789', 'name': 'CISA<sup>®</sup> Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '174,195.00', 'price': '205550.10'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[D] 66.10
------------------------------Captured stderr call------------------------------
--- Logging error --- Traceback (most recent call last): File "c:\users\qateam\appdata\local\programs\python\python38\lib\logging\__init__.py", line 1084, in emit stream.write(msg + self.terminator) File "c:\users\qateam\appdata\local\programs\python\python38\lib\encodings\cp1252.py", line 19, in encode return codecs.charmap_encode(input,self.errors,encoding_table)[0] UnicodeEncodeError: 'charmap' codec can't encode character '\u20b9' in position 134: character maps to <undefined> Call stack: File "c:\users\qateam\appdata\local\programs\python\python38\lib\runpy.py", line 194, in _run_module_as_main return _run_code(code, main_globals, None, File "c:\users\qateam\appdata\local\programs\python\python38\lib\runpy.py", line 87, in _run_code exec(code, run_globals) File "C:\Users\qateam\AppData\Local\Programs\Python\Python38\Scripts\pytest.exe\__main__.py", line 7, in <module> sys.exit(console_main()) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\config\__init__.py", line 190, in console_main code = main() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\config\__init__.py", line 167, in main ret: Union[ExitCode, int] = config.hook.pytest_cmdline_main( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 317, in pytest_cmdline_main return wrap_session(config, _main) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 270, in wrap_session session.exitstatus = doit(config, session) or 0 File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 324, in _main config.hook.pytest_runtestloop(session=session) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 349, in pytest_runtestloop item.config.hook.pytest_runtest_protocol(item=item, nextitem=nextitem) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 112, in pytest_runtest_protocol runtestprotocol(item, nextitem=nextitem) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 131, in runtestprotocol reports.append(call_and_report(item, "call", log)) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 220, in call_and_report call = call_runtest_hook(item, when, **kwds) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 259, in call_runtest_hook return CallInfo.from_call( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 339, in from_call result: Optional[TResult] = func() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 260, in <lambda> lambda: ihook(item=item, **kwds), when=when, reraise=reraise File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 167, in pytest_runtest_call item.runtest() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\python.py", line 1789, in runtest self.ihook.pytest_pyfunc_call(pyfuncitem=self) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\python.py", line 195, in pytest_pyfunc_call result = testfunction(**testargs) File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 124, in test_Orders_and_Payment_Flow_certification logging.info(f"course_data: {course_data}") Message: "course_data: ({'course_name': 'CISSP®', 'course_type': 'Online Self Learning', 'base_price': '₹ 168,525.00', 'final_price': '198,859.50'}, (['Credit Card', 'Debit Card', 'Net Banking', 'UPI', 'EMI', 'ShopSe EMI', 'CCAvenue'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'debitcard': 'All option clickable and Payment CTA appearing '}, {'net_banking': 'All option clickable and Payment CTA appearing '}, {'UPI': 'All option clickable and Payment CTA appearing '}, {'EMI': 'All option clickable and Payment CTA appearing '}, {'CCAvenue': 'All option clickable and Payment CTA appearing '}, {'ShopSE EMI': 'All option clickable and Payment CTA appearing '}]))" Arguments: ()
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/cyber-security/cissp-certification-training INFO  setup:orders_page.py:30 Country Set to: IN INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:345 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'CISSP®', 'course_type': 'Online Self Learning', 'base_price': '₹ 168,525.00', 'final_price': '198,859.50'}, (['Credit Card', 'Debit Card', 'Net Banking', 'UPI', 'EMI', 'ShopSe EMI', 'CCAvenue'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'debitcard': 'All option clickable and Payment CTA appearing '}, {'net_banking': 'All option clickable and Payment CTA appearing '}, {'UPI': 'All option clickable and Payment CTA appearing '}, {'EMI': 'All option clickable and Payment CTA appearing '}, {'CCAvenue': 'All option clickable and Payment CTA appearing '}, {'ShopSE EMI': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: 996452e9ea4c856b3ac0517e84bda514abde81d6606750f95ff5f486e6fb3c67 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+91-123456789', 'name': 'CISSP<sup>®</sup> Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '168,525.00', 'price': '198859.50'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[E] 66.74
------------------------------Captured stderr call------------------------------
--- Logging error --- Traceback (most recent call last): File "c:\users\qateam\appdata\local\programs\python\python38\lib\logging\__init__.py", line 1084, in emit stream.write(msg + self.terminator) File "c:\users\qateam\appdata\local\programs\python\python38\lib\encodings\cp1252.py", line 19, in encode return codecs.charmap_encode(input,self.errors,encoding_table)[0] UnicodeEncodeError: 'charmap' codec can't encode character '\u20b9' in position 163: character maps to <undefined> Call stack: File "c:\users\qateam\appdata\local\programs\python\python38\lib\runpy.py", line 194, in _run_module_as_main return _run_code(code, main_globals, None, File "c:\users\qateam\appdata\local\programs\python\python38\lib\runpy.py", line 87, in _run_code exec(code, run_globals) File "C:\Users\qateam\AppData\Local\Programs\Python\Python38\Scripts\pytest.exe\__main__.py", line 7, in <module> sys.exit(console_main()) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\config\__init__.py", line 190, in console_main code = main() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\config\__init__.py", line 167, in main ret: Union[ExitCode, int] = config.hook.pytest_cmdline_main( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 317, in pytest_cmdline_main return wrap_session(config, _main) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 270, in wrap_session session.exitstatus = doit(config, session) or 0 File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 324, in _main config.hook.pytest_runtestloop(session=session) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 349, in pytest_runtestloop item.config.hook.pytest_runtest_protocol(item=item, nextitem=nextitem) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 112, in pytest_runtest_protocol runtestprotocol(item, nextitem=nextitem) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 131, in runtestprotocol reports.append(call_and_report(item, "call", log)) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 220, in call_and_report call = call_runtest_hook(item, when, **kwds) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 259, in call_runtest_hook return CallInfo.from_call( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 339, in from_call result: Optional[TResult] = func() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 260, in <lambda> lambda: ihook(item=item, **kwds), when=when, reraise=reraise File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 167, in pytest_runtest_call item.runtest() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\python.py", line 1789, in runtest self.ihook.pytest_pyfunc_call(pyfuncitem=self) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\python.py", line 195, in pytest_pyfunc_call result = testfunction(**testargs) File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 124, in test_Orders_and_Payment_Flow_certification logging.info(f"course_data: {course_data}") Message: "course_data: ({'course_name': 'Big Data Hadoop and Spark Developer', 'course_type': 'Online Self Learning', 'base_price': '₹ 21,420.00', 'final_price': '25,275.60'}, (['Credit Card', 'Debit Card', 'Net Banking', 'UPI', 'EMI', 'ShopSe EMI', 'CCAvenue'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'debitcard': 'All option clickable and Payment CTA appearing '}, {'net_banking': 'All option clickable and Payment CTA appearing '}, {'UPI': 'All option clickable and Payment CTA appearing '}, {'EMI': 'All option clickable and Payment CTA appearing '}, {'CCAvenue': 'All option clickable and Payment CTA appearing '}, {'ShopSE EMI': 'All option clickable and Payment CTA appearing '}]))" Arguments: ()
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/big-data-and-analytics/big-data-and-hadoop-training INFO  setup:orders_page.py:30 Country Set to: IN INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:345 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'Big Data Hadoop and Spark Developer', 'course_type': 'Online Self Learning', 'base_price': '₹ 21,420.00', 'final_price': '25,275.60'}, (['Credit Card', 'Debit Card', 'Net Banking', 'UPI', 'EMI', 'ShopSe EMI', 'CCAvenue'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'debitcard': 'All option clickable and Payment CTA appearing '}, {'net_banking': 'All option clickable and Payment CTA appearing '}, {'UPI': 'All option clickable and Payment CTA appearing '}, {'EMI': 'All option clickable and Payment CTA appearing '}, {'CCAvenue': 'All option clickable and Payment CTA appearing '}, {'ShopSE EMI': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: c56fca7c90789776011a5116e9ca091e5fb943a8673580d8b5fb9294532f63c3 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+91-123456789', 'name': 'Big Data Hadoop and Spark Developer Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '21,420.00', 'price': '25275.60'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[G] 38.08
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: US INFO  setup:test_orders_and_payment_flow.py:166 Enroll Now button is not Appearing
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[H] 70.06
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/cyber-security/cisa-certification-training INFO  setup:orders_page.py:30 Country Set to: US INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'CISA®', 'course_type': 'Online Bootcamp', 'base_price': '$ 2,299.00', 'final_price': '2,299.00'}, (['Credit Card', 'PayPal', 'Affirm', 'Klarna'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'Affirm': 'All option clickable and Payment CTA appearing '}, {'klarna': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: 4c7e77ad96f9167bf758e1b999e15446dca1463729c3096ba7afe8c83a15805b INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+91-123456789', 'name': 'CISA<sup>®</sup> Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '2,299.00', 'price': '2299.00'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[I] 72.25
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/cyber-security/cissp-certification-training INFO  setup:orders_page.py:30 Country Set to: US INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'CISSP®', 'course_type': 'Online Self Learning', 'base_price': '$ 2,200.00', 'final_price': '2,200.00'}, (['Credit Card', 'PayPal', 'Klarna'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'klarna': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: 316b45dd4b50d46b12f7fc17bc30981c94b0884b0c232b58d1590fabdfc255e9 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+1-123456789', 'name': 'CISSP<sup>®</sup> Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '2,200.00', 'price': '2200.00'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[J] 72.43
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/big-data-and-analytics/big-data-and-hadoop-training INFO  setup:orders_page.py:30 Country Set to: US INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'Big Data Hadoop and Spark Developer', 'course_type': 'Online Self Learning', 'base_price': '$ 899.00', 'final_price': '899.00'}, (['Credit Card', 'PayPal', 'Klarna'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'klarna': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: 2ce10525b68321b8d195213bc97cc1489be8af0fe92e04d1d9c6311c11e77727 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+1-123456789', 'name': 'Big Data Hadoop and Spark Developer Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '899.00', 'price': '899.00'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[L] 37.54
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: GB INFO  setup:test_orders_and_payment_flow.py:166 Enroll Now button is not Appearing
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[M] 103.38
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/cyber-security/cisa-certification-training INFO  setup:orders_page.py:30 Country Set to: GB INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'CISA®', 'course_type': 'Online Bootcamp', 'base_price': '£ 2,799.00', 'final_price': '2,799.00'}, (['Credit Card', 'PayPal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: fee01ecd65bab82979f1bcac234eebae65e61fdbd07ff9fc03a0cadce31076bc INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789', 'name': 'CISA<sup>®</sup> Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '2,799.00', 'price': '2799.00'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[N] 102.36
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/cyber-security/cissp-certification-training INFO  setup:orders_page.py:30 Country Set to: GB INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'CISSP®', 'course_type': 'Online Self Learning', 'base_price': '£ 2,099.00', 'final_price': '2,099.00'}, (['Credit Card', 'PayPal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: 9747a78dea2dff47836ade81248d353a65ae3d623ef89e3012df8d08d8f03168 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789', 'name': 'CISSP<sup>®</sup> Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '2,099.00', 'price': '2099.00'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[O] 102.66
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/big-data-and-analytics/big-data-and-hadoop-training INFO  setup:orders_page.py:30 Country Set to: GB INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'Big Data Hadoop and Spark Developer', 'course_type': 'Online Self Learning', 'base_price': '£ 969.00', 'final_price': '969.00'}, (['Credit Card', 'PayPal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: 9df00a0cb9edb142be83f646df43c77e0b1586621ce9a817d38fe041b6142cb1 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789', 'name': 'Big Data Hadoop and Spark Developer Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '969.00', 'price': '969.00'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[Q] 37.27
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: AU INFO  setup:test_orders_and_payment_flow.py:166 Enroll Now button is not Appearing
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[R] 103.12
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/cyber-security/cisa-certification-training INFO  setup:orders_page.py:30 Country Set to: AU INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'CISA®', 'course_type': 'Online Bootcamp', 'base_price': 'A$ 3,799.00', 'final_price': '3,799.00'}, (['Credit Card', 'PayPal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: 4a1d89656852da2e19159d9b135af0a92cc492c4fdebeffb7380687c163b040b INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-123456789', 'name': 'CISA<sup>®</sup> Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '3,799.00', 'price': '3799.00'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[S] 101.92
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/cyber-security/cissp-certification-training INFO  setup:orders_page.py:30 Country Set to: AU INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'CISSP®', 'course_type': 'Online Self Learning', 'base_price': 'A$ 2,689.00', 'final_price': '2,689.00'}, (['Credit Card', 'PayPal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: a3c96f77e328dc5622964eb3cdb58660bd6f6a23cd2db0b9ad148b321246773a INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-123456789', 'name': 'CISSP<sup>®</sup> Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '2,689.00', 'price': '2689.00'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[T] 102.43
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/big-data-and-analytics/big-data-and-hadoop-training INFO  setup:orders_page.py:30 Country Set to: AU INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'Big Data Hadoop and Spark Developer', 'course_type': 'Online Self Learning', 'base_price': 'A$ 1,125.00', 'final_price': '1,125.00'}, (['Credit Card', 'PayPal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: c9e24cee0016c64ecbe9a0a9606f72d3bc8f4274fe56645bea1b65eb749ea567 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-123456789', 'name': 'Big Data Hadoop and Spark Developer Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '1,125.00', 'price': '1125.00'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[V] 37.32
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: DE INFO  setup:test_orders_and_payment_flow.py:166 Enroll Now button is not Appearing
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[W] 100.80
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/cyber-security/cisa-certification-training INFO  setup:orders_page.py:30 Country Set to: DE INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'CISA®', 'course_type': 'Online Bootcamp', 'base_price': '€ 2,799.00', 'final_price': '2,799.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: e379f1062990dc0330e044b8e4bab68f8ab81c5a98d40e5aae9999548c3b5914 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-123456789', 'name': 'CISA<sup>®</sup> Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '2,799.00', 'price': '2799.00'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[X] 100.95
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/cyber-security/cissp-certification-training INFO  setup:orders_page.py:30 Country Set to: DE INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'CISSP®', 'course_type': 'Online Self Learning', 'base_price': '€ 2,099.00', 'final_price': '2,099.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: 9459ab539678da9a56f1024dc4c6c4d048c736955f4417039b430927f77a14e1 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+49-123456789', 'name': 'CISSP<sup>®</sup> Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '2,099.00', 'price': '2099.00'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[Y] 102.35
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/big-data-and-analytics/big-data-and-hadoop-training INFO  setup:orders_page.py:30 Country Set to: DE INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'Big Data Hadoop and Spark Developer', 'course_type': 'Online Self Learning', 'base_price': '€ 749.00', 'final_price': '749.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: d845c6af2ac85a4d78bcd4812ce673826b4b390288999f617100bd1a6087d744 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+49-123456789', 'name': 'Big Data Hadoop and Spark Developer Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '749.00', 'price': '749.00'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AA] 37.00
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: SG INFO  setup:test_orders_and_payment_flow.py:166 Enroll Now button is not Appearing
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AB] 100.34
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/cyber-security/cisa-certification-training INFO  setup:orders_page.py:30 Country Set to: SG INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'CISA®', 'course_type': 'Online Bootcamp', 'base_price': '$ 2,799.00', 'final_price': '3,022.92'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: 71b67a80e072c1cb1fe1c70e24388d60b83738a13d6edab1c42f14fe7a81bd39 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+65-123456789', 'name': 'CISA<sup>®</sup> Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '2,799.00', 'price': '3022.92'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AC] 100.45
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/cyber-security/cissp-certification-training INFO  setup:orders_page.py:30 Country Set to: SG INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'CISSP®', 'course_type': 'Online Self Learning', 'base_price': '$ 2,099.00', 'final_price': '2,266.92'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: 17c514f86de1fe05e5470696b46f248782cdbc428136a139e933bfd346206f13 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+65-123456789', 'name': 'CISSP<sup>®</sup> Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '2,099.00', 'price': '2266.92'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AD] 100.26
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/big-data-and-analytics/big-data-and-hadoop-training INFO  setup:orders_page.py:30 Country Set to: SG INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'Big Data Hadoop and Spark Developer', 'course_type': 'Online Self Learning', 'base_price': '$ 748.00', 'final_price': '807.84'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: 3e263d57101142e6f5e9ba77602ddc05d0322af390b4eed52bc221c4268057c3 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+65-123456789', 'name': 'Big Data Hadoop and Spark Developer Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '748.00', 'price': '807.84'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AF] 36.97
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: AE INFO  setup:test_orders_and_payment_flow.py:166 Enroll Now button is not Appearing
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AG] 101.26
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/cyber-security/cisa-certification-training INFO  setup:orders_page.py:30 Country Set to: AE INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'CISA®', 'course_type': 'Online Bootcamp', 'base_price': '$ 2,799.00', 'final_price': '2,799.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: 8d566be8c111dd77795ca435f5cca330525a556b73dead23f58f71fda09b6642 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+971-123456789', 'name': 'CISA<sup>®</sup> Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '2,799.00', 'price': '2799.00'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AH] 101.86
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/cyber-security/cissp-certification-training INFO  setup:orders_page.py:30 Country Set to: AE INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'CISSP®', 'course_type': 'Online Self Learning', 'base_price': '$ 2,099.00', 'final_price': '2,099.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: e835348c14a14e656a507bac572dbc35a73d843baefa45d15456dff21fb13aa9 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+971-123456789', 'name': 'CISSP<sup>®</sup> Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '2,099.00', 'price': '2099.00'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AI] 100.10
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:102 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:113 Url Opened is: https://www.simplilearn.com/big-data-and-analytics/big-data-and-hadoop-training INFO  setup:orders_page.py:30 Country Set to: AE INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:228 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:121 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:124 course_data: ({'course_name': 'Big Data Hadoop and Spark Developer', 'course_type': 'Online Self Learning', 'base_price': '$ 749.00', 'final_price': '749.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:128 Token No is: f1157fcefff701389672b7f2e7f6c9422d941b782b4e69f3fd564cdf89245685 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+971-123456789', 'name': 'Big Data Hadoop and Spark Developer Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '749.00', 'price': '749.00'}] INFO  setup:test_orders_and_payment_flow.py:354 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[D] 66.28
------------------------------Captured stderr call------------------------------
--- Logging error --- Traceback (most recent call last): File "c:\users\qateam\appdata\local\programs\python\python38\lib\logging\__init__.py", line 1084, in emit stream.write(msg + self.terminator) File "c:\users\qateam\appdata\local\programs\python\python38\lib\encodings\cp1252.py", line 19, in encode return codecs.charmap_encode(input,self.errors,encoding_table)[0] UnicodeEncodeError: 'charmap' codec can't encode character '\u20b9' in position 151: character maps to <undefined> Call stack: File "c:\users\qateam\appdata\local\programs\python\python38\lib\runpy.py", line 194, in _run_module_as_main return _run_code(code, main_globals, None, File "c:\users\qateam\appdata\local\programs\python\python38\lib\runpy.py", line 87, in _run_code exec(code, run_globals) File "C:\Users\qateam\AppData\Local\Programs\Python\Python38\Scripts\pytest.exe\__main__.py", line 7, in <module> sys.exit(console_main()) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\config\__init__.py", line 190, in console_main code = main() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\config\__init__.py", line 167, in main ret: Union[ExitCode, int] = config.hook.pytest_cmdline_main( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 317, in pytest_cmdline_main return wrap_session(config, _main) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 270, in wrap_session session.exitstatus = doit(config, session) or 0 File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 324, in _main config.hook.pytest_runtestloop(session=session) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\main.py", line 349, in pytest_runtestloop item.config.hook.pytest_runtest_protocol(item=item, nextitem=nextitem) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 112, in pytest_runtest_protocol runtestprotocol(item, nextitem=nextitem) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 131, in runtestprotocol reports.append(call_and_report(item, "call", log)) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 220, in call_and_report call = call_runtest_hook(item, when, **kwds) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 259, in call_runtest_hook return CallInfo.from_call( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 339, in from_call result: Optional[TResult] = func() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 260, in <lambda> lambda: ihook(item=item, **kwds), when=when, reraise=reraise File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 167, in pytest_runtest_call item.runtest() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\python.py", line 1789, in runtest self.ihook.pytest_pyfunc_call(pyfuncitem=self) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\hooks.py", line 286, in __call__ return self._hookexec(self, self.get_hookimpls(), kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 93, in _hookexec return self._inner_hookexec(hook, methods, kwargs) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\manager.py", line 84, in <lambda> self._inner_hookexec = lambda hook, methods, kwargs: hook.multicall( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\pluggy\callers.py", line 187, in _multicall res = hook_impl.function(*args) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\python.py", line 195, in pytest_pyfunc_call result = testfunction(**testargs) File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 458, in test_Orders_and_Payment_Flow_masters_program logging.info(f"course_data: {course_data}") Message: "course_data: ({'course_name': 'Digital Marketing Specialist', 'course_type': 'Online Bootcamp', 'base_price': '₹ 54,407.00', 'final_price': '64,200.26'}, (['Credit Card', 'Debit Card', 'Net Banking', 'UPI', 'EMI', 'ShopSe EMI', 'CCAvenue'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'debitcard': 'All option clickable and Payment CTA appearing '}, {'net_banking': 'All option clickable and Payment CTA appearing '}, {'UPI': 'All option clickable and Payment CTA appearing '}, {'EMI': 'All option clickable and Payment CTA appearing '}, {'CCAvenue': 'All option clickable and Payment CTA appearing '}, {'ShopSE EMI': 'All option clickable and Payment CTA appearing '}]))" Arguments: ()
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/advanced-digital-marketing-certification-training-course INFO  setup:orders_page.py:30 Country Set to: IN INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:345 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Digital Marketing Specialist', 'course_type': 'Online Bootcamp', 'base_price': '₹ 54,407.00', 'final_price': '64,200.26'}, (['Credit Card', 'Debit Card', 'Net Banking', 'UPI', 'EMI', 'ShopSe EMI', 'CCAvenue'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'debitcard': 'All option clickable and Payment CTA appearing '}, {'net_banking': 'All option clickable and Payment CTA appearing '}, {'UPI': 'All option clickable and Payment CTA appearing '}, {'EMI': 'All option clickable and Payment CTA appearing '}, {'CCAvenue': 'All option clickable and Payment CTA appearing '}, {'ShopSE EMI': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: ae3289d4325ecd5253bbabb4a5510fe0a764179b96562c4e2c5bd77790ca55fa INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+91-123456789', 'name': 'Digital Marketing Specialist Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '54,407.00', 'price': '64200.26'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[G] 110.90
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/ui-ux-design-masters-program-certification-course INFO  setup:orders_page.py:30 Country Set to: US INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'UI/UX Design Expert', 'course_type': 'Online Bootcamp', 'base_price': '$ 1,999.00', 'final_price': '1,999.00'}, (['Credit Card', 'PayPal', 'Affirm', 'Klarna'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'Affirm': 'All option clickable and Payment CTA appearing '}, {'klarna': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: b3b34e4f04758da4285a9307a33f333ea5b6a823eb6ec41ecec3a131bc881eed INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+1-123456789', 'name': 'UI/UX Design Expert Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '1,999.00', 'price': '1999.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[H] 71.87
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/advanced-digital-marketing-certification-training-course INFO  setup:orders_page.py:30 Country Set to: US INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Digital Marketing Specialist', 'course_type': 'Online Bootcamp', 'base_price': '$ 1,649.00', 'final_price': '1,649.00'}, (['Credit Card', 'PayPal', 'Affirm', 'Klarna'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'Affirm': 'All option clickable and Payment CTA appearing '}, {'klarna': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: d9135011ead176856bd6bbfdf7c3f7acd9c05a130c39f76ec7d6864a131f0a94 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+1-123456789', 'name': 'Digital Marketing Specialist Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '1,649.00', 'price': '1649.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[I] 143.68
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training INFO  setup:orders_page.py:30 Country Set to: GB INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Full Stack Web Developer - MEAN Stack', 'course_type': 'Online Bootcamp', 'base_price': '£ 1,390.00', 'final_price': '1,390.00'}, (['Credit Card', 'PayPal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: 01a6d29bb2e67134500ce487bf86bc655490d2eb28aec066d09346bb156aba1c INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+1-123456789', 'name': 'Full Stack Web Developer - MEAN Stack Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '1,390.00', 'price': '1390.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[J] 144.14
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/automation-testing-masters-program-certification-training-course INFO  setup:orders_page.py:30 Country Set to: GB INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Automation Testing Masters Program', 'course_type': 'Online Bootcamp', 'base_price': '£ 1,099.00', 'final_price': '1,099.00'}, (['Credit Card', 'PayPal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: 4fa4978f5d3b853dca112d9ca6627da3e1d78a0daeecb60b7119b5da2190afb9 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+1-123456789', 'name': 'Automation Testing Masters Program Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '1,099.00', 'price': '1099.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[K] 145.14
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/ui-ux-design-masters-program-certification-course INFO  setup:orders_page.py:30 Country Set to: GB INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'UI/UX Design Expert', 'course_type': 'Online Bootcamp', 'base_price': '£ 1,700.00', 'final_price': '1,700.00'}, (['Credit Card', 'PayPal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: f44ccfc0a9cb9edcbec6b9d7e4d729f2cf23f78f7508808a4a9b4c05cac67434 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789', 'name': 'UI/UX Design Expert Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '1,700.00', 'price': '1700.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[L] 102.77
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/advanced-digital-marketing-certification-training-course INFO  setup:orders_page.py:30 Country Set to: GB INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Digital Marketing Specialist', 'course_type': 'Online Bootcamp', 'base_price': '£ 1,049.00', 'final_price': '1,049.00'}, (['Credit Card', 'PayPal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: 58b9e528ec86215335f049c8b36fb10618eb1190d7e008e6e5eb29bb52b57c36 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789', 'name': 'Digital Marketing Specialist Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '1,049.00', 'price': '1049.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[M] 143.58
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training INFO  setup:orders_page.py:30 Country Set to: AU INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Full Stack Web Developer - MEAN Stack', 'course_type': 'Online Bootcamp', 'base_price': 'A$ 1,605.00', 'final_price': '1,605.00'}, (['Credit Card', 'PayPal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: 433b000693f11bafb809d05631657eb33685bf56537dfac6487ac10b72e80fac INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789', 'name': 'Full Stack Web Developer - MEAN Stack Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '1,605.00', 'price': '1605.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[N] 144.71
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/automation-testing-masters-program-certification-training-course INFO  setup:orders_page.py:30 Country Set to: AU INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Automation Testing Masters Program', 'course_type': 'Online Bootcamp', 'base_price': 'A$ 1,649.00', 'final_price': '1,649.00'}, (['Credit Card', 'PayPal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: bbf140b5095ca09adea7e429a6972b47c910101c2e2f8997b4eb5a4b750961f6 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789', 'name': 'Automation Testing Masters Program Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '1,649.00', 'price': '1649.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[O] 144.41
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/ui-ux-design-masters-program-certification-course INFO  setup:orders_page.py:30 Country Set to: AU INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'UI/UX Design Expert', 'course_type': 'Online Bootcamp', 'base_price': 'A$ 1,949.00', 'final_price': '1,949.00'}, (['Credit Card', 'PayPal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: 5295ae2a2ed54a91aee11a4ac3f512e900a9cea7f0df93e5447582fd808c491c INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789', 'name': 'UI/UX Design Expert Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '1,949.00', 'price': '1949.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[P] 102.78
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/advanced-digital-marketing-certification-training-course INFO  setup:orders_page.py:30 Country Set to: AU INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Digital Marketing Specialist', 'course_type': 'Online Bootcamp', 'base_price': 'A$ 1,399.00', 'final_price': '1,399.00'}, (['Credit Card', 'PayPal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: a9bf3f4737871a5dd04c927524c90c237b91b872551096a37c22c3ed4faeffcc INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-123456789', 'name': 'Digital Marketing Specialist Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '1,399.00', 'price': '1399.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[Q] 143.45
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training INFO  setup:orders_page.py:30 Country Set to: DE INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Full Stack Web Developer - MEAN Stack', 'course_type': 'Online Bootcamp', 'base_price': '€ 1,390.00', 'final_price': '1,390.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: c611959c74ab544c5b18786e614d8528cca5056b70742ce03045c9467f3aad35 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-123456789', 'name': 'Full Stack Web Developer - MEAN Stack Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '1,390.00', 'price': '1390.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[R] 142.10
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/automation-testing-masters-program-certification-training-course INFO  setup:orders_page.py:30 Country Set to: DE INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Automation Testing Masters Program', 'course_type': 'Online Bootcamp', 'base_price': '€ 1,099.00', 'final_price': '1,099.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: fd8136657a179e1ffdf88183bea51d2ac2b5dcb7da98cc1bff772a9a36ac07e9 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-123456789', 'name': 'Automation Testing Masters Program Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '1,099.00', 'price': '1099.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[S] 143.12
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/ui-ux-design-masters-program-certification-course INFO  setup:orders_page.py:30 Country Set to: DE INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'UI/UX Design Expert', 'course_type': 'Online Bootcamp', 'base_price': '€ 1,700.00', 'final_price': '1,700.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: dfbad3ce91c4da41e400531d15745a216dd269bfcfcc83e83bd20a37ca391e32 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+49-123456789', 'name': 'UI/UX Design Expert Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '1,700.00', 'price': '1700.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[T] 101.51
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/advanced-digital-marketing-certification-training-course INFO  setup:orders_page.py:30 Country Set to: DE INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Digital Marketing Specialist', 'course_type': 'Online Bootcamp', 'base_price': '€ 1,049.00', 'final_price': '1,049.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: 28e4de1928498be1127837f49c381c94582f2a4eacb70e3bc23f6fc896038006 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+49-123456789', 'name': 'Digital Marketing Specialist Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '1,049.00', 'price': '1049.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[U] 143.16
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training INFO  setup:orders_page.py:30 Country Set to: SG INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Full Stack Web Developer - MEAN Stack', 'course_type': 'Online Bootcamp', 'base_price': '$ 1,390.00', 'final_price': '1,501.20'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: 06d4da045f44433fb161ab61242b1f9b025481a5d7ca1c2690f35d7bde53d22b INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+65-123456789', 'name': 'Full Stack Web Developer - MEAN Stack Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '1,390.00', 'price': '1501.20'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[V] 152.64
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/automation-testing-masters-program-certification-training-course INFO  setup:orders_page.py:30 Country Set to: SG INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Automation Testing Masters Program', 'course_type': 'Online Bootcamp', 'base_price': '$ 1,099.00', 'final_price': '1,186.92'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: ff70abfa6727e862a930a02efda981dd40beda323c6d66d0cdec66c0733f358b INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+65-123456789', 'name': 'Automation Testing Masters Program Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '1,099.00', 'price': '1186.92'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[W] 142.76
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/ui-ux-design-masters-program-certification-course INFO  setup:orders_page.py:30 Country Set to: SG INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'UI/UX Design Expert', 'course_type': 'Online Bootcamp', 'base_price': '$ 1,400.00', 'final_price': '1,512.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: 1659f2885258499d4ec7a83a8b25186547a240ee9f2234e608594a6e04de38c5 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+65-123456789', 'name': 'UI/UX Design Expert Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '1,400.00', 'price': '1512.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[X] 101.59
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/advanced-digital-marketing-certification-training-course INFO  setup:orders_page.py:30 Country Set to: AE INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Digital Marketing Specialist', 'course_type': 'Online Bootcamp', 'base_price': '$ 1,049.00', 'final_price': '1,049.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: 1271a109bfbcca59a6d0b90589aec48f09c3143855ef475847c4e6fbcd26961a INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+65-123456789', 'name': 'Digital Marketing Specialist Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '1,049.00', 'price': '1049.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[Y] 143.33
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training INFO  setup:orders_page.py:30 Country Set to: AE INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Full Stack Web Developer - MEAN Stack', 'course_type': 'Online Bootcamp', 'base_price': '$ 1,390.00', 'final_price': '1,390.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: c9dde545c4befc6997cd95d5104cdd0f572f1ab6fab6c16e2fcf12dfd95efed5 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+971-123456789', 'name': 'Full Stack Web Developer - MEAN Stack Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '1,390.00', 'price': '1390.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[Z] 142.75
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/automation-testing-masters-program-certification-training-course INFO  setup:orders_page.py:30 Country Set to: AE INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Automation Testing Masters Program', 'course_type': 'Online Bootcamp', 'base_price': '$ 1,099.00', 'final_price': '1,099.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: 286dc40a96e9cf3973033b7c00cd0638145149e3975a0084a6c8b7dfd1a68fa6 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+971-123456789', 'name': 'Automation Testing Masters Program Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '1,099.00', 'price': '1099.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[AA] 142.52
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/ui-ux-design-masters-program-certification-course INFO  setup:orders_page.py:30 Country Set to: AE INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'UI/UX Design Expert', 'course_type': 'Online Bootcamp', 'base_price': '$ 1,400.00', 'final_price': '1,400.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: 5a21c47b7506a5b5e827e494712abfe2cf76db8b7a723696aceaa2c1ebb0fa7b INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+971-123456789', 'name': 'UI/UX Design Expert Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '1,400.00', 'price': '1400.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[AB] 102.60
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:446 Url Opened is: https://www.simplilearn.com/advanced-digital-marketing-certification-training-course INFO  setup:orders_page.py:30 Country Set to: AE INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:162 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:561 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:455 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:458 course_data: ({'course_name': 'Digital Marketing Specialist', 'course_type': 'Online Bootcamp', 'base_price': '$ 1,049.00', 'final_price': '1,049.00'}, (['Credit Card', 'PayPal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'All option clickable and Payment CTA appearing '}, {'2checkout': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:462 Token No is: 80ecbd7d43d5986cc3859e48bd08b964ec2b02a921c08314505bf182ea5b5ae8 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+971-123456789', 'name': 'Digital Marketing Specialist Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '1,049.00', 'price': '1049.00'}] INFO  setup:test_orders_and_payment_flow.py:698 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_orderAndPayment_flow_certification_program_report_details_to_DB 0.55
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:53 Total rows present in file are 63 INFO  setup:test_orders_and_payment_flow.py:69 Total certification program urls are 35 INFO  setup:test_orders_and_payment_flow.py:71 Total testcases passes is 35 INFO  setup:test_orders_and_payment_flow.py:72 Total testcases failed is 0 INFO  setup:db_helper.py:51 DB_type selected : mysql INFO  setup:db_connection.py:96 Requested Query : INSERT INTO automation_ice9.td_order_and_payment_flow_report_details(module_name, sub_module_name, total_testcase_count, passed, failed, run_date) VALUES( 'Order and Payment Flow', 'Certification Program', '35', '35', '0', '2023-06-29');
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_orderAndPayment_flow_master_program_report_details_to_DB 0.36
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:385 Total rows present in file are 63 INFO  setup:test_orders_and_payment_flow.py:401 Total master program urls are 23 INFO  setup:test_orders_and_payment_flow.py:403 Total testcases passes is 23 INFO  setup:test_orders_and_payment_flow.py:404 Total testcases failed is 0 INFO  setup:db_helper.py:51 DB_type selected : mysql INFO  setup:db_connection.py:96 Requested Query : INSERT INTO automation_ice9.td_order_and_payment_flow_report_details(module_name, sub_module_name, total_testcase_count, passed, failed, run_date) VALUES( 'Order and Payment Flow', 'Master Program', '23', '23', '0', '2023-06-29');