public void Get_All_With_Id() { var content = CreateTestData(3).ToArray(); var provider = new PetaPocoUnitOfWorkProvider(Logger); var unitOfWork = provider.GetUnitOfWork(); using (var repo = new PublicAccessRepository(unitOfWork, CacheHelper, Logger, SqlSyntax)) { var entry1 = new PublicAccessEntry(content[0], content[1], content[2], new[] { new PublicAccessRule { RuleValue = "test", RuleType = "RoleName" }, }); repo.AddOrUpdate(entry1); var entry2 = new PublicAccessEntry(content[1], content[0], content[2], new[] { new PublicAccessRule { RuleValue = "test", RuleType = "RoleName" }, }); repo.AddOrUpdate(entry2); unitOfWork.Commit(); var found = repo.GetAll(entry1.Key).ToArray(); Assert.AreEqual(1, found.Count()); } }
public void Get_All() { var content = CreateTestData(30).ToArray(); var provider = new PetaPocoUnitOfWorkProvider(Logger); var unitOfWork = provider.GetUnitOfWork(); using (var repo = new PublicAccessRepository(unitOfWork, CacheHelper, Logger, SqlSyntax)) { var allEntries = new List <PublicAccessEntry>(); for (int i = 0; i < 10; i++) { var rules = new List <PublicAccessRule>(); for (int j = 0; j < 50; j++) { rules.Add(new PublicAccessRule { RuleValue = "test" + j, RuleType = "RoleName" + j }); } var entry1 = new PublicAccessEntry(content[i], content[i + 1], content[i + 2], rules); repo.AddOrUpdate(entry1); unitOfWork.Commit(); allEntries.Add(entry1); } //now remove a few rules from a few of the items and then add some more, this will put things 'out of order' which //we need to verify our sort order is working for the relator for (int i = 0; i < allEntries.Count; i++) { //all the even ones if (i % 2 == 0) { var rules = allEntries[i].Rules.ToArray(); for (int j = 0; j < rules.Length; j++) { //all the even ones if (j % 2 == 0) { allEntries[i].RemoveRule(rules[j]); } } allEntries[i].AddRule("newrule" + i, "newrule" + i); repo.AddOrUpdate(allEntries[i]); unitOfWork.Commit(); } } var found = repo.GetAll().ToArray(); Assert.AreEqual(10, found.Length); foreach (var publicAccessEntry in found) { var matched = allEntries.First(x => x.Key == publicAccessEntry.Key); Assert.AreEqual(matched.Rules.Count(), publicAccessEntry.Rules.Count()); } } }
public void Can_Delete() { var content = CreateTestData(3).ToArray(); var provider = new PetaPocoUnitOfWorkProvider(Logger); var unitOfWork = provider.GetUnitOfWork(); using (var repo = new PublicAccessRepository(unitOfWork, CacheHelper, Logger, SqlSyntax)) { var entry = new PublicAccessEntry(content[0], content[1], content[2], new[] { new PublicAccessRule { RuleValue = "test", RuleType = "RoleName" }, }); repo.AddOrUpdate(entry); unitOfWork.Commit(); repo.Delete(entry); unitOfWork.Commit(); entry = repo.Get(entry.Key); Assert.IsNull(entry); } }
public void Can_Add() { var content = CreateTestData(3).ToArray(); var provider = new PetaPocoUnitOfWorkProvider(Logger); var unitOfWork = provider.GetUnitOfWork(); using (var repo = new PublicAccessRepository(unitOfWork, CacheHelper, Logger, SqlSyntax)) { var entry = new PublicAccessEntry(content[0], content[1], content[2], new[] { new PublicAccessRule { RuleValue = "test", RuleType = "RoleName" }, }); repo.AddOrUpdate(entry); unitOfWork.Commit(); var found = repo.GetAll().ToArray(); Assert.AreEqual(1, found.Count()); Assert.AreEqual(content[0].Id, found[0].ProtectedNodeId); Assert.AreEqual(content[1].Id, found[0].LoginNodeId); Assert.AreEqual(content[2].Id, found[0].NoAccessNodeId); Assert.IsTrue(found[0].HasIdentity); Assert.AreNotEqual(default(DateTime), found[0].CreateDate); Assert.AreNotEqual(default(DateTime), found[0].UpdateDate); Assert.AreEqual(1, found[0].Rules.Count()); Assert.AreEqual("test", found[0].Rules.First().RuleValue); Assert.AreEqual("RoleName", found[0].Rules.First().RuleType); Assert.AreNotEqual(default(DateTime), found[0].Rules.First().CreateDate); Assert.AreNotEqual(default(DateTime), found[0].Rules.First().UpdateDate); Assert.IsTrue(found[0].Rules.First().HasIdentity); } }