[InlineData(3, "bigfile.csv", "step3.txt")] //=>not xml ext to avoid auto formatting
public void CheckStep(int stepNumber, string inputFileName, string expectedFileName)
{
var mapper = new MapperConfiguration(cfg => _ = MapperHelper.Configure(cfg)).CreateMapper();
var formatter = ((OutputType)stepNumber).GetFormatter();
var rows = formatter.Serialize(
CsvHelperProxy.ReadRows(Path.Combine("Assets", inputFileName))
.ToResult(mapper)
);
//using (var s = new StreamWriter(File.OpenWrite(@"c:\temp\totototo.xml")))
//{
// foreach (var row in rows)
// s.WriteLine(row);
//}
var expectedRows = new List <string>();
using (var stream = new StreamReader(File.OpenRead(Path.Combine("Assets", expectedFileName))))
{
while (!stream.EndOfStream)
{
expectedRows.Add(stream.ReadLine());
}
}
var expectedEnumerator = expectedRows.GetEnumerator();
foreach (var row in rows)
{
Assert.True(expectedEnumerator.MoveNext(), $"{stepNumber} : too many rows received !");
Assert.Equal(expectedEnumerator.Current, row);
}
Assert.False(expectedEnumerator.MoveNext(), $"{stepNumber} : not enough rows received !");
}
public async Task <ObjectResult> PostCsvAsync([FromBody] string csv)
{
_logger.LogDebug($"PostCsvAsync({csv}");
var result = Enumerable.Empty <OutputRowModel>();
using (var stream = csv.ToStream())
{
result = CsvHelperProxy.ReadRowsFromStream(stream).ToResult(_mapper).ToList();
}
return(Ok(result));
}
public void CheckReadRowsLowLevelWithMappingCount(int expected)
{
var mapper = new RowModelMapper();
var count = CsvHelperProxy
.ReadRowsLowLevel(Path.Combine("Assets", "bigfile.csv"))
.Select(mapper.Map)
.Skip(1)
.Where(m => m != null)
.Count();
Assert.Equal(expected, count);
}
public async Task <ObjectResult> GetCsvAsync([FromQuery, Required] string csvUri)
{
_logger.LogDebug($"GetCsvAsync({csvUri}");
var response = await ServiceHttpClient.GetAsync(csvUri);
var result = Enumerable.Empty <OutputRowModel>();
using (var stream = await response.Content.ReadAsStreamAsync())
{
result = CsvHelperProxy.ReadRowsFromStream(stream).ToResult(_mapper).ToList();
}
return(Ok(result));
}
public static void Run(ApplicationArguments arg)
{
var mapper = new MapperConfiguration(cfg => _ = MapperHelper.Configure(cfg)).CreateMapper();
var rows = arg.OutputType.GetFormatter().Serialize(CsvHelperProxy
.ReadRows(arg.File).ToResult(mapper)
);
foreach (var row in rows)
{
System.Console.WriteLine($"{row}");
}
System.Console.WriteLine("Press any key...");
System.Console.ReadKey();
}
public void CheckResultsBetweenTwoMethods()
{
var filepath = Path.Combine("Assets", "bigfile.csv");
var mapper = new RowModelMapper();
var homeMade = CsvHelperProxy
.ReadRows(filepath)
.Select(mapper.Map)
.Skip(1)
.Where(m => m != null).ToList();
var expected = CsvHelperProxy.Read <RowModel, RowModelMap>(filepath).ToList();
foreach (var r in expected)
{
Assert.True(homeMade.Remove(r), r.ToString() + " NotFound");
}
Assert.Empty(homeMade);
homeMade = CsvHelperProxy
.ReadRowsLowLevel(filepath)
.Select(mapper.Map)
.Skip(1)
.Where(m => m != null).ToList();
foreach (var r in expected)
{
Assert.True(homeMade.Remove(r), r.ToString() + " NotFound");
}
Assert.Empty(homeMade);
var automapper = new MapperConfiguration(cfg => _ = MapperHelper.Configure(cfg)).CreateMapper();
homeMade = CsvHelperProxy
.ReadRows(filepath)
.Select(v => automapper.Map <RowModel>(v))
.Skip(1)
.Where(m => m != null).ToList();
foreach (var r in expected)
{
Assert.True(homeMade.Remove(r), r.ToString() + " NotFound");
}
Assert.Empty(homeMade);
}
public void CheckReadWithMappingCount(int expected)
{
var count = CsvHelperProxy.Read <RowModel, RowModelMap>(Path.Combine("Assets", "bigfile.csv")).Count();
Assert.Equal(expected, count);
}
public void CheckReadRowsCount(int expected)
{
var count = CsvHelperProxy.ReadRows(Path.Combine("Assets", "bigfile.csv")).Count();
Assert.Equal(expected, count);
}
