public ViewEditorDialog(ISchemaProvider schemaProvider, ViewSchema view, bool create)
{
if (schemaProvider == null)
{
throw new ArgumentNullException("schemaProvider");
}
if (view == null)
{
throw new ArgumentNullException("view");
}
this.schemaProvider = schemaProvider;
this.view = view;
this.action = create ? SchemaActions.Create : SchemaActions.Alter;
this.Build();
if (create)
{
Title = GettextCatalog.GetString("Create View");
}
else
{
Title = GettextCatalog.GetString("Alter View");
}
notebook = new Notebook();
sqlEditor = new SqlEditorWidget();
sqlEditor.TextChanged += new EventHandler(SqlChanged);
notebook.AppendPage(sqlEditor, new Label(GettextCatalog.GetString("Definition")));
IDbFactory fac = schemaProvider.ConnectionPool.DbFactory;
if (fac.IsCapabilitySupported("View", action, ViewCapabilities.Comment))
{
commentEditor = new CommentEditorWidget();
notebook.AppendPage(commentEditor, new Label(GettextCatalog.GetString("Comment")));
}
notebook.Page = 0;
entryName.Text = view.Name;
if (!create)
{
sqlEditor.Text = schemaProvider.GetViewAlterStatement(view);
commentEditor.Comment = view.Comment;
}
vboxContent.PackStart(notebook, true, true, 0);
vboxContent.ShowAll();
SetWarning(null);
}
public ProcedureEditorDialog(IEditSchemaProvider schemaProvider, bool create, ProcedureEditorSettings settings)
{
if (schemaProvider == null)
{
throw new ArgumentNullException("schemaProvider");
}
this.settings = settings;
this.schemaProvider = schemaProvider;
this.action = create ? SchemaActions.Create : SchemaActions.Alter;
this.Build();
if (create)
{
Title = AddinCatalog.GetString("Create Procedure");
}
else
{
Title = AddinCatalog.GetString("Alter Procedure");
}
notebook = new Notebook();
sqlEditor = new SqlEditorWidget();
sqlEditor.TextChanged += new EventHandler(SqlChanged);
notebook.AppendPage(sqlEditor, new Label(AddinCatalog.GetString("Definition")));
if (settings.ShowComment)
{
commentEditor = new CommentEditorWidget();
notebook.AppendPage(commentEditor, new Label(AddinCatalog.GetString("Comment")));
}
if (!settings.ShowName)
{
nameLabel.Visible = false;
entryName.Visible = false;
}
vboxContent.PackStart(notebook, true, true, 0);
vboxContent.ShowAll();
SetWarning(null);
}
public SqlQueryView()
{
stoppedQueries = new List <object> ();
MonoDevelop.SourceEditor.Extension.TemplateExtensionNodeLoader.Init();
this.UntitledName = string.Concat(AddinCatalog.GetString("Untitled Sql Script"), ".sql");
vbox = new VBox(false, 6);
vbox.BorderWidth = 6;
Toolbar toolbar = new Toolbar();
toolbar.ToolbarStyle = ToolbarStyle.BothHoriz;
buttonExecute = new ToolButton(ImageService.GetImage("md-db-execute", IconSize.SmallToolbar),
AddinCatalog.GetString("_Execute"));
buttonExecute.Label = AddinCatalog.GetString("Execute");
buttonExecute.Sensitive = false;
buttonExecute.TooltipMarkup = AddinCatalog.GetString("Execute Query");
buttonExecute.IsImportant = true;
buttonExecute.Clicked += new EventHandler(ExecuteClicked);
buttonStop = new ToolButton("gtk-stop");
buttonStop.TooltipText = AddinCatalog.GetString("Stop Query Execution");
buttonStop.Sensitive = false;
buttonStop.Clicked += new EventHandler(StopClicked);
buttonClear = new ToolButton(ImageService.GetImage("gtk-clear", IconSize.Button),
AddinCatalog.GetString("Clear Results"));
buttonClear.TooltipText = AddinCatalog.GetString("Clear Results");
buttonClear.Clicked += new EventHandler(ClearClicked);
comboConnections = new DatabaseConnectionContextComboBox();
selectedConnection = comboConnections.DatabaseConnection;
comboConnections.Changed += new EventHandler(ConnectionChanged);
ToolItem comboItem = new ToolItem();
comboItem.Child = comboConnections;
toolbar.Add(buttonExecute);
toolbar.Add(buttonStop);
toolbar.Add(buttonClear);
toolbar.Add(new SeparatorToolItem());
toolbar.Add(comboItem);
pane = new VPaned();
// Sql History Window
ScrolledWindow windowHistory = new ScrolledWindow();
history = new SqlEditorWidget();
history.Editable = false;
windowHistory.AddWithViewport(history);
// Status of the Last Query
ScrolledWindow windowStatus = new ScrolledWindow();
status = new TextView();
windowStatus.Add(status);
notebook = new Notebook();
notebook.AppendPage(windowStatus, new Label(AddinCatalog.GetString("Status")));
notebook.AppendPage(windowHistory, new Label(AddinCatalog.GetString("Query History")));
pane.Pack2(notebook, true, true);
vbox.PackStart(toolbar, false, true, 0);
vbox.PackStart(pane, true, true, 0);
this.Document.TextReplaced += SqlChanged;
vbox.ShowAll();
Document.DocumentUpdated += delegate(object sender, EventArgs args) {
// Default mime type or a provider defined.
if (selectedConnection == null)
{
Document.MimeType = "text/x-sql";
}
else
{
Document.MimeType = GetMimeType();
}
};
Document.Text = string.Empty;
notebook.Hide();
}
public SqlQueryView()
{
stoppedQueries = new List <object> ();
vbox = new VBox(false, 6);
vbox.BorderWidth = 6;
sqlEditor = new SqlEditorWidget();
sqlEditor.TextChanged += new EventHandler(SqlChanged);
Toolbar toolbar = new Toolbar();
toolbar.ToolbarStyle = ToolbarStyle.BothHoriz;
buttonExecute = new ToolButton(
Services.Resources.GetImage("md-db-execute", IconSize.SmallToolbar),
GettextCatalog.GetString("Execute")
);
buttonStop = new ToolButton("gtk-stop");
buttonClear = new ToolButton(Services.Resources.GetImage("gtk-clear", IconSize.Button), GettextCatalog.GetString("Clear Results"));
buttonStop.Sensitive = false;
buttonExecute.Sensitive = false;
buttonExecute.Clicked += new EventHandler(ExecuteClicked);
buttonStop.Clicked += new EventHandler(StopClicked);
buttonClear.Clicked += new EventHandler(ClearClicked);
comboConnections = new DatabaseConnectionContextComboBox();
selectedConnection = comboConnections.DatabaseConnection;
comboConnections.Changed += new EventHandler(ConnectionChanged);
buttonExecute.IsImportant = true;
ToolItem comboItem = new ToolItem();
comboItem.Child = comboConnections;
toolbar.Add(buttonExecute);
toolbar.Add(buttonStop);
toolbar.Add(buttonClear);
toolbar.Add(new SeparatorToolItem());
toolbar.Add(comboItem);
pane = new VPaned();
ScrolledWindow windowStatus = new ScrolledWindow();
status = new TextView();
windowStatus.Add(status);
notebook = new Notebook();
notebook.AppendPage(windowStatus, new Label(GettextCatalog.GetString("Status")));
pane.Pack1(sqlEditor, true, true);
pane.Pack2(notebook, true, true);
vbox.PackStart(toolbar, false, true, 0);
vbox.PackStart(pane, true, true, 0);
vbox.ShowAll();
notebook.Hide();
}
