public void Should_Write_File_On_Same_Directory(string filePath) { // Arrange // Act var result = _csvFileWriter.Write(filePath, fileContent); // (Using Shouldly) Assert : Assert and Act together result.ShouldBe(true); // (Using NUnit) Assert : Assert and Act together // Assert.AreEqual(true, result); }
public void WriteSameAsReaderCritical() { var writeFile = new CsvFile(); writeFile.ID = "Write"; writeFile.FileName = mimicReader.ReadSettings.FirstOrDefault(x => x.ID == "Read").FileName; writeFile.SqlStatement = "Read"; writeFile.InOverview = true; writeFile.FileFormat.FieldDelimiter = "|"; try { var writer = new CsvFileWriter(writeFile, CancellationToken.None); var res = writer.Write(); Assert.Fail("No Exception"); } catch (ApplicationException) { } catch (System.IO.IOException) { } catch (Exception) { Assert.Fail("Wrong exception"); } }
public void WriteAllFormats() { var pd = new MockProcessDisplay(); var writeFile = new CsvFile { ID = "Write", FileName = Path.Combine(m_ApplicationDirectory, "BasicCSVOut2.txt") }; FileSystemUtils.FileDelete(writeFile.FileName); var setting = Helper.ReaderGetAllFormats(ApplicationSetting.ToolSetting); mimicReader.AddSetting(setting); writeFile.SqlStatement = setting.ID; writeFile.FileFormat.FieldDelimiter = "|"; var cf = writeFile.ColumnAdd(new Column { Name = "DateTime", DataType = DataType.DateTime }); cf.DateFormat = "yyyyMMdd"; cf.TimePartFormat = @"hh:mm"; cf.TimePart = "Time"; var writer = new CsvFileWriter(writeFile, CancellationToken.None); writer.Progress += pd.SetProcess; var res = writer.Write(); Assert.IsTrue(FileSystemUtils.FileExists(writeFile.FileName)); Assert.AreEqual(1065, res, "Records"); }
public Stream Compare( Stream source1, Stream source2, char reportValueDelimiter) { CsvDocument doc1 = Read( csvStream1Reader, 1, source1); CsvDocument doc2 = Read( csvStream2Reader, 2, source2); doc1 = TransformWithErrorHandling(doc1, transformer1, 1); doc2 = TransformWithErrorHandling(doc2, transformer2, 2); var comparer = BuildComparer(doc1.HeaderCells, doc2.HeaderCells); ComparisonResult result; try { result = comparer.Compare( doc1.ContentRows, doc2.ContentRows); } catch (InputParsingException) { throw; } catch (Exception e) { throw new DataComparisonException(e); } var stringyfyer = new Andy.Csv.Serialization.RowStringifier( new Andy.Csv.Serialization.CellValueEncoder()); try { string[] lines = ResultStringification.StringyfyyResults( result, doc1.HeaderCells, doc2.HeaderCells, reportValueDelimiter, stringyfyer); return(CsvFileWriter.Write(lines)); } catch (Exception e) { throw new ReportProductionException(e); } }
public void Object() { var ms = new MemoryStream(); CsvFileWriter.Write(ms, new [] { new { Int = 1, Double = 2.01 } }); var str = Encoding.UTF8.GetString(ms.GetBuffer()); Assert.Equal("Int,Double\r\n1,2.01\r\n", str.Trim('\0')); }
public void WriteSameAsReader() { var writeFile = new CsvFile(); writeFile.ID = "Write"; writeFile.FileName = mimicReader.ReadSettings.FirstOrDefault(x => x.ID == "Read").FileName; writeFile.SqlStatement = "Read"; writeFile.FileFormat.FieldDelimiter = "|"; var writer = new CsvFileWriter(writeFile, CancellationToken.None); Assert.IsTrue(string.IsNullOrEmpty(writer.ErrorMessage)); var res = writer.Write(); Assert.IsFalse(string.IsNullOrEmpty(writer.ErrorMessage)); }
public static void ToCsv(this Print print, string path, string columnsSeparator, string decimalSeparator = null, bool?addCsvHeader = null) { if (path == null) { throw new ArgumentNullException(nameof(path)); } if (columnsSeparator == null) { throw new ArgumentNullException(nameof(columnsSeparator)); } var raw = print.ToRaw(); CsvFileWriter.Write(path, raw.Item2, raw.Item3, columnsSeparator, decimalSeparator, addCsvHeader ?? false); }
public void SpecialChars() { var ms = new MemoryStream(); CsvFileWriter.Write(ms, new List <IList> { new List <object> { "a,b", "a\"b", "a\r\nb" }, new List <object> { 1, 2, 3 } }); var str = Encoding.UTF8.GetString(ms.GetBuffer()); Assert.Equal("\"a,b\",\"a\"\"b\",\"a\r\nb\"\r\n1,2,3\r\n", str.Trim('\0')); }
public void NullWrite() { var ms = new MemoryStream(); CsvFileWriter.Write(ms, new List <IList> { new List <object?> { "1", null, "3" }, new List <object?> { 1, 2, 3 } }); var str = Encoding.UTF8.GetString(ms.GetBuffer()); Assert.Equal("1,,3\r\n1,2,3\r\n", str.Trim('\0')); }
public void WriteCsvFile() { var cacheData = new[] { new ProcessedCacheData( new CacheData("GC7WP8Y", new LatLng(43.550767, 16.51405), -23.896, 905.656), new LatLng(43.558220, 16.509510) ) }; var csvWriter = new CsvFileWriter(); using (var writer = new StringWriter()) { csvWriter.Write(cacheData, writer); var csvString = writer.ToString(); var expected = "GC7WP8Y,43.55822,16.50951" + Environment.NewLine; csvString.Should().Be(expected); } }
public void Write() { var pd = new MockProcessDisplay(); var writeFile = new CsvFile { ID = "Write", FileName = Path.Combine(m_ApplicationDirectory, "BasicCSVOut.txt") }; FileSystemUtils.FileDelete(writeFile.FileName); writeFile.SqlStatement = "Read"; writeFile.FileFormat.FieldDelimiter = "|"; var writer = new CsvFileWriter(writeFile, CancellationToken.None); Assert.IsTrue(string.IsNullOrEmpty(writer.ErrorMessage)); writer.Progress += pd.SetProcess; var res = writer.Write(); Assert.IsTrue(FileSystemUtils.FileExists(writeFile.FileName)); Assert.AreEqual(7, res); }