public void CRUD_One_Hyperlink_And_Fetch_Runs_Successfully()
{
var connectionManager = new ConnectionManager(DbFile.GetConnectionString("testdb.db"));
var repository = new HyperlinkRepository(connectionManager);
var entry = new Hyperlink
{
Title = "New Hyperlink",
Url = "http://www.msn.com"
};
repository.InsertOne(entry);
var insertedEntity = repository.GetOne(1);
Assert.IsNotNull(entry);
insertedEntity.Title = "Modified Hyperlink";
repository.UpdateOne(insertedEntity);
var updatedEntity = repository.GetOne(1);
Assert.That(updatedEntity.Title, Is.EqualTo("Modified Hyperlink"));
repository.DeleteOne(updatedEntity);
var deletedEntity = repository.GetOne(insertedEntity.Id);
Assert.IsNull(deletedEntity);
}
public void CRUD_One_Attachment_And_Fetch_Runs_Successfully()
{
var connectionManager = new ConnectionManager(DbFile.GetConnectionString("testdb.db"));
var repository = new AttachmentRepository(connectionManager);
var entry = new Attachment
{
FileName = "filename.pdf",
Description = "New Attachment",
Extension = "pdf"
};
repository.InsertOne(entry);
var insertedEntity = repository.GetOne(1);
Assert.IsNotNull(entry);
insertedEntity.Description = "Modified Attachment";
repository.UpdateOne(insertedEntity);
var updatedEntity = repository.GetOne(1);
Assert.That(updatedEntity.Description, Is.EqualTo("Modified Attachment"));
repository.DeleteOne(updatedEntity);
var deletedEntity = repository.GetOne(insertedEntity.Id);
Assert.IsNull(deletedEntity);
}
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 SetupTest()
{
var databaseOperations =
new DatabaseOperationsRepository(DbFile.GetConnectionString("testdb.db"));
databaseOperations.CreateAndInitialize(DbFile.GetPath("testdb.db"), TxtFile.ReadText("RebuildDatabase.txt"));
}
public void CRUD_One_Snippet_And_Fetch_Runs_Successfully()
{
var connectionManager = new ConnectionManager(DbFile.GetConnectionString("testdb.db"));
var repository = new SnippetRepository(connectionManager);
var entry = new Snippet
{
Title = "New Hyperlink",
Content = "Here is some content for you.",
SyntaxHighlightId = 1
};
repository.InsertOne(entry);
var insertedEntity = repository.GetOne(1);
Assert.IsNotNull(entry);
insertedEntity.Title = "Modified Snippet";
repository.UpdateOne(insertedEntity);
var updatedEntity = repository.GetOne(1);
Assert.That(updatedEntity.Title, Is.EqualTo("Modified Snippet"));
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));
}