public void CRUD_One_DiaryEntry_And_Fetch_Runs_Successfully() { var connectionManager = new ConnectionManager(DbFile.GetConnectionString("testdb.db")); var repository = new DiaryEntryRepository(connectionManager); var dateCreated = DateTime.Parse("2017/03/12 13:12:21"); var entry = new DiaryEntry { Title = "New DiaryEntry", DateCreated = dateCreated.Ticks }; repository.InsertOne(entry); var insertedEntity = repository.GetOne(1); Assert.IsNotNull(entry); Assert.That(entry.Title, Is.EqualTo("New DiaryEntry")); Assert.That(new DateTime(entry.DateCreated), Is.EqualTo(dateCreated)); insertedEntity.Title = "Modified DiaryEntry"; repository.UpdateOne(insertedEntity); var updatedEntity = repository.GetOne(1); Assert.That(updatedEntity.Title, Is.EqualTo("Modified DiaryEntry")); repository.DeleteOne(updatedEntity); var deletedEntity = repository.GetOne(insertedEntity.Id); Assert.IsNull(deletedEntity); }
public void Find_DiaryEntry_By_TitlePart() { var connectionManager = new ConnectionManager(DbFile.GetConnectionString("testdb.db")); var diaryEntryRepository = new DiaryEntryRepository(connectionManager); diaryEntryRepository.InsertOne(new DiaryEntry { DateCreated = DateTime.Parse("2017/03/12 13:12:21").Ticks, Title = "Diary Entry 1" }); diaryEntryRepository.InsertOne(new DiaryEntry { DateCreated = DateTime.Parse("2017/03/15 08:01:59").Ticks, Title = "Diary Entry 2" }); var findCriteria = new DiaryEntryFindCriteria("Entry 1"); IEnumerable <DiaryEntry> foundEntries = diaryEntryRepository.Find(findCriteria); Assert.That(foundEntries.Count(), Is.EqualTo(1)); }