//[TestMethod] public void SPRepository_Test_Get_ByLookupValue() { using (ClientContext context = new ClientContext(ConfigurationManager.AppSettings["SiteUrl"])) { SecureString password = Common.ToSecureString(ConfigurationManager.AppSettings["UserPassword"]); context.Credentials = new SharePointOnlineCredentials(ConfigurationManager.AppSettings["UserLogin"], password); SPClientRepository <MockTestSPEntity> repo = new SPClientRepository <MockTestSPEntity>(context); List <MockTestSPEntity> result = repo.Query(test => test.LookupTarget.Title == "Lookup 2").ToList(); Assert.AreEqual(1, result.Count); } }
//[TestMethod] public void SPRepository_Test_GetAllData() { using (ClientContext context = new ClientContext(ConfigurationManager.AppSettings["SiteUrl"])) { SecureString password = Common.ToSecureString(ConfigurationManager.AppSettings["UserPassword"]); context.Credentials = new SharePointOnlineCredentials(ConfigurationManager.AppSettings["UserLogin"], password); IEntityRepository <MockTestSPEntity> repo = new SPClientRepository <MockTestSPEntity>(context); DateTime date = DateTime.Now; List <MockTestSPEntity> result = repo.Query(test => test.ModifiedDate > date).ToList(); Assert.AreEqual(10, result.Count); } }
public void SPRepository_Test_ComposeCaml_DefaultOrderBy() { using (ClientContext context = new ClientContext(ConfigurationManager.AppSettings["SiteUrl"])) { SecureString password = Common.ToSecureString(ConfigurationManager.AppSettings["UserPassword"]); context.Credentials = new SharePointOnlineCredentials(ConfigurationManager.AppSettings["UserLogin"], password); SPClientRepository <MockSPEntity> repo = new SPClientRepository <MockSPEntity>(context); string expectedQuery = "<View><Query><Where><Eq><FieldRef Name=\"Title\" /><Value Type=\"Text\">Test</Value></Eq></Where></Query><RowLimit>10</RowLimit><ViewFields><FieldRef Name=\"ID\" /><FieldRef Name=\"Title\" /><FieldRef Name=\"Created\" /><FieldRef Name=\"TestLookup\" /></ViewFields><OrderBy><FieldRef Name=\"ID\" Ascending=\"FALSE\"/></OrderBy></View>"; string whereSection = ExpressionToCamlMapper <MockSPEntity> .MapExpressionToCaml <MockSPEntity>(me => me.Title == "Test"); string actualQuery = repo.ComposeQuery(whereSection, 10); Assert.AreEqual(expectedQuery, actualQuery); } }
//[TestMethod] public void SPRepository_Test_EntityBuffer() { using (ClientContext context = new ClientContext(ConfigurationManager.AppSettings["SiteUrl"])) { SecureString password = Common.ToSecureString(ConfigurationManager.AppSettings["UserPassword"]); context.Credentials = new SharePointOnlineCredentials(ConfigurationManager.AppSettings["UserLogin"], password); SPClientRepository <MockTestSPEntity> repo = new SPClientRepository <MockTestSPEntity>(context); EntityBuffer <MockTestSPEntity> buffer = new EntityBuffer <MockTestSPEntity>(repo, t => t.Id > 0); int counter = 0; buffer.Enumerate(delegate(MockTestSPEntity entity) { counter++; }, 3); Assert.AreEqual(10, counter); } }