public static SqlWorkloadConfig LoadFromFile(string path)
{
JavaScriptSerializer ser = new JavaScriptSerializer(new SqlWorkloadConfigTypeResolver());
using (StreamReader r = new StreamReader(path))
{
string json = r.ReadToEnd();
var minifier = new JsMinifier();
// minify JSON to strip away comments
// Comments in config files are very useful but JSON parsers
// do not allow comments. Minification solves the issue.
SqlWorkloadConfig result = null;
string jsonMin = null;
try
{
jsonMin = minifier.Minify(json);
}
catch (Exception e)
{
throw new FormatException($"Unable to load configuration from '{path}'. The file contains syntax errors.", e);
}
try
{
result = ser.Deserialize <SqlWorkloadConfig>(jsonMin);
}
catch (Exception e)
{
throw new FormatException($"Unable to load configuration from '{path}'. The file contains semantic errors.", e);
}
return(result);
}
}
public static void Test()
{
JavaScriptSerializer ser = new JavaScriptSerializer(new SqlWorkloadConfigTypeResolver());
SqlWorkloadConfig x = new SqlWorkloadConfig()
{
Controller = new WorkloadController()
};
x.Controller.Listener = new ExtendedEventsWorkloadListener()
{
Source = "Listener\\ExtendedEvents\\sqlworkload.sql",
ConnectionInfo = new SqlConnectionInfo()
{
ServerName = "SQLDEMO\\SQL2014",
UserName = "******",
Password = "******"
}
};
//x.Controller.Listener.Filter.DatabaseFilter.PredicateValue = "DS3";
x.Controller.Consumers.Add(new ReplayConsumer()
{
ConnectionInfo = new SqlConnectionInfo()
{
ServerName = "SQLDEMO\\SQL2016",
UserName = "******",
Password = "******"
}
});
x.Controller.Consumers.Add(new ReplayConsumer()
{
ConnectionInfo = new SqlConnectionInfo()
{
ServerName = "SQLDEMO\\SQL2016",
UserName = "******",
Password = "******",
DatabaseName = "RTR",
SchemaName = "baseline"
},
DatabaseMap = new Dictionary <string, string>()
{
{ "DatabaseA", "DatabaseB" },
{ "DatabaseC", "DatabaseD" }
}
});
string s = ser.Serialize(x);
Console.WriteLine(s);
//SqlWorkloadConfig tc = ser.Deserialize<SqlWorkloadConfig>(Samples.Sample.ToString());
}
