def create_ui(self): dprint_ex(3, "Enter") self.suspend_layout() self.warning = not_running_warning_label() self.add(self.warning, False, True) self.connection_list = newTreeView(mforms.TreeDefault) self.connection_list.add_column(mforms.StringColumnType, "Id", 50, False) self.connection_list.add_column(mforms.StringColumnType, "User", 80, False) self.connection_list.add_column(mforms.StringColumnType, "Host", 120, False) self.connection_list.add_column(mforms.StringColumnType, "DB", 100, False) self.connection_list.add_column(mforms.StringColumnType, "Command", 80, False) self.connection_list.add_column(mforms.IntegerColumnType, "Time", 80, False) self.connection_list.add_column(mforms.StringColumnType, "State", 80, False) self.connection_list.add_column(mforms.StringColumnType, "Info", 300, False) self.connection_list.end_columns() self.connection_list.set_allow_sorting(True) self.connection_list.add_changed_callback( weakcb(self, "connection_selected")) #self.set_padding(8) self.add(self.connection_list, True, True) self.button_box = box = newBox(True) self.add(box, False, True) box.set_spacing(12) box.set_padding(12) refresh_button = newButton() refresh_button.set_text("Refresh") box.add_end(refresh_button, False, True) refresh_button.add_clicked_callback(weakcb(self, "refresh")) self.kill_button = newButton() self.kill_button.set_text("Kill Connection") box.add_end(self.kill_button, False, True) self.kill_button.add_clicked_callback(weakcb(self, "kill_connection")) self.killq_button = newButton() self.killq_button.set_text("Kill Query") box.add_end(self.killq_button, False, True) self.killq_button.add_clicked_callback(weakcb(self, "kill_query")) self.add(box, False, True) self.resume_layout() self.connection_selected() dprint_ex(3, "Leave")
def create_ui(self): self.set_padding(12) self.set_spacing(8) self.heading = make_panel_header("title_variables.png", self.server_profile.name, "Server Variables") self.add(self.heading, False, True) self.warning = not_running_warning_label() self.add(self.warning, False, True) self.tab = newTabView(False) self.add(self.tab, True, True) self.status = VariablesViewer( self.ctrl_be, wb_admin_variable_list.status_variable_list, "SHOW GLOBAL STATUS", 'status') self.status.set_padding(6) self.tab.add_page(self.status, "Status Variables") self.server = VariablesViewer( self.ctrl_be, wb_admin_variable_list.system_variable_list, "SHOW GLOBAL VARIABLES", 'system') self.server.set_padding(6) self.tab.add_page(self.server, "System Variables")
def create_ui(self): dprint_ex(3, "Enter") self.suspend_layout() self.warning = not_running_warning_label() self.add(self.warning, False, True) self.connection_list = newTreeView(mforms.TreeDefault) self.connection_list.add_column(mforms.StringColumnType, "Id", 50, False) self.connection_list.add_column(mforms.StringColumnType, "User", 80, False) self.connection_list.add_column(mforms.StringColumnType, "Host", 120, False) self.connection_list.add_column(mforms.StringColumnType, "DB", 100, False) self.connection_list.add_column(mforms.StringColumnType, "Command", 80, False) self.connection_list.add_column(mforms.IntegerColumnType, "Time", 80, False) self.connection_list.add_column(mforms.StringColumnType, "State", 80, False) self.connection_list.add_column(mforms.StringColumnType, "Info", 300, False) self.connection_list.end_columns() self.connection_list.set_allow_sorting(True) self.connection_list.add_changed_callback(weakcb(self, "connection_selected")) #self.set_padding(8) self.add(self.connection_list, True, True) self.button_box = box = newBox(True) self.add(box, False, True) box.set_spacing(12) box.set_padding(12) refresh_button = newButton() refresh_button.set_text("Refresh") box.add_end(refresh_button, False, True) refresh_button.add_clicked_callback(weakcb(self, "refresh")) self.kill_button = newButton() self.kill_button.set_text("Kill Connection") box.add_end(self.kill_button, False, True) self.kill_button.add_clicked_callback(weakcb(self, "kill_connection")) self.killq_button = newButton() self.killq_button.set_text("Kill Query") box.add_end(self.killq_button, False, True) self.killq_button.add_clicked_callback(weakcb(self, "kill_query")) self.add(box, False, True) self.resume_layout() self.connection_selected() dprint_ex(3, "Leave")
def create_ui(self): self.warning = not_running_warning_label() self.add(self.warning, False, True) self.warning.show(False) self.tabView = newTabView(False) self.add(self.tabView, True, True) self.general_log_tab = None self.slow_log_tab = None self.general_file_log_tab = None self.slow_file_log_tab = None self.error_file_log_tab = None
def create_ui(self): self.warning = not_running_warning_label() self.add(self.warning, False, True) self.warning.show(False) self.tabView = newTabView(False) self.add(self.tabView, True, True) self.general_log = GeneralLogView(self) self.tabView.add_page(self.general_log, "General") self.slow_log = SlowLogView(self) self.tabView.add_page(self.slow_log, "Slow Query Log")
def create_ui(self): self.warning = not_running_warning_label() self.add(self.warning, False, True) self.tab = newTabView(False) self.add(self.tab, True, True) self.status = VariablesViewer(self.ctrl_be, wb_admin_variable_list.vars_list["status"], "SHOW GLOBAL STATUS") self.status.set_padding(6) self.tab.add_page(self.status, "Status Variables") self.server = VariablesViewer(self.ctrl_be, wb_admin_variable_list.vars_list["system"], "SHOW GLOBAL VARIABLES") self.server.set_padding(6) self.tab.add_page(self.server, "System Variables")
def create_ui(self): self.warning = not_running_warning_label() self.add(self.warning, False, True) self.tab = newTabView(False) self.add(self.tab, True, True) self.status = VariablesViewer(self.ctrl_be, wb_admin_variable_list.vars_list['status'], "SHOW GLOBAL STATUS") self.status.set_padding(6) self.tab.add_page(self.status, "Status Variables") self.server = VariablesViewer(self.ctrl_be, wb_admin_variable_list.vars_list['system'], "SHOW GLOBAL VARIABLES") self.server.set_padding(6) self.tab.add_page(self.server, "System Variables")
def create_ui(self): self.suspend_layout() self.warning = not_running_warning_label() self.add(self.warning, False, True) self.tabview = newTabView(False) self.add(self.tabview, True, True) self.account_tab = SecurityAccount(self) self.tabview.add_page(self.account_tab, "Server Access Management") self.schema_privs_tab = SecuritySchemaPrivileges(self) self.tabview.add_page(self.schema_privs_tab, "Schema Privileges") self.resume_layout()
def create_ui(self): self.set_padding(12) self.set_spacing(8) self.heading = make_panel_header("title_variables.png", self.server_profile.name, "Server Variables") self.add(self.heading, False, True) self.warning = not_running_warning_label() self.add(self.warning, False, True) self.tab = newTabView(False) self.add(self.tab, True, True) self.status = VariablesViewer(self.ctrl_be, wb_admin_variable_list.status_variable_list, "SHOW GLOBAL STATUS", 'status') self.status.set_padding(6) self.tab.add_page(self.status, "Status Variables") self.server = VariablesViewer(self.ctrl_be, wb_admin_variable_list.system_variable_list, "SHOW GLOBAL VARIABLES", 'system') self.server.set_padding(6) self.tab.add_page(self.server, "System Variables")
def create_ui(self): dprint_ex(4, "Enter") self.suspend_layout() self.heading = make_panel_header("title_connections.png", self.instance_info.name, "Client Connections") self.add(self.heading, False, False) self.warning = not_running_warning_label() self.add(self.warning, False, True) self.connection_list = newTreeNodeView(mforms.TreeDefault|mforms.TreeFlatList|mforms.TreeAltRowColors) self.connection_list.add_column(mforms.LongIntegerColumnType, "Id", 50, False) self.connection_list.add_column(mforms.StringColumnType, "User", 80, False) self.connection_list.add_column(mforms.StringColumnType, "Host", 120, False) self.connection_list.add_column(mforms.StringColumnType, "DB", 100, False) self.connection_list.add_column(mforms.StringColumnType, "Command", 80, False) self.connection_list.add_column(mforms.LongIntegerColumnType, "Time", 60, False) self.connection_list.add_column(mforms.StringColumnType, "State", 80, False) self.info_column = self.connection_list.add_column(mforms.StringColumnType, "Info", 300, False) self.connection_list.end_columns() self.connection_list.set_allow_sorting(True) self.connection_list.add_changed_callback(weakcb(self, "connection_selected")) #self.set_padding(8) self.add(self.connection_list, True, True) self.button_box = box = newBox(True) box.set_spacing(12) refresh_button = newButton() refresh_button.set_text("Refresh") box.add_end(refresh_button, False, True) refresh_button.add_clicked_callback(weakcb(self, "refresh")) self.kill_button = newButton() self.kill_button.set_text("Kill Connection") box.add_end(self.kill_button, False, True) self.kill_button.add_clicked_callback(weakcb(self, "kill_connection")) self.killq_button = newButton() self.killq_button.set_text("Kill Query") box.add_end(self.killq_button, False, True) self.killq_button.add_clicked_callback(weakcb(self, "kill_query")) refresh_label = newLabel("Refresh Rate:") box.add(refresh_label, False, True) self._menu = mforms.newContextMenu() self._menu.add_item_with_title("Copy Info", self.copy_selected, "copy_selected") self._menu.add_item_with_title("Show in Editor", self.edit_selected, "edit_selected") self.connection_list.set_context_menu(self._menu) self.refresh_values = [0.5, 1, 2, 3, 4, 5, 10, 15, 30] self.refresh_values_size = len(self.refresh_values) self.refresh_selector = newSelector() self.refresh_selector.set_size(100,-1) for s in self.refresh_values: self.refresh_selector.add_item(str(s) + " seconds") self.refresh_selector.add_item("Don't Refresh") refresh_rate_index = grt.root.wb.options.options.get('Administrator:refresh_connections_rate_index', 9) self.refresh_selector.set_selected(refresh_rate_index) self.update_refresh_rate() self.refresh_selector.add_changed_callback(weakcb(self, "update_refresh_rate")) box.add(self.refresh_selector, False, True) self.hide_sleep_connections = newCheckBox() self.hide_sleep_connections.set_text('Hide sleeping connections') self.hide_sleep_connections.add_clicked_callback(self.refresh) box.add(self.hide_sleep_connections, False, True) self.add(box, False, True) self.resume_layout() self.connection_selected() dprint_ex(4, "Leave")
def create_ui(self): dprint_ex(4, "Enter") self.suspend_layout() self.heading = make_panel_header("title_connections.png", self.instance_info.name, "Client Connections") self.add(self.heading, False, False) self.warning = not_running_warning_label() self.add(self.warning, False, True) self.connection_list = newTreeNodeView(mforms.TreeDefault | mforms.TreeFlatList | mforms.TreeAltRowColors) self.connection_list.add_column(mforms.LongIntegerColumnType, "Id", 50, False) self.connection_list.add_column(mforms.StringColumnType, "User", 80, False) self.connection_list.add_column(mforms.StringColumnType, "Host", 120, False) self.connection_list.add_column(mforms.StringColumnType, "DB", 100, False) self.connection_list.add_column(mforms.StringColumnType, "Command", 80, False) self.connection_list.add_column(mforms.LongIntegerColumnType, "Time", 60, False) self.connection_list.add_column(mforms.StringColumnType, "State", 80, False) self.info_column = self.connection_list.add_column( mforms.StringColumnType, "Info", 300, False) self.connection_list.end_columns() self.connection_list.set_allow_sorting(True) self.connection_list.add_changed_callback( weakcb(self, "connection_selected")) #self.set_padding(8) self.add(self.connection_list, True, True) self.button_box = box = newBox(True) box.set_spacing(12) refresh_button = newButton() refresh_button.set_text("Refresh") box.add_end(refresh_button, False, True) refresh_button.add_clicked_callback(weakcb(self, "refresh")) self.kill_button = newButton() self.kill_button.set_text("Kill Connection") box.add_end(self.kill_button, False, True) self.kill_button.add_clicked_callback(weakcb(self, "kill_connection")) self.killq_button = newButton() self.killq_button.set_text("Kill Query") box.add_end(self.killq_button, False, True) self.killq_button.add_clicked_callback(weakcb(self, "kill_query")) refresh_label = newLabel("Refresh Rate:") box.add(refresh_label, False, True) self._menu = mforms.newContextMenu() self._menu.add_item_with_title("Copy Info", self.copy_selected, "copy_selected") self._menu.add_item_with_title("Show in Editor", self.edit_selected, "edit_selected") self.connection_list.set_context_menu(self._menu) self.refresh_values = [0.5, 1, 2, 3, 4, 5, 10, 15, 30] self.refresh_values_size = len(self.refresh_values) self.refresh_selector = newSelector() self.refresh_selector.set_size(100, -1) for s in self.refresh_values: self.refresh_selector.add_item(str(s) + " seconds") self.refresh_selector.add_item("Don't Refresh") refresh_rate_index = grt.root.wb.options.options.get( 'Administrator:refresh_connections_rate_index', 9) self.refresh_selector.set_selected(refresh_rate_index) self.update_refresh_rate() self.refresh_selector.add_changed_callback( weakcb(self, "update_refresh_rate")) box.add(self.refresh_selector, False, True) self.hide_sleep_connections = newCheckBox() self.hide_sleep_connections.set_text('Hide sleeping connections') self.hide_sleep_connections.add_clicked_callback(self.refresh) box.add(self.hide_sleep_connections, False, True) self.add(box, False, True) self.resume_layout() self.connection_selected() dprint_ex(4, "Leave")
def create_ui(self): dprint_ex(4, "Enter") self.suspend_layout() self.warning = not_running_warning_label() self.add(self.warning, False, True) self.connection_list = newTreeNodeView(mforms.TreeDefault | mforms.TreeFlatList) self.connection_list.add_column(mforms.LongIntegerColumnType, "Id", 50, False) self.connection_list.add_column(mforms.StringColumnType, "User", 80, False) self.connection_list.add_column(mforms.StringColumnType, "Host", 120, False) self.connection_list.add_column(mforms.StringColumnType, "DB", 100, False) self.connection_list.add_column(mforms.StringColumnType, "Command", 80, False) self.connection_list.add_column(mforms.IntegerColumnType, "Time", 60, False) self.connection_list.add_column(mforms.StringColumnType, "State", 80, False) self.info_column = self.connection_list.add_column( mforms.StringColumnType, "Info", 300, False) self.connection_list.end_columns() self.connection_list.set_allow_sorting(True) self.connection_list.add_changed_callback( weakcb(self, "connection_selected")) #self.set_padding(8) self.add(self.connection_list, True, True) self.button_box = box = newBox(True) box.set_spacing(12) box.set_padding(12) refresh_button = newButton() refresh_button.set_text("Refresh") box.add_end(refresh_button, False, True) refresh_button.add_clicked_callback(weakcb(self, "refresh")) copy_button = newButton() copy_button.set_text("Copy Selected") box.add_end(copy_button, False, True) copy_button.add_clicked_callback(weakcb(self, "copy_selected")) self.kill_button = newButton() self.kill_button.set_text("Kill Connection") box.add_end(self.kill_button, False, True) self.kill_button.add_clicked_callback(weakcb(self, "kill_connection")) self.killq_button = newButton() self.killq_button.set_text("Kill Query") box.add_end(self.killq_button, False, True) self.killq_button.add_clicked_callback(weakcb(self, "kill_query")) refresh_label = newLabel("Refresh Rate:") box.add(refresh_label, False, True) self.refresh_values = [0.5, 1, 2, 3, 4, 5, 10, 15, 30] self.refresh_values_size = len(self.refresh_values) self.refresh_selector = newSelector() self.refresh_selector.set_size(100, -1) for s in self.refresh_values: self.refresh_selector.add_item(str(s) + " seconds") self.refresh_selector.add_item("Don't Refresh") self.refresh_selector.set_selected(9) box.add(self.refresh_selector, False, True) self.refresh_selector.add_changed_callback( weakcb(self, "update_refresh_rate")) self.add(box, False, True) self.resume_layout() self.connection_selected() dprint_ex(4, "Leave")