def __init__(self, owner, sql_text):
WizardPage.__init__(self, owner, 'Review Generated Migration(s)')
self.save_button = mforms.newButton()
self.save_button.enable_internal_padding(True)
self.save_button.set_text('Save Migration(s) to Folder...')
self.save_button.set_tooltip('Select the folder to save your migration(s) to.')
self.save_button.add_clicked_callback(self.save_clicked)
self.sql_text = mforms.newCodeEditor()
self.sql_text.set_language(mforms.LanguageMySQL)
self.sql_text.set_text(sql_text)
def __init__(self, owner, sql_text):
WizardPage.__init__(self, owner, 'Review Generated Migration(s)')
self.save_button = mforms.newButton()
self.save_button.enable_internal_padding(True)
self.save_button.set_text('Save Migration(s) to Folder...')
self.save_button.set_tooltip('Select the folder to save your migration(s) to.')
self.save_button.add_clicked_callback(self.save_clicked)
self.sql_text = mforms.newCodeEditor()
self.sql_text.set_language(mforms.LanguageMySQL)
self.sql_text.set_text(sql_text)
def __init__(self, owner):
mforms.Table.__init__(self)
self.owner = owner
self.set_padding(8)
self.set_row_spacing(4)
self.set_column_spacing(4)
self.set_column_count(2)
self.set_row_count(16)
self.labels = {}
self.make_line("Processlist Id:", "PROCESSLIST_ID")
self.make_line("Thread Id:", "THREAD_ID")
self.make_line("Name:", "NAME")
self.make_line("Type:", "TYPE")
self.make_line("User:"******"PROCESSLIST_USER")
self.make_line("Host:", "PROCESSLIST_HOST")
self.make_line("Schema:", "PROCESSLIST_DB")
self.make_line("Command:", "PROCESSLIST_COMMAND")
self.make_line("Time:", "PROCESSLIST_TIME")
self.make_line("State:", "PROCESSLIST_STATE")
self.make_line("Role:", "ROLE")
self.make_line("Instrumented:", "INSTRUMENTED")
self.make_line("Parent Thread Id:", "PARENT_THREAD_ID")
l = mforms.newLabel("Info:")
l.set_style(mforms.BoldStyle)
self.add(l, 0, 1, 13, 14, mforms.HFillFlag|mforms.HExpandFlag)
self.info = mforms.newCodeEditor()
self.info.set_features(mforms.FeatureGutter, False)
self.info.set_features(mforms.FeatureReadOnly, True)
self.info.set_features(mforms.FeatureWrapText, True)
self.info.set_language(mforms.LanguageMySQL56)
self.info.set_size(0, 50)
self.add(self.info, 0, 2, 14, 15, mforms.HFillFlag|mforms.VFillFlag|mforms.HExpandFlag|mforms.VExpandFlag)
if self.owner.ctrl_be.target_version.is_supported_mysql_version_at_least(5, 7, 2):
self.explain = mforms.newButton()
self.explain.set_enabled(False)
self.explain.add_clicked_callback(self.owner.explain_selected)
self.explain.set_text("Explain for Connection")
self.add(self.explain, 1, 2, 15, 16, mforms.HFillFlag)
else:
self.explain = None
def __init__(self, owner):
mforms.Table.__init__(self)
self.owner = owner
self.set_padding(8)
self.set_row_spacing(4)
self.set_column_spacing(4)
self.set_column_count(2)
self.set_row_count(16)
self.labels = {}
self.make_line("Processlist Id:", "PROCESSLIST_ID")
self.make_line("Thread Id:", "THREAD_ID")
self.make_line("Name:", "NAME")
self.make_line("Type:", "TYPE")
self.make_line("User:"******"PROCESSLIST_USER")
self.make_line("Host:", "PROCESSLIST_HOST")
self.make_line("Schema:", "PROCESSLIST_DB")
self.make_line("Command:", "PROCESSLIST_COMMAND")
self.make_line("Time:", "PROCESSLIST_TIME")
self.make_line("State:", "PROCESSLIST_STATE")
self.make_line("Role:", "ROLE")
self.make_line("Instrumented:", "INSTRUMENTED")
self.make_line("Parent Thread Id:", "PARENT_THREAD_ID")
l = mforms.newLabel("Info:")
l.set_style(mforms.BoldStyle)
self.add(l, 0, 1, 13, 14, mforms.HFillFlag|mforms.HExpandFlag)
self.info = mforms.newCodeEditor()
self.info.set_features(mforms.FeatureGutter, False)
self.info.set_features(mforms.FeatureReadOnly, True)
self.info.set_features(mforms.FeatureWrapText, True)
self.info.set_language(mforms.LanguageMySQL56)
self.info.set_size(0, 50)
self.add(self.info, 0, 2, 14, 15, mforms.HFillFlag|mforms.VFillFlag|mforms.HExpandFlag|mforms.VExpandFlag)
if self.owner.ctrl_be.target_version.is_supported_mysql_version_at_least(5, 7, 2):
self.explain = mforms.newButton()
self.explain.set_enabled(False)
self.explain.add_clicked_callback(self.owner.explain_selected)
self.explain.set_text("Explain for Connection")
self.add(self.explain, 1, 2, 15, 16, mforms.HFillFlag)
else:
self.explain = None
def __init__(self, owner, sql_text):
WizardPage.__init__(self, owner, 'Review Generated Script')
self.save_button = mforms.newButton()
self.save_button.enable_internal_padding(True)
self.save_button.set_text('Save to File...')
self.save_button.set_tooltip('Save the text to a new file.')
self.save_button.add_clicked_callback(self.save_clicked)
self.copy_button = mforms.newButton()
self.copy_button.enable_internal_padding(True)
self.copy_button.set_text('Copy to Clipboard')
self.copy_button.set_tooltip('Copy the text to the clipboard.')
self.copy_button.add_clicked_callback(self.copy_clicked)
self.sql_text = mforms.newCodeEditor()
self.sql_text.set_language(mforms.LanguageMySQL)
self.sql_text.set_text(sql_text)
def __init__(self, owner, sql_text):
WizardPage.__init__(self, owner, 'Review Generated Script')
self.save_button = mforms.newButton()
self.save_button.enable_internal_padding(True)
self.save_button.set_text('Save to File...')
self.save_button.set_tooltip('Save the text to a new file.')
self.save_button.add_clicked_callback(self.save_clicked)
self.copy_button = mforms.newButton()
self.copy_button.enable_internal_padding(True)
self.copy_button.set_text('Copy to Clipboard')
self.copy_button.set_tooltip('Copy the text to the clipboard.')
self.copy_button.add_clicked_callback(self.copy_clicked)
self.sql_text = mforms.newCodeEditor()
self.sql_text.set_language(mforms.LanguageMySQL)
self.sql_text.set_text(sql_text)
def create_ui(self):
self.content.set_spacing(4)
self.content.add(
mforms.newLabel(
"Review and edit migrated objects. You can manually edit the generated SQL before applying them to the target database."
), False, True)
hbox = mforms.newBox(True)
self.tree_head_label = mforms.newLabel("Migrated Objects")
hbox.add(self.tree_head_label, False, False)
self._filter = mforms.newSelector()
self._filter.add_items(
["Migration Problems", "All Objects", "Column Mappings"])
self._filter.add_changed_callback(self._filter_changed)
hbox.add_end(self._filter, False, True)
hbox.add_end(mforms.newLabel("View:"), False, False)
self.content.add(hbox, False, True)
self._no_errors_text = "No migration problems found. %d warning(s).\nUse the View pulldown menu to review all objects."
self._no_errors = mforms.newLabel(
''
) # Label text will be set later when the warning count is calculated
self._no_errors.set_style(mforms.BigStyle)
self._no_errors.set_text_align(mforms.MiddleLeft)
self.content.add(self._no_errors, True, True)
self._tree = mforms.newTreeNodeView(mforms.TreeDefault)
self._tree.add_column(mforms.IconStringColumnType, "Source Object",
200, False)
self._tree.add_column(mforms.IconStringColumnType, "Target Object",
200, True)
self._tree.add_column(mforms.IconStringColumnType, "Migration Message",
300, False)
self._tree.end_columns()
self._tree.add_changed_callback(self._selection_changed)
self.content.add(self._tree, True, True)
self._tree.set_cell_edited_callback(self._cell_edited)
self._all_menu = mforms.newContextMenu()
self._all_menu.add_will_show_callback(self.all_menu_will_show)
self._all_menu.add_check_item_with_title("Skip Object",
self.skip_object,
"skip_object")
self._tree.set_context_menu(self._all_menu)
self._columns = mforms.newTreeNodeView(mforms.TreeShowColumnLines
| mforms.TreeShowRowLines
| mforms.TreeFlatList)
self.COL_SOURCE_SCHEMA = self._columns.add_column(
mforms.StringColumnType, "Source Schema", 100, False)
self.COL_SOURCE_TABLE = self._columns.add_column(
mforms.IconStringColumnType, "Source Table", 100, False)
self.COL_SOURCE_COLUMN = self._columns.add_column(
mforms.IconStringColumnType, "Source Column", 100, False)
self.COL_SOURCE_TYPE = self._columns.add_column(
mforms.StringColumnType, "Source Type", 100, False)
self.COL_SOURCE_FLAGS = self._columns.add_column(
mforms.StringColumnType, "Source Flags", 100, False)
self.COL_SOURCE_NOTNULL = self._columns.add_column(
mforms.CheckColumnType, "NN", 25, False)
self.COL_SOURCE_DEFAULT = self._columns.add_column(
mforms.StringColumnType, "Source Default Value", 100, False)
self.COL_SOURCE_COLLATION = self._columns.add_column(
mforms.StringColumnType, "Source Collation", 100, False)
self.COL_TARGET_SCHEMA = self._columns.add_column(
mforms.StringColumnType, "Target Schema", 100, False)
self.COL_TARGET_TABLE = self._columns.add_column(
mforms.IconStringColumnType, "Target Table", 100, False)
self.COL_TARGET_COLUMN = self._columns.add_column(
mforms.IconStringColumnType, "Target Column", 100, True)
self.COL_TARGET_TYPE = self._columns.add_column(
mforms.StringColumnType, "Target Type", 100, True)
self.COL_TARGET_FLAGS = self._columns.add_column(
mforms.StringColumnType, "Target Flags", 100, True)
self.COL_TARGET_AI = self._columns.add_column(mforms.CheckColumnType,
"AI", 25, True)
self.COL_TARGET_NOTNULL = self._columns.add_column(
mforms.CheckColumnType, "NN", 25, True)
self.COL_TARGET_DEFAULT = self._columns.add_column(
mforms.StringColumnType, "Target Default Value", 100, True)
self.COL_TARGET_COLLATION = self._columns.add_column(
mforms.StringColumnType, "Target Collation", 100, True)
self.COL_MESSAGE = self._columns.add_column(
mforms.IconStringColumnType, "Migration Message", 300, False)
self._columns.end_columns()
self._columns.set_allow_sorting(True)
self._columns.set_selection_mode(mforms.TreeSelectMultiple)
self._columns.add_changed_callback(self._selection_changed)
self.content.add(self._columns, True, True)
self._columns.set_cell_edited_callback(self._columns_cell_edited)
self._columns.show(False)
self._menu = mforms.newContextMenu()
self._menu.add_will_show_callback(self.menu_will_show)
self._menu.add_item_with_title(
"Set Target Type of Selected Columns...", self.set_target_type,
"set_target_type")
self._menu.add_item_with_title("Find and Replace Target Type...",
self.replace_target_type,
"replace_target_type")
self._menu.add_item_with_title("Find and Replace Target Flags...",
self.replace_target_flags,
"replace_target_flags")
self._menu.add_item_with_title(
"Find and Replace Target Default Value...",
self.replace_target_default_value, "replace_target_default_value")
self._menu.add_item_with_title("Find and Replace Target Collation...",
self.replace_target_collation,
"replace_target_collation")
self._columns.set_context_menu(self._menu)
self.help_label = mforms.newLabel(
"You can rename target schemas and tables, and change column definitions by clicking them once selected."
)
self.help_label.set_style(mforms.SmallStyle)
self.content.add(self.help_label, False, True)
self._advbox = mforms.newPanel(mforms.TitledBoxPanel)
self._advbox.set_title("SQL CREATE Script for Selected Object")
box = mforms.newBox(True)
self._code = mforms.newCodeEditor()
self._code.set_language(mforms.LanguageMySQL)
self._code.add_changed_callback(self._code_changed)
box.add(self._code, True, True)
vbox = mforms.newBox(False)
vbox.set_padding(12)
vbox.set_spacing(8)
self._lock_check = mforms.newCheckBox()
self._lock_check.set_text("Lock edited SQL")
self._lock_check.set_tooltip(
"Lock the SQL code to the edited one, preventing automatic regenerations from discarding changes made directly to the SQL script."
)
self._lock_check.add_clicked_callback(self._lock_clicked)
vbox.add(self._lock_check, False, True)
self._comment_check = mforms.newCheckBox()
self._comment_check.set_text("Comment out")
self._comment_check.set_tooltip(
"Mark the object to be commented out on the generated script, making it not get created in the target server."
)
self._comment_check.add_clicked_callback(self._comment_clicked)
vbox.add(self._comment_check, False, True)
self._sql_outdated_label = mforms.newLabel("Code is outdated")
self._sql_outdated_label.show(False)
self._sql_outdated_label.set_tooltip(
"The locked SQL code seems to be outdated compared to a newer, automatically generated one. Unlocking the object will update it, but your changes will be lost."
)
vbox.add(self._sql_outdated_label, False, True)
self._revert_btn = mforms.newButton()
self._revert_btn.set_text("Discard Changes")
vbox.add_end(self._revert_btn, False, True)
self._revert_btn.add_clicked_callback(self._discard_clicked)
self._apply_btn = mforms.newButton()
self._apply_btn.set_text("Apply Changes")
vbox.add_end(self._apply_btn, False, True)
self._apply_btn.add_clicked_callback(self._apply_clicked)
box.add(vbox, False, True)
self._advbox.add(box)
self._advbox.set_size(-1, 200)
self._advbox_shown = True
self.go_advanced() # toggle to hide
self.content.add(self._advbox, False, True)
self._filter_errors = False
self._filter_changed()
def create_ui(self):
self.content.set_spacing(4)
self.content.add(mforms.newLabel("Review and edit migrated objects. You can manually edit the generated SQL before applying them to the target database."), False, True)
hbox = mforms.newBox(True)
self.tree_head_label = mforms.newLabel("Migrated Objects")
hbox.add(self.tree_head_label, False, False)
self._filter = mforms.newSelector()
self._filter.add_items(["Migration Problems", "All Objects", "Column Mappings"])
self._filter.add_changed_callback(self._filter_changed)
hbox.add_end(self._filter, False, True)
hbox.add_end(mforms.newLabel("View:"), False, False)
self.content.add(hbox, False, True)
self._no_errors_text = "No migration problems found. %d warning(s).\nUse the View pulldown menu to review all objects."
self._no_errors = mforms.newLabel('') # Label text will be set later when the warning count is calculated
self._no_errors.set_style(mforms.BigStyle)
self._no_errors.set_text_align(mforms.MiddleLeft)
self.content.add(self._no_errors, True, True)
self._tree = mforms.newTreeView(mforms.TreeDefault)
self._tree.add_column(mforms.IconStringColumnType, "Source Object", 200, False)
self._tree.add_column(mforms.IconStringColumnType, "Target Object", 200, True)
self._tree.add_column(mforms.IconStringColumnType, "Migration Message", 300, False)
self._tree.end_columns()
self._tree.add_changed_callback(self._selection_changed)
self.content.add(self._tree, True, True)
self._tree.set_cell_edited_callback(self._cell_edited)
self._all_menu = mforms.newContextMenu()
self._all_menu.add_will_show_callback(self.all_menu_will_show)
self._all_menu.add_check_item_with_title("Skip Object", self.skip_object, "skip_object")
self._tree.set_context_menu(self._all_menu)
self._columns = mforms.newTreeView(mforms.TreeShowColumnLines|mforms.TreeShowRowLines|mforms.TreeFlatList)
self.COL_SOURCE_SCHEMA = self._columns.add_column(mforms.StringColumnType, "Source Schema", 100, False)
self.COL_SOURCE_TABLE = self._columns.add_column(mforms.IconStringColumnType, "Source Table", 100, False)
self.COL_SOURCE_COLUMN = self._columns.add_column(mforms.IconStringColumnType, "Source Column", 100, False)
self.COL_SOURCE_TYPE = self._columns.add_column(mforms.StringColumnType, "Source Type", 100, False)
self.COL_SOURCE_FLAGS = self._columns.add_column(mforms.StringColumnType, "Source Flags", 100, False)
self.COL_SOURCE_NOTNULL = self._columns.add_column(mforms.CheckColumnType, "NN", 25, False)
self.COL_SOURCE_DEFAULT = self._columns.add_column(mforms.StringColumnType, "Source Default Value", 100, False)
self.COL_SOURCE_COLLATION = self._columns.add_column(mforms.StringColumnType, "Source Collation", 100, False)
self.COL_TARGET_SCHEMA = self._columns.add_column(mforms.StringColumnType, "Target Schema", 100, False)
self.COL_TARGET_TABLE = self._columns.add_column(mforms.IconStringColumnType, "Target Table", 100, False)
self.COL_TARGET_COLUMN = self._columns.add_column(mforms.IconStringColumnType, "Target Column", 100, True)
self.COL_TARGET_TYPE = self._columns.add_column(mforms.StringColumnType, "Target Type", 100, True)
self.COL_TARGET_FLAGS = self._columns.add_column(mforms.StringColumnType, "Target Flags", 100, True)
self.COL_TARGET_AI = self._columns.add_column(mforms.CheckColumnType, "AI", 25, True)
self.COL_TARGET_NOTNULL = self._columns.add_column(mforms.CheckColumnType, "NN", 25, True)
self.COL_TARGET_DEFAULT = self._columns.add_column(mforms.StringColumnType, "Target Default Value", 100, True)
self.COL_TARGET_COLLATION = self._columns.add_column(mforms.StringColumnType, "Target Collation", 100, True)
self.COL_MESSAGE = self._columns.add_column(mforms.IconStringColumnType, "Migration Message", 300, False)
self._columns.end_columns()
self._columns.set_allow_sorting(True)
self._columns.set_selection_mode(mforms.TreeSelectMultiple)
self._columns.add_changed_callback(self._selection_changed)
self.content.add(self._columns, True, True)
self._columns.set_cell_edited_callback(self._columns_cell_edited)
self._columns.show(False)
self._menu = mforms.newContextMenu()
self._menu.add_will_show_callback(self.menu_will_show)
self._menu.add_item_with_title("Set Target Type of Selected Columns...", self.set_target_type, "set_target_type")
self._menu.add_item_with_title("Find and Replace Target Type...", self.replace_target_type, "replace_target_type")
self._menu.add_item_with_title("Find and Replace Target Flags...", self.replace_target_flags, "replace_target_flags")
self._menu.add_item_with_title("Find and Replace Target Default Value...", self.replace_target_default_value, "replace_target_default_value")
self._menu.add_item_with_title("Find and Replace Target Collation...", self.replace_target_collation, "replace_target_collation")
self._columns.set_context_menu(self._menu)
self.help_label = mforms.newLabel("You can rename target schemas and tables, and change column definitions by clicking them once selected.")
self.help_label.set_style(mforms.SmallStyle)
self.content.add(self.help_label, False, True)
self._advbox = mforms.newPanel(mforms.TitledBoxPanel)
self._advbox.set_title("SQL CREATE Script for Selected Object")
box = mforms.newBox(True)
self._code = mforms.newCodeEditor()
self._code.set_language(mforms.LanguageMySQL)
self._code.add_changed_callback(self._code_changed)
box.add(self._code, True, True)
vbox = mforms.newBox(False)
vbox.set_padding(12)
vbox.set_spacing(8)
self._lock_check = mforms.newCheckBox()
self._lock_check.set_text("Lock edited SQL")
self._lock_check.set_tooltip("Lock the SQL code to the edited one, preventing automatic regenerations from discarding changes made directly to the SQL script.")
self._lock_check.add_clicked_callback(self._lock_clicked)
vbox.add(self._lock_check, False, True)
self._comment_check = mforms.newCheckBox()
self._comment_check.set_text("Comment out")
self._comment_check.set_tooltip("Mark the object to be commented out on the generated script, making it not get created in the target server.")
self._comment_check.add_clicked_callback(self._comment_clicked)
vbox.add(self._comment_check, False, True)
self._sql_outdated_label = mforms.newLabel("Code is outdated")
self._sql_outdated_label.show(False)
self._sql_outdated_label.set_tooltip("The locked SQL code seems to be outdated compared to a newer, automatically generated one. Unlocking the object will update it, but your changes will be lost.")
vbox.add(self._sql_outdated_label, False, True)
self._revert_btn = mforms.newButton()
self._revert_btn.set_text("Discard Changes")
vbox.add_end(self._revert_btn, False, True)
self._revert_btn.add_clicked_callback(self._discard_clicked)
self._apply_btn = mforms.newButton()
self._apply_btn.set_text("Apply Changes")
vbox.add_end(self._apply_btn, False, True)
self._apply_btn.add_clicked_callback(self._apply_clicked)
box.add(vbox, False, True)
self._advbox.add(box)
self._advbox.set_size(-1, 200)
self._advbox_shown = True
self.go_advanced() # toggle to hide
self.content.add(self._advbox, False, True)
self._filter_errors = False
self._filter_changed()
def __init__(self, main):
WizardPage.__init__(self, main, "Create Target Results", wide=True)
self.main.add_wizard_page(self, "ObjectMigration",
"Create Target Results")
text = """Scripts to create the target schema were executed. No data has been migrated yet. Review the creation report below
for errors or warnings. If there are any errors, you can manually fix the scripts and click [Recreate Objects] to retry
the schema creation or return to the Manual Editing page to correct them there and retry the target creation."""
description = mforms.newLabel(text)
description.set_name("Page Description")
self.content.add(description, False, True)
hbox = mforms.newBox(True)
hbox.set_spacing(12)
hbox.set_homogeneous(True)
self._tree = mforms.newTreeView(mforms.TreeFlatList)
self._tree.set_name("Script Results")
self._tree.add_column(mforms.IconStringColumnType, "Object", 200,
False)
self._tree.add_column(mforms.IconStringColumnType, "Result", 600,
False)
self._tree.end_columns()
self._tree.add_changed_callback(self._selection_changed)
hbox.add(self._tree, True, True)
#self.content.add(self._tree, True, True)
self._advbox = mforms.newPanel(mforms.TitledBoxPanel)
self._advbox.set_title("SQL CREATE Script for Selected Object")
self._advbox.set_name("SQL IDE")
box = mforms.newBox(False)
self._code = mforms.newCodeEditor()
self._code.set_language(mforms.LanguageMySQL)
self._code.add_changed_callback(self._code_changed)
box.add(self._code, True, True)
vbox = mforms.newBox(True)
vbox.set_padding(12)
vbox.set_spacing(8)
self._comment_check = mforms.newCheckBox()
self._comment_check.set_text("Comment out")
self._comment_check.set_name("Comment Out")
self._comment_check.add_clicked_callback(self._comment_clicked)
vbox.add(self._comment_check, False, True)
self._revert_btn = mforms.newButton()
self._revert_btn.set_text("Discard")
vbox.add_end(self._revert_btn, False, True)
self._revert_btn.add_clicked_callback(self._discard_clicked)
self._apply_btn = mforms.newButton()
self._apply_btn.set_text("Apply")
vbox.add_end(self._apply_btn, False, True)
self._apply_btn.add_clicked_callback(self._apply_clicked)
box.add(vbox, False, True)
self._advbox.add(box)
#self._advbox.set_size(-1, 200)
#self._advbox_shown = True
#self.go_advanced() # toggle to hide
self.advanced_button.set_text("Recreate Objects")
#self.content.add(self._advbox, False, True)
hbox.add(self._advbox, True, True)
self.content.add(hbox, True, True)
self._msgbox = mforms.newPanel(mforms.TitledBoxPanel)
self._msgbox.set_title("Output Messages")
self._msgbox.set_name("Output Messages")
box = mforms.newBox(False)
box.set_padding(8)
self._msgs = mforms.newTextBox(mforms.VerticalScrollBar)
box.add(self._msgs, True, True)
self._msgbox.add(box)
self.content.add(self._msgbox, False, True)
self._msgbox.set_size(-1, 200)
self._error_tables = []
def __init__(self, main):
WizardPage.__init__(self, main, "Create Target Results", wide=True)
self.main.add_wizard_page(self, "ObjectMigration", "Create Target Results")
text = """Scripts to create the target schema were executed. No data has been migrated yet. Review the creation report below
for errors or warnings. If there are any errors, you can manually fix the scripts and click [Recreate Objects] to retry
the schema creation or return to the Manual Editing page to correct them there and retry the target creation."""
self.content.add(mforms.newLabel(text), False, True)
hbox = mforms.newBox(True)
hbox.set_spacing(12)
hbox.set_homogeneous(True)
self._tree = mforms.newTreeNodeView(mforms.TreeFlatList)
self._tree.add_column(mforms.IconStringColumnType, "Object", 200, False)
self._tree.add_column(mforms.IconStringColumnType, "Result", 600, False)
self._tree.end_columns()
self._tree.add_changed_callback(self._selection_changed)
hbox.add(self._tree, True, True)
#self.content.add(self._tree, True, True)
self._advbox = mforms.newPanel(mforms.TitledBoxPanel)
self._advbox.set_title("SQL CREATE Script for Selected Object")
box = mforms.newBox(False)
self._code = mforms.newCodeEditor()
self._code.set_language(mforms.LanguageMySQL)
self._code.add_changed_callback(self._code_changed)
box.add(self._code, True, True)
vbox = mforms.newBox(True)
vbox.set_padding(12)
vbox.set_spacing(8)
self._comment_check = mforms.newCheckBox()
self._comment_check.set_text("Comment out")
self._comment_check.add_clicked_callback(self._comment_clicked)
vbox.add(self._comment_check, False, True)
self._revert_btn = mforms.newButton()
self._revert_btn.set_text("Discard")
vbox.add_end(self._revert_btn, False, True)
self._revert_btn.add_clicked_callback(self._discard_clicked)
self._apply_btn = mforms.newButton()
self._apply_btn.set_text("Apply")
vbox.add_end(self._apply_btn, False, True)
self._apply_btn.add_clicked_callback(self._apply_clicked)
box.add(vbox, False, True)
self._advbox.add(box)
#self._advbox.set_size(-1, 200)
#self._advbox_shown = True
#self.go_advanced() # toggle to hide
self.advanced_button.set_text("Recreate Objects")
#self.content.add(self._advbox, False, True)
hbox.add(self._advbox, True, True)
self.content.add(hbox, True, True)
self._msgbox = mforms.newPanel(mforms.TitledBoxPanel)
self._msgbox.set_title("Output Messages")
box = mforms.newBox(False)
box.set_padding(8)
self._msgs = mforms.newTextBox(mforms.VerticalScrollBar)
box.add(self._msgs, True, True)
self._msgbox.add(box)
self.content.add(self._msgbox, False, True)
self._msgbox.set_size(-1, 200)
self._error_tables = []
def __init__(self, editor):
mforms.Form.__init__(self, mforms.Form.main_form(),
mforms.FormDialogFrame)
self.editor = editor
box = mforms.Box(False)
box.set_padding(12)
box.set_spacing(8)
box.add(
mforms.newLabel(
"Preview the first lines of the script below and click [Run] to start executing.\nNote: the preview below may display non-ASCII characters incorrectly, even if the MySQL server can treat them correctly."
), False, True)
self.file_info = mforms.newLabel("")
box.add(self.file_info, False, True)
self.text = mforms.newCodeEditor(None)
self.text.set_language(mforms.LanguageMySQL)
box.add(self.text, True, True)
table = mforms.newTable()
table.set_padding(20)
table.set_row_count(2)
table.set_column_count(3)
table.set_row_spacing(8)
table.set_column_spacing(4)
table.add(mforms.newLabel("Default Schema Name:"), 0, 1, 0, 1, 0)
self.schema = mforms.newSelector(mforms.SelectorCombobox)
table.add(self.schema, 1, 2, 0, 1,
mforms.HFillFlag | mforms.HExpandFlag)
help = mforms.newLabel(
"Schema to be used unless explicitly specified in the script.\nLeave blank if the script already specified it,\npick a schema from the drop down or type a name to\ncreate a new one."
)
help.set_style(mforms.SmallHelpTextStyle)
table.add(help, 2, 3, 0, 1, mforms.HFillFlag)
table.add(mforms.newLabel("Default Character Set:"), 0, 1, 1, 2, 0)
self.charset = mforms.newSelector()
self.charset.add_changed_callback(self.update_preview)
l = [""]
for ch in grt.root.wb.rdbmsMgmt.rdbms[0].characterSets:
l.append(ch.name)
self.charset.add_items(sorted(l))
table.add(self.charset, 1, 2, 1, 2,
mforms.HFillFlag | mforms.HExpandFlag)
help = mforms.newLabel(
"Default character set to use when executing the script,\nunless specified in the script."
)
help.set_style(mforms.SmallHelpTextStyle)
table.add(help, 2, 3, 1, 2, mforms.HFillFlag)
box.add(table, False, True)
self.ok = mforms.newButton()
self.ok.set_text("Run")
self.cancel = mforms.newButton()
self.cancel.set_text("Cancel")
hbox = mforms.Box(True)
hbox.set_spacing(8)
mforms.Utilities.add_end_ok_cancel_buttons(hbox, self.ok, self.cancel)
box.add_end(hbox, False, True)
self.set_content(box)