report.html

self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000001CC9934FC40>
value = 'A', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

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

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

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

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

test_prod\test_orders_and_payment_flow.py:120:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <pages_prod.orders_page.OrdersPage object at 0x000001CC9938F7F0>, country = 'in'

def change_country(self,country):
selenium_helper.scroll_to_page_bottom()
# selenium_helper.is_locator_present(self.locators['country_dropdown'],60)
selenium_helper.is_locator_visible(self.locators['country_dropdown'], 20)
# time.sleep(2)
self.country_dropdown.scroll_to_element()
time.sleep(2)
> self.country_dropdown.click_button()

pages_prod\orders_page.py:25:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <selenium.webdriver.remote.webelement.WebElement (session="b797715c4614e71d3f581727c9f46635", element="B052CCB0BFC08C354AC4D7A877F3F8B8_element_47")>

def click_button(self):
"""
Perform click on webElement
:param: None
:return: webElement
"""
self.element_to_be_clickable()
> self.click()

core\page_factory.py:173:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <selenium.webdriver.remote.webelement.WebElement (session="b797715c4614e71d3f581727c9f46635", element="B052CCB0BFC08C354AC4D7A877F3F8B8_element_47")>

def click(self):
"""Clicks the element."""
> self._execute(Command.CLICK_ELEMENT)

c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py:80:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <selenium.webdriver.remote.webelement.WebElement (session="b797715c4614e71d3f581727c9f46635", element="B052CCB0BFC08C354AC4D7A877F3F8B8_element_47")>
command = 'clickElement'
params = {'id': 'B052CCB0BFC08C354AC4D7A877F3F8B8_element_47', 'sessionId': 'b797715c4614e71d3f581727c9f46635'}

def _execute(self, command, params=None):
"""Executes a command against the underlying HTML element.

Args:
command: The name of the command to _execute as a string.
params: A dictionary of named parameters to send with the command.

Returns:
The command's JSON response loaded into a dictionary object.
"""
if not params:
params = {}
params['id'] = self._id
> return self._parent.execute(command, params)

c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py:633:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <selenium.webdriver.chrome.webdriver.WebDriver (session="b797715c4614e71d3f581727c9f46635")>
driver_command = 'clickElement', params = {'id': 'B052CCB0BFC08C354AC4D7A877F3F8B8_element_47'}

def execute(self, driver_command, params=None):
"""
Sends a command to be executed by a command.CommandExecutor.

:Args:
- driver_command: The name of the command to execute as a string.
- params: A dictionary of named parameters to send with the command.

:Returns:
The command's JSON response loaded into a dictionary object.
"""
if self.session_id is not None:
if not params:
params = {'sessionId': self.session_id}
elif 'sessionId' not in params:
params['sessionId'] = self.session_id

params = self._wrap_value(params)
response = self.command_executor.execute(driver_command, params)
if response:
> self.error_handler.check_response(response)

c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webdriver.py:321:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <selenium.webdriver.remote.errorhandler.ErrorHandler object at 0x000001CC9938F490>
response = {'status': 400, 'value': '{"value":{"error":"element click intercepted","message":"element click intercepted: Element ...\n\\tRtlGetAppContainerNamedObjectPath [0x77977B4E+286]\\n\\tRtlGetAppContainerNamedObjectPath [0x77977B1E+238]\\n"}}'}

def check_response(self, response):
"""
Checks that a JSON response from the WebDriver does not have an error.

:Args:
- response - The JSON response from the WebDriver server as a dictionary
object.

:Raises: If the response contains an error message.
"""
status = response.get('status', None)
if status is None or status == ErrorCode.SUCCESS:
return
value = None
message = response.get("message", "")
screen = response.get("screen", "")
stacktrace = None
if isinstance(status, int):
value_json = response.get('value', None)
if value_json and isinstance(value_json, basestring):
import json
try:
value = json.loads(value_json)
if len(value.keys()) == 1:
value = value['value']
status = value.get('error', None)
if status is None:
status = value["status"]
message = value["value"]
if not isinstance(message, basestring):
value = message
message = message.get('message')
else:
message = value.get('message', None)
except ValueError:
pass

exception_class = ErrorInResponseException
if status in ErrorCode.NO_SUCH_ELEMENT:
exception_class = NoSuchElementException
elif status in ErrorCode.NO_SUCH_FRAME:
exception_class = NoSuchFrameException
elif status in ErrorCode.NO_SUCH_WINDOW:
exception_class = NoSuchWindowException
elif status in ErrorCode.STALE_ELEMENT_REFERENCE:
exception_class = StaleElementReferenceException
elif status in ErrorCode.ELEMENT_NOT_VISIBLE:
exception_class = ElementNotVisibleException
elif status in ErrorCode.INVALID_ELEMENT_STATE:
exception_class = InvalidElementStateException
elif status in ErrorCode.INVALID_SELECTOR \
or status in ErrorCode.INVALID_XPATH_SELECTOR \
or status in ErrorCode.INVALID_XPATH_SELECTOR_RETURN_TYPER:
exception_class = InvalidSelectorException
elif status in ErrorCode.ELEMENT_IS_NOT_SELECTABLE:
exception_class = ElementNotSelectableException
elif status in ErrorCode.ELEMENT_NOT_INTERACTABLE:
exception_class = ElementNotInteractableException
elif status in ErrorCode.INVALID_COOKIE_DOMAIN:
exception_class = InvalidCookieDomainException
elif status in ErrorCode.UNABLE_TO_SET_COOKIE:
exception_class = UnableToSetCookieException
elif status in ErrorCode.TIMEOUT:
exception_class = TimeoutException
elif status in ErrorCode.SCRIPT_TIMEOUT:
exception_class = TimeoutException
elif status in ErrorCode.UNKNOWN_ERROR:
exception_class = WebDriverException
elif status in ErrorCode.UNEXPECTED_ALERT_OPEN:
exception_class = UnexpectedAlertPresentException
elif status in ErrorCode.NO_ALERT_OPEN:
exception_class = NoAlertPresentException
elif status in ErrorCode.IME_NOT_AVAILABLE:
exception_class = ImeNotAvailableException
elif status in ErrorCode.IME_ENGINE_ACTIVATION_FAILED:
exception_class = ImeActivationFailedException
elif status in ErrorCode.MOVE_TARGET_OUT_OF_BOUNDS:
exception_class = MoveTargetOutOfBoundsException
elif status in ErrorCode.JAVASCRIPT_ERROR:
exception_class = JavascriptException
elif status in ErrorCode.SESSION_NOT_CREATED:
exception_class = SessionNotCreatedException
elif status in ErrorCode.INVALID_ARGUMENT:
exception_class = InvalidArgumentException
elif status in ErrorCode.NO_SUCH_COOKIE:
exception_class = NoSuchCookieException
elif status in ErrorCode.UNABLE_TO_CAPTURE_SCREEN:
exception_class = ScreenshotException
elif status in ErrorCode.ELEMENT_CLICK_INTERCEPTED:
exception_class = ElementClickInterceptedException
elif status in ErrorCode.INSECURE_CERTIFICATE:
exception_class = InsecureCertificateException
elif status in ErrorCode.INVALID_COORDINATES:
exception_class = InvalidCoordinatesException
elif status in ErrorCode.INVALID_SESSION_ID:
exception_class = InvalidSessionIdException
elif status in ErrorCode.UNKNOWN_METHOD:
exception_class = UnknownMethodException
else:
exception_class = WebDriverException
if value == '' or value is None:
value = response['value']
if isinstance(value, basestring):
if exception_class == ErrorInResponseException:
raise exception_class(response, value)
raise exception_class(value)
if message == "" and 'message' in value:
message = value['message']

screen = None
if 'screen' in value:
screen = value['screen']

stacktrace = None
if 'stackTrace' in value and value['stackTrace']:
stacktrace = []
try:
for frame in value['stackTrace']:
line = self._value_or_default(frame, 'lineNumber', '')
file = self._value_or_default(frame, 'fileName', '<anonymous>')
if line:
file = "%s:%s" % (file, line)
meth = self._value_or_default(frame, 'methodName', '<anonymous>')
if 'className' in frame:
meth = "%s.%s" % (frame['className'], meth)
msg = " at %s (%s)"
msg = msg % (meth, file)
stacktrace.append(msg)
except TypeError:
pass
if exception_class == ErrorInResponseException:
raise exception_class(response, message)
elif exception_class == UnexpectedAlertPresentException:
alert_text = None
if 'data' in value:
alert_text = value['data'].get('text')
elif 'alert' in value:
alert_text = value['alert'].get('text')
raise exception_class(message, screen, stacktrace, alert_text)
> raise exception_class(message, screen, stacktrace)
E selenium.common.exceptions.ElementClickInterceptedException: Message: element click intercepted: Element <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAVCAYAAAAnzezqAAAACXBIWXMAAAsTAAALEwEAmpwYAAAAIGNIUk0AAHolAACAgwAA+f8AAIDpAAB1MAAA6mAAADqYAAAXb5JfxUYAAAFwSURBVHja7JZLL0NRFIW/cx+9pYrSEpV4pImoSJRGOmBKTPwR7c8x8QNEIjESicfEDENRI6UjrUsZ3FOVXu29BgxMT0M7YE3OnpxkZe+11t7C30rfA3FA0l6EgZLxVfDtbSsJjQ7jn4CBW+0wgUCP+q+mD90GDIdAF2DXQLqftSKE75QcJQd4HvT18FKWnJ3eUXebZJYnGE1EwXFAKE1VCt/3HVULPjy5bO89MBQLYgY0CreS9dUYczPK3ZQtiXB354qJ2Bvx/hraW4XFJBzuX7fHBfX6O9GogWWZZLMnbGwcYZo6yWQv+fxjCyJUhGWZOI5POOyRy6WpVl10XVAsvrK2NvX7BABWVxIcH5SZnR5DCLi8qJBZGicQ0FtwQbOhLEI0ncLNMxfn97y7Hqn5YVILI4AHnq/mgrnNSWUCjYbH4GAXkUgQIUBKF9uuoWkCoRYF0ri0i61F2PMPJeFAyPrfhn99HX/eguEO3YTyYwA5xXRn1+PnWgAAABZ0RVh0QXV0aG9yAElQMkxvY2F0aW9uLmNvbX+XuQ4AAAAASUVORK5CYII=" width="32" height="17" alt="Country Flag" class="country-flag-btn gm-added gm-observing gm-observing-cb" loading="lazy"> is not clickable at point (946, 414). Other element would receive the click: <iframe title="notification-frame-~5584baa3" name="notification-frame-~5584baa3" id="webklipper-publisher-widget-container-notification-frame" frameborder="0" marginheight="0" marginwidth="0" style="display: block; position: fixed; z-index: 16776272; left: -1000px; top: -1000px; visibility: visible; height: 100%; width: 100%; transform: translate(1000px, 1000px);" data-notification-layout-id="~184fc0b7" data-notification-layout-name="modal" class="gm-added gm-lazy"></iframe>
E (Session info: chrome=114.0.5735.199)

c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\errorhandler.py:242: ElementClickInterceptedException

During handling of the above exception, another exception occurred:

self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000001CC9934FC40>
value = 'A', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

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

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

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

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

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

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

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

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

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


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

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

except Exception as e:
counter = counter+1
logging.error("Exception occurred", exc_info=True)
filename = 'Report.csv'
course_name = 'NA'
course_type = 'Certification Program'
> if course_data == None:
E UnboundLocalError: local variable 'course_data' referenced before assignment

test_prod\test_orders_and_payment_flow.py:186: UnboundLocalError
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:104 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:116 Url Opened is: https://www.simplilearn.com/agile-and-scrum/agile-and-scrum-certification-training ERROR  setup:test_orders_and_payment_flow.py:182 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 120, in test_Orders_and_Payment_Flow_certification self.pg_orders.change_country(country_value) File "C:\test_repos\pre_sales_test_python\pages_prod\orders_page.py", line 25, in change_country self.country_dropdown.click_button() File "C:\test_repos\pre_sales_test_python\core\page_factory.py", line 173, in click_button self.click() File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 80, in click self._execute(Command.CLICK_ELEMENT) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webelement.py", line 633, in _execute return self._parent.execute(command, params) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\webdriver.py", line 321, in execute self.error_handler.check_response(response) File "c:\users\qateam\appdata\local\programs\python\python38\lib\site-packages\selenium\webdriver\remote\errorhandler.py", line 242, in check_response raise exception_class(message, screen, stacktrace) selenium.common.exceptions.ElementClickInterceptedException: Message: element click intercepted: Element <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAVCAYAAAAnzezqAAAACXBIWXMAAAsTAAALEwEAmpwYAAAAIGNIUk0AAHolAACAgwAA+f8AAIDpAAB1MAAA6mAAADqYAAAXb5JfxUYAAAFwSURBVHja7JZLL0NRFIW/cx+9pYrSEpV4pImoSJRGOmBKTPwR7c8x8QNEIjESicfEDENRI6UjrUsZ3FOVXu29BgxMT0M7YE3OnpxkZe+11t7C30rfA3FA0l6EgZLxVfDtbSsJjQ7jn4CBW+0wgUCP+q+mD90GDIdAF2DXQLqftSKE75QcJQd4HvT18FKWnJ3eUXebZJYnGE1EwXFAKE1VCt/3HVULPjy5bO89MBQLYgY0CreS9dUYczPK3ZQtiXB354qJ2Bvx/hraW4XFJBzuX7fHBfX6O9GogWWZZLMnbGwcYZo6yWQv+fxjCyJUhGWZOI5POOyRy6WpVl10XVAsvrK2NvX7BABWVxIcH5SZnR5DCLi8qJBZGicQ0FtwQbOhLEI0ncLNMxfn97y7Hqn5YVILI4AHnq/mgrnNSWUCjYbH4GAXkUgQIUBKF9uuoWkCoRYF0ri0i61F2PMPJeFAyPrfhn99HX/eguEO3YTyYwA5xXRn1+PnWgAAABZ0RVh0QXV0aG9yAElQMkxvY2F0aW9uLmNvbX+XuQ4AAAAASUVORK5CYII=" width="32" height="17" alt="Country Flag" class="country-flag-btn gm-added gm-observing gm-observing-cb" loading="lazy"> is not clickable at point (946, 414). Other element would receive the click: <iframe title="notification-frame-~5584baa3" name="notification-frame-~5584baa3" id="webklipper-publisher-widget-container-notification-frame" frameborder="0" marginheight="0" marginwidth="0" style="display: block; position: fixed; z-index: 16776272; left: -1000px; top: -1000px; visibility: visible; height: 100%; width: 100%; transform: translate(1000px, 1000px);" data-notification-layout-id="~184fc0b7" data-notification-layout-name="modal" class="gm-added gm-lazy"></iframe> (Session info: chrome=114.0.5735.199)

self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000001CC9935F940>
value = 'P', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

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

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

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

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

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

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

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

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

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


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

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

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


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

test_prod\test_orders_and_payment_flow.py:207: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:104 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:116 Url Opened is: https://www.simplilearn.com/agile-and-scrum/agile-and-scrum-certification-training INFO  setup:orders_page.py:30 Country Set to: AU INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:43 Payment Page is not Loaded INFO  setup:orders_page.py:44 url opend for payment is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDQtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:orders_page.py:54 clicked on Enroll Now button again INFO  setup:orders_page.py:59 Payment Page is not Loaded INFO  setup:orders_page.py:60 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDQtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu ERROR  setup:selenium_helper.py:61 Message: WARNING  setup:selenium_helper.py:62 the locator ('xpath', "//div[@id='ssvcApp']//div[contains(text(), 'Cart Summary')][contains(@class,'active_heading')]") on url https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDQtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu is not visible INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:133 Token No is: https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDQtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:182 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 148, in test_Orders_and_Payment_Flow_certification for i in course_data[1][1]: IndexError: tuple index out of range INFO  setup:test_orders_and_payment_flow.py:193 1st else block in Exception

self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000001CC9935FC40>
value = 'T', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

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

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

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

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

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

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

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

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

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


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

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

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


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

test_prod\test_orders_and_payment_flow.py:207: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:104 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:116 Url Opened is: https://www.simplilearn.com/big-data-and-analytics/big-data-and-hadoop-training INFO  setup:orders_page.py:30 Country Set to: AU INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:43 Payment Page is not Loaded INFO  setup:orders_page.py:44 url opend for payment is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjEtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:orders_page.py:54 clicked on Enroll Now button again INFO  setup:orders_page.py:59 Payment Page is not Loaded INFO  setup:orders_page.py:60 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjEtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu ERROR  setup:selenium_helper.py:61 Message: WARNING  setup:selenium_helper.py:62 the locator ('xpath', "//div[@id='ssvcApp']//div[contains(text(), 'Cart Summary')][contains(@class,'active_heading')]") on url https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjEtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu is not visible INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:133 Token No is: https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjEtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:182 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 148, in test_Orders_and_Payment_Flow_certification for i in course_data[1][1]: IndexError: tuple index out of range INFO  setup:test_orders_and_payment_flow.py:193 1st else block in Exception

self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000001CC9935FF40>
value = 'X', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

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

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

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

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

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

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

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

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

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


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

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

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


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

test_prod\test_orders_and_payment_flow.py:207: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:104 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:116 Url Opened is: https://www.simplilearn.com/cyber-security/cissp-certification-training INFO  setup:orders_page.py:30 Country Set to: DE INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:43 Payment Page is not Loaded INFO  setup:orders_page.py:44 url opend for payment is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDktMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:orders_page.py:54 clicked on Enroll Now button again INFO  setup:orders_page.py:59 Payment Page is not Loaded INFO  setup:orders_page.py:60 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDktMTIzNDU2Nzg5LFNpbXBsaWxlYXJu ERROR  setup:selenium_helper.py:61 Message: WARNING  setup:selenium_helper.py:62 the locator ('xpath', "//div[@id='ssvcApp']//div[contains(text(), 'Cart Summary')][contains(@class,'active_heading')]") on url https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDktMTIzNDU2Nzg5LFNpbXBsaWxlYXJu is not visible INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:133 Token No is: https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDktMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:182 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 148, in test_Orders_and_Payment_Flow_certification for i in course_data[1][1]: IndexError: tuple index out of range INFO  setup:test_orders_and_payment_flow.py:193 1st else block in Exception

self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000001CC99375100>
value = 'Z', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

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

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

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

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

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

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

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

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

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


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

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

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


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

test_prod\test_orders_and_payment_flow.py:207: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:104 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:116 Url Opened is: https://www.simplilearn.com/agile-and-scrum/agile-and-scrum-certification-training INFO  setup:orders_page.py:30 Country Set to: SG INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:43 Payment Page is not Loaded INFO  setup:orders_page.py:44 url opend for payment is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDktMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:orders_page.py:54 clicked on Enroll Now button again INFO  setup:orders_page.py:59 Payment Page is not Loaded INFO  setup:orders_page.py:60 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDktMTIzNDU2Nzg5LFNpbXBsaWxlYXJu ERROR  setup:selenium_helper.py:61 Message: WARNING  setup:selenium_helper.py:62 the locator ('xpath', "//div[@id='ssvcApp']//div[contains(text(), 'Cart Summary')][contains(@class,'active_heading')]") on url https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDktMTIzNDU2Nzg5LFNpbXBsaWxlYXJu is not visible INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:133 Token No is: https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNDktMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:182 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 148, in test_Orders_and_Payment_Flow_certification for i in course_data[1][1]: IndexError: tuple index out of range INFO  setup:test_orders_and_payment_flow.py:193 1st else block in Exception

self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000001CC99375400>
value = 'AD', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

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

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

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

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

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

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

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

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

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


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

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

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


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

test_prod\test_orders_and_payment_flow.py:207: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:104 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:116 Url Opened is: https://www.simplilearn.com/big-data-and-analytics/big-data-and-hadoop-training INFO  setup:orders_page.py:30 Country Set to: SG INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:43 Payment Page is not Loaded INFO  setup:orders_page.py:44 url opend for payment is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjUtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:orders_page.py:54 clicked on Enroll Now button again INFO  setup:orders_page.py:59 Payment Page is not Loaded INFO  setup:orders_page.py:60 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjUtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu ERROR  setup:selenium_helper.py:61 Message: WARNING  setup:selenium_helper.py:62 the locator ('xpath', "//div[@id='ssvcApp']//div[contains(text(), 'Cart Summary')][contains(@class,'active_heading')]") on url https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjUtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu is not visible INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:133 Token No is: https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjUtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:182 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 148, in test_Orders_and_Payment_Flow_certification for i in course_data[1][1]: IndexError: tuple index out of range INFO  setup:test_orders_and_payment_flow.py:193 1st else block in Exception

self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowCertificationProgram object at 0x000001CC993754C0>
value = 'AE', initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

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

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

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

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

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

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

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

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

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


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

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

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


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

test_prod\test_orders_and_payment_flow.py:207: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:104 Total URL Present is: 5 INFO  setup:test_orders_and_payment_flow.py:116 Url Opened is: https://www.simplilearn.com/agile-and-scrum/agile-and-scrum-certification-training INFO  setup:orders_page.py:30 Country Set to: AE INFO  setup:orders_page.py:38 clicked on Enroll Now button INFO  setup:orders_page.py:43 Payment Page is not Loaded INFO  setup:orders_page.py:44 url opend for payment is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjUtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:orders_page.py:54 clicked on Enroll Now button again INFO  setup:orders_page.py:59 Payment Page is not Loaded INFO  setup:orders_page.py:60 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjUtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu ERROR  setup:selenium_helper.py:61 Message: WARNING  setup:selenium_helper.py:62 the locator ('xpath', "//div[@id='ssvcApp']//div[contains(text(), 'Cart Summary')][contains(@class,'active_heading')]") on url https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjUtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu is not visible INFO  setup:test_orders_and_payment_flow.py:126 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:129 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:133 Token No is: https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrNjUtMTIzNDU2Nzg5LFNpbXBsaWxlYXJu INFO  setup:test_orders_and_payment_flow.py:143 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:182 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 148, in test_Orders_and_Payment_Flow_certification for i in course_data[1][1]: IndexError: tuple index out of range INFO  setup:test_orders_and_payment_flow.py:193 1st else block in Exception

self = <test_orders_and_payment_flow.TestOrderAndPaymentFlowMastersProgram object at 0x000001CC9938F220>, value = 'AB'
initialize_pages = None
testdata = {'contact_no': '123456789', 'country': ['in', 'us', 'gb', 'au', 'de', 'sg', ...], 'db_type': 'mysql', 'dynamo_db_type': 'dynamo', ...}

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

test_prod\test_orders_and_payment_flow.py:542: Failed
-------------------------------Captured log call--------------------------------
INFO  setup:test_orders_and_payment_flow.py:451 Url Opened is: https://www.simplilearn.com/advanced-digital-marketing-certification-training-course INFO  setup:orders_page.py:30 Country Set to: AE INFO  setup:orders_page.py:159 clicked on Enroll Now button for Masters Program INFO  setup:orders_page.py:164 Payment Page is not Loaded INFO  setup:orders_page.py:165 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== INFO  setup:orders_page.py:175 clicked on Enroll Now button for Masters Program again INFO  setup:orders_page.py:180 Payment Page is not Loaded INFO  setup:orders_page.py:181 url opend for paymnent is : https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== ERROR  setup:selenium_helper.py:61 Message: WARNING  setup:selenium_helper.py:62 the locator ('xpath', "//div[@id='ssvcApp']//div[contains(text(), 'Cart Summary')][contains(@class,'active_heading')]") on url https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== is not visible INFO  setup:test_orders_and_payment_flow.py:460 <class 'tuple'> INFO  setup:test_orders_and_payment_flow.py:463 course_data: ('Failed to Load Cart Page',) INFO  setup:test_orders_and_payment_flow.py:467 Token No is: https://www.simplilearn.com/cart/add-to-cart?auh=c2ltcGxpbGVhcm5hdXRvbWF0aW9uQGdtYWlsLmNvbSwrOTcxLTEyMzQ1Njc4OSxTaW1wbGlsZWFybg== INFO  setup:test_orders_and_payment_flow.py:477 RAW SQL Data: [] ERROR  setup:test_orders_and_payment_flow.py:517 Exception occurred Traceback (most recent call last): File "C:\test_repos\pre_sales_test_python\test_prod\test_orders_and_payment_flow.py", line 482, in test_Orders_and_Payment_Flow_masters_program for i in course_data[1][1]: IndexError: tuple index out of range INFO  setup:test_orders_and_payment_flow.py:528 1st else block in Exception