public async Task SomeValues()
{
try
{
// Run the test against one instance of the context
using (var context = new BloggingContext(Setup.DbOpts))
{
var repository = new AspNetCore.ExistingDb.Repositories.HashesRepository(context, Setup.Conf, Setup.Cache, Setup.Logger, Setup.ServerTiming);
await repository.AddAsync(new ThinHashes
{
Key = "alamakota",
HashMD5 = "dc246bcdd6cb3548579770a034d2e678",
HashSHA256 = "63b347973bb99fed9277b33cb4646b205e9a31331acfa574add3d2351f445e43"
});
await repository.SaveAsync();
}
using (var context = new BloggingContext(Setup.DbOpts))
{
var repository = new AspNetCore.ExistingDb.Repositories.HashesRepository(context, Setup.Conf, Setup.Cache, Setup.Logger, Setup.ServerTiming);
var found = await repository.FindByAsync(x => x.HashSHA256 == "63b347973bb99fed9277b33cb4646b205e9a31331acfa574add3d2351f445e43");
Assert.NotNull(found);
Assert.NotEmpty(found);
Assert.Equal("alamakota", found.First().Key);
}
}
catch (Exception)
{
throw;
}
}
public async Task AutoComplete()
{
try
{
// Run the test against one instance of the context
using (var context = new BloggingContext(Setup.DbOpts))
{
var repository = new AspNetCore.ExistingDb.Repositories.HashesRepository(context, Setup.Conf, Setup.Cache, Setup.Logger, Setup.ServerTiming);
await repository.AddRangeAsync(new[] {
new ThinHashes
{
Key = "alamakota",
HashMD5 = "dc246bcdd6cb3548579770a034d2e678",
HashSHA256 = "63b347973bb99fed9277b33cb4646b205e9a31331acfa574add3d2351f445e43"
},
new ThinHashes
{
Key = "fakefakef",
HashMD5 = "fakefakefakefakefakefakefakefake",
HashSHA256 = "fakefakefakefakefakefakefakefakefakefakefakefakefakefakefakefake"
}
});
await repository.SaveAsync();
}
using (var context = new BloggingContext(Setup.DbOpts))
{
var repository = new AspNetCore.ExistingDb.Repositories.HashesRepository(context, Setup.Conf, Setup.Cache, Setup.Logger, Setup.ServerTiming);
var found = await repository.AutoComplete("NOEXIST");
Assert.NotNull(found);
Assert.NotEmpty(found);
Assert.Equal("nothing found", found.First().Key);
found = await repository.AutoComplete("fake");
Assert.NotNull(found);
Assert.NotEmpty(found);
Assert.Contains(found.First().Key, "fakefakef");
found = await repository.AutoComplete("63b347973bb99");
Assert.NotNull(found);
Assert.NotEmpty(found);
Assert.Contains(found.First().Key, "alamakota");
found = await repository.AutoComplete("fakefakefakefakefakefakefake");
Assert.NotNull(found);
Assert.NotEmpty(found);
Assert.Contains(found.First().Key, "fakefakef");
}
}
catch (Exception)
{
throw;
}
}
public async Task Search_FOUND()
{
try
{
// Run the test against one instance of the context
using (var context = new BloggingContext(Setup.DbOpts))
{
var repository = new AspNetCore.ExistingDb.Repositories.HashesRepository(context, Setup.Conf, Setup.Cache, Setup.Logger, Setup.ServerTiming);
await repository.AddRangeAsync(new[] {
new ThinHashes
{
Key = "alamakota",
HashMD5 = "dc246bcdd6cb3548579770a034d2e678",
HashSHA256 = "63b347973bb99fed9277b33cb4646b205e9a31331acfa574add3d2351f445e43"
},
new ThinHashes
{
Key = "fakefakef",
HashMD5 = "fakefakefakefakefakefakefakefake",
HashSHA256 = "fakefakefakefakefakefakefakefakefakefakefakefakefakefakefakefake"
}
});
await repository.SaveAsync();
}
using (var context = new BloggingContext(Setup.DbOpts))
{
var repository = new AspNetCore.ExistingDb.Repositories.HashesRepository(context, Setup.Conf, Setup.Cache, Setup.Logger, Setup.ServerTiming);
var found = await repository.PagedSearchAsync("Key", "desc", "fake", 0, 10, CancellationToken);
Assert.True(found.Count > 0);
Assert.NotEmpty(found.Itemz);
Assert.True(1 == found.Itemz.Count());
Assert.Equal("fakefakef", found.Itemz.First()[0]);
}
}
catch (Exception)
{
throw;
}
}
public async Task CalculateHashesInfo()
{
try
{
// Run the test against one instance of the context
using (var context = new BloggingContext(Setup.DbOpts))
{
var repository = new AspNetCore.ExistingDb.Repositories.HashesRepository(context, Setup.Conf, Setup.Cache, Setup.Logger, Setup.ServerTiming);
int count = 100;
var tasks = new List <Task>(count + 1);
for (int i = 0; i < count; i++)
{
tasks.Add(repository.AddRangeAsync(new[] {
new ThinHashes
{
Key = $"alamakota_{i}",
HashMD5 = $"dc246bcdd6cb3548579770a034d2e678_{i}",
HashSHA256 = $"63b347973bb99fed9277b33cb4646b205e9a31331acfa574add3d2351f445e43_{i}"
},
new ThinHashes
{
Key = $"bakebakeb_{i}",
HashMD5 = $"bakebakebakebakebakebakebakebake_{i}",
HashSHA256 = $"bakebakebakebakebakebakebakebakebakebakebakebakebakebakebakebake_{i}"
},
new ThinHashes
{
Key = $"cakecakec_{i}",
HashMD5 = $"cakecakecakecakecakecakecakecake_{i}",
HashSHA256 = $"cakecakecakecakecakecakecakecakecakecakecakecakecakecakecakecake_{i}"
},
}));
}
Task.WaitAll(tasks.ToArray());
await repository.SaveAsync();
}
using (var context = new BloggingContext(Setup.DbOpts))
{
var repository = new AspNetCore.ExistingDb.Repositories.HashesRepository(context, Setup.Conf, Setup.Cache, Setup.Logger, Setup.ServerTiming);
var factory = new LoggerFactory();
var logger = factory.CreateLogger <HashesRepository>();
var expected = await repository.CurrentHashesInfo;
Assert.Null(expected);
var res0 = await repository.CalculateHashesInfo(logger, Setup.DbOpts);
Assert.NotNull(res0);
var res1 = await repository.CalculateHashesInfo(logger, Setup.DbOpts);
Assert.NotNull(res1);
Assert.Same(res0, res1);
Assert.Equal("abc", res0.Alphabet);
Assert.Equal(300, res0.Count);
Assert.False(res0.IsCalculating);
Assert.Equal(12, res0.KeyLength);
expected = await repository.CurrentHashesInfo;
Assert.NotNull(expected);
Assert.Equal(res1.ID, expected.ID);
Assert.Equal(res1.Alphabet, expected.Alphabet);
Assert.Equal(res1.Count, expected.Count);
Assert.Equal(res1.IsCalculating, expected.IsCalculating);
Assert.Equal(res1.KeyLength, expected.KeyLength);
Assert.Equal(res1.ToString(), expected.ToString());
}
}
catch (Exception)
{
throw;
}
}
public async Task Paging_lots_of_elements(int itemsCount)
{
try
{
// Run the test against one instance of the context
using (var context = new BloggingContext(Setup.DbOpts))
{
var repository = new AspNetCore.ExistingDb.Repositories.HashesRepository(context, Setup.Conf, Setup.Cache, Setup.Logger, Setup.ServerTiming);
var tasks = new List <Task>(itemsCount + 1);
for (int i = 0; i < itemsCount; i++)
{
tasks.Add(repository.AddRangeAsync(new[] {
new ThinHashes
{
Key = $"alamakota_{i}",
HashMD5 = $"dc246bcdd6cb3548579770a034d2e678_{i}",
HashSHA256 = $"63b347973bb99fed9277b33cb4646b205e9a31331acfa574add3d2351f445e43_{i}"
},
new ThinHashes
{
Key = $"fakefakef_{i}",
HashMD5 = $"fakefakefakefakefakefakefakefake_{i}",
HashSHA256 = $"fakefakefakefakefakefakefakefakefakefakefakefakefakefakefakefake_{i}"
}
}));
}
Task.WaitAll(tasks.ToArray());
await repository.SaveAsync();
}
using (var context = new BloggingContext(Setup.DbOpts))
{
var repository = new AspNetCore.ExistingDb.Repositories.HashesRepository(context, Setup.Conf, Setup.Cache, Setup.Logger, Setup.ServerTiming);
var found = await repository.PagedSearchAsync("Key", "asc", "fake", 2, 10, CancellationToken);
Assert.True(found.Count > 0);
Assert.NotEmpty(found.Itemz);
Assert.Equal(found.Count, itemsCount);
Assert.Equal(10, found.Itemz.Count());
Assert.Equal("fakefakef_10", found.Itemz.First()[0]);
Assert.Equal("fakefakefakefakefakefakefakefakefakefakefakefakefakefakefakefake_10", found.Itemz.First()[2]);
}
}
catch (Exception)
{
throw;
}
finally
{
Setup.Conn.Dispose();
}
//2nd run
var db = SetupInMemoryDB();
db.Wait();
Setup = db.Result;
try
{
// Run the test against one instance of the context
using (var context = new BloggingContext(Setup.DbOpts))
{
var repository = new AspNetCore.ExistingDb.Repositories.HashesRepository(context, Setup.Conf, Setup.Cache, Setup.Logger, Setup.ServerTiming);
var tasks = new List <Task>(itemsCount + 1);
for (int i = 0; i < itemsCount; i++)
{
tasks.Add(repository.AddRangeAsync(new[] {
new ThinHashes
{
Key = $"alamakota_{i}",
HashMD5 = $"dc246bcdd6cb3548579770a034d2e678_{i}",
HashSHA256 = $"63b347973bb99fed9277b33cb4646b205e9a31331acfa574add3d2351f445e43_{i}"
},
new ThinHashes
{
Key = $"fakefakef_{i}",
HashMD5 = $"fakefakefakefakefakefakefakefake_{i}",
HashSHA256 = $"fakefakefakefakefakefakefakefakefakefakefakefakefakefakefakefake_{i}"
}
}));
}
Task.WaitAll(tasks.ToArray());
await repository.SaveAsync();
}
using (var context = new BloggingContext(Setup.DbOpts))
{
var repository = new AspNetCore.ExistingDb.Repositories.HashesRepository(context, Setup.Conf, Setup.Cache, Setup.Logger, Setup.ServerTiming);
var found = await repository.PagedSearchAsync("Key", "asc", "63b347973bb99f", 2, 10, CancellationToken);
Assert.True(found.Count > 0);
Assert.NotEmpty(found.Itemz);
Assert.Equal(found.Count, itemsCount);
Assert.Equal(10, found.Itemz.Count());
Assert.Equal("alamakota_10", found.Itemz.First()[0]);
Assert.Equal("63b347973bb99fed9277b33cb4646b205e9a31331acfa574add3d2351f445e43_10", found.Itemz.First()[2]);
}
}
catch (Exception)
{
throw;
}
}