public static MySqlConnectionConfig Parse(string connectionString)
{
var config = new MySqlConnectionConfig();
string[] pairValues = connectionString.Split(';');
foreach (var pairValue in pairValues)
{
string[] item = pairValue.Split('=');
switch (item[0])
{
case "Server":
config.Server = item[1];
break;
case "Database":
config.Database = item[1];
break;
case "Uid":
config.User = item[1];
break;
case "Pwd":
config.Password = item[1];
break;
}
}
return(config);
}
public MySqlConnection GetConnection(MySqlConnectionConfig config)
{
if (Connect(config.User, config.Password, config.Server, config.Database))
{
return(_connection);
}
return(null);
}
public void On_SerializeToConnectionString_ReturnsCorrectString()
{
var sample = new MySqlConnectionConfig()
{
User = "******",
Password = "******",
Server = "localhost",
Database = "gladysdb"
};
string result = MySqlConnectionStringParser.SerializeToConnectionString(sample);
Assert.AreEqual(expected: "Uid=gladys;Pwd=gladyspass;Server=localhost;Database=gladysdb", actual: result);
}
public static MySqlConnectionConfig Load(string path)
{
MySqlConnectionConfig config = null;
try
{
StreamReader reader = new StreamReader(path);
string connectionStringLine = reader.ReadLine();
if (connectionStringLine != null)
{
config = Parse(connectionStringLine);
}
reader.Close();
}
catch
{
throw new Exception("Loading ConnectionConfig Fail");
}
return(config);
}
public static string SerializeToConnectionString(MySqlConnectionConfig config)
{
return($"Uid={config.User};Pwd={config.Password};Server={config.Server};Database={config.Database}");
}
