public void SerializeEqualToQuery_Transform_SingleRow() { // Create an instance of the XmlSerializer specifying type and namespace. var cdXml = new ColumnDefinitionXml() { Index = 1, Role = ColumnRole.Key, TransformationInner = new LightTransformXml() { Language = LanguageType.CSharp, OriginalType = ColumnType.Numeric, Code = "value * 1000" } }; var serializer = new XmlSerializer(typeof(ColumnDefinitionXml)); var content = string.Empty; using (var stream = new MemoryStream()) { using (var writer = new StreamWriter(stream, Encoding.UTF8)) serializer.Serialize(writer, cdXml); content = Encoding.UTF8.GetString(stream.ToArray()); } Debug.WriteLine(content); Assert.That(content, Is.StringContaining("<transform ")); Assert.That(content, Is.Not.StringContaining("index=\"0\"")); Assert.That(content, Is.StringContaining("value * 1000")); Assert.That(content, Is.Not.StringContaining("Intern")); }
private ResultSetComparisonSettings BuildSettings() { //Buiding object used during test var xml = new EqualToXml(); //default values/def xml.KeysDef = ResultSetComparisonSettings.KeysChoice.AllExpectLast; //default tolerance xml.Tolerance = "100"; //Build a value column (numeric, specific tolerance) var colXml = new ColumnDefinitionXml(); colXml.Index = 1; colXml.Role = ColumnRole.Value; colXml.Type = ColumnType.Numeric; colXml.Tolerance = "1"; //Build a value column (without info) var colLightXml = new ColumnDefinitionXml(); colLightXml.Index = 2; colLightXml.Role = ColumnRole.Value; //Build a value column (numeric) var col4Xml = new ColumnDefinitionXml(); col4Xml.Index = 4; col4Xml.Role = ColumnRole.Value; col4Xml.Type = ColumnType.Numeric; //Build a ignore column (without info) var colIgnoreXml = new ColumnDefinitionXml(); colIgnoreXml.Index = 5; colIgnoreXml.Role = ColumnRole.Ignore; //Add columns to definition var cols = new List <ColumnDefinitionXml>(); cols.Add(colXml); cols.Add(colLightXml); cols.Add(col4Xml); cols.Add(colIgnoreXml); xml.columnsDef = cols; //get settings var settings = xml.GetSettings(); //Set the columnCount settings.ApplyTo(10); return(settings); }
public void Instantiate_NoToleranceDefined_InstantiatedToNullOrNone(ColumnRole columnRole) { var colDef = new ColumnDefinitionXml() { Index = 0, Role = columnRole, Tolerance = string.Empty }; var tolerance = ToleranceFactory.Instantiate(colDef); Assert.That(Tolerance.IsNullOrNone(tolerance), Is.True); }
private EqualToXml BuildEqualToXml() { //Buiding object used during test var xml = new EqualToXml(); //default values/def xml.KeyName = "Zero, Three, Six, Seven, Eight"; //default values/def xml.ValueName = "Nine"; //default values/def xml.ValuesDefaultType = ColumnType.Numeric; //default tolerance xml.Tolerance = "100"; //Build a value column (numeric, specific tolerance) var colXml = new ColumnDefinitionXml(); colXml.Name = "One"; colXml.Role = ColumnRole.Value; colXml.Type = ColumnType.Numeric; colXml.Tolerance = "1"; //Build a value column (without info) var colLightXml = new ColumnDefinitionXml(); colLightXml.Name = "Two"; colLightXml.Role = ColumnRole.Value; //Build a value column (numeric) var col4Xml = new ColumnDefinitionXml(); col4Xml.Name = "Four"; col4Xml.Role = ColumnRole.Value; col4Xml.Type = ColumnType.Numeric; //Build a ignore column (without info) var colIgnoreXml = new ColumnDefinitionXml(); colIgnoreXml.Name = "Five"; colIgnoreXml.Role = ColumnRole.Ignore; //Add columns to definition var cols = new List <ColumnDefinitionXml>(); cols.Add(colXml); cols.Add(colLightXml); cols.Add(col4Xml); cols.Add(colIgnoreXml); xml.columnsDef = cols; return(xml); }
private EqualToXml BuildEqualToXmlIndex() { //Buiding object used during test var xml = new EqualToXml(); //default values/def xml.KeysDef = SettingsResultSetComparisonByIndex.KeysChoice.AllExpectLast; //default values/def xml.ValuesDefaultType = ColumnType.Numeric; //default tolerance xml.Tolerance = "100"; //Build a value column (numeric, specific tolerance) var colXml = new ColumnDefinitionXml(); colXml.Index = 1; colXml.Role = ColumnRole.Value; colXml.Type = ColumnType.Numeric; colXml.Tolerance = "1"; //Build a value column (without info) var colLightXml = new ColumnDefinitionXml(); colLightXml.Index = 2; colLightXml.Role = ColumnRole.Value; //Build a value column (numeric) var col4Xml = new ColumnDefinitionXml(); col4Xml.Index = 4; col4Xml.Role = ColumnRole.Value; col4Xml.Type = ColumnType.Numeric; //Build a ignore column (without info) var colIgnoreXml = new ColumnDefinitionXml(); colIgnoreXml.Index = 5; colIgnoreXml.Role = ColumnRole.Ignore; //Add columns to definition var cols = new List <ColumnDefinitionXml>(); cols.Add(colXml); cols.Add(colLightXml); cols.Add(col4Xml); cols.Add(colIgnoreXml); xml.columnsDef = cols; return(xml); }
public void Serialize_CSharp_CodeTransfo() { var def = new ColumnDefinitionXml(); def.TransformationInner = new TransformationXml(); def.TransformationInner.Language = LanguageType.CSharp; def.TransformationInner.Code = "value.Trim().ToUpper();"; var manager = new XmlManager(); var xml = manager.XmlSerializeFrom <ColumnDefinitionXml>(def); Assert.That(xml, Is.StringContaining(">value.Trim().ToUpper();<")); }
public void Serialize_Native_CodeTransfo() { var def = new ColumnDefinitionXml(); def.TransformationInner = new TransformationXml(); def.TransformationInner.Language = LanguageType.Native; def.TransformationInner.Code = "empty-to-null"; var manager = new XmlManager(); var xml = manager.XmlSerializeFrom <ColumnDefinitionXml>(def); Assert.That(xml, Is.StringContaining("native")); Assert.That(xml, Is.StringContaining(">empty-to-null<")); }
public void Serialize_Format_CodeTransfo() { var def = new ColumnDefinitionXml(); def.TransformationInner = new TransformationXml(); def.TransformationInner.Language = LanguageType.Format; def.TransformationInner.Code = "##.000"; var manager = new XmlManager(); var xml = manager.XmlSerializeFrom <ColumnDefinitionXml>(def); Assert.That(xml, Is.StringContaining("format")); Assert.That(xml, Is.StringContaining(">##.000<")); }
public void Serialize_CSharp_CodeTransfo() { var def = new ColumnDefinitionXml() { TransformationInner = new LightTransformXml() { Language = LanguageType.CSharp, Code = "value.Trim().ToUpper();" } }; var manager = new XmlManager(); var xml = manager.XmlSerializeFrom <ColumnDefinitionXml>(def); Assert.That(xml, Does.Contain(">value.Trim().ToUpper();<")); Assert.That(xml, Does.Not.Contain("column-index")); }
public void Serialize_Format_CodeTransfo() { var def = new ColumnDefinitionXml() { TransformationInner = new LightTransformXml() { Language = LanguageType.Format, Code = "##.000" } }; var manager = new XmlManager(); var xml = manager.XmlSerializeFrom <ColumnDefinitionXml>(def); Assert.That(xml, Does.Contain("format")); Assert.That(xml, Does.Contain(">##.000<")); Assert.That(xml, Does.Not.Contain("column-index")); }
public void Serialize_Native_CodeTransfo() { var def = new ColumnDefinitionXml() { TransformationInner = new LightTransformXml() { Language = LanguageType.Native, Code = "empty-to-null" } }; var manager = new XmlManager(); var xml = manager.XmlSerializeFrom <ColumnDefinitionXml>(def); Assert.That(xml, Does.Contain("native")); Assert.That(xml, Does.Contain(">empty-to-null<")); Assert.That(xml, Does.Not.Contain("column-index")); }