/// <summary>
/// A Site Settings Step is generic and the name is mapped to the <see cref="IDeploymentStepFactory.Name"/> so its 'Type' should be determined though a lookup.
/// A normal steps name is not mapped to the <see cref="IDeploymentStepFactory.Name"/> and should use its type.
/// </summary>
private string GetStepType(IDictionary <string, IDeploymentStepFactory> deploymentStepFactories, DeploymentStep step)
{
if (deploymentStepFactories.TryGetValue(step.Name, out var deploymentStepFactory))
{
return(deploymentStepFactory.Name);
}
else
{
return(step.GetType().Name);
}
}
public void logger(DeploymentStep ds, int i)
{
string msg = "";
if (ds is CreateElementStep || ds is DropElementStep)
{
DeploymentScriptDomStep domStep = ds as DeploymentScriptDomStep;
TSqlScript script = domStep.Script as TSqlScript;
TSqlStatement t = script.Batches[0].Statements[0];
msg = $"{DateTime.Now.ToLongTimeString()}, {i:000} - {ds.GetType().Name}: {t.GetType().Name}";
}
else
{
msg = $"{DateTime.Now.ToLongTimeString()}, {i:000} - {ds.GetType().Name}: - ";
}
using (StreamWriter w = File.AppendText(logfilepath)) { w.WriteLine(msg); }
}
/// <summary>
/// Writes details for the various operation types
/// that could be contained in the deployment plan.
/// Optionally writes script bodies, depending on
/// the value of the IncludeScripts property.
/// </summary>
private void ReportPlanOperations(XmlWriter xmlw)
{// write the node to indicate the start
// of the list of operations.
xmlw.WriteStartElement("Operations");
// Loop through the steps in the plan,
// starting at the beginning.
DeploymentStep currentStep = _planHead;
while (currentStep != null)
{
// Report the type of step
xmlw.WriteStartElement(currentStep.GetType().Name);
// based on the type of step, report
// the relevant information.
// Note that this procedure only handles
// a subset of all step types.
if (currentStep is SqlRenameStep)
{
SqlRenameStep renameStep = (SqlRenameStep)currentStep;
xmlw.WriteAttributeString("OriginalName", renameStep.OldName);
xmlw.WriteAttributeString("NewName", renameStep.NewName);
xmlw.WriteAttributeString("Category", GetElementCategory(renameStep.RenamedElement));
}
else if (currentStep is SqlMoveSchemaStep)
{
SqlMoveSchemaStep moveStep = (SqlMoveSchemaStep)currentStep;
xmlw.WriteAttributeString("OrignalName", moveStep.PreviousName);
xmlw.WriteAttributeString("NewSchema", moveStep.NewSchema);
xmlw.WriteAttributeString("Category", GetElementCategory(moveStep.MovedElement));
}
else if (currentStep is SqlTableMigrationStep)
{
SqlTableMigrationStep dmStep = (SqlTableMigrationStep)currentStep;
xmlw.WriteAttributeString("Name", GetElementName(dmStep.SourceTable));
xmlw.WriteAttributeString("Category", GetElementCategory(dmStep.SourceElement));
}
else if (currentStep is CreateElementStep)
{
CreateElementStep createStep = (CreateElementStep)currentStep;
xmlw.WriteAttributeString("Name", GetElementName(createStep.SourceElement));
xmlw.WriteAttributeString("Category", GetElementCategory(createStep.SourceElement));
}
else if (currentStep is AlterElementStep)
{
AlterElementStep alterStep = (AlterElementStep)currentStep;
xmlw.WriteAttributeString("Name", GetElementName(alterStep.SourceElement));
xmlw.WriteAttributeString("Category", GetElementCategory(alterStep.SourceElement));
}
else if (currentStep is DropElementStep)
{
DropElementStep dropStep = (DropElementStep)currentStep;
xmlw.WriteAttributeString("Name", GetElementName(dropStep.TargetElement));
xmlw.WriteAttributeString("Category", GetElementCategory(dropStep.TargetElement));
}
// If the script bodies are to be included,
// add them to the report.
if (this.IncludeScripts)
{
using (StringWriter sw = new StringWriter())
{
currentStep.GenerateBatchScript(sw);
string tsqlBody = sw.ToString();
if (string.IsNullOrEmpty(tsqlBody) == false)
{
xmlw.WriteCData(tsqlBody);
}
}
}
// close off the current step
xmlw.WriteEndElement();
currentStep = currentStep.Next;
}
xmlw.WriteEndElement();
}