public void Find_UsingWhereWithAnd_ReturnsOnePerson() { using (var session = TestHelper.CreateSession()) { var entityStore = new SimoEntityStore(session, DbName); var persons = entityStore.Query<Person>(q => q.Where(@"this.Name == 'Daniel' && this.Age == 21")); Assert.AreEqual(1, persons.Count); Assert.AreEqual(1, persons.Where(p => p.Name == "Daniel").Count()); } }
public void Find_UsingWhereWithOr_ReturnsThreePersons() { using (var session = TestHelper.CreateSession()) { var entityStore = new SimoEntityStore(session, DbName); var persons = entityStore.Query<Person>(q => q.Where(@"this.Name == 'Daniel' || this.Name == 'Sue'")); Assert.AreEqual(6, persons.Count); Assert.AreEqual(3, persons.Where(p => p.Name == "Daniel").Count()); Assert.AreEqual(3, persons.Where(p => p.Name == "Sue").Count()); } }
public void QueryFor_UsingAllQueryWithInts_ReturnsThreePersons() { using (var session = TestHelper.CreateSession()) { var entityStore = new SimoEntityStore(session, DbName); var persons = entityStore.Query<Person>(q => q["TimeCodes"].HasAll(100, 200)); Assert.AreEqual(3, persons.Count); Assert.AreEqual(1, persons.Where(p => p.Name == "Daniel").Count()); Assert.AreEqual(1, persons.Where(p => p.Name == "Adam").Count()); Assert.AreEqual(1, persons.Where(p => p.Name == "Sue").Count()); } }
public void QueryFor_IntervalUsingQueryLtAndGt_ReturnsThreePersons() { using (var session = TestHelper.CreateSession()) { var entityStore = new SimoEntityStore(session, DbName); var persons = entityStore.Query<Person>(q => q["Age"].Gt(21).Lt(29)); Assert.AreEqual(3, persons.Count); Assert.AreEqual(1, persons.Where(p => p.Name == "Daniel").Count()); Assert.AreEqual(1, persons.Where(p => p.Name == "Adam").Count()); Assert.AreEqual(1, persons.Where(p => p.Name == "Sue").Count()); } }
public void QueryFor_UsingBetweenQuery_ReturnsThreePersons() { using (var session = TestHelper.CreateSession()) { var entityStore = new SimoEntityStore(session, DbName); var persons = entityStore.Query<Person>(q => q["Age"].Between(22, 28)); Assert.AreEqual(3, persons.Count); Assert.AreEqual(1, persons.Where(p => p.Name == "Daniel").Count()); Assert.AreEqual(1, persons.Where(p => p.Name == "Adam").Count()); Assert.AreEqual(1, persons.Where(p => p.Name == "Sue").Count()); } }
public void QueryFor_UsingSizeQueryOnArrayWithStrings_ReturnsThreePersons() { using (var session = TestHelper.CreateSession()) { var entityStore = new SimoEntityStore(session, DbName); var persons = entityStore.Query<Person>(q => q["Tags"].Size(2)); Assert.AreEqual(3, persons.Count); Assert.AreEqual(1, persons.Where(p => p.Name == "Daniel").Count()); Assert.AreEqual(1, persons.Where(p => p.Name == "Adam").Count()); Assert.AreEqual(1, persons.Where(p => p.Name == "Sue").Count()); } }
public void QueryFor_UsingSizeQueryOnArrayWithNoStrings_ReturnsNoPersons() { using (var session = TestHelper.CreateSession()) { var entityStore = new SimoEntityStore(session, DbName); var persons = entityStore.Query<Person>(q => q["Tags"].Size(0)); Assert.AreEqual(0, persons.Count); } }
public void QueryFor_UsingNotInQuery_ReturnsOnePerson() { using (var session = TestHelper.CreateSession()) { var entityStore = new SimoEntityStore(session, DbName); var persons = entityStore.Query<Person>(q => q["Name"].NotIn("Daniel", "Sue").And("Age").NotIn(21, 23)); Assert.AreEqual(1, persons.Count); Assert.AreEqual(1, persons.Where(p => p.Name == "Adam").Count()); } }
public void QueryFor_UsingNotExistsQueryWhereMemberExists_ReturnsNoPersons() { using (var session = TestHelper.CreateSession()) { var entityStore = new SimoEntityStore(session, DbName); var persons = entityStore.Query<Person>(q => q["Tags"].NotExists()); Assert.AreEqual(3, persons.Count); } }
public void QueryFor_UsingMultipleInOnDifferentProps_ReturnsOnePerson() { using (var session = TestHelper.CreateSession()) { var entityStore = new SimoEntityStore(session, DbName); var persons = entityStore.Query<Person>(q => q["Name"].In("Daniel").And("Age").In(21)); Assert.AreEqual(1, persons.Count); } }