report.html

Report generated on 02-Jul-2023 at 01:43:58 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 6231.64 seconds.

58 passed, 0 skipped, 7 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 0x000002D748C16280>
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.199) 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] 70.71
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000002D748C16FD0>
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.199) 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.41
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000002D748C343D0>
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.199) 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] 70.29
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000002D748C34790>
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.199) 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] 70.03
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000002D748C34B50>
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.199) 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] 69.56
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000002D748C34F10>
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.199) 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.66
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000002D748C3F310>
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.199) INFO  setup:test_orders_and_payment_flow.py:182 If block in Exception
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[B] 37.14
-------------------------------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.52
------------------------------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: fa79807a0711c13d647592daedbe92b8528e5d234862a435f36b27bc240ad4d2 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.73
------------------------------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: a5efd45784a48f34cd710f1ece547a08634ff5a26364d1b28ee17d9e84c4935e 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] 67.76
------------------------------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: 0c52caaa3ef8d8c96e5de9a13099b74743108a6d9bb66a72119a4b9413d5b159 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] 37.88
-------------------------------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] 71.22
-------------------------------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: 1a3133e5ed03060f092efcb5596d4a54718f53aec2b582df0d51d5e7d70fccf8 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+1-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.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/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: 1dc3fcf4e4c887f5539761f8e9fe67b72c7c9ee64a8bdaab9d6416d593c6827c 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] 73.91
-------------------------------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: 03dcc36a6db1223ca99c91d3367532c863fad5fc7c04c851343de969c1abf0ef 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] 36.99
-------------------------------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] 104.63
-------------------------------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: 070da30ed39efc4cea34384fdd74ef9cc8cc69c851d82e51d9958c993195606c INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+1-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.55
-------------------------------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: bf63db2b7844513c45ce86d915e7206b27d9fa2ba467c5b3d61bab02b78db398 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,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] 103.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/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: be673a196d09e0a8f97427c3d5242b79931bfac859e6087fa447a5b530b14022 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.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/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] 104.96
-------------------------------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: 32f5df09e61cdf7fb683b21f2a4f3707c32e3b85c0db06fd15644da000a4e5b9 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': '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] 102.42
-------------------------------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: 2ecc9a95bea2e908186a574612b42b2f6b10761971f4a9cf497c30a7bac5b974 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,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] 103.07
-------------------------------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: 66d0657c48bb4c11427d5c3fe692b3090c56fdc90d798adf4c19f8d05417b339 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.56
-------------------------------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] 101.70
-------------------------------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: 40d83408ff5c1e7384c43c15c3c543d7961290d014b122f15f4fa5c7fb7176b8 INFO  setup:test_orders_and_payment_flow.py:138 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+49-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] 101.70
-------------------------------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: 7916eb36db85d950173daf6683f423f8b98ecb3cf7a943c449b9792538688960 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] 101.58
-------------------------------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: f29dd7fc7d97c7c24e9b6328888a57d601a128c8b07fc2c878f0568bd8b7bd96 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.61
-------------------------------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] 134.19
-------------------------------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:43 Payment Page is not Loaded INFO  setup:orders_page.py:44 url opend for payment is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDktMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:orders_page.py:54 clicked on Enroll Now button again INFO  setup:orders_page.py:57 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: d902034fedb909616c268dcaac4165a39ed29b16f8b0e69a1bc10e792042056d 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] 101.55
-------------------------------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: c47c10471349f84235374b388db76ca81d9844d01a2d602a11a89139b20c1bc7 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] 101.20
-------------------------------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: 87ef3dabd07ea3b5592c89c1ebdec5fbc06cb7d42f8a9da440cb9e755647fcb9 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.98
-------------------------------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] 100.46
-------------------------------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: 5f9876a7a48c745524b2552dda9b69e9d10635647ba23f1a7d968685f5ffffd0 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] 100.98
-------------------------------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: e1db46309b2fdbe7c58367233945e4ec71643af8d23767fb1cfdf29b82282850 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] 101.75
-------------------------------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: 56a40e40fe16a2806430e5b095c3527c434cac06511e78c53164b7c00d9a1a2f 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[A] 108.16
------------------------------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 160: 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': 'Full Stack Web Developer - MEAN Stack', 'course_type': 'Online Bootcamp', 'base_price': '₹ 45,762.00', 'final_price': '53,999.16'}, (['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/full-stack-web-developer-mean-stack-certification-training 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': 'Full Stack Web Developer - MEAN Stack', 'course_type': 'Online Bootcamp', 'base_price': '₹ 45,762.00', 'final_price': '53,999.16'}, (['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: 7a4e20dacae8082fc9876a4575fa8a6f611054d61180da70a4d6327dc8597040 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+91-123456789', 'name': 'Full Stack Web Developer - MEAN Stack Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '45,762.00', 'price': '53999.16'}] 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[B] 110.15
------------------------------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 157: 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': 'Automation Testing Masters Program', 'course_type': 'Online Bootcamp', 'base_price': '₹ 45,762.00', 'final_price': '53,999.16'}, (['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/automation-testing-masters-program-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': 'Automation Testing Masters Program', 'course_type': 'Online Bootcamp', 'base_price': '₹ 45,762.00', 'final_price': '53,999.16'}, (['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: 767d83c34006fae77fd7c47f6dc73500bf444c0e0a088f3278be4978eff13828 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+91-123456789', 'name': 'Automation Testing Masters Program Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '45,762.00', 'price': '53999.16'}] 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[C] 107.78
------------------------------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 142: 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': 'UI/UX Design Expert', 'course_type': 'Online Bootcamp', 'base_price': '₹ 52,541.50', 'final_price': '61,998.97'}, (['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/ui-ux-design-masters-program-certification-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': 'UI/UX Design Expert', 'course_type': 'Online Bootcamp', 'base_price': '₹ 52,541.50', 'final_price': '61,998.97'}, (['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: cd28dd44c90afb60f2718beb26b7cc5d9aa5a0246ef431a456b4fcdfb95b2db5 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+91-123456789', 'name': 'UI/UX Design Expert Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '52,541.50', 'price': '61998.97'}] 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[D] 67.79
------------------------------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: deaa795ded9fa14350164f3557166ae54d30b5ec3b426ef2cfd26b6ec31002ef 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[E] 112.53
-------------------------------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 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': 'Full Stack Web Developer - MEAN Stack', 'course_type': 'Online Bootcamp', 'base_price': '$ 1,499.00', 'final_price': '1,499.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: 0c4f67930ac876d82dd5dbd685f1872a646dba419e1767647c2a8dbaffe68cbc 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,499.00', 'price': '1499.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[F] 112.27
-------------------------------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 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': 'Automation Testing Masters Program', 'course_type': 'Online Bootcamp', 'base_price': '$ 1,499.00', 'final_price': '1,499.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: 1a09d8e855579ed82d637b0f212ddb9de95be8fb6f79150541b899b7904ab19e 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 Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '1,499.00', 'price': '1499.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[G] 112.38
-------------------------------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: 3abd41c5b0305a45dd6b7abdf280f32075fe442c8355e8fc8f0684b72dd4f8b5 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] 70.71
-------------------------------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: b4ac95ef396ce333b2645239917c5f9e72e414a44353dbf6b6c75c50e6f7014f 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] 145.84
-------------------------------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: 2b7a9762be416d5f906e4b0d862fc8c569ccf2e3ca0bbd584a9377c05c005636 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] 145.50
-------------------------------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: ab626da507a3bd467cf8c9698afb86beb05e3b5fc24d0909382e2540f80264d8 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 Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', '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] 144.40
-------------------------------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: c1bd67a4d2908c4f665b23ae38d41ef4d7a42210604a59c3fbe509702faf879b 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.80
-------------------------------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: 432f6753bc434996dfe0cf1048fbf0236d8347a47316ff003fc518e61581966a 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] 145.07
-------------------------------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: 3651282de9960bbdc02f9d2325cf82e95fbe71b5e549d7251b2ad410c9c58f58 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,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.93
-------------------------------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: 25020fb837c07ba251ddea3996af70f69c2dc5598c19fb00cd9f51b162c290b0 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 Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', '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] 145.07
-------------------------------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: 795c14870c4aa45385bc4f5354e10c5f880057853858a5f56f745013f9b4aff8 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-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] 103.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: 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: 079da564138d904cdc024efa6bde7388ac5cc101cde7bc464073f9f3b131caff 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.79
-------------------------------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: 275decd5cea2779c89f23a9c75f798157660a6b52aebe484c73c029882973f38 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+49-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] 143.52
-------------------------------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: a51b487d93066e1bb0bef1626dc0b85c68cbcdb6d69c4fc9b71fb57e4a6cba50 INFO  setup:test_orders_and_payment_flow.py:472 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+49-123456789', 'name': 'Automation Testing Masters Program Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', '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.49
-------------------------------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: 382cdcd8aa6c30a3f9a1fade54520e2a4d181b33825dec569a3a9724df8b614e 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] 102.23
-------------------------------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: 9ce2dd498fc097ec247661c5807fae815a5d3ada38bd63dc277ea41489487c31 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.32
-------------------------------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: fb47a070c25d65a582781139ed57fb6653f65e3a856ae1b77b87512069ccd9b6 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] 143.19
-------------------------------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: 5a28b52b3e5a0200adab9463fb77d8c0747692362fa8f914944f4693b2e8eba4 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 Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', '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] 143.26
-------------------------------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: 1ea269b54e160855b77e046a3f05957ecf5229d1a4350aff28ca762934623a8c 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] 105.68
-------------------------------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: 6faf983067be97b06634f4e14bb993a270865a478a85d8ffd68050abaf74dbb9 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::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[Y] 146.71
-------------------------------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: 72e47244fefa4895caf79bc45df4dbe7c2e223122fb7b6bd88f8339ee8a4012f 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] 145.13
-------------------------------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: f6a26bb27f222bf96b18172fd32796c375a9b0dd4d4a0c334bd80e0ec54f523d 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 Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', '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] 144.91
-------------------------------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: f30991b667e7042de69cda3319da256282875ef6777c71adec3f618b48593e2f 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] 103.61
-------------------------------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: 47b71438e1501e53688547a67b893cb2c05399953459291ab8fb037b1782e93d 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.71
-------------------------------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-07-02');
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_orderAndPayment_flow_master_program_report_details_to_DB 0.42
-------------------------------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 28 INFO  setup:test_orders_and_payment_flow.py:403 Total testcases passes is 28 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', '28', '28', '0', '2023-07-02');