public void When_writing_cell_value_it_should_respect_culture()
{
// Arrange
var output = new StringWriter();
var culture = new CultureInfo("nl-NL");
using (DelimitedValuesWriter writer = new DelimitedValuesWriterBuilder()
.WritingTo(output)
.WithSingleColumnHeader("A")
.WithSettings(new DelimitedValuesWriterSettingsBuilder()
.WithoutColumnNamesOnFirstLine()
.WithCulture(culture))
.Build())
{
// Act
using (IDelimitedValuesWriterRow row = writer.CreateRow())
{
string firstColumnName = writer.ColumnNames.First();
row.SetCell(firstColumnName, 3.5m);
}
}
// Assert
output.ToString().Should().Be("3,5" + Environment.NewLine);
}
public void When_cell_contains_field_separator_it_should_escape_cell()
{
// Arrange
var output = new StringWriter();
using (DelimitedValuesWriter writer = new DelimitedValuesWriterBuilder()
.WritingTo(output)
.WithSettings(new DelimitedValuesWriterSettingsBuilder()
.WithTextQualifier('\'')
.WithFieldSeparator('|')
.WithoutColumnNamesOnFirstLine())
.WithColumnHeaders("A", "B")
.Build())
{
using (IDelimitedValuesWriterRow row = writer.CreateRow())
{
row.SetCell("A", "X|Y");
row.SetCell("B", "Z");
}
// Act
}
// Assert
output.ToString().Should().Be("'X|Y'|Z" + Environment.NewLine);
}
public void When_disposing_row_multiple_times_it_should_write_the_row_only_once()
{
// Arrange
var output = new StringWriter();
using (DelimitedValuesWriter writer = new DelimitedValuesWriterBuilder()
.WritingTo(output)
.WithSettings(new DelimitedValuesWriterSettingsBuilder()
.WithoutColumnNamesOnFirstLine())
.WithSingleColumnHeader("A")
.Build())
{
IDelimitedValuesWriterRow row = writer.CreateRow();
row.SetCell("A", "X");
// Act
row.Dispose();
row.Dispose();
}
IEnumerable <string> lines = TextToLines(output.ToString());
// Assert
lines.Should().HaveCount(1);
}
private static void SetTimeElapsedSinceStart(IDelimitedValuesWriterRow row, string columnName, CompetitionRunResult runResult, RecordedTime?time)
{
TimeSpanWithAccuracy?elapsed = GetElapsedSinceStart(runResult.Timings, time);
if (elapsed != null)
{
row.SetCell(columnName, elapsed.Value);
}
}
public void When_completing_row_creation_after_disposal_it_should_fail()
{
// Arrange
DelimitedValuesWriter writer = new DelimitedValuesWriterBuilder().Build();
IDelimitedValuesWriterRow row = writer.CreateRow();
writer.Dispose();
// Act
Action action = row.Dispose;
// Assert
action.Should().ThrowExactly <ObjectDisposedException>();
}
public void When_unspecified_column_names_are_assigned_a_cell_value_it_should_fail()
{
// Arrange
using DelimitedValuesWriter writer = new DelimitedValuesWriterBuilder()
.WithSingleColumnHeader("A")
.Build();
// Act
Action action = () =>
{
using IDelimitedValuesWriterRow row = writer.CreateRow();
row.SetCell("B", "dummy");
};
// Assert
action.Should().ThrowExactly <ArgumentException>().WithMessage("Column with name 'B' does not exist.*");
}
public static void ExportTo(string path, IEnumerable <CompetitionRunResult> runResults)
{
Guard.NotNullNorEmpty(path, nameof(path));
Guard.NotNull(runResults, nameof(runResults));
using var textWriter = new StreamWriter(path);
var settings = new DelimitedValuesWriterSettings
{
Culture = Settings.Default.ImportExportCulture
};
using var valuesWriter = new DelimitedValuesWriter(textWriter, ExportColumnNames, settings);
foreach (CompetitionRunResult runResult in runResults)
{
using IDelimitedValuesWriterRow row = valuesWriter.CreateRow();
row.SetCell(ImportExportColumns.CompetitorNumber, runResult.Competitor.Number);
row.SetCell(ImportExportColumns.HandlerName, runResult.Competitor.HandlerName);
row.SetCell(ImportExportColumns.DogName, runResult.Competitor.DogName);
row.SetCell(ImportExportColumns.CountryCode, runResult.Competitor.CountryCode);
if (runResult.Timings != null)
{
SetTimeElapsedSinceStart(row, ImportExportColumns.IntermediateTime1, runResult, runResult.Timings.IntermediateTime1);
SetTimeElapsedSinceStart(row, ImportExportColumns.IntermediateTime2, runResult, runResult.Timings.IntermediateTime2);
SetTimeElapsedSinceStart(row, ImportExportColumns.IntermediateTime3, runResult, runResult.Timings.IntermediateTime3);
SetTimeElapsedSinceStart(row, ImportExportColumns.FinishTime, runResult, runResult.Timings.FinishTime);
}
if (runResult.HasCompleted)
{
row.SetCell(ImportExportColumns.FaultCount, runResult.FaultCount);
row.SetCell(ImportExportColumns.RefusalCount, runResult.RefusalCount);
row.SetCell(ImportExportColumns.IsEliminated, runResult.IsEliminated);
row.SetCell(ImportExportColumns.Placement, runResult.PlacementText);
}
}
}
public void When_writing_cell_value_with_custom_converter_it_should_succeed()
{
// Arrange
var output = new StringWriter();
using (DelimitedValuesWriter writer = new DelimitedValuesWriterBuilder()
.WritingTo(output)
.WithSingleColumnHeader("A")
.WithSettings(new DelimitedValuesWriterSettingsBuilder()
.WithoutColumnNamesOnFirstLine())
.Build())
{
// Act
using (IDelimitedValuesWriterRow row = writer.CreateRow())
{
row.SetCell("A", 123, _ => "Y");
}
}
// Assert
output.ToString().Should().Be("Y" + Environment.NewLine);
}
public void When_cell_is_not_assigned_a_value_it_should_become_an_empty_cell()
{
// Arrange
var output = new StringWriter();
using (DelimitedValuesWriter writer = new DelimitedValuesWriterBuilder()
.WritingTo(output)
.WithSettings(new DelimitedValuesWriterSettingsBuilder()
.WithFieldSeparator('|')
.WithoutColumnNamesOnFirstLine())
.WithColumnHeaders("A", "B", "C")
.Build())
{
// Act
using (IDelimitedValuesWriterRow row = writer.CreateRow())
{
row.SetCell("A", "X");
}
}
// Assert
output.ToString().Should().Be("X||" + Environment.NewLine);
}
public void When_writing_cell_value_as_nullable_boolean_it_should_succeed()
{
// Arrange
var output = new StringWriter();
using (DelimitedValuesWriter writer = new DelimitedValuesWriterBuilder()
.WritingTo(output)
.WithColumnHeaders("A", "B", "C")
.WithSettings(new DelimitedValuesWriterSettingsBuilder()
.WithoutColumnNamesOnFirstLine())
.Build())
{
// Act
using (IDelimitedValuesWriterRow row = writer.CreateRow())
{
row.SetCell <bool?>("A", true);
row.SetCell <bool?>("B", null);
row.SetCell <bool?>("C", false);
}
}
// Assert
output.ToString().Should().Be("True,,False" + Environment.NewLine);
}
public void When_cell_contains_text_qualifier_it_should_escape_cell()
{
// Arrange
var output = new StringWriter();
using (DelimitedValuesWriter writer = new DelimitedValuesWriterBuilder()
.WritingTo(output)
.WithSettings(new DelimitedValuesWriterSettingsBuilder()
.WithTextQualifier('\'')
.WithoutColumnNamesOnFirstLine())
.WithSingleColumnHeader("A")
.Build())
{
using (IDelimitedValuesWriterRow row = writer.CreateRow())
{
row.SetCell("A", "Bed 'n Breakfast");
}
// Act
}
// Assert
output.ToString().Should().Be("'Bed ''n Breakfast'" + Environment.NewLine);
}
