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_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.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")
