//------------------------------------------------------------------------------
void DbMySQLTableEditor::create_table_page()
{
// Connect Table tab widgets
bind_entry_and_be_setter("table_name", this, &DbMySQLTableEditor::set_table_name);
Gtk::ComboBox* combo = 0;
xml()->get_widget("engine_combo", combo);
setup_combo_for_string_list(combo);
fill_combo_from_string_list(combo, _be->get_engines_list());
add_option_combo_change_handler(combo, "ENGINE", sigc::mem_fun(this, &DbMySQLTableEditor::set_table_option_by_name));
combo = 0;
xml()->get_widget("collation_combo", combo);
setup_combo_for_string_list(combo);
std::vector<std::string> collations(_be->get_charset_collation_list());
collations.insert(collations.begin(), "*Default*");
fill_combo_from_string_list(combo, collations);
add_option_combo_change_handler(combo, "CHARACTER SET - COLLATE", sigc::mem_fun(this, &DbMySQLTableEditor::set_table_option_by_name));
Gtk::TextView *tview = 0;
xml()->get_widget("table_comments", tview);
add_text_change_timer(tview, sigc::mem_fun(this, &DbMySQLTableEditor::set_comment));
}
//------------------------------------------------------------------------------
DbMySQLTableEditorFKPage::DbMySQLTableEditorFKPage(DbMySQLTableEditor *owner
,MySQLTableEditorBE *be
,Glib::RefPtr<Gtk::Builder> xml)
: _owner(owner)
, _be(be)
, _xml(xml)
, _edit_conn(0)
, _ce(0)
, _fk_page_content(0)
, _fk_page_not_supported_label(0)
{
_xml->get_widget("fks", _fk_tv);
_xml->get_widget("fk_columns", _fk_columns_tv);
_fk_tv->set_enable_tree_lines(true);
_fk_tv->set_headers_visible(true);
_fk_tv->get_selection()->set_mode(Gtk::SELECTION_MULTIPLE);
switch_be(_be);
_fk_tv->signal_cursor_changed().connect(sigc::mem_fun(*this, &DbMySQLTableEditorFKPage::fk_cursor_changed));
_xml->get_widget("fk_update", _fk_update_combo);
setup_combo_for_string_list(_fk_update_combo);
fill_combo_from_string_list(_fk_update_combo, _be->get_fk_action_options());
_fk_update_combo->signal_changed().connect(sigc::bind(sigc::mem_fun(this, &DbMySQLTableEditorFKPage::combo_box_changed)
,::bec::FKConstraintListBE::OnUpdate
)
);
_xml->get_widget("fk_delete", _fk_delete_combo);
setup_combo_for_string_list(_fk_delete_combo);
fill_combo_from_string_list(_fk_delete_combo, _be->get_fk_action_options());
_fk_delete_combo->signal_changed().connect(sigc::bind(sigc::mem_fun(this, &DbMySQLTableEditorFKPage::combo_box_changed)
,::bec::FKConstraintListBE::OnDelete
)
);
Gtk::TextView *fk_comment(0);
_xml->get_widget("fk_comment", fk_comment);
_owner->add_text_change_timer(fk_comment, sigc::mem_fun(this, &DbMySQLTableEditorFKPage::set_comment));
_xml->get_widget("fk_model_only", _fk_model_only);
_fk_model_only->signal_toggled().connect(sigc::mem_fun(this, &DbMySQLTableEditorFKPage::model_only_toggled));
_xml->get_widget("fk_page_content_box", _fk_page_content);
_xml->get_widget("fk_page_not_supported_label", _fk_page_not_supported_label);
_fk_page_not_supported_label->set_text("Note: foreign keys can only be defined for certain storage engines (like InnoDB)."
" The server accepts foreign key definitions for other storage engines but silently ignores"
" them. Switch your table engine (on the Table tab) to one that supports foreign"
" keys to allow adjustments here."
);
_fk_page_not_supported_label->set_line_wrap(true);
_fk_page_not_supported_label->hide();
check_fk_support();
}
//------------------------------------------------------------------------------
DbMySQLTableEditorIndexPage::DbMySQLTableEditorIndexPage(DbMySQLTableEditor *owner, MySQLTableEditorBE *be,
Glib::RefPtr<Gtk::Builder> xml)
: _owner(owner), _be(be), _xml(xml), _editing_done_id(0), _editable_cell(0) {
_xml->get_widget("indexes", _indexes_tv);
_indexes_tv->set_enable_tree_lines(true);
_indexes_tv->set_headers_visible(true);
switch_be(be);
_indexes_tv->signal_cursor_changed().connect(
sigc::mem_fun(*this, &DbMySQLTableEditorIndexPage::index_cursor_changed));
std::vector<std::string> asc_desc_list;
asc_desc_list.push_back("ASC");
asc_desc_list.push_back("DESC");
_sort_order_model = model_from_string_list(asc_desc_list);
_xml->get_widget("index_storage_combo", _index_storage_combo);
setup_combo_for_string_list(_index_storage_combo);
fill_combo_from_string_list(_index_storage_combo, _be->get_index_storage_types());
_index_storage_combo_conn = _index_storage_combo->signal_changed().connect(
sigc::mem_fun(this, &DbMySQLTableEditorIndexPage::update_index_storage_type_in_be));
_owner->bind_entry_and_be_setter("index_key_block_size", this,
&DbMySQLTableEditorIndexPage::set_index_key_block_size);
_owner->bind_entry_and_be_setter("index_parser", this, &DbMySQLTableEditorIndexPage::set_index_parser);
Gtk::TextView *text(0);
_xml->get_widget("index_comment", text);
_owner->add_text_change_timer(text, sigc::mem_fun(this, &DbMySQLTableEditorIndexPage::set_index_comment));
this->update_gui_for_server();
_order_model = model_from_string_list(std::vector<std::string>());
}
//------------------------------------------------------------------------------
void DbMySQLTableEditor::do_refresh_form_data()
{
refresh_table_page();
_columns_page->refresh();
_indexes_page->refresh();
_fks_page->refresh();
_triggers_page->refresh();
_part_page->refresh();
_opts_page->refresh();
if (!is_editing_live_object())
{
Gtk::Notebook *notebook;
xml()->get_widget("mysql_editor_notebook", notebook);
_privs_page->refresh();
}
else
{
Gtk::ComboBox *cbox = 0;
xml()->get_widget("schema_combo", cbox);
if (cbox)
{
fill_combo_from_string_list(cbox, _be->get_all_schema_names());
cbox->set_active(0);
}
}
}
SchemaEditor(grt::Module *m, bec::GRTManager *grtm, const grt::BaseListRef &args)
: PluginEditorBase(m, grtm, args, "modules/data/editor_schema.glade")
, _be(new MySQLSchemaEditorBE(grtm, db_mysql_SchemaRef::cast_from(args[0])))
{
xml()->get_widget("mysql_schema_editor_notebook", _editor_notebook);
Gtk::Widget *widget;
xml()->get_widget("base_table", widget);
Gtk::Image *image;
xml()->get_widget("image", image);
image->set(ImageCache::get_instance()->image_from_filename("db.Schema.editor.48x48.png", false));
bind_entry_and_be_setter("name_entry", this, &SchemaEditor::set_name);
if (_be->is_editing_live_object() && _be->get_schema()->oldName() != "")
{
Gtk::Entry *entry;
xml()->get_widget("name_entry", entry);
entry->set_sensitive(false);
}
Gtk::Button *btn;
xml()->get_widget("refactor_btn", btn);
btn->set_sensitive(_be->refactor_possible());
btn->signal_clicked().connect(sigc::mem_fun(this, &SchemaEditor::refactor_schema));
Gtk::ComboBox *combo;
xml()->get_widget("collation_combo", combo);
Glib::RefPtr<Gtk::ListStore> store(Glib::RefPtr<Gtk::ListStore>::cast_dynamic(xml()->get_object("collation_store")));
setup_combo_for_string_list(combo);
fill_combo_from_string_list(combo, _be->get_charset_collation_list());
add_option_combo_change_handler(combo, "CHARACTER SET - COLLATE", sigc::mem_fun(this, &SchemaEditor::set_schema_option_by_name));
Gtk::TextView *tview;
xml()->get_widget("text_view", tview);
add_text_change_timer(tview, sigc::mem_fun(this, &SchemaEditor::set_comment));
//!widget->reparent(*this);
add(*_editor_notebook);
_editor_notebook->show();
show_all();
refresh_form_data();
}
bool DbMySQLTableEditorIndexPage::real_refresh()
{
if (!_editing_sig.empty())
_editing_sig.disconnect();
Gtk::TreeView *tv = 0;
_xml->get_widget("index_columns", tv);
tv->unset_model();
tv->remove_all_columns();
_index_node = bec::NodeId();
_be->get_indexes()->select_index(_index_node);
fill_combo_from_string_list(_index_storage_combo, _be->get_index_storage_types());
_indexes_tv->remove_all_columns();
_indexes_model = ListModelWrapper::create(_be->get_indexes(), _indexes_tv, "DbMySQLTableEditorIndexPage");
_indexes_model->model().append_string_column(0, "Index Name", EDITABLE, NO_ICON);
_indexes_model->model().append_combo_column(1, "Type", model_from_string_list(_be->get_index_types()), EDITABLE, true);
_indexes_tv->set_model(_indexes_model);
Gtk::CellRenderer* rend = _indexes_tv->get_column_cell_renderer(0);
_editing_sig = rend->signal_editing_started().
connect(sigc::mem_fun(this, &DbMySQLTableEditorIndexPage::cell_editing_started));
const bool has_columns = _be->get_columns()->count() > 1;
tv->set_sensitive(has_columns);
_indexes_tv->set_sensitive(has_columns);
index_cursor_changed();
return false;
}
