def _open_maintenance_dialogue(self): if self.test_level == 'table': self.page.expand_tables_node("Server", self.server['name'], self.server['db_password'], self.database_name, 'public') table_node = self.page.check_if_element_exists_with_scroll( TreeAreaLocators.table_node(self.table_name)) status = False if table_node: status = True self.assertTrue( status, "Table name {} is not visible/selected".format( self.table_name)) table_node.click() else: self.page.expand_database_node("Server", self.server['name'], self.server['db_password'], self.database_name) self.page.retry_click( (By.LINK_TEXT, NavMenuLocators.tools_menu_link_text), (By.CSS_SELECTOR, NavMenuLocators.maintenance_obj_css)) maintenance_obj = self.wait.until( EC.visibility_of_element_located( (By.CSS_SELECTOR, NavMenuLocators.maintenance_obj_css))) maintenance_obj.click() self.page.check_if_element_exist_by_xpath( NavMenuLocators.maintenance_operation, 10)
def _tables_node_expandable(self): self.page.expand_tables_node("Server", self.server['name'], self.server['db_password'], self.test_db, 'public') table_node = self.page.check_if_element_exists_with_scroll( TreeAreaLocators.table_node(self.test_table_name)) table_node.click()
def _create_table(self): self.test_table_name = "test_table" + str(random.randint(1000, 3000)) test_utils.create_table(self.server, self.test_db, self.test_table_name) self.page.expand_tables_node("Server", self.server['name'], self.server['db_password'], self.test_db, 'public') table_node = self.page.check_if_element_exists_with_scroll( TreeAreaLocators.table_node(self.test_table_name)) table_node.click()
def test_view_data_tool_button(self): self.page.expand_tables_node("Servers", self.server['name'], self.server['db_password'], self.test_db, "public") table_node = self.page.check_if_element_exists_with_scroll( TreeAreaLocators.table_node(self.test_table_name)) table_node.click() self.assertTrue( self.page.retry_click( (By.CSS_SELECTOR, BrowserToolBarLocators.view_table_data_button_css), (By.CSS_SELECTOR, BrowserToolBarLocators.view_data_panel_css)), 'View/Edit Data tab did not open after clicking View/Edit button.') self.page.close_query_tool(prompt=False)
def runTest(self): self.test_table_name = "test_table" + str(random.randint(1000, 3000)) test_utils.create_table(self.server, self.test_db, self.test_table_name) self.page.expand_tables_node("Server", self.server['name'], self.server['db_password'], self.test_db, 'public') table_node = self.page.check_if_element_exists_with_scroll( TreeAreaLocators.table_node(self.test_table_name)) table_node.click() self.page.click_tab("SQL") # Wait till data is displayed in SQL Tab self.assertTrue( self.page.check_if_element_exist_by_xpath( "//*[contains(@class,'CodeMirror-lines') and " "contains(.,'CREATE TABLE IF NOT EXISTS public.%s')]" % self.test_table_name, 10), "No data displayed in SQL tab")