public async Task Find_searches_URL()
{
try
{
// Insert seed data into the database using one instance of the context
using (var context = new BloggingContext(DBFixture.Setup.DbOpts))
{
var repository = new BloggingRepository(context);
await repository.AddAsync(new Blog { Url = "http://sample.com/cats" });
await repository.AddAsync(new Blog { Url = "http://sample.com/catfish" });
await repository.AddAsync(new Blog { Url = "http://sample.com/dogs" });
await repository.SaveAsync();
}
// Use a clean instance of the context to run the test
using (var context = new BloggingContext(DBFixture.Setup.DbOpts))
{
var repository = new BloggingRepository(context);
var result = await repository.FindByAsync(b => b.Url.Contains("cat"));
Assert.Equal(2, result.Count());
}
}
catch (Exception)
{
throw;
}
}
public async Task Delete_by_URL()
{
try
{
// Insert seed data into the database using one instance of the context
using (var context = new BloggingContext(DBFixture.Setup.DbOpts))
{
var repository = new BloggingRepository(context);
await repository.AddAsync(new Blog { Url = "http://sample.com/foobar" });
await repository.SaveAsync();
}
// Use a clean instance of the context to run the test
using (var context = new BloggingContext(DBFixture.Setup.DbOpts))
{
var repository = new BloggingRepository(context);
var result = (await repository.FindByAsync(x => x.Url == "http://sample.com/foobar")).FirstOrDefault();
repository.Delete(result);
await repository.SaveAsync();
Assert.Empty((await repository.FindByAsync(x => x.Url == "http://sample.com/foobar")));
}
}
catch (Exception)
{
throw;
}
}
public async Task Add_writes_to_database()
{
try
{
// Run the test against one instance of the context
using (var context = new BloggingContext(DBFixture.Setup.DbOpts))
{
var repository = new BloggingRepository(context);
await repository.AddAsync(new Blog { Url = "http://sample.com", /*BlogId = 1,*/ Post = null });
await repository.SaveAsync();
}
// Use a separate instance of the context to verify correct data was saved to database
using (var context = new BloggingContext(DBFixture.Setup.DbOpts))
{
Assert.Equal(1, await context.Blogs.CountAsync(x => x.Url == "http://sample.com"));
}
}
catch (Exception)
{
throw;
}
}
public async Task Edit()
{
try
{
// Insert seed data into the database using one instance of the context
using (var context = new BloggingContext(DBFixture.Setup.DbOpts))
{
var repository = new BloggingRepository(context);
await repository.AddAsync(new Blog { Url = "http://some.address.com/foo" });
await repository.SaveAsync();
}
// Use a clean instance of the context to run the test
using (var context = new BloggingContext(DBFixture.Setup.DbOpts))
{
var repository = new BloggingRepository(context);
var result = (await repository.FindByAsync(x => x.Url == "http://some.address.com/foo")).FirstOrDefault();
Assert.NotNull(result);
result.Url = "http://domain.com/bar";
repository.Edit(result);
await repository.SaveAsync();
}
using (var context = new BloggingContext(DBFixture.Setup.DbOpts))
{
var repository = new BloggingRepository(context);
var result = await repository.FindByAsync(x => x.Url.StartsWith("http://domain.com"));
Assert.Equal("http://domain.com/bar", result.First().Url);
}
}
catch (Exception)
{
throw;
}
}