public void CheckWordCount()
{
var querry = (from word in unitOfWork.Words.GetAll()
group word by word.TopicId into wordsByTipic
select new { topicId = wordsByTipic.Key, qunatity = wordsByTipic.Count() }).ToList();
var serializer = new CsvSerializer.Serializer();
var file = new FileStream("actual1.csv", FileMode.Truncate);
serializer.Serialize(file, querry);
file.Close();
CompareFiles("initial1.csv", "actual1.csv", "Result1.csv");
}
public void AssertLinesEndWithCorrectLineEnding()
{
// Arrange
var serializer = new Serializer { Settings = new CsvSettings { NewLineDelimeter = "\n" } };
var person = new Person { FirstName = "Nate \"D\"", LastName = "Zaugg" };
var ms = new MemoryStream();
string expected = "FirstName,LastName\n\"Nate \"\"D\"\"\",Zaugg\n";
string actual;
// Act
serializer.Serialize(ms, person);
actual = Encoding.UTF8.GetString(ms.ToArray());
// Assert
Assert.AreEqual(expected, actual);
}
public void AssertHeaderPrintsOnlyWhenRequested()
{
// Arrange
var serializer = new Serializer { Settings = new CsvSettings { WriteHeaders = false } };
var person = new Person { FirstName = "Nate \"D\"", LastName = "Zaugg" };
var ms = new MemoryStream();
string expected = "\"Nate \"\"D\"\"\",Zaugg\r\n";
string actual;
// Act
serializer.Serialize(ms, person);
actual = Encoding.UTF8.GetString(ms.ToArray());
// Assert
Assert.AreEqual(expected, actual);
}
public void AssertValuesWithCamasReceiveQuotes()
{
// Arrange
var serializer = new Serializer();
var person = new Person { FirstName = "Nate", LastName = "Dr, Zaugg" };
var ms = new MemoryStream();
string expected = "FirstName,LastName\r\nNate,\"Dr, Zaugg\"\r\n";
string actual;
// Act
serializer.Serialize(ms, person);
actual = Encoding.UTF8.GetString(ms.ToArray());
// Assert
Assert.AreEqual(expected, actual);
}
private void CompareFiles(string name1, string name2, string resultName)
{
List <string> original = new List <string>();
var file = new StreamReader(name1);
string line;
while ((line = file.ReadLine()) != null)
{
original.Add(line);
}
file.Close();
file = new StreamReader(name2);
List <string> afterMigration = new List <string>();
while ((line = file.ReadLine()) != null)
{
afterMigration.Add(line);
}
file.Close();
foreach (var item in afterMigration)
{
original.Remove(item);
}
var serializer = new CsvSerializer.Serializer();
Assert.AreEqual(original.Count(), 0);
if (original.Count() != 0)
{
var outFile = new FileStream(resultName, FileMode.Create);
serializer.Serialize(outFile, original);
outFile.Close();
}
else
{
var outFile = new StreamWriter(resultName);
outFile.Write("Everything is fine");
outFile.Close();
}
}
public void ReadDB()
{
var querry = (from word in unitOfWork.Words.GetAll()
group word by word.TopicId into wordsByTipic
select new { topicId = wordsByTipic.Key, qunatity = wordsByTipic.Count() }).ToList();
var serializer = new CsvSerializer.Serializer();
var file = new FileStream("initial1.csv", FileMode.Truncate);
serializer.Serialize(file, querry);
var querry2 = (from topic in unitOfWork.Topics.GetAll()
orderby topic.Name
select new { id = topic.Id, name = topic.Name }).ToList();
file.Close();
file = new FileStream("initial2.csv", FileMode.Truncate);
serializer.Serialize(file, querry2);
file.Close();
}
public void AssertValuesWithLineEndingsDoTheRightThing()
{
// Arrange
var serializer = new Serializer { Settings = new CsvSettings { RemoveLineBreaksInFields = false } };
var person = new Person { FirstName = "Nate", LastName = "Dr\r\n Zaugg" };
var ms = new MemoryStream();
string expected = "FirstName,LastName\r\nNate,\"Dr\r\n Zaugg\"\r\n";
string actual;
// Act
serializer.Serialize(ms, person);
actual = Encoding.UTF8.GetString(ms.ToArray());
// Assert
Assert.AreEqual(expected, actual);
}
public void IntegrationTestSimpleObjectArray()
{
// Arrange
var serializer = new Serializer();
var people = new[]
{
new Person{ FirstName = "Nate \"D\"", LastName = "Zaugg" },
new Person{ FirstName = "James\r\nTheKid", LastName = "King" },
new Person{ FirstName = "Tiffany", LastName = "Zaugg" },
};
var ms = new MemoryStream();
string expected = "FirstName,LastName\r\n\"Nate \"\"D\"\"\",Zaugg\r\nJames TheKid,King\r\nTiffany,Zaugg\r\n";
string actual;
// Act
serializer.Serialize(ms, people);
actual = Encoding.UTF8.GetString(ms.ToArray());
// Assert
Assert.AreEqual(expected, actual);
}
public void IntegrationTestSimpleObject()
{
// Arrange
var serializer = new Serializer();
var person = new Person { FirstName = "Nate \"D\"", LastName = "Zaugg" };
var ms = new MemoryStream();
string expected = "FirstName,LastName\r\n\"Nate \"\"D\"\"\",Zaugg\r\n";
string actual;
// Act
serializer.Serialize(ms, person);
actual = Encoding.UTF8.GetString(ms.ToArray());
// Assert
Assert.AreEqual(expected, actual);
}
public void FlattenObjectAsColumns()
{
// Arrange
var serializer = new Serializer();
var order = new Order
{
Id = "Order/12",
OrderDate = new DateTime(2015, 06, 01),
Customer = new Person { FirstName = "Nate", LastName = "Zaugg" }
};
var ms = new MemoryStream();
string expected = "Id,OrderDate,Customer.FirstName,Customer.LastName,Subtotal,Tax,Total\r\nOrder/12,6/1/2015 12:00:00 AM,Nate,Zaugg,0,0,0\r\n";
string actual;
// Act
serializer.Serialize(ms, order);
actual = Encoding.UTF8.GetString(ms.ToArray());
// Assert
Assert.AreEqual(expected, actual);
}
public void FlattenCollectionsAsColumns()
{
// Arrange
var serializer = new Serializer();
var order = new Order
{
Id = "Order/12",
OrderDate = new DateTime(2015, 06, 01),
Customer = new Person { FirstName = "Nate", LastName = "Zaugg" },
Subtotal = 300,
Tax = 22,
Total = 322
};
order.Add(new OrderItem { Id = "1", Name = "Galaxy S5", ShortDescription = "My phone is nice!", Qty = 1, PricePerQty = 200, LineTotal = 200 });
order.Add(new OrderItem { Id = "2", Name = "Xoom Tablet", ShortDescription = "I like Xoom tab", Qty = 1, PricePerQty = 100, LineTotal = 100 });
var ms = new MemoryStream();
string expected = "Id,OrderDate,Customer.FirstName,Customer.LastName,Subtotal,Tax,Total,Items1.Name,Items1.ShortDescription,Items1.PricePerQty,Items1.Qty,Items1.LineTotal,Items2.Name,Items2.ShortDescription,Items2.PricePerQty,Items2.Qty,Items2.LineTotal\r\nOrder/12,6/1/2015 12:00:00 AM,Nate,Zaugg,300,22,322,Galaxy S5,My phone is nice!,200,1,200,Xoom Tablet,I like Xoom tab,100,1,100\r\n";
string actual;
// Act
serializer.Serialize(ms, order);
actual = Encoding.UTF8.GetString(ms.ToArray());
// Assert
Assert.AreEqual(expected, actual);
}
