public void SaveDictionaryData()
{
Dictionary <string, string> dic = new Dictionary <string, string>();
List <string[]> combination = new List <string[]>();
dic.Add("user", "myuser");
dic.Add("port", "33060");
dic.Add("schema", "Dictionary");
dic.Add("alias", "DictionaryAlias");
for (int i = 0; i < dic.Count; i++)
{
Combinations(dic.Select(c => c.Key).ToList(), i + 1).ForEach(k => combination.Add(k));
}
int counter = 1;
foreach (string[] values in combination)
{
Dictionary <string, string> dicTest = new Dictionary <string, string>();
dicTest.Add("host", "localhost");
values.ToList().ForEach(o => dicTest.Add(o, dic[o]));
string name = "Dictionary" + string.Join("", values);
SessionConfigManager.Save(name, dicTest);
SessionConfig sc = SessionConfigManager.Get(name);
Assert.Equal(name, sc.Name);
StringBuilder uri = new StringBuilder("mysqlx://");
if (dicTest.ContainsKey("user"))
{
uri.Append(dicTest["user"]).Append("@");
}
uri.Append(dicTest["host"]);
if (dicTest.ContainsKey("port"))
{
uri.Append(":").Append(dicTest["port"]);
}
if (dicTest.ContainsKey("schema"))
{
uri.Append("/").Append(dicTest["schema"]);
}
Assert.Equal(uri.ToString(), sc.Uri);
if (dicTest.ContainsKey("alias"))
{
Assert.Equal("DictionaryAlias", sc.GetAppData("alias"));
}
counter++;
}
}
public void Save()
{
// save using SessionConfig instance
SessionConfig scSave = new SessionConfig("SessionConfig", "mysqlx://myuser@localhost/SessionConfig");
scSave.SetAppData("alias", "SessionConfigAlias");
SessionConfigManager.Save(scSave);
SessionConfig sc = SessionConfigManager.Get("SessionConfig");
Assert.Equal("SessionConfig", sc.Name);
Assert.Equal("mysqlx://myuser@localhost/SessionConfig", sc.Uri);
Assert.Equal("SessionConfigAlias", sc.GetAppData("alias"));
// save using Json string and Uri
SessionConfigManager.Save("JsonString", "{ \"uri\": \"mysqlx://myuser@localhost/JsonString\", \"appdata\": { \"alias\": \"JsonStringAlias\" } }");
sc = SessionConfigManager.Get("JsonString");
Assert.Equal("JsonString", sc.Name);
Assert.Equal("mysqlx://myuser@localhost/JsonString", sc.Uri);
Assert.Equal("JsonStringAlias", sc.GetAppData("alias"));
// save using DbDoc
SessionConfigManager.Save("DbDoc", new DbDoc("{ \"uri\": \"mysqlx://myuser@localhost/DbDoc\", \"appdata\": { \"alias\": \"DbDocAlias\" } }"));
sc = SessionConfigManager.Get("DbDoc");
Assert.Equal("DbDoc", sc.Name);
Assert.Equal("mysqlx://myuser@localhost/DbDoc", sc.Uri);
Assert.Equal("DbDocAlias", sc.GetAppData("alias"));
// save overwrites key if key already exists
SessionConfigManager.Save("DbDoc", new DbDoc("{ \"uri\": \"mysqlx://myuser@localhost/DbDocUpdated\", \"appdata\": { \"alias\": \"DbDocAliasUpdated\", \"other\": 5 } }"));
sc = SessionConfigManager.Get("DbDoc");
Assert.Equal("DbDoc", sc.Name);
Assert.Equal("mysqlx://myuser@localhost/DbDocUpdated", sc.Uri);
Assert.Equal("DbDocAliasUpdated", sc.GetAppData("alias"));
Assert.Equal("DbDocAliasUpdated", sc.GetAppData("alias"));
Assert.Equal("5", sc.GetAppData("other"));
// save using Dictionary and Uri
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("uri", "mysqlx://myuser@localhost/Dictionary");
dic.Add("alias", "DictionaryAlias");
SessionConfigManager.Save("Dictionary", dic);
sc = SessionConfigManager.Get("Dictionary");
Assert.Equal("Dictionary", sc.Name);
Assert.Equal("mysqlx://myuser@localhost/Dictionary", sc.Uri);
Assert.Equal("DictionaryAlias", sc.GetAppData("alias"));
// save using Dictionary and connection attributes
Dictionary <string, string> dic2 = new Dictionary <string, string>();
dic2.Add("user", "myuser");
dic2.Add("host", "localhost");
dic2.Add("port", "33060");
dic2.Add("schema", "Dictionary2");
dic2.Add("alias", "Dictionary2Alias");
SessionConfigManager.Save("Dictionary2", dic2);
sc = SessionConfigManager.Get("Dictionary2");
Assert.Equal("Dictionary2", sc.Name);
Assert.Equal("mysqlx://myuser@localhost:33060/Dictionary2", sc.Uri);
Assert.Equal("Dictionary2Alias", sc.GetAppData("alias"));
// save using Uri and appdata as json
SessionConfigManager.Save("UriJson", "mysqlx://myuser@localhost/UriJson", "{ \"alias\": \"UriJsonAlias\" }");
sc = SessionConfigManager.Get("UriJson");
Assert.Equal("UriJson", sc.Name);
Assert.Equal("mysqlx://myuser@localhost/UriJson", sc.Uri);
Assert.Equal("UriJsonAlias", sc.GetAppData("alias"));
// save using Uri and appdata as dictionary
Dictionary <string, string> dicAppData = new Dictionary <string, string>();
dicAppData.Add("alias", "UriDicAlias");
SessionConfigManager.Save("UriDic", "mysqlx://myuser@localhost/UriDic", dicAppData);
sc = SessionConfigManager.Get("UriDic");
Assert.Equal("UriDic", sc.Name);
Assert.Equal("mysqlx://myuser@localhost/UriDic", sc.Uri);
Assert.Equal("UriDicAlias", sc.GetAppData("alias"));
// save using Json string and connection attributes
SessionConfigManager.Save("JsonStringAttributes", "{ \"host\": \"localhost\", \"user\": \"\", \"port\": 33060, \"schema\": \"JsonStringAttributes\", \"appdata\": { \"alias\": \"JsonStringAttributesAlias\", \"other\": 5 }, \"a\":1 }");
sc = SessionConfigManager.Get("JsonStringAttributes");
Assert.Equal("JsonStringAttributes", sc.Name);
Assert.Equal("mysqlx://localhost:33060/JsonStringAttributes", sc.Uri);
Assert.Equal("JsonStringAttributesAlias", sc.GetAppData("alias"));
Assert.Equal("5", sc.GetAppData("other"));
// save using json anonymous
SessionConfigManager.Save("JsonAnonymous", new
{
host = "localhost",
user = "",
port = 33060,
schema = "JsonAnonymous",
appdata = new
{
alias = "JsonAnonymousAlias",
other = 5
}
});
sc = SessionConfigManager.Get("JsonAnonymous");
Assert.Equal("JsonAnonymous", sc.Name);
Assert.Equal("mysqlx://localhost:33060/JsonAnonymous", sc.Uri);
Assert.Equal("JsonAnonymousAlias", sc.GetAppData("alias"));
Assert.Equal("5", sc.GetAppData("other"));
}