public void GetTooltipStringTestExternalMetaColumn()
{
IDTSExternalMetadataColumn100 ic = new ExternalMetadataColumnTestImpl();
ic.Name = "name";
string expected = "Name: name\nData type: DT_NULL\nLength: 0\nScale: 0\nPrecision: 0\nCode page: 0";
string actual = DataFlowComponentUI.GetTooltipString(ic);
Assert.AreEqual(expected, actual);
}
public void FormatTooltipTextTest()
{
string name = "name";
string dataType = "dataType";
string length = "length";
string scale = "scale";
string precision = "precision";
string codePage = "codePage";
string expected = "Name: name\nData type: dataType\nLength: length\nScale: scale\nPrecision: precision\nCode page: codePage";
string actual;
actual = DataFlowComponentUI.FormatTooltipText(name, dataType, length, scale, precision, codePage);
Assert.AreEqual(expected, actual);
}
public void GetTooltipStringTest()
{
string expected = string.Empty;
string result = string.Empty;
Microsoft.SqlServer.Dts.Runtime.Package package;
IDTSComponentMetaData100 multipleHash;
CManagedComponentWrapper multipleHashInstance;
String lineageString;
MainPipe dataFlowTask;
// Microsoft.SqlServer.Dts.Runtime.Application app;
StaticTestUtilities.BuildSSISPackage(out package, out multipleHash, out multipleHashInstance, out lineageString, out dataFlowTask /*, out app */);
result = DataFlowComponentUI.GetTooltipString(multipleHash.InputCollection[0].InputColumnCollection[0]);
expected = "Name: StringData\nData type: DT_STR\nLength: 255\nScale: 0\nPrecision: 0\nCode page: 1252";
Assert.AreEqual(expected, result, "Checking IDTSInputColumn");
int outputID = multipleHash.OutputCollection[0].ID;
int outputColumnPos = multipleHash.OutputCollection[0].OutputColumnCollection.Count;
// Add output column CRC32BinaryOutput (CRC32, Binary)
IDTSOutputColumn100 CRC32CBinaryOutput = multipleHashInstance.InsertOutputColumnAt(outputID, outputColumnPos++, "BinaryOutput", "CRC32C Hash of the input");
CRC32CBinaryOutput.CustomPropertyCollection[Utility.OutputColumnOutputTypePropName].Value = MultipleHash.OutputTypeEnumerator.Binary;
CRC32CBinaryOutput.CustomPropertyCollection[Utility.HashTypePropName].Value = MultipleHash.HashTypeEnumerator.CRC32C;
CRC32CBinaryOutput.Name = "BinaryOutput";
CRC32CBinaryOutput.CustomPropertyCollection[Utility.InputColumnLineagePropName].Value = lineageString;
Utility.SetOutputColumnDataType(MultipleHash.HashTypeEnumerator.CRC32C, MultipleHash.OutputTypeEnumerator.Binary, CRC32CBinaryOutput);
result = DataFlowComponentUI.GetTooltipString(CRC32CBinaryOutput);
expected = "Name: BinaryOutput\nData type: DT_BYTES\nLength: 4\nScale: 0\nPrecision: 0\nCode page: 0";
Assert.AreEqual(expected, result, "Check IDTSOutputColumn100");
// Add output column CRC32CHexOutput (CRC32C, HexString)
IDTSOutputColumn100 CRC32CHexOutput = multipleHashInstance.InsertOutputColumnAt(outputID, outputColumnPos++, "HexOutput", "CRC32C Hash of the input");
CRC32CHexOutput.CustomPropertyCollection[Utility.OutputColumnOutputTypePropName].Value = MultipleHash.OutputTypeEnumerator.HexString;
CRC32CHexOutput.CustomPropertyCollection[Utility.HashTypePropName].Value = MultipleHash.HashTypeEnumerator.CRC32C;
CRC32CHexOutput.Name = "HexOutput";
CRC32CHexOutput.CustomPropertyCollection[Utility.InputColumnLineagePropName].Value = lineageString;
Utility.SetOutputColumnDataType(MultipleHash.HashTypeEnumerator.CRC32C, MultipleHash.OutputTypeEnumerator.HexString, CRC32CHexOutput);
// Add output column CRC32CBaseOutput (CRC32C, Base64String)
IDTSOutputColumn100 CRC32CBaseOutput = multipleHashInstance.InsertOutputColumnAt(outputID, outputColumnPos++, "BaseOutput", "CRC32C Hash of the input");
CRC32CBaseOutput.CustomPropertyCollection[Utility.OutputColumnOutputTypePropName].Value = MultipleHash.OutputTypeEnumerator.Base64String;
CRC32CBaseOutput.CustomPropertyCollection[Utility.HashTypePropName].Value = MultipleHash.HashTypeEnumerator.CRC32C;
CRC32CBaseOutput.Name = "BaseOutput";
CRC32CBaseOutput.CustomPropertyCollection[Utility.InputColumnLineagePropName].Value = lineageString;
Utility.SetOutputColumnDataType(MultipleHash.HashTypeEnumerator.CRC32C, MultipleHash.OutputTypeEnumerator.Base64String, CRC32CBaseOutput);
// Add SQL CE Destination
// Add SQL CE Connection
ConnectionManager sqlCECM = null;
IDTSComponentMetaData100 sqlCETarget = null;
CManagedComponentWrapper sqlCEInstance = null;
StaticTestUtilities.CreateSQLCEComponent(package, dataFlowTask, sqlCEDatabaseName, sqlCEPassword, "TestRecords", out sqlCECM, out sqlCETarget, out sqlCEInstance);
// StaticTestUtilities.CreatePath(dataFlowTask, multipleHash.OutputCollection[0], sqlCETarget, sqlCEInstance);
// Create the path from source to destination.
IDTSPath100 path = dataFlowTask.PathCollection.New();
path.AttachPathAndPropagateNotifications(multipleHash.OutputCollection[0], sqlCETarget.InputCollection[0]);
// Get the destination's default input and virtual input.
IDTSInput100 input = sqlCETarget.InputCollection[0];
IDTSVirtualInput100 vInput = input.GetVirtualInput();
IDTSVirtualInputColumn100 vColumn = vInput.VirtualInputColumnCollection[0];
result = DataFlowComponentUI.GetTooltipString(vColumn);
expected = "Name: StringData\nData type: DT_STR\nLength: 255\nScale: 0\nPrecision: 0\nCode page: 1252\nSource: Flat File Source";
Assert.AreEqual(expected, result, "Check IDTSVirtualInputColumn100");
result = DataFlowComponentUI.GetTooltipString(sqlCETarget.InputCollection[0].ExternalMetadataColumnCollection[0]);
expected = "Name: StringData\nData type: DT_WSTR\nLength: 255\nScale: 0\nPrecision: 0\nCode page: 0";
Assert.AreEqual(expected, result, "Check IDTSExternalMetadataColumn");
result = DataFlowComponentUI.GetTooltipString("String");
expected = String.Empty;
Assert.AreEqual(expected, result, "Check String Object");
}
/// <summary>
/// Initializes a new instance of the DataFlowElement class.
/// The Element that has a Tag
/// </summary>
/// <param name="name">The name to use for this element</param>
/// <param name="tag">The tag to attach to this element</param>
public DataFlowElement(string name, object tag)
{
this.name = name;
this.tag = tag;
this.toolTip = DataFlowComponentUI.GetTooltipString(tag);
}
