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");
}
