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']