public async Task GetOneTest(int id)
{
var connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
var options = new DbContextOptionsBuilder <LetterDbContext>()
.UseSqlite(connection)
.Options;
using (var context = new LetterDbContext(options))
{
context.Database.EnsureCreated();
LetterDbContextInitializer.Initialize(context);
}
using (var context = new LetterDbContext(options))
{
LettersQueries lettersQueries = GetLettersQueries(context);
var result = await lettersQueries.GetOneAsync(id);
if (result == null)
{
Assert.Null(result);
}
else
{
Assert.True(result.LetterID > 0);
Assert.True(id.Equals(result.LetterID));
}
}
}
public async Task GetByConsumerTests()
{
var connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
var options = new DbContextOptionsBuilder <LetterDbContext>()
.UseSqlite(connection)
.Options;
using (var context = new LetterDbContext(options))
{
context.Database.EnsureCreated();
LetterDbContextInitializer.Initialize(context);
}
using (var context = new LetterDbContext(options))
{
LettersQueries lettersQueries = GetLettersQueries(context);
var result = await lettersQueries.GetByTenantAsync(Guid.NewGuid());
if (result == null)
{
Assert.Null(result);
}
else
{
Assert.NotNull(result);
Assert.True(result.Count > 0);
}
}
}