private void InsertPeople() { QueryTests.Insert(new Person { Age = 25, Name = "jane" }); QueryTests.Insert(new Person { Age = 60, Name = "deb" }); QueryTests.Insert(new Person { Age = 63, Name = "bob" }); QueryTests.Insert(new Person { Age = 74, Name = "alicia" }); QueryTests.Insert(new Person { Age = 34, Name = "joe" }); QueryTests.Insert(new Person { Age = 29, Name = "deb" }); QueryTests.Insert(new Person { Age = 21, Name = "carl" }); QueryTests.Insert(new Person { Age = 45, Name = "betty" }); }
public void LinqContains() { QueryTests.Insert(new House { Description = "this is a nice house" }); QueryTests.Insert(new House { Description = "not it is not" }); Console.WriteLine("houses with nice in description:"); QueryTests.AsQueryable <House>() .Where(h => h.Description.Contains("nice")) .ToList() .ForEach(h => Console.WriteLine(h.Description)); }
public void testSQLQueryFormatter100() { Query q = new Query(StudentDTD.STUDENTPERSONAL); q.AddCondition("Name/FirstName", ComparisonOperators.LE, "Sally"); // Convert the query to XML and back Query reparsed = QueryTests.SaveToXMLAndReparse(q, SifVersion.LATEST); IDictionary fields = new Hashtable(); fields["Name/FirstName"] = new SQLField("Users.FName", DbType.String); SQLQueryFormatter formatter = new SQLQueryFormatter(); String sql = formatter.Format(reparsed, fields); Assert.AreEqual("( Users.FName <= 'Sally' )", sql, "Query format"); }
public void testSQLQueryFormatter050() { Query q = new Query(StudentDTD.STUDENTPERSONAL); q.AddCondition("Demographics/RaceList/Race/Code", ComparisonOperators.EQ, "1002"); // Convert the query to XML and back Query reparsed = QueryTests.SaveToXMLAndReparse(q, SifVersion.LATEST); IDictionary fields = new Hashtable(); fields["Demographics/RaceList/Race/Code"] = new SQLField("Users.vchFirstName{0998=I;0999=A;1000=B;1001=H;1002=W}", DbType.String); SQLQueryFormatter formatter = new SQLQueryFormatter(); String sql = formatter.Format(reparsed, fields); Assert.AreEqual("( Users.vchFirstName = 'W' )", sql, "Query format"); }
public void Evaluation() { // find all people in their 80s Console.WriteLine(Query.Mod("age", 10, 8)); // find all people who have a first name starting with A Console.WriteLine(Query.Matches("name", new Regex("^[aA]"))); // arbitrary javascript, slow! use in conjunction with non where queries that hit an index or really narrow down documents first var where = Query.Where("this.age === 1"); Console.WriteLine(where); Console.WriteLine("where matches:"); QueryTests.Insert(new BsonDocument { { "age", 2 } }); QueryTests.Insert(new BsonDocument { { "age", 1 } }); QueryTests.Find(where) .ToList() .ForEach(Console.WriteLine); }
//[Route("")] public async Task <QueryTestsResponse> QueryTests() { var query = new QueryTests(Request.GetQueryOptions()); return(await _queryProcessor.ProcessQuery <QueryTests, QueryTestsResponse>(query)); }
private void PrintResults(AggregateArgs matchAndSort) { QueryTests.Aggregate(matchAndSort) .ToList() .ForEach(Console.WriteLine); }