protected NBiConstraint InstantiateConstraint()
{
BaseResultSetComparisonConstraint ctr = null;
if (ConstraintXml.GetCommand() != null)
{
var commandText = ConstraintXml.GetCommand().CommandText;
var connectionString = ConstraintXml.GetCommand().Connection.ConnectionString;
var timeout = ((QueryXml)(ConstraintXml.BaseItem)).Timeout;
IEnumerable <IQueryParameter> parameters = null;
IEnumerable <IQueryTemplateVariable> variables = null;
if (ConstraintXml.Query != null)
{
parameters = ConstraintXml.Query.GetParameters();
variables = ConstraintXml.Query.GetVariables();
}
var commandBuilder = new CommandBuilder();
var cmd = commandBuilder.Build(connectionString, commandText, parameters, variables, timeout);
ctr = InstantiateConstraint(cmd);
}
else if (ConstraintXml.ResultSet != null)
{
if (!string.IsNullOrEmpty(ConstraintXml.ResultSet.File))
{
Trace.WriteLineIf(NBiTraceSwitch.TraceVerbose, "ResultSet defined in external file!");
ctr = InstantiateConstraint(ConstraintXml.ResultSet.GetFile());
if (ConstraintXml.Settings.CsvProfile != null)
{
ctr = ctr.CsvProfile(ConstraintXml.Settings.CsvProfile);
}
}
else if (ConstraintXml.ResultSet.Rows != null)
{
Trace.WriteLineIf(NBiTraceSwitch.TraceVerbose, "ResultSet defined in embedded resultSet!");
ctr = InstantiateConstraint(ConstraintXml.ResultSet.Content);
}
}
else if (ConstraintXml.XmlSource != null)
{
var selects = new List <AbstractSelect>();
var factory = new SelectFactory();
foreach (var select in ConstraintXml.XmlSource.XPath.Selects)
{
selects.Add(factory.Instantiate(select.Value, select.Attribute, select.Evaluate));
}
XPathEngine engine = null;
if (ConstraintXml.XmlSource.File != null)
{
Trace.WriteLineIf(NBiTraceSwitch.TraceVerbose, string.Format("Xml file at '{0}'", ConstraintXml.XmlSource.GetFile()));
engine = new XPathFileEngine(ConstraintXml.XmlSource.GetFile(), ConstraintXml.XmlSource.XPath.From.Value, selects);
}
else if (ConstraintXml.XmlSource.Url != null)
{
Trace.WriteLineIf(NBiTraceSwitch.TraceVerbose, string.Format("Xml file at '{0}'", ConstraintXml.XmlSource.Url.Value));
engine = new XPathUrlEngine(ConstraintXml.XmlSource.Url.Value, ConstraintXml.XmlSource.XPath.From.Value, selects);
}
else
{
throw new ArgumentException("File or Url can't be both empty when declaring an xml-source.");
}
ctr = InstantiateConstraint(engine);
}
if (ctr == null)
{
throw new ArgumentException();
}
//Manage settings for comparaison
var builder = new ResultSetComparisonBuilder();
if (ConstraintXml.Behavior == EqualToXml.ComparisonBehavior.SingleRow)
{
builder.Setup(false, 0, null, 0, null,
ConstraintXml.ValuesDefaultType,
ToleranceFactory.Instantiate(ConstraintXml.ValuesDefaultType, ConstraintXml.Tolerance),
ConstraintXml.ColumnsDef
, ComparisonKind.EqualTo
);
}
else
{
builder.Setup(
true,
ConstraintXml.KeysDef,
ConstraintXml.KeyName,
ConstraintXml.ValuesDef,
ConstraintXml.ValueName,
ConstraintXml.ValuesDefaultType,
ToleranceFactory.Instantiate(ConstraintXml.ValuesDefaultType, ConstraintXml.Tolerance),
ConstraintXml.ColumnsDef,
ComparisonKind
);
}
builder.Build();
ctr = ctr.Using(builder.GetComparer());
var settings = builder.GetSettings();
ctr = ctr.Using(settings);
//Manage transformations
var transformationProvider = new TransformationProvider();
foreach (var columnDef in ConstraintXml.ColumnsDef)
{
if (columnDef.Transformation != null)
{
transformationProvider.Add(columnDef.Index, columnDef.Transformation);
}
}
ctr = ctr.Using(transformationProvider);
//Manage parallelism
if (ConstraintXml.ParallelizeQueries)
{
ctr = ctr.Parallel();
}
else
{
ctr = ctr.Sequential();
}
return(ctr);
}
protected NBiConstraint InstantiateConstraint()
{
BaseResultSetComparisonConstraint ctr = null;
//Manage transformations
var transformationProvider = new TransformationProvider();
foreach (var columnDef in ConstraintXml.ColumnsDef)
{
if (columnDef.Transformation != null)
{
transformationProvider.Add(columnDef.Index, columnDef.Transformation);
}
}
if (ConstraintXml.GetCommand() != null)
{
ctr = InstantiateConstraint(((QueryXml)(ConstraintXml.BaseItem)), ConstraintXml.Settings, transformationProvider);
}
else if (ConstraintXml.ResultSet != null)
{
ctr = InstantiateConstraint(ConstraintXml.ResultSet, ConstraintXml.Settings, transformationProvider);
}
else if (ConstraintXml.XmlSource != null)
{
ctr = InstantiateConstraint(ConstraintXml.XmlSource, ConstraintXml.Settings, transformationProvider);
}
if (ctr == null)
{
throw new ArgumentException();
}
//Manage settings for comparaison
var builder = new SettingsEquivalerBuilder();
if (ConstraintXml.Behavior == EqualToXml.ComparisonBehavior.SingleRow)
{
builder.Setup(false);
builder.Setup(ConstraintXml.ValuesDefaultType, ConstraintXml.Tolerance);
builder.Setup(ConstraintXml.ColumnsDef);
}
else
{
builder.Setup(ConstraintXml.KeysDef, ConstraintXml.ValuesDef);
builder.Setup(
ConstraintXml.KeyName?.Replace(" ", "").Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Distinct(),
ConstraintXml.ValueName?.Replace(" ", "").Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Distinct());
builder.Setup(ConstraintXml.ValuesDefaultType, ConstraintXml.Tolerance);
builder.Setup(ConstraintXml.ColumnsDef);
}
builder.Build();
var settings = builder.GetSettings();
var factory = new EquivalerFactory();
var comparer = factory.Instantiate(settings, EquivalenceKind);
ctr = ctr.Using(comparer);
ctr = ctr.Using(settings);
//Manage parallelism
if (ConstraintXml.ParallelizeQueries)
{
ctr = ctr.Parallel();
}
else
{
ctr = ctr.Sequential();
}
return(ctr);
}
