public override void initialize_connections(ConfigurationPropertyHolder configuration_property_holder) { if (!string.IsNullOrEmpty(connection_string)) { // Must allow User variables for SPROCs var connectionBuilder = new MySqlConnectionStringBuilder(connection_string); if (!connectionBuilder.AllowUserVariables) { connectionBuilder.Add("Allow User Variables", "True"); connection_string = connectionBuilder.ConnectionString; } string[] parts = connection_string.Split(';'); foreach (string part in parts) { if (string.IsNullOrEmpty(server_name) && (part.to_lower().Contains("server") || part.to_lower().Contains("data source"))) { server_name = part.Substring(part.IndexOf("=") + 1); } if (string.IsNullOrEmpty(database_name) && (part.to_lower().Contains("database") || part.to_lower().Contains("database"))) { database_name = part.Substring(part.IndexOf("=") + 1); } } } if (server_name == infrastructure.ApplicationParameters.default_server_name) { server_name = "localhost"; } if (string.IsNullOrEmpty(connection_string)) { InteractivePrompt.write_header(configuration_property_holder); var user_name = InteractivePrompt.get_user("root", configuration_property_holder); var password = InteractivePrompt.get_password("root", configuration_property_holder); InteractivePrompt.write_footer(); connection_string = build_connection_string(server_name, database_name, user_name, password); } configuration_property_holder.ConnectionString = connection_string; set_provider(); if (string.IsNullOrEmpty(admin_connection_string)) { var builder = new MySqlConnectionStringBuilder(connection_string); builder.Database = "information_schema"; admin_connection_string = builder.ConnectionString; } configuration_property_holder.ServerName = server_name; configuration_property_holder.DatabaseName = database_name; configuration_property_holder.ConnectionStringAdmin = admin_connection_string; }
public override void initialize_connections(ConfigurationPropertyHolder configuration_property_holder) { if (!string.IsNullOrEmpty(connection_string)) { var parts = connection_string.Split(';'); foreach (var part in parts) { if (string.IsNullOrEmpty(server_name) && (part.to_lower().Contains("server") || part.to_lower().Contains("data source"))) { server_name = part.Substring(part.IndexOf("=") + 1); } if (string.IsNullOrEmpty(database_name) && (part.to_lower().Contains("database") || part.to_lower().Contains("database"))) { database_name = part.Substring(part.IndexOf("=") + 1); } } } server_name = server_name.to_lower(); database_name = database_name.to_lower(); configuration_property_holder.ServerName = server_name; configuration_property_holder.DatabaseName = database_name; if (server_name == infrastructure.ApplicationParameters.default_server_name) { server_name = "localhost"; } if (string.IsNullOrEmpty(connection_string)) { InteractivePrompt.write_header(configuration_property_holder); var user_name = InteractivePrompt.get_user("postgres", configuration_property_holder); var password = InteractivePrompt.get_password("postgres", configuration_property_holder); InteractivePrompt.write_footer(); connection_string = build_connection_string(server_name, database_name, user_name, password); } configuration_property_holder.ConnectionString = connection_string; set_provider(); if (string.IsNullOrEmpty(admin_connection_string)) { admin_connection_string = Regex.Replace(connection_string, "database=.*?;", "database=postgres;", RegexOptions.IgnoreCase); } configuration_property_holder.ConnectionStringAdmin = admin_connection_string; }