report.html

Report generated on 25-Jul-2023 at 02:45:41 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 9935.84 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[T] 245.51
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000002A56C7F2CD0>
value = 'T', 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()
time.sleep(2)
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
selenium_helper.scroll_to_page_bottom()
self.pg_home.close_iframe_popUp()
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_clickable(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:207: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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: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=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjEtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:orders_page.py:54 clicked on Enroll Now button again INFO  setup:orders_page.py:59 Payment Page is not Loaded INFO  setup:orders_page.py:60 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjEtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu ERROR  setup:selenium_helper.py:61 Message: WARNING  setup:selenium_helper.py:62 the locator ('xpath', "//div[@id='ssvcApp']//div[contains(text(), 'Cart Summary')][contains(@class,'active_heading')]") on url https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjEtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu is not visible INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:133 Token No is: https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjEtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:182 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 148, in test_Orders_and_Payment_Flow_certification for i in course_data[1][1]: IndexError: tuple index out of range INFO  setup:test_orders_and_payment_flow.py:193 1st else block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[X] 245.46
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000002A56C7F2FD0>
value = 'X', 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()
time.sleep(2)
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
selenium_helper.scroll_to_page_bottom()
self.pg_home.close_iframe_popUp()
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_clickable(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:207: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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: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=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjEtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:orders_page.py:54 clicked on Enroll Now button again INFO  setup:orders_page.py:59 Payment Page is not Loaded INFO  setup:orders_page.py:60 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjEtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu ERROR  setup:selenium_helper.py:61 Message: WARNING  setup:selenium_helper.py:62 the locator ('xpath', "//div[@id='ssvcApp']//div[contains(text(), 'Cart Summary')][contains(@class,'active_heading')]") on url https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjEtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu is not visible INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:133 Token No is: https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjEtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:182 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 148, in test_Orders_and_Payment_Flow_certification for i in course_data[1][1]: IndexError: tuple index out of range INFO  setup:test_orders_and_payment_flow.py:193 1st else block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AC] 245.61
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000002A56C8083D0>
value = 'AC', 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()
time.sleep(2)
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
selenium_helper.scroll_to_page_bottom()
self.pg_home.close_iframe_popUp()
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_clickable(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:207: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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: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:59 Payment Page is not Loaded INFO  setup:orders_page.py:60 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDktMTIzNDU2Nzg5LFNpbXBsaWxlYXJu ERROR  setup:selenium_helper.py:61 Message: WARNING  setup:selenium_helper.py:62 the locator ('xpath', "//div[@id='ssvcApp']//div[contains(text(), 'Cart Summary')][contains(@class,'active_heading')]") on url https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDktMTIzNDU2Nzg5LFNpbXBsaWxlYXJu is not visible INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:133 Token No is: https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDktMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:182 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 148, in test_Orders_and_Payment_Flow_certification for i in course_data[1][1]: IndexError: tuple index out of range INFO  setup:test_orders_and_payment_flow.py:193 1st else block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AD] 245.62
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000002A56C808490>
value = 'AD', 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()
time.sleep(2)
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
selenium_helper.scroll_to_page_bottom()
self.pg_home.close_iframe_popUp()
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_clickable(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:207: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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: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:59 Payment Page is not Loaded INFO  setup:orders_page.py:60 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDktMTIzNDU2Nzg5LFNpbXBsaWxlYXJu ERROR  setup:selenium_helper.py:61 Message: WARNING  setup:selenium_helper.py:62 the locator ('xpath', "//div[@id='ssvcApp']//div[contains(text(), 'Cart Summary')][contains(@class,'active_heading')]") on url https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDktMTIzNDU2Nzg5LFNpbXBsaWxlYXJu is not visible INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:133 Token No is: https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDktMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:182 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 148, in test_Orders_and_Payment_Flow_certification for i in course_data[1][1]: IndexError: tuple index out of range INFO  setup:test_orders_and_payment_flow.py:193 1st else block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AG] 245.60
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000002A56C8086D0>
value = 'AG', 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()
time.sleep(2)
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
selenium_helper.scroll_to_page_bottom()
self.pg_home.close_iframe_popUp()
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_clickable(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:207: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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: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=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== INFO  setup:orders_page.py:54 clicked on Enroll Now button again INFO  setup:orders_page.py:59 Payment Page is not Loaded INFO  setup:orders_page.py:60 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== ERROR  setup:selenium_helper.py:61 Message: WARNING  setup:selenium_helper.py:62 the locator ('xpath', "//div[@id='ssvcApp']//div[contains(text(), 'Cart Summary')][contains(@class,'active_heading')]") on url https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== is not visible INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:133 Token No is: https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:182 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 148, in test_Orders_and_Payment_Flow_certification for i in course_data[1][1]: IndexError: tuple index out of range INFO  setup:test_orders_and_payment_flow.py:193 1st else block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AI] 245.96
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000002A56C808850>
value = 'AI', 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()
time.sleep(2)
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
selenium_helper.scroll_to_page_bottom()
self.pg_home.close_iframe_popUp()
self.pg_orders.change_country(country_value)

if selenium_helper.is_locator_clickable(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:207: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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: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=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== INFO  setup:orders_page.py:54 clicked on Enroll Now button again INFO  setup:orders_page.py:59 Payment Page is not Loaded INFO  setup:orders_page.py:60 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== ERROR  setup:selenium_helper.py:61 Message: WARNING  setup:selenium_helper.py:62 the locator ('xpath', "//div[@id='ssvcApp']//div[contains(text(), 'Cart Summary')][contains(@class,'active_heading')]") on url https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== is not visible INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:133 Token No is: https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:182 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 148, in test_Orders_and_Payment_Flow_certification for i in course_data[1][1]: IndexError: tuple index out of range INFO  setup:test_orders_and_payment_flow.py:193 1st else block in Exception
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[AB] 200.02
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowMastersProgram object at 0x000002A56C8232B0>, value = 'AB'
initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

test_prod\test_orders_and_payment_flow.py:542: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 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:164 Payment Page is not Loaded INFO  setup:orders_page.py:165 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== INFO  setup:orders_page.py:175 clicked on Enroll Now button for Masters Program again INFO  setup:orders_page.py:180 Payment Page is not Loaded INFO  setup:orders_page.py:181 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== ERROR  setup:selenium_helper.py:61 Message: WARNING  setup:selenium_helper.py:62 the locator ('xpath', "//div[@id='ssvcApp']//div[contains(text(), 'Cart Summary')][contains(@class,'active_heading')]") on url https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== is not visible INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:467 Token No is: https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== INFO  setup:test_orders_and_payment_flow.py:477 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:517 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 482, in test_Orders_and_Payment_Flow_masters_program for i in course_data[1][1]: IndexError: tuple index out of range INFO  setup:test_orders_and_payment_flow.py:528 1st else block in Exception
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[A] 192.41
------------------------------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 171: 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 129, in test_Orders_and_Payment_Flow_certification logging.info(f"course_data: {course_data}") Message: "course_data: ({'course_name': 'Certified ScrumMaster® (CSM)', 'course_type': 'Aug 05 - Aug 06\\n(2 days) Classroom', 'base_price': '₹ 18,999.00', 'final_price': '22,418.82'}, (['Credit Card', 'Debit Card', 'Net Banking', 'UPI', '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 '}]))" Arguments: ()
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/csm-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/csm-certification-training is not visible INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:selenium_helper.py:61 Message: WARNING  setup:selenium_helper.py:62 the locator ('xpath', "//li[@id='shopse']//h2[contains(text(),'EMI')][not(contains(@style,'none'))]/ancestor::a") on url https://www.simplilearn.com/secure/checkout/details?authtoken=b8ebf425d25a2117d4450e41445ad3ae145129514d0a58403790ec63e2efd2cc is not visible INFO  setup:test_orders_and_payment_flow.py:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:345 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ({'course_name': 'Certified ScrumMaster® (CSM)', 'course_type': 'Aug 05 - Aug 06\n(2 days) Classroom', 'base_price': '₹ 18,999.00', 'final_price': '22,418.82'}, (['Credit Card', 'Debit Card', 'Net Banking', 'UPI', '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 '}])) INFO  setup:test_orders_and_payment_flow.py:133 Token No is: b8ebf425d25a2117d4450e41445ad3ae145129514d0a58403790ec63e2efd2cc INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+91-123456789', 'name': 'Certified ScrumMaster<sup>®</sup> (CSM) Classroom', 'training_type_txt': 'Classroom', 'display_total_price': '18,999.00', 'price': '22418.82'}] INFO  setup:test_orders_and_payment_flow.py:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[B] 79.27
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: IN ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "(//div[@class='card']//a[contains(text(),'Enroll Now')])") on url https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training is not visible INFO  setup:test_orders_and_payment_flow.py:171 Enroll Now button is not Appearing
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[C] 96.49
------------------------------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 129, 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:116 Url Opened is: https://www.simplilearn.com/cyber-security/cisa-certification-training INFO  setup:home_page.py:519 Popup Iframe present INFO  setup:home_page.py:521 Inside Iframe 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:345 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 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:133 Token No is: 3275b382e3bad683562e0e1b9121851032f76843a7da1782fa562d23b0850728 INFO  setup:test_orders_and_payment_flow.py:143 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:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[D] 111.47
------------------------------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 129, 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:116 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:345 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 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:133 Token No is: 22307d2537b4942bc1da690c326aca9558987516c4542f2adcc98aa4a1e207ab INFO  setup:test_orders_and_payment_flow.py:143 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:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[E] 111.92
------------------------------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 129, 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:116 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:345 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 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:133 Token No is: 218ec36ba7cda461df15319fa3dc5b5ead947cc67d64b9f1815f68424d74c3e6 INFO  setup:test_orders_and_payment_flow.py:143 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:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[F] 188.81
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/csm-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/csm-certification-training is not visible 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ({'course_name': 'Certified ScrumMaster® (CSM)', 'course_type': 'Jul 29 - Jul 30\n(2 days) Classroom', 'base_price': '$ 599.00', 'final_price': '599.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:133 Token No is: 0ebde8399e9e7fd95c85eaa7f37995be048bb6f3ce70abb86d4600bc717bd4f1 INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+1-123456789', 'name': 'Certified ScrumMaster<sup>®</sup> (CSM) Classroom', 'training_type_txt': 'Classroom', 'display_total_price': '599.00', 'price': '599.00'}] INFO  setup:test_orders_and_payment_flow.py:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[G] 78.93
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: US ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "(//div[@class='card']//a[contains(text(),'Enroll Now')])") on url https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training is not visible INFO  setup:test_orders_and_payment_flow.py:171 Enroll Now button is not Appearing
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[H] 116.39
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 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:133 Token No is: 159207a77ebc1450076d6cac8afabb31a29c4720c215b1889c472ea1213d6332 INFO  setup:test_orders_and_payment_flow.py:143 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:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[I] 117.70
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 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:133 Token No is: 3bc5a5d1387a402207e3c43d54d3bbc72be261be1431e2fd185994273219b43a INFO  setup:test_orders_and_payment_flow.py:143 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:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[J] 117.38
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 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:133 Token No is: d9897b9bbdac99c523cf4ab879f8e0d535ab178a80caa879cfc7e584b2371e13 INFO  setup:test_orders_and_payment_flow.py:143 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:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[K] 221.27
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/csm-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/csm-certification-training is not visible 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ({'course_name': 'Certified ScrumMaster® (CSM)', 'course_type': 'Jul 26 - Jul 28\n(2 days) Classroom', 'base_price': '£ 549.00', 'final_price': '549.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:133 Token No is: bf846c87e3b2f3d592e652b1a356420c9859629150a7ace3dcd8d8a75608a16a INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789', 'name': 'Certified ScrumMaster<sup>®</sup> (CSM) Classroom', 'training_type_txt': 'Classroom', 'display_total_price': '549.00', 'price': '549.00'}] INFO  setup:test_orders_and_payment_flow.py:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[L] 79.48
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: GB ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "(//div[@class='card']//a[contains(text(),'Enroll Now')])") on url https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training is not visible INFO  setup:test_orders_and_payment_flow.py:171 Enroll Now button is not Appearing
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[M] 148.67
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 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:133 Token No is: 849aa6ec4f46427ae568015270e0ba53ead1e9acd270f0fef32d8d8d00d13def INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789', 'name': 'CISA<sup>®</sup> Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '2,799.00', 'price': '2799.00'}] INFO  setup:test_orders_and_payment_flow.py:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[N] 152.60
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 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:133 Token No is: 1ccd9508d2195be704a9b2c62c72f44d1c55ecc9da52d18b5d096783efaae279 INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789', 'name': 'CISSP<sup>®</sup> Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '2,099.00', 'price': '2099.00'}] INFO  setup:test_orders_and_payment_flow.py:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[O] 148.85
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 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:133 Token No is: 37e992359ecbc7c70997e1b06e869e0ff80482a9e60b1b5928bcc299617a3d04 INFO  setup:test_orders_and_payment_flow.py:143 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:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[P] 223.33
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/csm-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/csm-certification-training is not visible 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ({'course_name': 'Certified ScrumMaster® (CSM)', 'course_type': 'Jul 26 - Jul 28\n(2 days) Classroom', 'base_price': 'A$ 799.00', 'final_price': '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:133 Token No is: 257d2f560c6f0f82d574fc5b93afc0c38d76060118233ab12624979676c18919 INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-123456789', 'name': 'Certified ScrumMaster<sup>®</sup> (CSM) Classroom', 'training_type_txt': 'Classroom', 'display_total_price': '799.00', 'price': '799.00'}] INFO  setup:test_orders_and_payment_flow.py:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[Q] 79.20
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: AU ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "(//div[@class='card']//a[contains(text(),'Enroll Now')])") on url https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training is not visible INFO  setup:test_orders_and_payment_flow.py:171 Enroll Now button is not Appearing
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[R] 149.66
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 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:133 Token No is: f6f84efb1c9981e7683b2201ebea4cd57507e27e56ca84b36edbd29e12d1af7e INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-123456789', 'name': 'CISA<sup>®</sup> Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '3,799.00', 'price': '3799.00'}] INFO  setup:test_orders_and_payment_flow.py:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[S] 148.73
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 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:133 Token No is: 1cd45bf80d472fa9d14e85be10ee264f69251142114b159c68155908349eaa55 INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-123456789', 'name': 'CISSP<sup>®</sup> Online Self Learning', 'training_type_txt': 'Online Self Learning', 'display_total_price': '2,689.00', 'price': '2689.00'}] INFO  setup:test_orders_and_payment_flow.py:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[U] 221.85
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/csm-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/csm-certification-training is not visible 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ({'course_name': 'Certified ScrumMaster® (CSM)', 'course_type': 'Jul 26 - Jul 28\n(2 days) Classroom', 'base_price': '€ 599.00', 'final_price': '599.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:133 Token No is: a776ac34b25ad34808892580a9c7e7838688fb0fd9c46ff16592f36430a33d97 INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-123456789', 'name': 'Certified ScrumMaster<sup>®</sup> (CSM) Classroom', 'training_type_txt': 'Classroom', 'display_total_price': '599.00', 'price': '599.00'}] INFO  setup:test_orders_and_payment_flow.py:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[V] 78.70
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: DE ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "(//div[@class='card']//a[contains(text(),'Enroll Now')])") on url https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training is not visible INFO  setup:test_orders_and_payment_flow.py:171 Enroll Now button is not Appearing
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[W] 146.01
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 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:133 Token No is: 7e4b3884cb53975675ce37a5058c7704aea8be393d06b330b360f4a438308926 INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-123456789', 'name': 'CISA<sup>®</sup> Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '2,799.00', 'price': '2799.00'}] INFO  setup:test_orders_and_payment_flow.py:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[Y] 146.95
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 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:133 Token No is: 8d537fc3c6dd5347352136d83fdc4047cb79c1aebb2137b097e6c3b93ed649ce INFO  setup:test_orders_and_payment_flow.py:143 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:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[Z] 221.14
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/csm-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/csm-certification-training is not visible 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ({'course_name': 'Certified ScrumMaster® (CSM)', 'course_type': 'Jul 26 - Jul 28\n(2 days) Classroom', 'base_price': '$ 599.00', 'final_price': '646.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:133 Token No is: ba8c919e9fca2788ef91bce1a3a68a015fb7fbd710beffc71ccbab7594b4c79a INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+49-123456789', 'name': 'Certified ScrumMaster<sup>®</sup> (CSM) Classroom', 'training_type_txt': 'Classroom', 'display_total_price': '599.00', 'price': '646.92'}] INFO  setup:test_orders_and_payment_flow.py:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AA] 78.91
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: SG ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "(//div[@class='card']//a[contains(text(),'Enroll Now')])") on url https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training is not visible INFO  setup:test_orders_and_payment_flow.py:171 Enroll Now button is not Appearing
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AB] 167.39
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 Url Opened is: https://www.simplilearn.com/cyber-security/cisa-certification-training INFO  setup:orders_page.py:30 Country Set to: SG INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 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:133 Token No is: a436ecdbf23ac4c67824251fc4f32fa4da9521c7f8244edacecfcfe0aaacefb5 INFO  setup:test_orders_and_payment_flow.py:143 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': '3022.92'}] INFO  setup:test_orders_and_payment_flow.py:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AE] 221.45
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/csm-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/csm-certification-training is not visible 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ({'course_name': 'Certified ScrumMaster® (CSM)', 'course_type': 'Jul 26 - Jul 28\n(2 days) Classroom', 'base_price': '$ 599.00', 'final_price': '599.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:133 Token No is: ba52ddf8dc19b04a2e64f11cad69ee7aa3d39c47e8857c515fbb3b916ff86c42 INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+971-123456789', 'name': 'Certified ScrumMaster<sup>®</sup> (CSM) Classroom', 'training_type_txt': 'Classroom', 'display_total_price': '599.00', 'price': '599.00'}] INFO  setup:test_orders_and_payment_flow.py:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AF] 79.92
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: AE ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//button[contains(text(),'Enroll now')]") on url https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "(//div[@class='card']//a[contains(text(),'Enroll Now')])") on url https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training is not visible INFO  setup:test_orders_and_payment_flow.py:171 Enroll Now button is not Appearing
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AH] 146.35
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:116 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:233 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 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:133 Token No is: 3e98e7e91f5dd32e6ee1aae191fd4aeaf869c596f57527f01da7de644675d1aa INFO  setup:test_orders_and_payment_flow.py:143 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:359 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[A] 142.32
------------------------------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 463, 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:451 Url Opened is: https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training INFO  setup:orders_page.py:30 Country Set to: IN ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:345 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 8e0ff09931899a2a0d2c072e4bde56d0cb3dbbcbd4a30e72e0c123b9b95eabcf INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[B] 141.75
------------------------------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 463, 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:451 Url Opened is: https://www.simplilearn.com/automation-testing-masters-program-certification-training-course INFO  setup:orders_page.py:30 Country Set to: IN ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/automation-testing-masters-program-certification-training-course is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/automation-testing-masters-program-certification-training-course is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:345 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 33eb1fcb036166d14f8fa72738a6d6cd50bbda367ca16f3084c9ff3cde774cda INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[C] 142.07
------------------------------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 463, 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:451 Url Opened is: https://www.simplilearn.com/ui-ux-design-masters-program-certification-course INFO  setup:orders_page.py:30 Country Set to: IN ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/ui-ux-design-masters-program-certification-course is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/ui-ux-design-masters-program-certification-course is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:345 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 0e70a8219bc1203a7b97eb08bdca864388509e1e84e0522a0bae853c2981b248 INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[D] 70.19
------------------------------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 463, 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:451 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:345 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: a1a94689d9f2139a456c85e5b0e3a70fa41e27e74eb376553270d712676e2aeb INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[E] 146.72
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 Url Opened is: https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training INFO  setup:orders_page.py:30 Country Set to: US ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 405215a53b99b45c5171427420e9b7268ae49dd1976f36c5f1653e1cb4d0230d INFO  setup:test_orders_and_payment_flow.py:477 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': '1,499.00', 'price': '1499.00'}] INFO  setup:test_orders_and_payment_flow.py:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[F] 160.53
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 Url Opened is: https://www.simplilearn.com/automation-testing-masters-program-certification-training-course INFO  setup:orders_page.py:30 Country Set to: US ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/automation-testing-masters-program-certification-training-course is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/automation-testing-masters-program-certification-training-course is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 0d35982bef11d0e45a4f7632e15d0c22e59ff812af1d47e36415f3074cd00bd1 INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[G] 146.30
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 Url Opened is: https://www.simplilearn.com/ui-ux-design-masters-program-certification-course INFO  setup:orders_page.py:30 Country Set to: US ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/ui-ux-design-masters-program-certification-course is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/ui-ux-design-masters-program-certification-course is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 852d60f501e65a0590912ba2396c69eefb39db5383cb88ae4026c3cf578c1645 INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[H] 74.09
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: c4f8b8f426b2094b0f7a7632ba5cb927ebbb074dc13d701a0e628a741912f66b INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[I] 178.80
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 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 ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 7671c10e99c94ce0b46973201b4904d3eb401396fcc154626c82dba65ad01a6c INFO  setup:test_orders_and_payment_flow.py:477 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789', 'name': 'Full Stack Web Developer - MEAN Stack Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '1,390.00', 'price': '1390.00'}] INFO  setup:test_orders_and_payment_flow.py:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[J] 178.48
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 Url Opened is: https://www.simplilearn.com/automation-testing-masters-program-certification-training-course INFO  setup:orders_page.py:30 Country Set to: GB ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/automation-testing-masters-program-certification-training-course is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/automation-testing-masters-program-certification-training-course is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 07185d033023fcb9b9a776cc0666dae7634d8e5db9ea1f28d4e0a8bb4eca22f5 INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[K] 178.11
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 Url Opened is: https://www.simplilearn.com/ui-ux-design-masters-program-certification-course INFO  setup:orders_page.py:30 Country Set to: GB ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/ui-ux-design-masters-program-certification-course is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/ui-ux-design-masters-program-certification-course is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: be45a191b832d9923741900a1796f3379ab9e1ea2d11b28ad60455835dd34b81 INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[L] 109.17
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 147c004cd51243a693f0feeab7323382068b07520717945ef0d57ee2165089ac INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[M] 178.78
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 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 ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 9dd28c7f55e9cc1326e3228c3e3a74e09480429f4ff673cb16caad223c0bd49f INFO  setup:test_orders_and_payment_flow.py:477 RAW SQL Data: [{'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789', 'name': 'Full Stack Web Developer - MEAN Stack Online Classroom Flexi-Pass', 'training_type_txt': 'Online Classroom Flexi-Pass', 'display_total_price': '1,605.00', 'price': '1605.00'}] INFO  setup:test_orders_and_payment_flow.py:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[N] 178.68
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 Url Opened is: https://www.simplilearn.com/automation-testing-masters-program-certification-training-course INFO  setup:orders_page.py:30 Country Set to: AU ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/automation-testing-masters-program-certification-training-course is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/automation-testing-masters-program-certification-training-course is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: f70f18b26ba74e1694d36d3edc5f1a2e6f39390253354f89b96a7f034d5a30f3 INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[O] 178.82
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 Url Opened is: https://www.simplilearn.com/ui-ux-design-masters-program-certification-course INFO  setup:orders_page.py:30 Country Set to: AU ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/ui-ux-design-masters-program-certification-course is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/ui-ux-design-masters-program-certification-course is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: e7a994603ca2d6407f8582dadf6943b166e3f7027c4e2384e1edf0d92eb6fc8a INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[P] 106.92
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: c9d2040b833788a9f318816ff1903dc0ac8ef589b2a4c3fd072daeb50de95c99 INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[Q] 178.52
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 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 ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 8991e8881c34436d5a86e76cb568dbd14b045d395e9ead992206201dda203560 INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[R] 177.23
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 Url Opened is: https://www.simplilearn.com/automation-testing-masters-program-certification-training-course INFO  setup:orders_page.py:30 Country Set to: DE ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/automation-testing-masters-program-certification-training-course is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/automation-testing-masters-program-certification-training-course is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 9178e824adf805d1e6a80ee93f9a552346a2a5c06230ca40b1d7cfc731c6e97d INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[S] 176.97
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 Url Opened is: https://www.simplilearn.com/ui-ux-design-masters-program-certification-course INFO  setup:orders_page.py:30 Country Set to: DE ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/ui-ux-design-masters-program-certification-course is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/ui-ux-design-masters-program-certification-course is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: aed9a315bfedfadbd335846546779941e4050479f2318bc61ec912ba57be6f48 INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[T] 104.92
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 053aa152c14ba3e3a31c8926ca90bfdacd217641938a99f5f455d00d864bfd0f INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[U] 177.54
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 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 ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: d569f00117bb3a26f6d59804de8622c534e209bebaf29f351742d7dd1a1e9d47 INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[V] 179.96
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 Url Opened is: https://www.simplilearn.com/automation-testing-masters-program-certification-training-course INFO  setup:orders_page.py:30 Country Set to: SG ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/automation-testing-masters-program-certification-training-course is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/automation-testing-masters-program-certification-training-course is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 4baaa6afd6575813455161e5ea80be7b4c251b00ec85d7fdb019c8257c9c5100 INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[W] 174.09
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 Url Opened is: https://www.simplilearn.com/ui-ux-design-masters-program-certification-course INFO  setup:orders_page.py:30 Country Set to: SG ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/ui-ux-design-masters-program-certification-course is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/ui-ux-design-masters-program-certification-course is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 89a730945fd397eef112b3c93b55205483aada16c1dc137a4b1f0bfd2a3c8f68 INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[X] 171.02
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 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:164 Payment Page is not Loaded INFO  setup:orders_page.py:165 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjUtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:orders_page.py:175 clicked on Enroll Now button for Masters Program again INFO  setup:orders_page.py:178 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 5c907f00b796972d71dcdaefab50dcce818e76729c514fbf4505b22986948953 INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[Y] 177.35
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 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 ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/full-stack-web-developer-mean-stack-certification-training is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 4bc8799ac2bf5993faf45af523a44a3a3492eac41f0067e30a7c76a16a0c4979 INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[Z] 177.15
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 Url Opened is: https://www.simplilearn.com/automation-testing-masters-program-certification-training-course INFO  setup:orders_page.py:30 Country Set to: AE ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/automation-testing-masters-program-certification-training-course is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/automation-testing-masters-program-certification-training-course is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 30521dd7dd2e392e483deca617122d920953a454fff519ac9c68de243c07df7c INFO  setup:test_orders_and_payment_flow.py:477 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:703 Verifiaction Status Log Message: ['DB Verification Successfull']
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[AA] 177.29
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 Url Opened is: https://www.simplilearn.com/ui-ux-design-masters-program-certification-course INFO  setup:orders_page.py:30 Country Set to: AE ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/ui-ux-design-masters-program-certification-course is not visible ERROR  setup:selenium_helper.py:113 Message: WARNING  setup:selenium_helper.py:114 the locator ('xpath', "//form[@id='frmBundles']//a") on url https://www.simplilearn.com/ui-ux-design-masters-program-certification-course is not visible 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:566 <class 'tuple'> INFO  setup:ssvc_cart_page.py:367 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 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:467 Token No is: 96631de88b1d7c202489d83f14f427e360a18823b0d5f2297cbc09744a80a745 INFO  setup:test_orders_and_payment_flow.py:477 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:703 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.58
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:55 Total rows present in file are 63 INFO  setup:test_orders_and_payment_flow.py:71 Total certification program urls are 35 INFO  setup:test_orders_and_payment_flow.py:73 Total testcases passes is 35 INFO  setup:test_orders_and_payment_flow.py:74 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-25');
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:390 Total rows present in file are 63 INFO  setup:test_orders_and_payment_flow.py:406 Total master program urls are 27 INFO  setup:test_orders_and_payment_flow.py:408 Total testcases passes is 27 INFO  setup:test_orders_and_payment_flow.py:409 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', '27', '27', '0', '2023-07-25');