def connect_database(sql_query):
try:
con = connector.connect(
host=parseConfigurationFile()['DB_HOST'],
user=parseConfigurationFile()['DB_USER'],
password=parseConfigurationFile()['DB_PASSWORD'],
port=parseConfigurationFile()['DB_PORT'],
database=parseConfigurationFile()['DB_NAME'])
con.autocommit(False)
temp_Query = str(sql_query).split(" ")[0]
if temp_Query.lower() is "insert" or temp_Query.lower(
) is "update" or temp_Query.lower() is "delete":
con_cursor = con.cursor()
con_cursor.execute(sql_query)
con.commit()
return True
elif temp_Query.lower() is "select":
con_cursor = con.cursor()
con_cursor.execute(sql_query)
return con_cursor.fetchall()
else:
print("Failed Connecting database")
exit(1)
except connector.Error as err:
print("Failed creating database: {err}")
exit(1)
def initialize(request):
try:
print(
f"\nTest started at {datetime.datetime.utcnow().strftime('%d-%m-%Y %H:%M')}"
)
driver = webdriver.Firefox(
executable_path=parseConfigurationFile()['FIREFOX_EXE_PATH'])
driver.maximize_window()
driver.set_page_load_timeout(10)
driver.delete_all_cookies()
driver.implicitly_wait(20)
driver.get(parseConfigurationFile()['BASE_URL'])
request.cls.driver = driver
yield driver
if driver is not None:
driver.quit()
print(
f"\nTest ended at {datetime.datetime.utcnow().strftime('%d-%m-%Y %H:%M')}"
)
except Exception:
exc_info = sys.exc_info()
traceback.print_exception(*exc_info)
def test_verify_customer_registration(self, gender, fname, lname, email,
dob, passowrd):
driver = self.driver
launch_page = LaunchPage(driver)
register_page = launch_page.fnc_clickOnRegistrationLink()
email = str(randomNumber(10, 999)) + email
register_page.fnc_enter_new_registration_details(
gender, fname, lname, email, dob, passowrd)
driver.save_screenshot("./Screenshots/Registration" +
current_timestamp('%d%m%y%H%M') + ".png")
registration_complete_msg = register_page.fnc_verify_registration_completion_message(
)
assert registration_complete_msg == parseConfigurationFile(
)['REGISTRATION_SUCCESS_MESSAGE']
def test_verify_item_search_from_launch_page(self, itemname):
driver = self.driver
launch_page = LaunchPage(driver)
launch_page.fnc_search_item_from_launch_page(itemname)
assert driver.title == parseConfigurationFile()['SEARCH_PAGE_TITLE']
def test_verify_RegisterPage_opens_on_click_RegisterLink(self):
driver = self.driver
launch_page = LaunchPage(driver)
launch_page.fnc_clickOnRegistrationLink()
assert driver.title == parseConfigurationFile()['REGISTER_PAGE_TITLE']