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