public void AddToCsvRepoWorksWhenFileDoesNotExist(MockPoco input)
{
// Arrange
var fileName = Path.GetRandomFileName();
var outputFile = new FileInfo(Path.ChangeExtension(fileName, "csv"));
CsvContext <MockPoco> csvContext = null;
CsvRepo <MockPoco> repository = null;
try
{
csvContext = new CsvContext <MockPoco>(outputFile)
{
Culture = CultureInfo.InvariantCulture
};
repository = new CsvRepo <MockPoco>(csvContext);
// Act
repository.Add(input);
csvContext.SaveChanges();
var received = File.ReadAllText(outputFile.FullName);
// Assert
Assert.Contains(input.Value, received);
}
finally
{
repository?.Dispose();
outputFile.Delete();
}
}
public void AddStock(Company company)
{
// Arrange
var fileName = Path.GetRandomFileName();
var outputFile = new FileInfo(Path.ChangeExtension(fileName, "csv"));
CsvContext <StockQuote> csvContext = null;
CsvRepo <StockQuote> repository = null;
try
{
csvContext = new StockCsvContext(outputFile)
{
Culture = CultureInfo.InvariantCulture
};
repository = new CsvRepo <StockQuote>(csvContext);
// Act
repository.AddRange(company.Quotes);
csvContext.SaveChanges();
var received = File.ReadAllText(outputFile.FullName);
// Assert
var actual = received.Split(Environment.NewLine).Length;
var expected = company.Quotes.Count + 2;
Assert.Equal(expected, actual);
}
finally
{
repository?.Dispose();
outputFile.Delete();
}
}
public void GetGets(MockPoco input)
{
// Arrange
var fileName = Path.GetRandomFileName();
var outputFile = new FileInfo(Path.ChangeExtension(fileName, "csv"));
CsvContext <MockPoco> csvContext = null;
CsvRepo <MockPoco> repository = null;
try
{
csvContext = new CsvContext <MockPoco>(outputFile)
{
Culture = CultureInfo.InvariantCulture
};
repository = new CsvRepo <MockPoco>(csvContext);
csvContext.Entities.Add(input);
csvContext.SaveChanges();
// Act
var received = repository.Get(input);
// Assert
Assert.Equal(input, received);
}
finally
{
repository?.Dispose();
outputFile.Delete();
}
}
public void RemoveRangeRemovesRange(List <MockPoco> input)
{
// Arrange
var fileName = Path.GetRandomFileName();
var outputFile = new FileInfo(Path.ChangeExtension(fileName, "csv"));
CsvContext <MockPoco> csvContext = null;
CsvRepo <MockPoco> repository = null;
try
{
csvContext = new CsvContext <MockPoco>(outputFile)
{
Culture = CultureInfo.InvariantCulture
};
repository = new CsvRepo <MockPoco>(csvContext);
foreach (var entity in input)
{
csvContext.Entities.Add(entity);
}
// Act
repository.RemoveRange(input);
csvContext.SaveChanges();
// Assert
var rawAllText = File.ReadAllText(outputFile.FullName);
List <MockPoco> fromFileParsed = null;
using (var csv = new CsvReader(new StringReader(rawAllText)))
{
fromFileParsed = csv.GetRecords <MockPoco>().ToList();
}
var actual = fromFileParsed.GroupBy(x => x.Value).OrderBy(x => x.Key).Select(g => new { g.Key, Count = g.Count() }).ToList();
Assert.Empty(actual);
}
finally
{
repository?.Dispose();
outputFile.Delete();
}
}
public void AddOrUpdateUpdates(MockPoco input)
{
string oldValue = input.Value;
const string newValue = "newValue5";
// Arrange
var fileName = Path.GetRandomFileName();
var outputFile = new FileInfo(Path.ChangeExtension(fileName, "csv"));
using (var streamWriter = outputFile.CreateText())
{
streamWriter.Write($"Id,Value\r\n{input.Id},{input.Value}\r\n");
}
CsvContext <MockPoco> csvContext = null;
CsvRepo <MockPoco> repository = null;
try
{
csvContext = new CsvContext <MockPoco>(outputFile)
{
Culture = CultureInfo.InvariantCulture
};
repository = new CsvRepo <MockPoco>(csvContext);
csvContext.SaveChanges();
// Act
input.Value = newValue;
repository.AddOrUpdate(input);
csvContext.SaveChanges();
var received = File.ReadAllText(outputFile.FullName);
// Assert
Assert.Contains(newValue, received);
Assert.DoesNotContain(oldValue, received);
}
finally
{
repository?.Dispose();
outputFile.Delete();
}
}
public void UnitOfWorkDoesNotCommitChangesWhenNotSupposedTo(Company company)
{
// Arrange
var fileName = Path.GetRandomFileName();
var outputFile = new FileInfo(Path.ChangeExtension(fileName, "csv"));
CsvContext <StockQuote> csvContext = null;
CsvRepo <StockQuote> repository = null;
CsvUnitOfWork <StockQuote> tested = null;
try
{
csvContext = new StockCsvContext(outputFile)
{
Culture = CultureInfo.InvariantCulture
};
repository = new CsvRepo <StockQuote>(csvContext);
tested = new CsvUnitOfWork <StockQuote>(csvContext);
// Act
tested.Repo.AddRange(company.Quotes);
tested.Dispose();
string received = null;
if (File.Exists(outputFile.FullName))
{
received = File.ReadAllText(outputFile.FullName);
}
// Assert
var actual = received?.Split(Environment.NewLine)?.Length;
Assert.True(!actual.HasValue || actual.Value == 0);
}
finally
{
tested?.Dispose();
repository?.Dispose();
outputFile.Delete();
}
}
public void AddToCsvRepoWorksWhenNonEmptyFileExists(MockPoco input)
{
// Arrange
var fileName = Path.GetRandomFileName();
var outputFile = new FileInfo(Path.ChangeExtension(fileName, "csv"));
using (var streamWriter = outputFile.CreateText())
{
streamWriter.Write("Id,Value\r\n5,test5\r\n");
}
CsvContext <MockPoco> csvContext = null;
CsvRepo <MockPoco> repository = null;
try
{
csvContext = new CsvContext <MockPoco>(outputFile)
{
Culture = CultureInfo.InvariantCulture
};
repository = new CsvRepo <MockPoco>(csvContext);
// Act
repository.Add(input);
csvContext.SaveChanges();
var received = File.ReadAllText(outputFile.FullName);
// Assert
Assert.Contains("test5", received);
Assert.Contains(input.Value, received);
}
finally
{
repository?.Dispose();
outputFile.Delete();
}
}
public void AddThrowsWhenAttemptedToAddExisitngId()
{
// Arrange
var fileName = Path.GetRandomFileName();
var outputFile = new FileInfo(Path.ChangeExtension(fileName, "csv"));
CsvContext <MockPoco> csvContext = null;
CsvRepo <MockPoco> repository = null;
//
var set = new HashSet <int>();
set.Add(1);
set.Add(1);
//
using (var streamWriter = outputFile.CreateText())
{
streamWriter.Write("Id,Value\r\n5,test5\r\n");
}
try
{
csvContext = new CsvContext <MockPoco>(outputFile)
{
Culture = CultureInfo.InvariantCulture
};
repository = new CsvRepo <MockPoco>(csvContext);
// Act & Assert
Assert.Throws <ArgumentException>(() => repository.Add(new MockPoco {
Id = 5
}));
}
finally
{
repository?.Dispose();
outputFile.Delete();
}
}
public void UpdateUpdatesAfterChangesCommited(MockPoco input)
{
string oldValue = input.Value;
const string newValue = "newValue5";
// Arrange
var fileName = Path.GetRandomFileName();
var outputFile = new FileInfo(Path.ChangeExtension(fileName, "csv"));
CsvContext <MockPoco> csvContext = null;
CsvRepo <MockPoco> repository = null;
try
{
csvContext = new CsvContext <MockPoco>(outputFile)
{
Culture = CultureInfo.InvariantCulture
};
repository = new CsvRepo <MockPoco>(csvContext);
// Act
repository.Add(input);
csvContext.SaveChanges();
input.Value = newValue;
csvContext.SaveChanges();
var received = File.ReadAllText(outputFile.FullName);
// Assert
Assert.Contains(newValue, received);
Assert.DoesNotContain(oldValue, received);
}
finally
{
repository?.Dispose();
outputFile.Delete();
}
}
public StockCsvUnitOfWork(StockCsvContext <Company> context)
{
_context = context;
Repository = new CsvRepo <Company>(context);
}
