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