report.html

self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x00000178FB5D12B0>
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")
def test_Orders_and_Payment_Flow_certification(self,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')
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
with open("Orders_and_Payment_Flow_Certification.txt") as file:
counter = 0
for url in file:
country_list = testdata['country']
for country in country_list:
try:
pytest.driver.delete_all_cookies()
pytest.driver.get(url)
logging.info(f"Url Opened is: {url}")
selenium_helper.wait_for_page_to_load(10,url)
self.pg_orders.change_country(country)

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)
course_data = self._complete_payment(country,testdata['payment_type'],testdata['name'],testdata['email_id'],testdata['contact_no'])
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'
# course_type = sql_items['training_type_txt']
rows = [[country.upper(),course_name,course_type,url,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 '/details?authtoken' not in pytest.driver.current_url and selenium_helper.is_locator_present(self.pg_orders.locators['btn_enroll_now_cohort_classes'],3) != True and selenium_helper.is_locator_present(self.pg_orders.locators['btn_enroll_now'],3) != True:
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.upper(),course_name,course_type,url,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.upper(),course_name,course_type,url,'','','','Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
elif len (course_data) == 1:
rows = [[country.upper(),course_name,course_type,url,'',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.upper(),course_name,course_type,url,'',course_data[1][0],course_data[1][1],'Fail']]
with open(filename, 'a', newline='\n') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(rows)
continue

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

test_prod\test_orders_and_payment_flow.py:119: Failed
------------------------------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 136: 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 187, in console_main code = main() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\config\__init__.py", line 164, in main ret = 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 306, 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 257, 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 313, 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 338, 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 110, in pytest_runtest_protocol runtestprotocol(item, nextitem=nextitem) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 127, 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 216, 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 255, in call_runtest_hook return CallInfo.from_call( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 310, in from_call result = func() # type: Optional[TResult] File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 256, 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 163, in pytest_runtest_call item.runtest() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\python.py", line 1627, 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 184, in pytest_pyfunc_call result = testfunction(**testargs) File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 58, in test_Orders_and_Payment_Flow_certification logging.info(f"course_data: {course_data}") Message: "course_data: ({'course_name': 'PMI-ACP®', 'course_type': 'Online Self Learning', 'base_price': '₹ 11,940.00', 'final_price': '14,089.20'}, (['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': 'Payment CTA appearing'}, {'EMI': 'Payment CTA appearing'}, {'CCAvenue': 'Payment CTA appearing'}]))" Arguments: () --- 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 133: 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 187, in console_main code = main() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\config\__init__.py", line 164, in main ret = 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 306, 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 257, 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 313, 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 338, 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 110, in pytest_runtest_protocol runtestprotocol(item, nextitem=nextitem) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 127, 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 216, 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 255, in call_runtest_hook return CallInfo.from_call( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 310, in from_call result = func() # type: Optional[TResult] File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 256, 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 163, in pytest_runtest_call item.runtest() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\python.py", line 1627, 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 184, in pytest_pyfunc_call result = testfunction(**testargs) File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 58, in test_Orders_and_Payment_Flow_certification logging.info(f"course_data: {course_data}") Message: "course_data: ({'course_name': 'CISA®', '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': 'Payment CTA appearing'}, {'EMI': 'Payment CTA appearing'}, {'CCAvenue': 'Payment CTA appearing'}, {'ShopSE EMI': 'Payment CTA appearing'}]))" Arguments: () --- 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 187, in console_main code = main() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\config\__init__.py", line 164, in main ret = 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 306, 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 257, 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 313, 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 338, 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 110, in pytest_runtest_protocol runtestprotocol(item, nextitem=nextitem) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 127, 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 216, 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 255, in call_runtest_hook return CallInfo.from_call( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 310, in from_call result = func() # type: Optional[TResult] File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 256, 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 163, in pytest_runtest_call item.runtest() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\python.py", line 1627, 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 184, in pytest_pyfunc_call result = testfunction(**testargs) File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 58, 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': 'Payment CTA appearing'}, {'EMI': 'Payment CTA appearing'}, {'CCAvenue': 'Payment CTA appearing'}, {'ShopSE EMI': 'Payment CTA appearing'}]))" Arguments: () --- 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 187, in console_main code = main() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\config\__init__.py", line 164, in main ret = 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 306, 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 257, 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 313, 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 338, 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 110, in pytest_runtest_protocol runtestprotocol(item, nextitem=nextitem) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 127, 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 216, 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 255, in call_runtest_hook return CallInfo.from_call( File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 310, in from_call result = func() # type: Optional[TResult] File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\runner.py", line 256, 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 163, in pytest_runtest_call item.runtest() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\_pytest\python.py", line 1627, 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 184, in pytest_pyfunc_call result = testfunction(**testargs) File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 58, 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': 'Payment CTA appearing'}, {'EMI': 'Payment CTA appearing'}, {'CCAvenue': 'Payment CTA appearing'}, {'ShopSE EMI': 'Payment CTA appearing'}]))" Arguments: ()
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:37 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:48 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 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/index?auh=LCw%3D 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/index?auh=LCw%3D 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/index?auh=LCw%3D is not visible INFO  setup:test_orders_and_payment_flow.py:58 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: https://www.simplilearn.com/cart/index?auh=LCw%3D INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:97 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 67, 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 162, in convert_items_to_json data = (data[0]['items']) IndexError: list index out of range INFO  setup:test_orders_and_payment_flow.py:48 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 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'Certified ScrumMaster® (CSM)', 'course_type': 'Jan 21 - Jan 22\n(2 days) Classroom', 'base_price': '$ 599.00', 'final_price': '599.00'}, (['Credit Card', 'Paypal', 'Affirm', 'Klarna', 'Splitit'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}, {'Affirm': 'Payment CTA appearing '}, {'Split_it': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 80c6c8c35a8a45bb7dc3faa75ca3534c28ed6594199ac70e4b5bf56f8788d9a4 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:28:{s:2:"id";s:1:"4";s:4:"name";s:50:"Certified ScrumMaster^® (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:"1725261";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^® (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-01-21";s:2:"to";s:10:"2023-01-22";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:68 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': '1725261', '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-01-21', 'to': '2023-01-22', 'days': 'isExpired', 'isSold': 'workshopDates', 'primary_label_id': '9', 'primary_label_name': 'Agile and Scrum'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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:41 Payment Page Loaded 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=c46111dec5de82a197f39da8ff6ef080151f006df8d293d40766a6931f2f89b6 is not visible INFO  setup:test_orders_and_payment_flow.py:58 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: c46111dec5de82a197f39da8ff6ef080151f006df8d293d40766a6931f2f89b6 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:28:{s:2:"id";s:1:"4";s:4:"name";s:50:"Certified ScrumMaster^® (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:"1724487";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^® (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-01-21";s:2:"to";s:10:"2023-01-22";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:68 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': '1724487', '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-01-21', 'to': '2023-01-22', 'days': 'isExpired', 'isSold': 'workshopDates', 'primary_label_id': '9', 'primary_label_name': 'Agile and Scrum'} ERROR  setup:test_orders_and_payment_flow.py:276 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 240, 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:278 Verifiaction Status Log Message: [] ERROR  setup:test_orders_and_payment_flow.py:97 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 71, in test_Orders_and_Payment_Flow_certification if 'successfull' in message[0].lower(): IndexError: list index out of range INFO  setup:test_orders_and_payment_flow.py:48 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 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'Certified ScrumMaster® (CSM)', 'course_type': 'Jan 21 - Jan 22\n(2 days) Classroom', 'base_price': 'A$ 799.00', 'final_price': '799.00'}, (['Credit Card', 'Paypal', 'Splitit'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}, {'Split_it': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 16e8faf1e7f6b672f8d3ab0aba3f55910b754797b57fae5dcb3b12a9260795b1 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:28:{s:2:"id";s:1:"4";s:4:"name";s:50:"Certified ScrumMaster^® (CSM) Classroom";s:11:"description";s:4:" - 1";s:5:"price";s:6:"799.00";s:9:"basePrice";s:3:"799";s:19:"display_total_price";s:6:"799.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:"1724482";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^® (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-01-21";s:2:"to";s:10:"2023-01-22";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:68 SQL DATA in JSON format: {'id': '4', 'name': 'Certified ScrumMaster (CSM) Classroom', 'description': ' - 1', 'price': '799.00', 'basePrice': '799', 'display_total_price': '799.00', 'quantity': 'isEarlyBird', 'type': 'classroom', 'trainingType_id': '1', 'workshopId': '1724482', '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-01-21', 'to': '2023-01-22', 'days': 'isExpired', 'isSold': 'workshopDates', 'primary_label_id': '9', 'primary_label_name': 'Agile and Scrum'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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=751f04b8871a5d05959af44abdee7658dc4cf54e3e23d68b71bbc92cbaac75af 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=ef57c992a60ca57443ed0b2cbab626c531f2299b57248fec7858c69c19bf6cdf 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=ef57c992a60ca57443ed0b2cbab626c531f2299b57248fec7858c69c19bf6cdf is not visible INFO  setup:test_orders_and_payment_flow.py:58 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: ef57c992a60ca57443ed0b2cbab626c531f2299b57248fec7858c69c19bf6cdf INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:28:{s:2:"id";s:1:"4";s:4:"name";s:50:"Certified ScrumMaster^® (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:"1724494";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^® (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-01-21";s:2:"to";s:10:"2023-01-22";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:68 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': '1724494', '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-01-21', 'to': '2023-01-22', 'days': 'isExpired', 'isSold': 'workshopDates', 'primary_label_id': '9', 'primary_label_name': 'Agile and Scrum'} ERROR  setup:test_orders_and_payment_flow.py:276 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 240, 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:278 Verifiaction Status Log Message: [] ERROR  setup:test_orders_and_payment_flow.py:97 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 71, in test_Orders_and_Payment_Flow_certification if 'successfull' in message[0].lower(): IndexError: list index out of range INFO  setup:test_orders_and_payment_flow.py:48 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 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'Certified ScrumMaster® (CSM)', 'course_type': 'Jan 21 - Jan 22\n(2 days) Classroom', 'base_price': '$ 599.00', 'final_price': '646.92'}, (['Credit Card', 'Paypal', 'Splitit', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}, {'2checkout': 'Payment CTA appearing '}, {'Split_it': 'All option clickable and Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: ee6f3427c56f86eb795e963b5258fe4c1396b69e344987a985c6e2d73ac74a96 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:28:{s:2:"id";s:1:"4";s:4:"name";s:50:"Certified ScrumMaster^® (CSM) Classroom";s:11:"description";s:4:" - 1";s:5:"price";s:6:"646.92";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:"1724499";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^® (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-01-21";s:2:"to";s:10:"2023-01-22";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:68 SQL DATA in JSON format: {'id': '4', 'name': 'Certified ScrumMaster (CSM) Classroom', 'description': ' - 1', 'price': '646.92', 'basePrice': '599', 'display_total_price': '599.00', 'quantity': 'isEarlyBird', 'type': 'classroom', 'trainingType_id': '1', 'workshopId': '1724499', '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-01-21', 'to': '2023-01-22', 'days': 'isExpired', 'isSold': 'workshopDates', 'primary_label_id': '9', 'primary_label_name': 'Agile and Scrum'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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 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:156 <class 'tuple'> ERROR  setup:test_orders_and_payment_flow.py:97 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 55, in test_Orders_and_Payment_Flow_certification course_data = self._complete_payment(country,testdata['payment_type'],testdata['name'],testdata['email_id'],testdata['contact_no']) File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 158, in _complete_payment self.pg_ssv_cart.complete_payment(country) File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 329, in complete_payment self.select_credit_card_row_validity_month.select_element_by_value("08") File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 123, in select_element_by_value select.select_by_value(value) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\support\select.py", line 82, in select_by_value self._setSelected(opt) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\support\select.py", line 212, in _setSelected option.click() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 80, in click self._execute(Command.CLICK_ELEMENT) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 633, in _execute return self._parent.execute(command, params) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webdriver.py", line 321, in execute self.error_handler.check_response(response) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\errorhandler.py", line 242, in check_response raise exception_class(message, screen, stacktrace) selenium.common.exceptions.StaleElementReferenceException: Message: stale element reference: element is not attached to the page document (Session info: chrome=109.0.5414.75) INFO  setup:test_orders_and_payment_flow.py:48 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: IN INFO  setup: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=40c2fb10d739a937633389800165bec231ed033a9b0c48937c5a3b02cd23e2d8 is not visible INFO  setup:test_orders_and_payment_flow.py:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:316 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'PMI-ACP®', 'course_type': 'Online Self Learning', 'base_price': '₹ 11,940.00', 'final_price': '14,089.20'}, (['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': 'Payment CTA appearing'}, {'EMI': 'Payment CTA appearing'}, {'CCAvenue': 'Payment CTA appearing'}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 40c2fb10d739a937633389800165bec231ed033a9b0c48937c5a3b02cd23e2d8 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:1:"9";s:4:"name";s:41:"PMI-ACP^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:8:"14089.20";s:9:"basePrice";s:16:"11940.0000000000";s:19:"display_total_price";s:9:"11,940.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:20:"PMI-ACP^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:81:"https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-PMI-ACP.svgz";s:10:"course_url";s:47:"/agile-and-scrum/pmi-acp-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";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': '+91-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '9', 'name': 'PMI-ACP Online Self Learning', 'description': ' - 1', 'price': '14089.20', 'basePrice': '11940.0000000000', 'display_total_price': '11,940.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'PMI-ACP', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-PMI-ACP.svgz', 'course_url': '/agile-and-scrum/pmi-acp-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '9', 'primary_label_name': 'Agile and Scrum'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: US INFO  setup: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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'PMI-ACP®', 'course_type': 'Online Self Learning', 'base_price': '$ 1,049.00', 'final_price': '1,049.00'}, (['Credit Card', 'Paypal', 'Klarna'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 4c0c3e114f50379d4ce8c24d2c4b577461257393f39a6d78b2a5db7afd605d47 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:1:"9";s:4:"name";s:41:"PMI-ACP^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"1049.00";s:9:"basePrice";s:15:"1049.0000000000";s:19:"display_total_price";s:8:"1,049.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:20:"PMI-ACP^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:81:"https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-PMI-ACP.svgz";s:10:"course_url";s:47:"/agile-and-scrum/pmi-acp-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";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:68 SQL DATA in JSON format: {'id': '9', 'name': 'PMI-ACP Online Self Learning', 'description': ' - 1', 'price': '1049.00', 'basePrice': '1049.0000000000', 'display_total_price': '1,049.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'PMI-ACP', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-PMI-ACP.svgz', 'course_url': '/agile-and-scrum/pmi-acp-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '9', 'primary_label_name': 'Agile and Scrum'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: GB INFO  setup: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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'PMI-ACP®', 'course_type': 'Online Self Learning', 'base_price': '£ 1,049.00', 'final_price': '1,049.00'}, (['Credit Card', 'Paypal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: aebc63e80c9342d2fc3007b0b71de7fc5a9f6d71dac09ab0ec9ae42baa8c14d3 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:1:"9";s:4:"name";s:41:"PMI-ACP^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"1049.00";s:9:"basePrice";s:9:"1049.0000";s:19:"display_total_price";s:8:"1,049.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:20:"PMI-ACP^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:81:"https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-PMI-ACP.svgz";s:10:"course_url";s:47:"/agile-and-scrum/pmi-acp-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";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': '+44-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '9', 'name': 'PMI-ACP Online Self Learning', 'description': ' - 1', 'price': '1049.00', 'basePrice': '1049.0000', 'display_total_price': '1,049.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'PMI-ACP', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-PMI-ACP.svgz', 'course_url': '/agile-and-scrum/pmi-acp-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '9', 'primary_label_name': 'Agile and Scrum'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: AU INFO  setup: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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'PMI-ACP®', 'course_type': 'Online Self Learning', 'base_price': 'A$ 1,049.00', 'final_price': '1,049.00'}, (['Credit Card', 'Paypal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 0310a870e6281719088f831c41cecd2411b4af7fcd67d71b0a7313891cc58143 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:1:"9";s:4:"name";s:41:"PMI-ACP^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"1049.00";s:9:"basePrice";s:15:"1049.0000000000";s:19:"display_total_price";s:8:"1,049.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:20:"PMI-ACP^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:81:"https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-PMI-ACP.svgz";s:10:"course_url";s:47:"/agile-and-scrum/pmi-acp-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";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:68 SQL DATA in JSON format: {'id': '9', 'name': 'PMI-ACP Online Self Learning', 'description': ' - 1', 'price': '1049.00', 'basePrice': '1049.0000000000', 'display_total_price': '1,049.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'PMI-ACP', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-PMI-ACP.svgz', 'course_url': '/agile-and-scrum/pmi-acp-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '9', 'primary_label_name': 'Agile and Scrum'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: DE INFO  setup: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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'PMI-ACP®', 'course_type': 'Online Self Learning', 'base_price': '€ 1,049.00', 'final_price': '1,049.00'}, (['Credit Card', 'Paypal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}, {'2checkout': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 782fc18e9be5f96bdeaf8a61025c37d259c40f2d43b2221ffcf886a5a8202c77 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:1:"9";s:4:"name";s:41:"PMI-ACP^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"1049.00";s:9:"basePrice";s:15:"1049.0000000000";s:19:"display_total_price";s:8:"1,049.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:20:"PMI-ACP^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:81:"https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-PMI-ACP.svgz";s:10:"course_url";s:47:"/agile-and-scrum/pmi-acp-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";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:68 SQL DATA in JSON format: {'id': '9', 'name': 'PMI-ACP Online Self Learning', 'description': ' - 1', 'price': '1049.00', 'basePrice': '1049.0000000000', 'display_total_price': '1,049.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'PMI-ACP', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-PMI-ACP.svgz', 'course_url': '/agile-and-scrum/pmi-acp-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '9', 'primary_label_name': 'Agile and Scrum'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: SG INFO  setup: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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'PMI-ACP®', 'course_type': 'Online Self Learning', 'base_price': '$ 1,049.00', 'final_price': '1,132.92'}, (['Credit Card', 'Paypal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}, {'2checkout': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: a0769f5eeb1aff39c5580a22944edaa65f727c482028525eca35ac27e2eebf00 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:1:"9";s:4:"name";s:41:"PMI-ACP^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"1132.92";s:9:"basePrice";s:15:"1049.0000000000";s:19:"display_total_price";s:8:"1,049.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:20:"PMI-ACP^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:81:"https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-PMI-ACP.svgz";s:10:"course_url";s:47:"/agile-and-scrum/pmi-acp-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";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:68 SQL DATA in JSON format: {'id': '9', 'name': 'PMI-ACP Online Self Learning', 'description': ' - 1', 'price': '1132.92', 'basePrice': '1049.0000000000', 'display_total_price': '1,049.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'PMI-ACP', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-PMI-ACP.svgz', 'course_url': '/agile-and-scrum/pmi-acp-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '9', 'primary_label_name': 'Agile and Scrum'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 Url Opened is: https://www.simplilearn.com/agile-and-scrum/pmi-acp-certification-training INFO  setup:orders_page.py:30 Country Set to: AE INFO  setup: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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'PMI-ACP®', 'course_type': 'Online Self Learning', 'base_price': '$ 1,049.00', 'final_price': '1,049.00'}, (['Credit Card', 'Paypal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}, {'2checkout': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 81a7001fa8279e24831fea288aae3cd6716d60dc04969b88ac9202b32ea3b54d INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:1:"9";s:4:"name";s:41:"PMI-ACP^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"1049.00";s:9:"basePrice";s:15:"1049.0000000000";s:19:"display_total_price";s:8:"1,049.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:20:"PMI-ACP^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:81:"https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-PMI-ACP.svgz";s:10:"course_url";s:47:"/agile-and-scrum/pmi-acp-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";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': '+971-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '9', 'name': 'PMI-ACP Online Self Learning', 'description': ' - 1', 'price': '1049.00', 'basePrice': '1049.0000000000', 'display_total_price': '1,049.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'PMI-ACP', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/AGILE-AND-SCRUM-PMI-ACP.svgz', 'course_url': '/agile-and-scrum/pmi-acp-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '9', 'primary_label_name': 'Agile and Scrum'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 Url Opened is: https://www.simplilearn.com/cyber-security/cisa-certification-training INFO  setup:orders_page.py:30 Country Set to: IN INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded INFO  setup:test_orders_and_payment_flow.py:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:316 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'CISA®', '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': 'Payment CTA appearing'}, {'EMI': 'Payment CTA appearing'}, {'CCAvenue': 'Payment CTA appearing'}, {'ShopSE EMI': 'Payment CTA appearing'}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 9587ac4bf88d86fde8868786da373c7fbe6065ec830a862c5267cd789f4ca588 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"32";s:4:"name";s:38:"CISA^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:9:"198859.50";s:9:"basePrice";s:17:"168525.0000000000";s:19:"display_total_price";s:10:"168,525.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:17:"CISA^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:67:"https://www.simplilearn.com/ice9/course_images/icons/ITSecCISA.svgz";s:10:"course_url";s:43:"/cyber-security/cisa-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:1:"3";s:18:"primary_label_name";s:14:"Cyber Security";s:12:"cateforyInfo";a:1:{i:3;s:14:"Cyber Security";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+91-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '32', 'name': 'CISA Online Self Learning', 'description': ' - 1', 'price': '198859.50', 'basePrice': '168525.0000000000', 'display_total_price': '168,525.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'CISA', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/ITSecCISA.svgz', 'course_url': '/cyber-security/cisa-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '3', 'primary_label_name': 'Cyber Security'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'CISA®', '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': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 4d49bd229bc7da516638da757c90a2983cf4917cb3319bfd38db061b780b969c INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"32";s:4:"name";s:38:"CISA^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"2200.00";s:9:"basePrice";s:15:"2200.0000000000";s:19:"display_total_price";s:8:"2,200.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:17:"CISA^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:67:"https://www.simplilearn.com/ice9/course_images/icons/ITSecCISA.svgz";s:10:"course_url";s:43:"/cyber-security/cisa-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:1:"3";s:18:"primary_label_name";s:14:"Cyber Security";s:12:"cateforyInfo";a:1:{i:3;s:14:"Cyber Security";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+1-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '32', 'name': 'CISA Online Self Learning', 'description': ' - 1', 'price': '2200.00', 'basePrice': '2200.0000000000', 'display_total_price': '2,200.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'CISA', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/ITSecCISA.svgz', 'course_url': '/cyber-security/cisa-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '3', 'primary_label_name': 'Cyber Security'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'CISA®', 'course_type': 'Online Self Learning', 'base_price': '£ 2,499.00', 'final_price': '2,499.00'}, (['Credit Card', 'Paypal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 3fe1ca030dbed5c4e22a7488b8d4cde3c69f135d667fd166aab9c487d83cdc79 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"32";s:4:"name";s:38:"CISA^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"2499.00";s:9:"basePrice";s:15:"2499.0000000000";s:19:"display_total_price";s:8:"2,499.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:17:"CISA^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:67:"https://www.simplilearn.com/ice9/course_images/icons/ITSecCISA.svgz";s:10:"course_url";s:43:"/cyber-security/cisa-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:1:"3";s:18:"primary_label_name";s:14:"Cyber Security";s:12:"cateforyInfo";a:1:{i:3;s:14:"Cyber Security";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '32', 'name': 'CISA Online Self Learning', 'description': ' - 1', 'price': '2499.00', 'basePrice': '2499.0000000000', 'display_total_price': '2,499.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'CISA', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/ITSecCISA.svgz', 'course_url': '/cyber-security/cisa-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '3', 'primary_label_name': 'Cyber Security'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'CISA®', 'course_type': 'Online Self Learning', 'base_price': 'A$ 2,675.00', 'final_price': '2,675.00'}, (['Credit Card', 'Paypal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 2413b3ca7d57c15ed56972db789bdd33799a586c441a4808ce82e34045766a17 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"32";s:4:"name";s:38:"CISA^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"2675.00";s:9:"basePrice";s:15:"2675.0000000000";s:19:"display_total_price";s:8:"2,675.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:17:"CISA^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:67:"https://www.simplilearn.com/ice9/course_images/icons/ITSecCISA.svgz";s:10:"course_url";s:43:"/cyber-security/cisa-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:1:"3";s:18:"primary_label_name";s:14:"Cyber Security";s:12:"cateforyInfo";a:1:{i:3;s:14:"Cyber Security";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '32', 'name': 'CISA Online Self Learning', 'description': ' - 1', 'price': '2675.00', 'basePrice': '2675.0000000000', 'display_total_price': '2,675.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'CISA', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/ITSecCISA.svgz', 'course_url': '/cyber-security/cisa-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '3', 'primary_label_name': 'Cyber Security'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'CISA®', 'course_type': 'Online Self Learning', 'base_price': '€ 2,499.00', 'final_price': '2,499.00'}, (['Credit Card', 'Paypal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}, {'2checkout': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 6dfc0482d140d8569b067f26d71ab1713f67faac7701d6885a072747bd941fd5 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"32";s:4:"name";s:38:"CISA^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"2499.00";s:9:"basePrice";s:15:"2499.0000000000";s:19:"display_total_price";s:8:"2,499.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:17:"CISA^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:67:"https://www.simplilearn.com/ice9/course_images/icons/ITSecCISA.svgz";s:10:"course_url";s:43:"/cyber-security/cisa-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:1:"3";s:18:"primary_label_name";s:14:"Cyber Security";s:12:"cateforyInfo";a:1:{i:3;s:14:"Cyber Security";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+61-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '32', 'name': 'CISA Online Self Learning', 'description': ' - 1', 'price': '2499.00', 'basePrice': '2499.0000000000', 'display_total_price': '2,499.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'CISA', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/ITSecCISA.svgz', 'course_url': '/cyber-security/cisa-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '3', 'primary_label_name': 'Cyber Security'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'CISA®', 'course_type': 'Online Self Learning', 'base_price': '$ 2,499.00', 'final_price': '2,698.92'}, (['Credit Card', 'Paypal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}, {'2checkout': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 9e2a56d5a86f2a9ee97028123c647f01ca686a87c89727267061f8701d53c4ca INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"32";s:4:"name";s:38:"CISA^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"2698.92";s:9:"basePrice";s:15:"2499.0000000000";s:19:"display_total_price";s:8:"2,499.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:17:"CISA^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:67:"https://www.simplilearn.com/ice9/course_images/icons/ITSecCISA.svgz";s:10:"course_url";s:43:"/cyber-security/cisa-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:1:"3";s:18:"primary_label_name";s:14:"Cyber Security";s:12:"cateforyInfo";a:1:{i:3;s:14:"Cyber Security";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+65-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '32', 'name': 'CISA Online Self Learning', 'description': ' - 1', 'price': '2698.92', 'basePrice': '2499.0000000000', 'display_total_price': '2,499.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'CISA', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/ITSecCISA.svgz', 'course_url': '/cyber-security/cisa-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '3', 'primary_label_name': 'Cyber Security'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 Url Opened is: https://www.simplilearn.com/cyber-security/cisa-certification-training INFO  setup:orders_page.py:30 Country Set to: AE INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'CISA®', 'course_type': 'Online Self Learning', 'base_price': '$ 2,499.00', 'final_price': '2,499.00'}, (['Credit Card', 'Paypal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}, {'2checkout': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 7e39a8ddaacaa6872ce6ce152c067ef76b7a49498b0e93dde7ec16b27e83cd1f INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"32";s:4:"name";s:38:"CISA^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"2499.00";s:9:"basePrice";s:15:"2499.0000000000";s:19:"display_total_price";s:8:"2,499.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:17:"CISA^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:67:"https://www.simplilearn.com/ice9/course_images/icons/ITSecCISA.svgz";s:10:"course_url";s:43:"/cyber-security/cisa-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:1:"3";s:18:"primary_label_name";s:14:"Cyber Security";s:12:"cateforyInfo";a:1:{i:3;s:14:"Cyber Security";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+65-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '32', 'name': 'CISA Online Self Learning', 'description': ' - 1', 'price': '2499.00', 'basePrice': '2499.0000000000', 'display_total_price': '2,499.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'CISA', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/ITSecCISA.svgz', 'course_url': '/cyber-security/cisa-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '3', 'primary_label_name': 'Cyber Security'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:316 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 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': 'Payment CTA appearing'}, {'EMI': 'Payment CTA appearing'}, {'CCAvenue': 'Payment CTA appearing'}, {'ShopSE EMI': 'Payment CTA appearing'}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: ea47a4f96f1d25e53ff65da0ff416b5477eedcac27a0c47997f7d422762f7993 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"34";s:4:"name";s:39:"CISSP^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:9:"198859.50";s:9:"basePrice";s:17:"168525.0000000000";s:19:"display_total_price";s:10:"168,525.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:18:"CISSP^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:68:"https://www.simplilearn.com/ice9/course_images/icons/ITSecCISSP.svgz";s:10:"course_url";s:44:"/cyber-security/cissp-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:1:"3";s:18:"primary_label_name";s:14:"Cyber Security";s:12:"cateforyInfo";a:1:{i:3;s:14:"Cyber Security";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+91-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '34', 'name': 'CISSP Online Self Learning', 'description': ' - 1', 'price': '198859.50', 'basePrice': '168525.0000000000', 'display_total_price': '168,525.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'CISSP', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/ITSecCISSP.svgz', 'course_url': '/cyber-security/cissp-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '3', 'primary_label_name': 'Cyber Security'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 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': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 2a0bf4d4f8c7763f54ecdca16590b9ad315fabb60a703b2151fba3c7f2a24892 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"34";s:4:"name";s:39:"CISSP^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"2200.00";s:9:"basePrice";s:15:"2200.0000000000";s:19:"display_total_price";s:8:"2,200.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:18:"CISSP^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:68:"https://www.simplilearn.com/ice9/course_images/icons/ITSecCISSP.svgz";s:10:"course_url";s:44:"/cyber-security/cissp-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:1:"3";s:18:"primary_label_name";s:14:"Cyber Security";s:12:"cateforyInfo";a:1:{i:3;s:14:"Cyber Security";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+1-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '34', 'name': 'CISSP Online Self Learning', 'description': ' - 1', 'price': '2200.00', 'basePrice': '2200.0000000000', 'display_total_price': '2,200.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'CISSP', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/ITSecCISSP.svgz', 'course_url': '/cyber-security/cissp-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '3', 'primary_label_name': 'Cyber Security'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'CISSP®', 'course_type': 'Online Self Learning', 'base_price': '£ 2,499.00', 'final_price': '2,499.00'}, (['Credit Card', 'Paypal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 9db3e8ea41ad23f46f2ef1a71816257e83f9845dd0dabe80e521779180400f92 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"34";s:4:"name";s:39:"CISSP^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"2499.00";s:9:"basePrice";s:15:"2499.0000000000";s:19:"display_total_price";s:8:"2,499.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:18:"CISSP^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:68:"https://www.simplilearn.com/ice9/course_images/icons/ITSecCISSP.svgz";s:10:"course_url";s:44:"/cyber-security/cissp-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:1:"3";s:18:"primary_label_name";s:14:"Cyber Security";s:12:"cateforyInfo";a:1:{i:3;s:14:"Cyber Security";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '34', 'name': 'CISSP Online Self Learning', 'description': ' - 1', 'price': '2499.00', 'basePrice': '2499.0000000000', 'display_total_price': '2,499.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'CISSP', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/ITSecCISSP.svgz', 'course_url': '/cyber-security/cissp-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '3', 'primary_label_name': 'Cyber Security'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'CISSP®', 'course_type': 'Online Self Learning', 'base_price': 'A$ 3,299.00', 'final_price': '3,299.00'}, (['Credit Card', 'Paypal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: b7f21b6ce6719c50819376f8d2f10fb00e0628b07348b00d1fd014f957bdb535 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"34";s:4:"name";s:39:"CISSP^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"3299.00";s:9:"basePrice";s:15:"3299.0000000000";s:19:"display_total_price";s:8:"3,299.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:18:"CISSP^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:68:"https://www.simplilearn.com/ice9/course_images/icons/ITSecCISSP.svgz";s:10:"course_url";s:44:"/cyber-security/cissp-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:1:"3";s:18:"primary_label_name";s:14:"Cyber Security";s:12:"cateforyInfo";a:1:{i:3;s:14:"Cyber Security";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '34', 'name': 'CISSP Online Self Learning', 'description': ' - 1', 'price': '3299.00', 'basePrice': '3299.0000000000', 'display_total_price': '3,299.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'CISSP', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/ITSecCISSP.svgz', 'course_url': '/cyber-security/cissp-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '3', 'primary_label_name': 'Cyber Security'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 Url Opened is: https://www.simplilearn.com/cyber-security/cissp-certification-training INFO  setup:orders_page.py:30 Country Set to: DE INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'CISSP®', 'course_type': 'Online Self Learning', 'base_price': '€ 2,599.00', 'final_price': '2,599.00'}, (['Credit Card', 'Paypal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}, {'2checkout': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 20394e57dc982d7d813b2d4d3c7ae46cc15b2ef4fb5949edb6de992c20b77fe9 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"34";s:4:"name";s:39:"CISSP^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"2599.00";s:9:"basePrice";s:15:"2599.0000000000";s:19:"display_total_price";s:8:"2,599.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:18:"CISSP^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:68:"https://www.simplilearn.com/ice9/course_images/icons/ITSecCISSP.svgz";s:10:"course_url";s:44:"/cyber-security/cissp-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:1:"3";s:18:"primary_label_name";s:14:"Cyber Security";s:12:"cateforyInfo";a:1:{i:3;s:14:"Cyber Security";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+44-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '34', 'name': 'CISSP Online Self Learning', 'description': ' - 1', 'price': '2599.00', 'basePrice': '2599.0000000000', 'display_total_price': '2,599.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'CISSP', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/ITSecCISSP.svgz', 'course_url': '/cyber-security/cissp-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '3', 'primary_label_name': 'Cyber Security'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 Url Opened is: https://www.simplilearn.com/cyber-security/cissp-certification-training INFO  setup:orders_page.py:30 Country Set to: SG INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'CISSP®', 'course_type': 'Online Self Learning', 'base_price': '$ 2,599.00', 'final_price': '2,806.92'}, (['Credit Card', 'Paypal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}, {'2checkout': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 91bf56e6afe7ccd5964275e98cd27a3ee4879f515760f06038fc20e05ad40200 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"34";s:4:"name";s:39:"CISSP^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"2806.92";s:9:"basePrice";s:15:"2599.0000000000";s:19:"display_total_price";s:8:"2,599.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:18:"CISSP^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:68:"https://www.simplilearn.com/ice9/course_images/icons/ITSecCISSP.svgz";s:10:"course_url";s:44:"/cyber-security/cissp-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:1:"3";s:18:"primary_label_name";s:14:"Cyber Security";s:12:"cateforyInfo";a:1:{i:3;s:14:"Cyber Security";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+65-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '34', 'name': 'CISSP Online Self Learning', 'description': ' - 1', 'price': '2806.92', 'basePrice': '2599.0000000000', 'display_total_price': '2,599.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'CISSP', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/ITSecCISSP.svgz', 'course_url': '/cyber-security/cissp-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '3', 'primary_label_name': 'Cyber Security'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'CISSP®', 'course_type': 'Online Self Learning', 'base_price': '$ 2,599.00', 'final_price': '2,599.00'}, (['Credit Card', 'Paypal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}, {'2checkout': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 82c8066a2b0ee703aec0d737778480ebb6eba46563ae4c42f372e7f4ee27ccb6 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"34";s:4:"name";s:39:"CISSP^® Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"2599.00";s:9:"basePrice";s:15:"2599.0000000000";s:19:"display_total_price";s:8:"2,599.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:18:"CISSP^®";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:68:"https://www.simplilearn.com/ice9/course_images/icons/ITSecCISSP.svgz";s:10:"course_url";s:44:"/cyber-security/cissp-certification-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:1:"3";s:18:"primary_label_name";s:14:"Cyber Security";s:12:"cateforyInfo";a:1:{i:3;s:14:"Cyber Security";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+971-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '34', 'name': 'CISSP Online Self Learning', 'description': ' - 1', 'price': '2599.00', 'basePrice': '2599.0000000000', 'display_total_price': '2,599.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'CISSP', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/ITSecCISSP.svgz', 'course_url': '/cyber-security/cissp-certification-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '3', 'primary_label_name': 'Cyber Security'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:316 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 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': 'Payment CTA appearing'}, {'EMI': 'Payment CTA appearing'}, {'CCAvenue': 'Payment CTA appearing'}, {'ShopSE EMI': 'Payment CTA appearing'}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: f4ea852bd31cfae4d6e7a8dfe5c8469393d6d655173215d870dd540bf594bfcb INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"15";s:4:"name";s:56:"Big Data Hadoop and Spark Developer Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:8:"25275.60";s:9:"basePrice";s:10:"21420.0000";s:19:"display_total_price";s:9:"21,420.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:35:"Big Data Hadoop and Spark Developer";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:96:"https://www.simplilearn.com/ice9/course_images/icons/Big-Data_Big-Data-and-Hadoop-Developer.svgz";s:10:"course_url";s:52:"/big-data-and-analytics/big-data-and-hadoop-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:2:"35";s:18:"primary_label_name";s:8:"Big Data";s:12:"cateforyInfo";a:2:{i:35;s:8:"Big Data";i:16;s:18:"Big Data Analytics";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+91-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '15', 'name': 'Big Data Hadoop and Spark Developer Online Self Learning', 'description': ' - 1', 'price': '25275.60', 'basePrice': '21420.0000', 'display_total_price': '21,420.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'Big Data Hadoop and Spark Developer', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/Big-Data_Big-Data-and-Hadoop-Developer.svgz', 'course_url': '/big-data-and-analytics/big-data-and-hadoop-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '35', 'primary_label_name': 'Big Data'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 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': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 292ed1f523dfb5bc16b0ef3f9ce367ab1af02526d45c0db568b2127d61768a55 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"15";s:4:"name";s:56:"Big Data Hadoop and Spark Developer Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:6:"899.00";s:9:"basePrice";s:14:"899.0000000000";s:19:"display_total_price";s:6:"899.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:35:"Big Data Hadoop and Spark Developer";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:96:"https://www.simplilearn.com/ice9/course_images/icons/Big-Data_Big-Data-and-Hadoop-Developer.svgz";s:10:"course_url";s:52:"/big-data-and-analytics/big-data-and-hadoop-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:2:"35";s:18:"primary_label_name";s:8:"Big Data";s:12:"cateforyInfo";a:2:{i:35;s:8:"Big Data";i:16;s:18:"Big Data Analytics";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+91-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '15', 'name': 'Big Data Hadoop and Spark Developer Online Self Learning', 'description': ' - 1', 'price': '899.00', 'basePrice': '899.0000000000', 'display_total_price': '899.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'Big Data Hadoop and Spark Developer', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/Big-Data_Big-Data-and-Hadoop-Developer.svgz', 'course_url': '/big-data-and-analytics/big-data-and-hadoop-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '35', 'primary_label_name': 'Big Data'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 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': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 844e86bf95123f600c56f0048c263ed326a7c87983a55737477b272a815fef4d INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"15";s:4:"name";s:56:"Big Data Hadoop and Spark Developer Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:6:"969.00";s:9:"basePrice";s:8:"969.0000";s:19:"display_total_price";s:6:"969.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:35:"Big Data Hadoop and Spark Developer";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:96:"https://www.simplilearn.com/ice9/course_images/icons/Big-Data_Big-Data-and-Hadoop-Developer.svgz";s:10:"course_url";s:52:"/big-data-and-analytics/big-data-and-hadoop-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:2:"35";s:18:"primary_label_name";s:8:"Big Data";s:12:"cateforyInfo";a:2:{i:35;s:8:"Big Data";i:16;s:18:"Big Data Analytics";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+91-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '15', 'name': 'Big Data Hadoop and Spark Developer Online Self Learning', 'description': ' - 1', 'price': '969.00', 'basePrice': '969.0000', 'display_total_price': '969.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'Big Data Hadoop and Spark Developer', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/Big-Data_Big-Data-and-Hadoop-Developer.svgz', 'course_url': '/big-data-and-analytics/big-data-and-hadoop-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '35', 'primary_label_name': 'Big Data'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 Url Opened is: https://www.simplilearn.com/big-data-and-analytics/big-data-and-hadoop-training INFO  setup:orders_page.py:30 Country Set to: AU INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'Big Data Hadoop and Spark Developer', 'course_type': 'Online Self Learning', 'base_price': 'A$ 1,125.00', 'final_price': '1,125.00'}, (['Credit Card', 'Paypal'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: a05e533ff23ca1f1e223caf4306fb0cd9bd5e236d8bf65f117d99d7b37df99ae INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"15";s:4:"name";s:56:"Big Data Hadoop and Spark Developer Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:7:"1125.00";s:9:"basePrice";s:15:"1125.0000000000";s:19:"display_total_price";s:8:"1,125.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:35:"Big Data Hadoop and Spark Developer";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:96:"https://www.simplilearn.com/ice9/course_images/icons/Big-Data_Big-Data-and-Hadoop-Developer.svgz";s:10:"course_url";s:52:"/big-data-and-analytics/big-data-and-hadoop-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:2:"35";s:18:"primary_label_name";s:8:"Big Data";s:12:"cateforyInfo";a:2:{i:35;s:8:"Big Data";i:16;s:18:"Big Data Analytics";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+91-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '15', 'name': 'Big Data Hadoop and Spark Developer Online Self Learning', 'description': ' - 1', 'price': '1125.00', 'basePrice': '1125.0000000000', 'display_total_price': '1,125.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'Big Data Hadoop and Spark Developer', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/Big-Data_Big-Data-and-Hadoop-Developer.svgz', 'course_url': '/big-data-and-analytics/big-data-and-hadoop-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '35', 'primary_label_name': 'Big Data'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 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:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 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': 'Payment CTA appearing '}, {'2checkout': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: c62b255b048bc1dc3bc9989866b9e297b523699fd7c1cdaa05a0e676bcc72363 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"15";s:4:"name";s:56:"Big Data Hadoop and Spark Developer Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:6:"749.00";s:9:"basePrice";s:8:"749.0000";s:19:"display_total_price";s:6:"749.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:35:"Big Data Hadoop and Spark Developer";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:96:"https://www.simplilearn.com/ice9/course_images/icons/Big-Data_Big-Data-and-Hadoop-Developer.svgz";s:10:"course_url";s:52:"/big-data-and-analytics/big-data-and-hadoop-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:2:"35";s:18:"primary_label_name";s:8:"Big Data";s:12:"cateforyInfo";a:2:{i:35;s:8:"Big Data";i:16;s:18:"Big Data Analytics";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+49-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '15', 'name': 'Big Data Hadoop and Spark Developer Online Self Learning', 'description': ' - 1', 'price': '749.00', 'basePrice': '749.0000', 'display_total_price': '749.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'Big Data Hadoop and Spark Developer', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/Big-Data_Big-Data-and-Hadoop-Developer.svgz', 'course_url': '/big-data-and-analytics/big-data-and-hadoop-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '35', 'primary_label_name': 'Big Data'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 Url Opened is: https://www.simplilearn.com/big-data-and-analytics/big-data-and-hadoop-training INFO  setup:orders_page.py:30 Country Set to: SG INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 course_data: ({'course_name': 'Big Data Hadoop and Spark Developer', 'course_type': 'Online Self Learning', 'base_price': '$ 748.00', 'final_price': '807.84'}, (['Credit Card', 'Paypal', '2Checkout'], [{'creditcard': 'All option clickable and Payment CTA appearing '}, {'Paypal': 'Payment CTA appearing '}, {'2checkout': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 4276cbab03493451f8dbdd6a7a1b348579c9be8f1564468a8bbbb2884672dfe2 INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"15";s:4:"name";s:56:"Big Data Hadoop and Spark Developer Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:6:"807.84";s:9:"basePrice";s:8:"748.0000";s:19:"display_total_price";s:6:"748.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:35:"Big Data Hadoop and Spark Developer";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:96:"https://www.simplilearn.com/ice9/course_images/icons/Big-Data_Big-Data-and-Hadoop-Developer.svgz";s:10:"course_url";s:52:"/big-data-and-analytics/big-data-and-hadoop-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:2:"35";s:18:"primary_label_name";s:8:"Big Data";s:12:"cateforyInfo";a:2:{i:35;s:8:"Big Data";i:16;s:18:"Big Data Analytics";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+49-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '15', 'name': 'Big Data Hadoop and Spark Developer Online Self Learning', 'description': ' - 1', 'price': '807.84', 'basePrice': '748.0000', 'display_total_price': '748.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'Big Data Hadoop and Spark Developer', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/Big-Data_Big-Data-and-Hadoop-Developer.svgz', 'course_url': '/big-data-and-analytics/big-data-and-hadoop-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '35', 'primary_label_name': 'Big Data'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull'] INFO  setup:test_orders_and_payment_flow.py:48 Url Opened is: https://www.simplilearn.com/big-data-and-analytics/big-data-and-hadoop-training INFO  setup:orders_page.py:30 Country Set to: AE INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:41 Payment Page Loaded ERROR  setup:ssvc_cart_page.py:55 Exception in City dropdown Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\pages_prod\ssvc_cart_page.py", line 52, in fill_learner_details_and_proceed self.city_dropdown.select_element_by_index(1) File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 60, in __getattr__ raise NoSuchElementException("An exception of type " + type(error).__name__ + " occurred. With Element -: " + loc) selenium.common.exceptions.NoSuchElementException: Message: An exception of type TimeoutException occurred. With Element -: city_dropdown INFO  setup:test_orders_and_payment_flow.py:156 <class 'tuple'> INFO  setup:ssvc_cart_page.py:336 Payment Deatils Entered INFO  setup:test_orders_and_payment_flow.py:58 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': 'Payment CTA appearing '}, {'2checkout': 'Payment CTA appearing '}])) INFO  setup:test_orders_and_payment_flow.py:62 Token No is: 8abf1314944575c8e70a05711ef61d724357bee0d778084ee35aa63f2c8f6bfe INFO  setup:test_orders_and_payment_flow.py:66 RAW SQL Data: [{'items': 'a:1:{i:0;a:23:{s:2:"id";s:2:"15";s:4:"name";s:56:"Big Data Hadoop and Spark Developer Online Self Learning";s:11:"description";s:4:" - 1";s:5:"price";s:6:"749.00";s:9:"basePrice";s:8:"749.0000";s:19:"display_total_price";s:6:"749.00";s:8:"quantity";i:1;s:11:"isEarlyBird";i:0;s:4:"type";s:6:"online";s:15:"trainingType_id";s:1:"2";s:10:"accessDays";s:3:"180";s:13:"productTypeId";s:1:"1";s:15:"productTypeName";s:6:"course";s:11:"actual_name";s:35:"Big Data Hadoop and Spark Developer";s:7:"priceId";s:0:"";s:11:"billingType";i:1;s:7:"img_url";s:96:"https://www.simplilearn.com/ice9/course_images/icons/Big-Data_Big-Data-and-Hadoop-Developer.svgz";s:10:"course_url";s:52:"/big-data-and-analytics/big-data-and-hadoop-training";s:17:"training_type_txt";s:20:"Online Self Learning";s:9:"messageTT";s:0:"";s:16:"primary_label_id";s:2:"35";s:18:"primary_label_name";s:8:"Big Data";s:12:"cateforyInfo";a:2:{i:35;s:8:"Big Data";i:16;s:18:"Big Data Analytics";}}}', 'emailId': 'simplilearnautomation@gmail.com', 'contactNumber': '+971-123456789'}] INFO  setup:test_orders_and_payment_flow.py:68 SQL DATA in JSON format: {'id': '15', 'name': 'Big Data Hadoop and Spark Developer Online Self Learning', 'description': ' - 1', 'price': '749.00', 'basePrice': '749.0000', 'display_total_price': '749.00', 'quantity': 'isEarlyBird', 'type': 'online', 'trainingType_id': '2', 'accessDays': '180', 'productTypeId': '1', 'productTypeName': 'course', 'actual_name': 'Big Data Hadoop and Spark Developer', 'priceId': '', 'img_url': 'https://www.simplilearn.com/ice9/course_images/icons/Big-Data_Big-Data-and-Hadoop-Developer.svgz', 'course_url': '/big-data-and-analytics/big-data-and-hadoop-training', 'training_type_txt': 'Online Self Learning', 'messageTT': '', 'primary_label_id': '35', 'primary_label_name': 'Big Data'} INFO  setup:test_orders_and_payment_flow.py:278 Verifiaction Status Log Message: ['DB Verification Successfull']