public Dataset(SsisTestSuite ssisTestSuite, string name, ConnectionRef connectionReference, bool isResultsStored, string query, DataTable results)
: this(ssisTestSuite, name, connectionReference, isResultsStored, query)
{
Results = results;
}
public ParameterCommand(SsisTestSuite testSuite, object parent, XmlNode commandXml)
: base(testSuite, parent, commandXml)
{
InitializeProperties();
}
public PropertyCommand(SsisTestSuite testSuite, object parent, XmlNode commandXml)
: base(testSuite, parent, commandXml)
{
InitializeProperties(PropertyOperation.Get.ToString(), string.Empty, string.Empty);
}
public TestRef(SsisTestSuite testSuite, string path)
{
TestSuite = testSuite;
Path = path;
}
public ParameterCommand(SsisTestSuite testSuite, object parent)
: base(testSuite, parent)
{
InitializeProperties();
}
internal Context(SsisTestSuite testSuite)
: this()
{
TestSuite = testSuite;
}
public TestRef(SsisTestSuite testSuite, XmlNode testRef)
{
TestSuite = testSuite;
LoadFromXml(testRef);
}
public Test(SsisTestSuite testSuite, string name, string project, string package, string password, string task)
: this(testSuite, name, project, package, password, task, DTSExecResult.Success)
{
}
public Test(SsisTestSuite testSuite, string name, string package, string password, string task, DTSExecResult taskResult)
: this(testSuite, name, null, package, password, task, taskResult)
{
}
protected CommandBase(SsisTestSuite testSuite, object parent, XmlNode commandXml)
: this(testSuite, commandXml)
{
Parent = parent;
}
// TODO: Add Context to all parents, children
internal Test(Context context, SsisTestSuite testSuite, string name, string package, string password, string task)
: this(testSuite, name, null, package, password, task, DTSExecResult.Success)
{
_context = context;
}
protected CommandBase(SsisTestSuite testSuite, XmlNode commandXml)
: this(testSuite)
{
LoadFromXml(commandXml);
}
protected CommandBase(SsisTestSuite testSuite, object parent)
: this(testSuite)
{
Parent = parent;
}
protected CommandBase(SsisTestSuite testSuite)
: this()
{
_testSuite = testSuite;
}
public ProcessCommand(SsisTestSuite testSuite, object parent, string commandXml)
: base(testSuite, parent, commandXml)
{
InitializeProperties();
}
public VariableCommand(SsisTestSuite testSuite)
: base(testSuite)
{
InitializeProperties();
}
public ProcessCommand(SsisTestSuite testSuite, XmlNode commandXml)
: base(testSuite, commandXml)
{
InitializeProperties();
}
public VariableCommand(SsisTestSuite testSuite, string commandXml)
: base(testSuite, commandXml)
{
InitializeProperties();
}
internal Context(SsisTestSuite testSuite, Test test)
: this(testSuite)
{
Test = test;
}
public DataCompareCommand(SsisTestSuite testSuite)
: base(testSuite)
{
InitializeProperties();
}
public void Execute()
{
SsisTestSuite ts = new SsisTestSuite(this.Path);
TestSuite.RunTestSuite(ts);
}
public DataCompareCommand(SsisTestSuite testSuite, object parent)
: base(testSuite, parent)
{
InitializeProperties();
}
public ParameterCommand(SsisTestSuite testSuite)
: base(testSuite)
{
InitializeProperties();
}
public DataCompareCommand(SsisTestSuite testSuite, string commandXml)
: base(testSuite, commandXml)
{
InitializeProperties();
}
public ParameterCommand(SsisTestSuite testSuite, string commandXml)
: base(testSuite, commandXml)
{
InitializeProperties();
}
public static Package LoadPackage(SsisTestSuite testSuite, string packageName, SecureString packagePassword, string projectPath, out object loadedProject)
{
var ssisApp = new Application();
Package package = null;
PackageRef packageRef = null;
loadedProject = null;
bool isPackagePathFilePath = false;
if (string.IsNullOrEmpty(projectPath) && packageName.Contains(".dtsx"))
{
// Assume that it is a file path.
var fileInfo = new FileInfo(Environment.ExpandEnvironmentVariables(packageName));
if (fileInfo.Exists)
{
isPackagePathFilePath = true;
if (packagePassword != null)
{
ssisApp.PackagePassword = ConvertToUnsecureString(packagePassword);
}
try
{
package = ssisApp.LoadPackage(fileInfo.FullName, null);
}
catch (DtsRuntimeException)
{
isPackagePathFilePath = false;
}
}
}
if (!isPackagePathFilePath)
{
if (testSuite.PackageList.ContainsKey(packageName))
{
packageRef = testSuite.PackageList[packageName];
}
else
{
foreach (PackageRef packageReference in testSuite.PackageList.Values)
{
if ((packageReference.Name != null &&
string.Compare(
packageReference.Name,
packageName,
StringComparison.OrdinalIgnoreCase) == 0) ||
(packageReference.PackagePath != null &&
string.Compare(
packageReference.PackagePath,
packageName,
StringComparison.OrdinalIgnoreCase) == 0))
{
packageRef = packageReference;
break;
}
}
}
if (packageRef == null)
{
throw new KeyNotFoundException(string.Format(CultureInfo.CurrentCulture, "{0} was not found in the test suite package references.", packageName));
}
package = packageRef.LoadPackage();
#if SQL2012 || SQL2014 || SQL2017
loadedProject = packageRef.Project;
#endif
}
return(package);
}
public PropertyCommand(SsisTestSuite testSuite)
: base(testSuite)
{
InitializeProperties(PropertyOperation.Get.ToString(), string.Empty, string.Empty);
}
public ProcessCommand(SsisTestSuite testSuite)
: base(testSuite)
{
InitializeProperties();
}
public ComponentSourceCommand(SsisTestSuite testSuite, string commandXml)
: base(testSuite, commandXml)
{
InitializeProperties(PropertyOperation.Get.ToString(), string.Empty, string.Empty);
}
public DirectoryCommand(SsisTestSuite testSuite, XmlNode commandXml)
: base(testSuite, commandXml)
{
InitializeProperties();
}