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); } }