public void Can_create_csv_from_Categories()
{
NorthwindData.LoadData(false);
var category = NorthwindFactory.Category(1, "between \"quotes\" here", "with, comma", null);
var categories = new[] { category, category };
var csv = CsvSerializer.SerializeToCsv(categories);
Log(csv);
Assert.That(csv, Is.EqualTo(
"Id,CategoryName,Description,Picture"
+ Environment.NewLine
+ "1,\"between \"\"quotes\"\" here\",\"with, comma\","
+ Environment.NewLine
+ "1,\"between \"\"quotes\"\" here\",\"with, comma\","
+ Environment.NewLine
));
}
public void Can_create_csv_from_Categories_pipe_separator()
{
CsvConfig.ItemSeperatorString = "|";
NorthwindData.LoadData(false);
var category = NorthwindFactory.Category(1, "between \"quotes\" here", "with, comma", null);
var categories = new[] { category, category };
var csv = CsvSerializer.SerializeToCsv(categories);
Log(csv);
Assert.That(csv, Is.EqualTo(
"Id|CategoryName|Description|Picture"
+ Environment.NewLine
+ "1|\"between \"\"quotes\"\" here\"|with, comma|"
+ Environment.NewLine
+ "1|\"between \"\"quotes\"\" here\"|with, comma|"
+ Environment.NewLine
));
}
public void Can_generate_csv_with_invalid_chars_pipe_separator()
{
CsvConfig.ItemSeperatorString = "|";
var fields = new[] { "1", "2", "3\"", "4", "5\"five,six\"", "7,7.1", "\"7,7.1\"", "8" };
var csv = CsvSerializer.SerializeToCsv(fields);
Log(csv);
Assert.That(csv, Is.EqualTo(
"1|2|\"3\"\"\"|4|\"5\"\"five,six\"\"\"|7,7.1|\"\"\"7,7.1\"\"\"|8"
+ Environment.NewLine
));
}
public void Can_generate_csv_with_invalid_chars_pipe_delimiter()
{
CsvConfig.ItemDelimiterString = "|";
var fields = new[] { "1", "2", "3\"", "4", "5\"five,six\"", "7,7.1", "\"7,7.1\"", "8" };
var csv = CsvSerializer.SerializeToCsv(fields);
Log(csv);
Assert.That(csv, Is.EqualTo(
"1,2,3\",4,|5\"five,six\"|,|7,7.1|,|\"7,7.1\"|,8"
+ Environment.NewLine
));
}
public void Can_generate_csv_with_invalid_chars()
{
var fields = new[] { "1", "2", "3\"", "4", "5\"five,six\"", "7,7.1", "\"7,7.1\"", "8" };
var csv = CsvSerializer.SerializeToCsv(fields);
Log(csv);
Assert.That(csv, Is.EqualTo(
"1,2,\"3\"\"\",4,\"5\"\"five,six\"\"\",\"7,7.1\",\"\"\"7,7.1\"\"\",8"
+ Environment.NewLine
));
}
public void Can_create_csv_from_Categories_long_delimiter()
{
CsvConfig.ItemDelimiterString = "~^~";
NorthwindData.LoadData(false);
var category = NorthwindFactory.Category(1, "between \"quotes\" here", "with, comma", null);
var categories = new[] { category, category };
var csv = CsvSerializer.SerializeToCsv(categories);
Log(csv);
Assert.That(csv, Is.EqualTo(
"Id,CategoryName,Description,Picture"
+ Environment.NewLine
+ "1,between \"quotes\" here,~^~with, comma~^~,"
+ Environment.NewLine
+ "1,between \"quotes\" here,~^~with, comma~^~,"
+ Environment.NewLine
));
}
