/// <summary>
/// Selects connection node in the Server Explorer window.
/// </summary>
private void SelectConnectionNode()
{
//MySqlDataProviderPackage package = MySqlDataProviderPackage.Instance;
// Extracts connection mamanger global service
DataExplorerConnectionManager manager = Package.GetGlobalService(typeof(DataExplorerConnectionManager))
as DataExplorerConnectionManager;
if (manager == null)
{
Debug.Fail("Failed to get connection manager!");
return;
}
// Searches for connection using connection string for current connection
DataExplorerConnection connection = manager.FindConnection(
Guids.Provider, HierarchyAccessor.Connection.EncryptedConnectionString, true);
if (connection == null)
{
Debug.Fail("Failed to find proper connection node!");
return;
}
// Select connection node
manager.SelectConnection(connection);
}
/// <summary>
/// Opens the Add Data Connection Dialog with the data source being a MySQL database and the server field
/// set to the ip of the intance. If the proper dependencies are not installed (for the MySQL database)
/// the user will be prompted to install them before they can continue.
/// </summary>
private void OpenDataConnectionDialog()
{
// Create a data connection dialog and add all possible data sources to it.
DataConnectionDialogFactory factory = (DataConnectionDialogFactory)Package.GetGlobalService(typeof(DataConnectionDialogFactory));
DataConnectionDialog dialog = factory.CreateConnectionDialog();
dialog.AddAllSources();
// Check if the MySQL data source exists.
// TODO(talarico): This is added when the user has MySQL for Visual Studio installed. We should also
// probably check for the needed pieces in the MySQL Connector/Net.
if (dialog.AvailableSources.Contains(CloudSqlUtils.DataSource))
{
EventsReporterWrapper.ReportEvent(OpenCloudSqlConnectionDialogEvent.Create());
// Pre select the MySQL data source.
dialog.SelectedSource = CloudSqlUtils.DataSource;
// Create the connection string to pre populate the server address in the dialog.
InstanceItem instance = GetItem();
var serverAddress = String.IsNullOrEmpty(instance.IpAddress) ? instance.Ipv6Address : instance.IpAddress;
dialog.DisplayConnectionString = CloudSqlUtils.FormatServerConnectionString(serverAddress);
bool addDataConnection = dialog.ShowDialog();
if (addDataConnection)
{
// Create a name for the data connection
var parsedConnection = CloudSqlUtils.ParseConnection(dialog.DisplayConnectionString);
string connectionName;
if (parsedConnection.Server == serverAddress)
{
connectionName = $"{Instance.Project}[{Instance.Name}][{parsedConnection.Database}]";
}
else
{
connectionName = $"{parsedConnection.Server}[{parsedConnection.Database}]";
}
// Add the MySQL data connection to the data explorer
DataExplorerConnectionManager manager = (DataExplorerConnectionManager)Package.GetGlobalService(typeof(DataExplorerConnectionManager));
manager.AddConnection(connectionName, CloudSqlUtils.DataProvider, dialog.EncryptedConnectionString, true);
}
}
else
{
// MySQL for Visual Studio isn't installed, prompt the user to install it.
MySQLInstallerWindow.PromptUser();
}
}
private void OpenDataConnectionDialog()
{
ExtensionAnalytics.ReportCommand(CommandName.OpenMySQLDataConnectionDialog, CommandInvocationSource.Button);
// Create a data connection dialog and add all possible data sources to it.
DataConnectionDialogFactory factory = (DataConnectionDialogFactory)Package.GetGlobalService(typeof(DataConnectionDialogFactory));
DataConnectionDialog dialog = factory.CreateConnectionDialog();
dialog.AddAllSources();
// Check if the MySQL data source exists.
// TODO(talarico): This is added when the user has MySQL for Visual Studio installed. We should also
// probably check for the needed pieces in the MySQL Connector/Net.
if (dialog.AvailableSources.Contains(MySQLUtils.MySQLDataSource))
{
// Pre select the MySQL data source.
dialog.SelectedSource = MySQLUtils.MySQLDataSource;
// Create the connection string to pre populate the server address in the dialog.
MySqlConnectionStringBuilder builderPrePopulate = new MySqlConnectionStringBuilder();
InstanceItem instance = _item.Value;
builderPrePopulate.Server = String.IsNullOrEmpty(instance.IpAddress) ? instance.Ipv6Address : instance.IpAddress;
dialog.DisplayConnectionString = builderPrePopulate.GetConnectionString(false);
bool addDataConnection = dialog.ShowDialog();
if (addDataConnection)
{
ExtensionAnalytics.ReportCommand(CommandName.AddMySQLDataConnection, CommandInvocationSource.Button);
// Create a name for the data connection
MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder(dialog.DisplayConnectionString);
string database = $"{_instance.Project}[{builder.Server}][{builder.Database}]";
// Add the MySQL data connection to the data explorer
DataExplorerConnectionManager manager = (DataExplorerConnectionManager)Package.GetGlobalService(typeof(DataExplorerConnectionManager));
manager.AddConnection(database, MySQLUtils.MySQLDataProvider, dialog.EncryptedConnectionString, true);
}
}
else
{
// MySQL for Visual Studio isn't installed, prompt the user to install it.
ExtensionAnalytics.ReportEvent("MySQLForVisualStudio", "Missing");
MySQLInstallerWindow.PromptUser();
}
}
