public PnPAppConfigManager(string sqlConnectionString, string configurationName)
{
//System.Diagnostics.Debugger.Launch();
// let's find the right id based on the name
using (TestModelContainer context = new TestModelContainer(sqlConnectionString))
{
var configuration = context.TestConfigurationSet.Where(s => s.Name.Equals(configurationName, StringComparison.InvariantCultureIgnoreCase)).First();
if (configuration != null)
{
this.configurationId = configuration.Id;
}
else
{
throw new Exception(String.Format("Test configuration with name {0} was not found", configurationName));
}
}
this.sqlConnectionString = sqlConnectionString;
}
public PnPAppConfigManager(string sqlConnectionString, string configurationName)
{
//System.Diagnostics.Debugger.Launch();
// let's find the right id based on the name
using (TestModelContainer context = new TestModelContainer(sqlConnectionString))
{
var configuration = context.TestConfigurationSet.Where(s => s.Name.Equals(configurationName, StringComparison.InvariantCultureIgnoreCase)).First();
if (configuration != null)
{
this.configurationId = configuration.Id;
}
else
{
throw new Exception(String.Format("Test configuration with name {0} was not found", configurationName));
}
}
this.sqlConnectionString = sqlConnectionString;
}
public string GetConfigurationElement(string element)
{
using (TestModelContainer context = new TestModelContainer(sqlConnectionString))
{
TestConfiguration testConfig = context.TestConfigurationSet.Find(configurationId);
if (testConfig == null)
{
throw new Exception(String.Format("Test configuration with ID {0} was not found", configurationId));
}
if (element.Equals("PnPBranch", StringComparison.InvariantCultureIgnoreCase))
{
return testConfig.Branch;
}
else if (element.Equals("PnPBuild", StringComparison.InvariantCultureIgnoreCase))
{
return testConfig.VSBuildConfiguration;
}
return "";
}
}
public string GetConfigurationElement(string element)
{
using (TestModelContainer context = new TestModelContainer(sqlConnectionString))
{
TestConfiguration testConfig = context.TestConfigurationSet.Find(configurationId);
if (testConfig == null)
{
throw new Exception(String.Format("Test configuration with ID {0} was not found", configurationId));
}
if (element.Equals("PnPBranch", StringComparison.InvariantCultureIgnoreCase))
{
return(testConfig.Branch);
}
else if (element.Equals("PnPBuild", StringComparison.InvariantCultureIgnoreCase))
{
return(testConfig.VSBuildConfiguration);
}
return("");
}
}
/// <summary>
/// Default constructor
/// </summary>
/// <param name="parameters">Dictionary with parameter values</param>
public TestManager(Dictionary<string, string> parameters)
{
//System.Diagnostics.Debugger.Launch();
loggerParameters = parameters;
// validate is we've the needed params
if (String.IsNullOrEmpty(GetParameter("PnPSQLConnectionString")) || String.IsNullOrEmpty(GetParameter("PnPConfigurationToTest")))
{
throw new ArgumentException("Requested parameters (PnPSQLConnectionString and PnPConfigurationToTest) are not defined");
}
// we pass the connection string as base64 encoded + replaced "=" with " to avoid problems with the default implementation of the VSTestLogger interface
context = new TestModelContainer(Base64Decode(GetParameter("PnPSQLConnectionString")).Replace(""", "\""));
// find the used configuration
string configurationToTest = GetParameter("PnPConfigurationToTest");
testConfiguration = context.TestConfigurationSet.Where(s => s.Name.Equals(configurationToTest, StringComparison.InvariantCultureIgnoreCase)).First();
if (testConfiguration == null)
{
throw new Exception(String.Format("Test configuration with name {0} was not found", configurationToTest));
}
}
/// <summary>
/// Default constructor
/// </summary>
/// <param name="parameters">Dictionary with parameter values</param>
public TestManager(Dictionary <string, string> parameters)
{
//System.Diagnostics.Debugger.Launch();
loggerParameters = parameters;
// validate is we've the needed params
if (String.IsNullOrEmpty(GetParameter("PnPSQLConnectionString")) || String.IsNullOrEmpty(GetParameter("PnPConfigurationToTest")))
{
throw new ArgumentException("Requested parameters (PnPSQLConnectionString and PnPConfigurationToTest) are not defined");
}
// we pass the connection string as base64 encoded + replaced "=" with " to avoid problems with the default implementation of the VSTestLogger interface
context = new TestModelContainer(Base64Decode(GetParameter("PnPSQLConnectionString")).Replace(""", "\""));
// find the used configuration
string configurationToTest = GetParameter("PnPConfigurationToTest");
testConfiguration = context.TestConfigurationSet.Where(s => s.Name.Equals(configurationToTest, StringComparison.InvariantCultureIgnoreCase)).First();
if (testConfiguration == null)
{
throw new Exception(String.Format("Test configuration with name {0} was not found", configurationToTest));
}
}
public void GenerateAppConfig(string appConfigFolder)
{
using (TestModelContainer context = new TestModelContainer(sqlConnectionString))
{
TestConfiguration testConfig = context.TestConfigurationSet.Find(configurationId);
if (testConfig == null)
{
throw new Exception(String.Format("Test configuration with ID {0} was not found", configurationId));
}
string appConfigFile = Path.Combine(appConfigFolder, "app.config");
// If there's already an app.config file then delete it
if (File.Exists(appConfigFile))
{
File.Delete(appConfigFile);
}
// Generate app.config XML file
using (XmlWriter writer = XmlWriter.Create(appConfigFile))
{
writer.WriteStartElement("configuration");
writer.WriteStartElement("appSettings");
// These app settings property value pairs are always present
WriteProperty(writer, "SPOTenantUrl", testConfig.TenantUrl);
WriteProperty(writer, "SPODevSiteUrl", testConfig.TestSiteUrl);
if (testConfig.Type == TestConfigurationType.SharePoint2013 || testConfig.Type == TestConfigurationType.SharePoint2016)
{
if (!testConfig.TestAuthentication.AppOnly)
{
WriteProperty(writer, "OnPremUserName", testConfig.TestAuthentication.User);
WriteProperty(writer, "OnPremDomain", testConfig.TestAuthentication.Domain);
WriteProperty(writer, "OnPremPassword", testConfig.TestAuthentication.Password);
}
else // App-Only
{
WriteProperty(writer, "AppId", testConfig.TestAuthentication.AppId);
WriteProperty(writer, "AppSecret", testConfig.TestAuthentication.AppSecret);
}
// dump additional properties
foreach (var testConfigurationProperty in testConfig.TestConfigurationProperties)
{
WriteProperty(writer, testConfigurationProperty.Name, testConfigurationProperty.Value);
}
// dump "special" additional properties
WriteProperty(writer, "TestAutomationDatabaseConnectionString", GetConnectionString(sqlConnectionString));
}
else // Online
{
WriteProperty(writer, "SPOCredentialManagerLabel", testConfig.TestAuthentication.CredentialManagerLabel);
if(!testConfig.TestAuthentication.AppOnly)
{
// System.Diagnostics.Debugger.Launch();
// Always output the username since some tests depend on this
if (!String.IsNullOrEmpty(testConfig.TestAuthentication.CredentialManagerLabel))
{
NetworkCredential cred = CredentialManager.GetCredential(testConfig.TestAuthentication.CredentialManagerLabel);
WriteProperty(writer, "SPOUserName", cred.UserName);
}
else
{
WriteProperty(writer, "SPOUserName", testConfig.TestAuthentication.User);
}
WriteProperty(writer, "SPOPassword", testConfig.TestAuthentication.Password);
}
else // App-Only
{
WriteProperty(writer, "AppId", testConfig.TestAuthentication.AppId);
WriteProperty(writer, "AppSecret", testConfig.TestAuthentication.AppSecret);
}
// dump additional properties
foreach (var testConfigurationProperty in testConfig.TestConfigurationProperties)
{
WriteProperty(writer, testConfigurationProperty.Name, testConfigurationProperty.Value);
}
// dump "special" additional properties
WriteProperty(writer, "TestAutomationDatabaseConnectionString", GetConnectionString(sqlConnectionString));
}
writer.WriteEndElement(); //appSettings
writer.WriteStartElement("system.diagnostics");
writer.WriteStartElement("sharedListeners");
writer.WriteStartElement("add");
writer.WriteAttributeString("name", "console");
writer.WriteAttributeString("type", "System.Diagnostics.ConsoleTraceListener");
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteStartElement("sources");
writer.WriteStartElement("source");
writer.WriteAttributeString("name", "OfficeDevPnP.Core");
writer.WriteAttributeString("switchValue", "Verbose");
writer.WriteStartElement("listeners");
writer.WriteStartElement("add");
writer.WriteAttributeString("name", "console");
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteStartElement("trace");
writer.WriteAttributeString("indentsize", "0");
writer.WriteAttributeString("autoflush", "true");
writer.WriteStartElement("listeners");
writer.WriteStartElement("add");
writer.WriteAttributeString("name", "console");
}
}
}
public void GenerateAppConfig(string appConfigFolder)
{
using (TestModelContainer context = new TestModelContainer(sqlConnectionString))
{
TestConfiguration testConfig = context.TestConfigurationSet.Find(configurationId);
if (testConfig == null)
{
throw new Exception(String.Format("Test configuration with ID {0} was not found", configurationId));
}
string appConfigFile = Path.Combine(appConfigFolder, "app.config");
// If there's already an app.config file then delete it
if (File.Exists(appConfigFile))
{
File.Delete(appConfigFile);
}
// Generate app.config XML file
using (XmlWriter writer = XmlWriter.Create(appConfigFile))
{
writer.WriteStartElement("configuration");
writer.WriteStartElement("appSettings");
// These app settings property value pairs are always present
WriteProperty(writer, "SPOTenantUrl", testConfig.TenantUrl);
WriteProperty(writer, "SPODevSiteUrl", testConfig.TestSiteUrl);
if (testConfig.Type == TestConfigurationType.SharePoint2013 || testConfig.Type == TestConfigurationType.SharePoint2016)
{
WriteProperty(writer, "SPOCredentialManagerLabel", testConfig.TestAuthentication.CredentialManagerLabel);
if (!testConfig.TestAuthentication.AppOnly)
{
if (!String.IsNullOrEmpty(testConfig.TestAuthentication.CredentialManagerLabel))
{
NetworkCredential cred = CredentialManager.GetCredential(testConfig.TestAuthentication.CredentialManagerLabel);
if (cred.UserName.IndexOf("\\") > 0)
{
string[] userParts = cred.UserName.Split('\\');
WriteProperty(writer, "OnPremUserName", userParts[1]);
WriteProperty(writer, "OnPremDomain", userParts[0]);
}
else
{
throw new ArgumentException(String.Format("Username {0} stored in credential manager value {1} needs to be formatted as domain\\user", cred.UserName, testConfig.TestAuthentication.CredentialManagerLabel));
}
}
else
{
WriteProperty(writer, "OnPremUserName", testConfig.TestAuthentication.User);
WriteProperty(writer, "OnPremDomain", testConfig.TestAuthentication.Domain);
WriteProperty(writer, "OnPremPassword", testConfig.TestAuthentication.Password);
}
}
else // App-Only
{
WriteProperty(writer, "AppId", testConfig.TestAuthentication.AppId);
WriteProperty(writer, "AppSecret", testConfig.TestAuthentication.AppSecret);
}
// dump additional properties
foreach (var testConfigurationProperty in testConfig.TestConfigurationProperties)
{
WriteProperty(writer, testConfigurationProperty.Name, testConfigurationProperty.Value);
}
// dump "special" additional properties
WriteProperty(writer, "TestAutomationDatabaseConnectionString", GetConnectionString(sqlConnectionString));
}
else // Online
{
WriteProperty(writer, "SPOCredentialManagerLabel", testConfig.TestAuthentication.CredentialManagerLabel);
if (!testConfig.TestAuthentication.AppOnly)
{
// System.Diagnostics.Debugger.Launch();
// Always output the username since some tests depend on this
if (!String.IsNullOrEmpty(testConfig.TestAuthentication.CredentialManagerLabel))
{
NetworkCredential cred = CredentialManager.GetCredential(testConfig.TestAuthentication.CredentialManagerLabel);
WriteProperty(writer, "SPOUserName", cred.UserName);
}
else
{
WriteProperty(writer, "SPOUserName", testConfig.TestAuthentication.User);
WriteProperty(writer, "SPOPassword", testConfig.TestAuthentication.Password);
}
}
else // App-Only
{
WriteProperty(writer, "AppId", testConfig.TestAuthentication.AppId);
WriteProperty(writer, "AppSecret", testConfig.TestAuthentication.AppSecret);
}
// dump additional properties
foreach (var testConfigurationProperty in testConfig.TestConfigurationProperties)
{
WriteProperty(writer, testConfigurationProperty.Name, testConfigurationProperty.Value);
}
// dump "special" additional properties
WriteProperty(writer, "TestAutomationDatabaseConnectionString", GetConnectionString(sqlConnectionString));
}
writer.WriteEndElement(); //appSettings
writer.WriteStartElement("system.diagnostics");
writer.WriteStartElement("sharedListeners");
writer.WriteStartElement("add");
writer.WriteAttributeString("name", "console");
writer.WriteAttributeString("type", "System.Diagnostics.ConsoleTraceListener");
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteStartElement("sources");
writer.WriteStartElement("source");
writer.WriteAttributeString("name", "OfficeDevPnP.Core");
writer.WriteAttributeString("switchValue", "Verbose");
writer.WriteStartElement("listeners");
writer.WriteStartElement("add");
writer.WriteAttributeString("name", "console");
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteStartElement("trace");
writer.WriteAttributeString("indentsize", "0");
writer.WriteAttributeString("autoflush", "true");
writer.WriteStartElement("listeners");
writer.WriteStartElement("add");
writer.WriteAttributeString("name", "console");
}
}
}
/// <summary>
/// Execute MSBuild run, collect the console output and store it in the database.
/// </summary>
/// <param name="pnpConfigurationToTest">Configuration to run</param>
/// <param name="sqlConnectionString">Connection string to PnP Test Automation database that contains the configuration</param>
/// <param name="buildTarget">Build file (.targets)</param>
public void Execute(string pnpConfigurationToTest, string sqlConnectionString, string buildTarget)
{
// Prep an entity framework connection string and create a dbcontext
connectionString = String.Format("metadata=res://*/SQL.TestModel.csdl|res://*/SQL.TestModel.ssdl|res://*/SQL.TestModel.msl;provider=System.Data.SqlClient;provider connection string=\"{0}\"", sqlConnectionString);
context = new TestModelContainer(connectionString);
string msBuildExe = ConfigurationManager.AppSettings[Constants.settingMSBuildExe].ToString();
if (String.IsNullOrEmpty(msBuildExe))
{
msBuildExe = @"c:\Windows\Microsoft.NET\Framework\v4.0.30319\MSBuild.exe";
}
// Create process
var proc = new Process();
proc.StartInfo.FileName = msBuildExe;
proc.StartInfo.Arguments = String.Format("/property:PnPConfigurationToTest={0};PnPSQLConnectionString=\"metadata=res://*/SQL.TestModel.csdl|res://*/SQL.TestModel.ssdl|res://*/SQL.TestModel.msl;provider=System.Data.SqlClient;provider connection string="{1}"\" \"{2}\"", pnpConfigurationToTest, sqlConnectionString, buildTarget);
// set up output redirection
proc.StartInfo.RedirectStandardOutput = true;
proc.StartInfo.RedirectStandardError = true;
proc.EnableRaisingEvents = true;
proc.StartInfo.CreateNoWindow = true;
proc.StartInfo.UseShellExecute = false;
// see below for output handler
proc.ErrorDataReceived += proc_DataReceived;
proc.OutputDataReceived += proc_DataReceived;
proc.Start();
proc.BeginErrorReadLine();
proc.BeginOutputReadLine();
// wait for process to terminate gracefully...if not terminated after the defined timespan kill the process and all childprocesses spawned from this process
int maxRunTimeInMinutes;
if (!Int32.TryParse(ConfigurationManager.AppSettings[Constants.settingMaxRunTimeInMinutes], out maxRunTimeInMinutes))
{
maxRunTimeInMinutes = 180;
}
WriteLine(String.Format("Starting MSBuild with a max run time of {0} minutes", maxRunTimeInMinutes));
if (!proc.WaitForExit(Convert.ToInt32(new TimeSpan(0, maxRunTimeInMinutes, 0).TotalMilliseconds)))
{
try
{
WriteLine("[IMPORTANT] Started killing of the MSBuild process and it's child processes due to exceeded run time");
// kill vstest.console process if it's availabe
var vsTestProcesses = Process.GetProcessesByName("vstest.console");
if (vsTestProcesses.Length > 0)
{
for (int i = 0; i < vsTestProcesses.Length; i++)
{
KillAllProcessesSpawnedBy(Convert.ToUInt32(vsTestProcesses[i].Id));
WriteLine(string.Format("Killing {0}", vsTestProcesses[i].ProcessName));
vsTestProcesses[i].Kill();
}
}
// kill all the processes spawned by this process
KillAllProcessesSpawnedBy(Convert.ToUInt32(proc.Id));
// kill this process as it has been running too long
WriteLine(string.Format("Killing {0}", proc.ProcessName));
proc.Kill();
WriteLine("[IMPORTANT] Termination done!");
}
catch { }
}
// persist the log file
TestRun run = context.TestRunSet.Find(this.testRunId);
run.MSBuildLog = sb.ToString();
// If the run did not finish by now then something went wrong
if (run.Status != RunStatus.Done)
{
run.Status = RunStatus.Failed;
}
// Persist the changes
SaveChanges();
}