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);
}
}
}
public async Task UpdateLetterTest(int value)
{
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);
}
LetterModel letterModel = new LetterModel()
{
Receivers = new List <ReceiverModel>(), SentStatus = true, SentDate = DateTime.Today, TemplateId = 1
};
using (var context = new LetterDbContext(options))
{
LettersCommands lettersCommands = null;
Letter letterUpdated = null;
try
{
lettersCommands = this.GetStorageCommand(context);
await lettersCommands.UpdateAsync(value, letterModel);
letterUpdated = context.Letters.SingleOrDefault(let => let.Id == value);
if (letterUpdated == null)
{
Assert.Null(letterUpdated);
return;
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
Assert.True(letterUpdated.SentStatus == letterModel.SentStatus);
Assert.True(letterUpdated.SentDate == letterModel.SentDate);
}
}
public async Task DeleteLetterTest(int value)
{
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))
{
LettersCommands lettersCommands = null;
Letter letterCreated = null;
try
{
lettersCommands = this.GetStorageCommand(context);
await lettersCommands.DeleteAsync(value);
letterCreated = context.Letters.SingleOrDefault(let => let.Id == value);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
Assert.Null(letterCreated);
}
}
