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"));
}
