public void TestSmartQueryWithSpecialFields() { var christineJson = Store.Query(QuerySpec.BuildExactQuerySpec(EMPLOYEES_SOUP, "employeeId", "00010", 1), 0)[0] as JObject; Assert.AreEqual("Christine", christineJson.GetValue(FIRST_NAME), "Wrong elt"); JArray result = Store.Query( QuerySpec.BuildSmartQuerySpec( "select {employees:_soup}, {employees:_soupEntryId}, {employees:_soupLastModifiedDate}, {employees:salary} from {employees} where {employees:lastName} = 'Haas'", 1), 0); Assert.AreEqual(1, result.Count, "Expected one row"); Assert.AreEqual(christineJson.ToString(), result[0][0].ToString(), "Wrong soup"); Assert.AreEqual(christineJson.GetValue(SoupEntryId), result[0][1], "Wrong soupEntryId"); Assert.AreEqual(christineJson.GetValue(SoupLastModifiedDate), result[0][2], "Wrong soupLastModifiedDate"); }
public void TestSmartQueryReturningSoupStringAndInteger() { JArray query = Store.Query(QuerySpec.BuildExactQuerySpec(EMPLOYEES_SOUP, "employeeId", "00010", 1), 0); var christineJson = query[0] as JObject; Assert.AreEqual("Christine", christineJson.GetValue(FIRST_NAME).ToString(), "Wrong elt"); JArray result = Store.Query( QuerySpec.BuildSmartQuerySpec( "select {employees:_soup}, {employees:firstName}, {employees:salary} from {employees} where {employees:lastName} = 'Haas'", 1), 0); Assert.AreEqual(1, result.Count(), "Expected one row"); Assert.AreEqual(christineJson.ToString(), result[0][0].ToString(), "Wrong soup"); Assert.AreEqual("Christine", result[0][1].ToString(), "Wrong first name"); Assert.AreEqual(200000, (int)(result[0][2]), "Wrong salary"); }