public void Execute(IEnumerable <DataRow> rows, ISampler <DataRow> sampler, JsonWriter writer)
{
rows = rows ?? new List <DataRow>();
sampler.Build(rows);
var sampled = sampler.GetResult();
writer.WriteStartObject();
writer.WritePropertyName("total-rows");
writer.WriteValue(rows.Count());
if (sampler.GetIsSampled())
{
writer.WritePropertyName("sampled-rows");
writer.WriteValue(rows.Count() - sampler.GetExcludedRowCount());
}
if (sampled.Count() > 0)
{
writer.WritePropertyName("table");
writer.WriteStartObject();
writer.WritePropertyName("columns");
writer.WriteStartArray();
var formatters = new List <CellFormatter>();
foreach (DataColumn column in sampled.ElementAt(0).Table.Columns)
{
writer.WriteStartObject();
writer.WritePropertyName("position");
writer.WriteValue(column.Ordinal);
writer.WritePropertyName("name");
writer.WriteValue(column.ColumnName);
var cpFormatter = new ColumnPropertiesFormatter();
writer.WritePropertyName("role");
writer.WriteValue(cpFormatter.GetRoleText((ColumnRole)(column.ExtendedProperties["NBi::Role"] ?? ColumnRole.Key)));
writer.WritePropertyName("type");
writer.WriteValue(cpFormatter.GetTypeText((ColumnType)(column.ExtendedProperties["NBi::Type"] ?? ColumnType.Text)));
formatters.Add(new CellFormatterFactory().GetObject((ColumnType)(column.ExtendedProperties["NBi::Type"] ?? ColumnType.Text)));
var tolerance = (Tolerance)(column.ExtendedProperties["NBi::Tolerance"]);
if (!Tolerance.IsNullOrNone(tolerance))
{
writer.WritePropertyName("tolerance");
writer.WriteValue(cpFormatter.GetToleranceText(tolerance).Trim());
}
var rounding = (Rounding)(column.ExtendedProperties["NBi::Rounding"]);
if (rounding != null)
{
writer.WritePropertyName("rounding");
writer.WriteValue(cpFormatter.GetRoundingText(rounding));
}
writer.WriteEndObject();
}
writer.WriteEndArray(); //columns
BuildRows(sampled, formatters, writer);
writer.WriteEndObject(); //table
}
writer.WriteEndObject();
}
protected virtual void RenderColumns(IEnumerable <ExtendedMetadata> extendedMetadatas, JsonWriter writer)
{
writer.WritePropertyName("columns");
writer.WriteStartArray();
foreach (var extendedMetadata in extendedMetadatas)
{
writer.WriteStartObject();
writer.WritePropertyName("position");
writer.WriteValue(extendedMetadata.Ordinal);
writer.WritePropertyName("name");
writer.WriteValue(extendedMetadata.Name);
var cpFormatter = new ColumnPropertiesFormatter();
writer.WritePropertyName("role");
writer.WriteValue(cpFormatter.GetRoleText(extendedMetadata.Role));
writer.WritePropertyName("type");
writer.WriteValue(cpFormatter.GetTypeText(extendedMetadata.Type));
if (!Tolerance.IsNullOrNone(extendedMetadata.Tolerance))
{
writer.WritePropertyName("tolerance");
writer.WriteValue(cpFormatter.GetToleranceText(extendedMetadata.Tolerance).Trim());
}
if (extendedMetadata.Rounding != null)
{
writer.WritePropertyName("rounding");
writer.WriteValue(cpFormatter.GetRoundingText(extendedMetadata.Rounding));
}
writer.WriteEndObject();
}
writer.WriteEndArray(); //columns
}
public void GetText_NumericRounding_CorrectHeader()
{
var formatter = new ColumnPropertiesFormatter();
var text = formatter.GetText(ColumnRole.Value, ColumnType.Numeric, null, new NumericRounding(10.5m, Rounding.RoundingStyle.Round));
Assert.That(text, Is.StringContaining("VALUE"));
Assert.That(text, Is.StringContaining("Numeric"));
Assert.That(text, Is.StringContaining("(round 10.5)"));
}
public void GetText_DateTimeRounding_CorrectHeader()
{
var formatter = new ColumnPropertiesFormatter();
var text = formatter.GetText(ColumnRole.Value, ColumnType.DateTime, null, new DateTimeRounding(new TimeSpan(0, 15, 0), Rounding.RoundingStyle.Floor));
Assert.That(text, Is.StringContaining("VALUE"));
Assert.That(text, Is.StringContaining("DateTime"));
Assert.That(text, Is.StringContaining("(floor 00:15:00)"));
}
public void GetText_DateTimeTolerance_CorrectHeader()
{
var formatter = new ColumnPropertiesFormatter();
var text = formatter.GetText(ColumnRole.Value, ColumnType.DateTime, new DateTimeTolerance(new TimeSpan(0, 15, 0)), null);
Assert.That(text, Is.StringContaining("VALUE"));
Assert.That(text, Is.StringContaining("DateTime"));
Assert.That(text, Is.StringContaining("(+/- 00:15:00)"));
}
public void GetText_NumericPercentageOneSidedMoreTolerance_CorrectHeader()
{
var formatter = new ColumnPropertiesFormatter();
var text = formatter.GetText(ColumnRole.Value, ColumnType.Numeric, new NumericPercentageTolerance(new decimal(0.125), SideTolerance.More), null);
Assert.That(text, Is.StringContaining("VALUE"));
Assert.That(text, Is.StringContaining("Numeric"));
Assert.That(text, Is.StringContaining("(+/- +12.500%)"));
}
public void GetText_NumericAbsoluteOnSidedLessTolerance_CorrectHeader()
{
var formatter = new ColumnPropertiesFormatter();
var text = formatter.GetText(ColumnRole.Value, ColumnType.Numeric, new NumericAbsoluteTolerance(new decimal(0.5), SideTolerance.Less), null);
Assert.That(text, Is.StringContaining("VALUE"));
Assert.That(text, Is.StringContaining("Numeric"));
Assert.That(text, Is.StringContaining("(+/- -0.5)"));
}
public void GetText_NoToleranceOrRounding_DoesntEndWithSpace()
{
var formatter = new ColumnPropertiesFormatter();
var text = formatter.GetText(ColumnRole.Value, ColumnType.Numeric, null, null);
Assert.That(text, Is.StringContaining("VALUE"));
Assert.That(text, Is.StringContaining("Numeric"));
Assert.That(text, Is.Not.StringEnding(" "));
}
public void Execute(IEnumerable <DataRow> rows, ISampler <DataRow> sampler, IEnumerable <ColumnMetadata> metadata, JsonWriter writer)
{
rows = rows ?? new List <DataRow>();
sampler.Build(rows);
var sampled = sampler.GetResult();
writer.WriteStartObject();
writer.WritePropertyName("total-rows");
writer.WriteValue(rows.Count());
if (sampler.GetIsSampled())
{
writer.WritePropertyName("sampled-rows");
writer.WriteValue(rows.Count() - sampler.GetExcludedRowCount());
}
if (sampled.Count() > 0)
{
writer.WritePropertyName("table");
writer.WriteStartObject();
writer.WritePropertyName("columns");
writer.WriteStartArray();
var formatters = new List <IPresenter>();
var columns = sampled.ElementAt(0).Table.Columns;
for (var i = 0; i < columns.Count; i++)
{
var meta = metadata.ElementAt(i);
writer.WriteStartObject();
writer.WritePropertyName("position");
writer.WriteValue(columns[i].Ordinal);
writer.WritePropertyName("name");
writer.WriteValue(columns[i].ColumnName);
var cpFormatter = new ColumnPropertiesFormatter();
writer.WritePropertyName("role");
writer.WriteValue(cpFormatter.GetRoleText(meta.Role));
writer.WritePropertyName("type");
writer.WriteValue(cpFormatter.GetTypeText(meta.Type));
if (!Tolerance.IsNullOrNone(meta.Tolerance))
{
writer.WritePropertyName("tolerance");
writer.WriteValue(cpFormatter.GetToleranceText(meta.Tolerance).Trim());
}
if (meta.Rounding != null)
{
writer.WritePropertyName("rounding");
writer.WriteValue(cpFormatter.GetRoundingText(meta.Rounding));
}
formatters.Add(new PresenterFactory().Instantiate(metadata.ElementAt(i).Type));
writer.WriteEndObject();
}
writer.WriteEndArray(); //columns
BuildRows(sampled, formatters, writer);
writer.WriteEndObject(); //table
}
writer.WriteEndObject();
}
