report.html

Report generated on 18-Mar-2023 at 01:52:12 by pytest-html v2.1.1

Environment

Packages {"pluggy": "0.13.1", "py": "1.9.0", "pytest": "6.1.0"}
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"}
Python 3.8.5

Summary

63 tests ran in 6726.67 seconds.

(Un)check the boxes to filter the results.

60 passed, 0 skipped, 3 failed, 0 errors, 0 expected failures, 0 unexpected passes

Results

Show all details / Hide all details

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

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

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

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

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

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

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

# Step 04: Validate the Dynamo db and MySql data for the payment
token_no = pytest.driver.current_url.split('authtoken=')[-1]
logging.info(f"Token No is: {token_no}")
query = testdata['sql_query'].replace('<token_no>',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")

message = self.verify_mySQL_data_certification(course_data[0],sql_items,sql_data,testdata)
if 'successfull' in message[0].lower():
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)
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:
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:
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:
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:136: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:55 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:66 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 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/secure/checkout/details/error?authtoken=0bb2e8694ee1e09d8313af1f0b22284177658e4c70ddc7b9c90cdcacf88f5a8d 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/secure/checkout/details/error?authtoken=93e772ce1714771cdc4644c654e40158d87982fee185f176b74ab0df2a32e09c 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/secure/checkout/details/error?authtoken=93e772ce1714771cdc4644c654e40158d87982fee185f176b74ab0df2a32e09c is not visible INFO  setup:test_orders_and_payment_flow.py:74 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:77 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:81 Token No is: 93e772ce1714771cdc4644c654e40158d87982fee185f176b74ab0df2a32e09c INFO  setup:test_orders_and_payment_flow.py:85 RAW SQL Data: [{'items': 'a:1:{i:0;a:28:{s:2:"id";s:1:"4";s:4:"name";s:50:"Certified ScrumMaster<sup>®</sup> (CSM) Classroom";s:11:"description";s:4:" - 1";s:5:"price";s:6:"549.00";s:9:"basePrice";s:3:"549";s:19:"display_total_price";s:6:"549.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:9:"classroom";s:15:"trainingType_id";s:1:"1";s:10:"workshopId";s:7:"1732669";s:5:"venue";s:3:"TBD";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:40:"Certified ScrumMaster<sup>®</sup> (CSM)";s:11:"billingType";i:1;s:7:"img_url";s:77:"https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-CSM.svgz";s:10:"course_url";s:43:"/agile-and-scrum/csm-certification-training";s:17:"training_type_txt";s:9:"Classroom";s:4:"from";s:10:"2023-03-18";s:2:"to";s:10:"2023-03-19";s:4:"days";i:2;s:9:"isExpired";i:0;s:6:"isSold";i:0;s:13:"workshopDates";N;s:16:"primary_label_id";s:1:"9";s:18:"primary_label_name";s:15:"Agile and Scrum";s:12:"cateforyInfo";a:1:{i:9;s:15:"Agile and Scrum";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+1-123456789'}] INFO  setup:test_orders_and_payment_flow.py:87 SQL DATA in JSON format: {'id': '4', 'name': 'Certified ScrumMaster (CSM) Classroom', 'description': ' - 1', 'price': '549.00', 'basePrice': '549', 'display_total_price': '549.00', 'quantity': 'isEarlyBird', 'type': 'classroom', 'trainingType_id': '1', 'workshopId': '1732669', 'venue': 'TBD', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'Certified ScrumMaster (CSM)', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-CSM.svgz', 'course_url': '/agile-and-scrum/csm-certification-training', 'training_type_txt': 'Classroom', 'from': '2023-03-18', 'to': '2023-03-19', 'days': 'isExpired', 'isSold': 'workshopDates', 'primary_label_id': '9', 'primary_label_name': 'Agile and Scrum'} ERROR  setup:test_orders_and_payment_flow.py:282 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 246, in verify_mySQL_data_certification if self.remove_special_character(course_data['course_name']) in self.remove_special_character(sql_items['name']): TypeError: string indices must be integers INFO  setup:test_orders_and_payment_flow.py:284 Verifiaction Status Log Message: [] ERROR  setup:test_orders_and_payment_flow.py:114 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 90, in test_Orders_and_Payment_Flow_certification if 'successfull' in message[0].lower(): IndexError: list index out of range
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[U] 205.55
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000001B78D8C23A0>
value = 'U', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

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

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

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

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

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

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

# Step 04: Validate the Dynamo db and MySql data for the payment
token_no = pytest.driver.current_url.split('authtoken=')[-1]
logging.info(f"Token No is: {token_no}")
query = testdata['sql_query'].replace('<token_no>',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")

message = self.verify_mySQL_data_certification(course_data[0],sql_items,sql_data,testdata)
if 'successfull' in message[0].lower():
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)
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:
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:
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:
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:136: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:55 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:66 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 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/secure/checkout/details/error?authtoken=a09e5b6afe0e2076ccbb5d8f1cedd8471369b1cebf579aad36129ccce09c38ae 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/secure/checkout/details/error?authtoken=563cdbfaaeba1b3e229392e0bfb15f1e24a207e22c8119a658f6f86707bf3784 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/secure/checkout/details/error?authtoken=563cdbfaaeba1b3e229392e0bfb15f1e24a207e22c8119a658f6f86707bf3784 is not visible INFO  setup:test_orders_and_payment_flow.py:74 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:77 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:81 Token No is: 563cdbfaaeba1b3e229392e0bfb15f1e24a207e22c8119a658f6f86707bf3784 INFO  setup:test_orders_and_payment_flow.py:85 RAW SQL Data: [{'items': 'a:1:{i:0;a:28:{s:2:"id";s:1:"4";s:4:"name";s:50:"Certified ScrumMaster<sup>®</sup> (CSM) Classroom";s:11:"description";s:4:" - 1";s:5:"price";s:6:"599.00";s:9:"basePrice";s:3:"599";s:19:"display_total_price";s:6:"599.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:9:"classroom";s:15:"trainingType_id";s:1:"1";s:10:"workshopId";s:7:"1732676";s:5:"venue";s:3:"TBD";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:40:"Certified ScrumMaster<sup>®</sup> (CSM)";s:11:"billingType";i:1;s:7:"img_url";s:77:"https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-CSM.svgz";s:10:"course_url";s:43:"/agile-and-scrum/csm-certification-training";s:17:"training_type_txt";s:9:"Classroom";s:4:"from";s:10:"2023-03-18";s:2:"to";s:10:"2023-03-19";s:4:"days";i:2;s:9:"isExpired";i:0;s:6:"isSold";i:0;s:13:"workshopDates";N;s:16:"primary_label_id";s:1:"9";s:18:"primary_label_name";s:15:"Agile and Scrum";s:12:"cateforyInfo";a:1:{i:9;s:15:"Agile and Scrum";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-123456789'}] INFO  setup:test_orders_and_payment_flow.py:87 SQL DATA in JSON format: {'id': '4', 'name': 'Certified ScrumMaster (CSM) Classroom', 'description': ' - 1', 'price': '599.00', 'basePrice': '599', 'display_total_price': '599.00', 'quantity': 'isEarlyBird', 'type': 'classroom', 'trainingType_id': '1', 'workshopId': '1732676', 'venue': 'TBD', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'Certified ScrumMaster (CSM)', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-CSM.svgz', 'course_url': '/agile-and-scrum/csm-certification-training', 'training_type_txt': 'Classroom', 'from': '2023-03-18', 'to': '2023-03-19', 'days': 'isExpired', 'isSold': 'workshopDates', 'primary_label_id': '9', 'primary_label_name': 'Agile and Scrum'} ERROR  setup:test_orders_and_payment_flow.py:282 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 246, in verify_mySQL_data_certification if self.remove_special_character(course_data['course_name']) in self.remove_special_character(sql_items['name']): TypeError: string indices must be integers INFO  setup:test_orders_and_payment_flow.py:284 Verifiaction Status Log Message: [] ERROR  setup:test_orders_and_payment_flow.py:114 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 90, in test_Orders_and_Payment_Flow_certification if 'successfull' in message[0].lower(): IndexError: list index out of range
Failed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AI] 132.61
self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000001B78DA30C40>
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()
pytest.driver.get(url_value)
logging.info(f"Url Opened is: {url_value}")
selenium_helper.wait_for_page_to_load(10,value)
self.pg_orders.change_country(country_value)

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

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

# Step 04: Validate the Dynamo db and MySql data for the payment
token_no = pytest.driver.current_url.split('authtoken=')[-1]
logging.info(f"Token No is: {token_no}")
query = testdata['sql_query'].replace('<token_no>',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")

message = self.verify_mySQL_data_certification(course_data[0],sql_items,sql_data,testdata)
if 'successfull' in message[0].lower():
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)
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:
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:
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:
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:136: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:55 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:66 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.bootcamp-sl.discover.online.purdue.edu/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg==&_gl=1*186mf8o*_ga*MTk3NzY2MjYzNy4xNjc5MDgxMTYy*_ga_CG9EYRX7VL*MTY3OTA4MTE2MS4xLjEuMTY3OTA4MTE4OC4zMy4wLjA. 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.bootcamp-sl.discover.online.purdue.edu/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg==&_gl=1*gwk30g*_ga*MTk3NzY2MjYzNy4xNjc5MDgxMTYy*_ga_CG9EYRX7VL*MTY3OTA4MTE2MS4xLjEuMTY3OTA4MTIyMC4xLjAuMA.. 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.bootcamp-sl.discover.online.purdue.edu/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg==&_gl=1*gwk30g*_ga*MTk3NzY2MjYzNy4xNjc5MDgxMTYy*_ga_CG9EYRX7VL*MTY3OTA4MTE2MS4xLjEuMTY3OTA4MTIyMC4xLjAuMA.. is not visible INFO  setup:test_orders_and_payment_flow.py:74 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:77 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:81 Token No is: https://www.bootcamp-sl.discover.online.purdue.edu/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg==&_gl=1*gwk30g*_ga*MTk3NzY2MjYzNy4xNjc5MDgxMTYy*_ga_CG9EYRX7VL*MTY3OTA4MTE2MS4xLjEuMTY3OTA4MTIyMC4xLjAuMA.. INFO  setup:test_orders_and_payment_flow.py:85 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:114 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 86, in test_Orders_and_Payment_Flow_certification sql_items = self.convert_items_to_json(sql_data) File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 168, in convert_items_to_json data = (data[0]['items']) IndexError: list index out of range
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[A] 108.18
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[B] 61.23
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[C] 56.47
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[D] 55.83
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[E] 88.56
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[F] 106.75
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[G] 65.94
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[H] 66.45
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[I] 65.63
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[J] 66.28
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[L] 94.99
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[M] 96.07
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[N] 94.65
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[O] 94.96
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[P] 138.55
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[Q] 94.21
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[R] 94.47
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[S] 94.24
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[T] 95.34
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[V] 93.30
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[W] 93.11
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[X] 93.70
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[Y] 93.33
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[Z] 136.34
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AA] 92.50
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AB] 93.78
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AC] 93.29
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AD] 94.52
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AE] 136.43
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AF] 92.73
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AG] 92.63
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowCertificationProgram::test_Orders_and_Payment_Flow_certification[AH] 92.89
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[A] 98.31
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[B] 98.28
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[C] 98.72
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[D] 55.48
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[E] 106.75
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[F] 106.29
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[G] 104.21
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[H] 64.54
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[I] 137.05
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[J] 135.58
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[K] 137.05
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[L] 94.63
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[M] 137.46
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[N] 136.55
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[O] 137.34
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[P] 94.71
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[Q] 135.37
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[R] 135.07
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[S] 134.18
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[T] 92.89
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[U] 134.84
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[V] 133.78
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[W] 136.03
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[X] 93.02
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[Y] 135.13
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[Z] 135.57
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[AA] 135.17
Passed test_orders_and_payment_flow.py::TestOrderAndPaymentFlowMastersProgram::test_Orders_and_Payment_Flow_masters_program[AB] 92.87