public void NotOrTest()
{
KiiBucket bucket = KiiUser.CurrentUser.Bucket("my_bucket");
KiiObject obj1 = bucket.NewKiiObject();
obj1["name"] = "foo";
obj1.Save();
KiiObject obj2 = bucket.NewKiiObject();
obj2["name"] = "bar";
obj2.Save();
KiiObject obj3 = bucket.NewKiiObject();
obj3["name"] = "hoge";
obj3.Save();
KiiQuery query = new KiiQuery(KiiClause.Not(KiiClause.Or(KiiClause.Equals("name", "foo"), KiiClause.Equals("name", "bar"))));
query.SortByAsc("name");
KiiQueryResult <KiiObject> results = bucket.Query(query);
Assert.AreEqual(1, results.Count);
Assert.AreEqual("hoge", results[0].GetString("name"));
}
public void Test_0101_Or_1()
{
KiiClause c = KiiClause.Or(
KiiClause.Equals("name", "kii")
);
Assert.AreEqual("{\"type\":\"eq\",\"field\":\"name\",\"value\":\"kii\"}", c.ToJson().ToString());
}
public void Test_0111_Or_null()
{
KiiClause.Or(
KiiClause.Equals("name", "kii"),
null,
KiiClause.GreaterThan("score", 100),
null
);
}
public void Test_2_5_CountWithOrQuery()
{
MockHttpClientFactory factory = new MockHttpClientFactory();
Kii.HttpClientFactory = factory;
// set response
MockHttpClient client = factory.Client;
client.AddResponse(200, "{\"aggregations\" : { \"count_field\" : 5 } }");
string bucketName = "TestBucket";
KiiBucket bucket = Kii.Bucket(bucketName);
KiiClause clause1 = KiiClause.Equals("key1", "value1");
KiiClause clause2 = KiiClause.Equals("key2", "value2");
KiiClause clause = KiiClause.Or(clause1, clause2);
KiiQuery query = new KiiQuery(clause);
int count = bucket.Count(query);
Assert.AreEqual(5, count);
// check request.
Console.WriteLine(client.RequestBody[0]);
string url = Utils.Path(ConstantValues.DEFAULT_BASE_URL, "apps", "appId", "buckets", "TestBucket", "query");
Assert.AreEqual(url, client.RequestUrl[0]);
Assert.AreEqual(KiiHttpMethod.POST, client.RequestMethod[0]);
MockHttpHeaderList headerList = client.RequestHeader[0];
Assert.AreEqual("appId", headerList["X-Kii-AppID"]);
Assert.AreEqual("appKey", headerList["X-Kii-AppKey"]);
String queryStr = "{ " +
"\"bucketQuery\" : {" +
"\"clause\" : {" +
"\"type\" : \"or\"," +
"\"clauses\" :[ {" +
"\"type\" : \"eq\"," +
"\"field\" : \"key1\"," +
"\"value\" : \"value1\"" +
"}," +
"{" +
"\"type\" : \"eq\"," +
"\"field\" : \"key2\"," +
"\"value\" : \"value2\"" +
"}]" +
"}," +
"\"aggregations\" : [ {" +
"\"type\" : \"COUNT\"," +
"\"putAggregationInto\" : \"count_field\"" +
"}]" +
"}" +
"}";
JsonObject expectedBodyJson = new JsonObject(queryStr);
JsonObject actualBodyJson = new JsonObject(client.RequestBody[0]);
KiiAssertion.AssertJson(expectedBodyJson, actualBodyJson);
}
public void Test_0100_Or()
{
KiiClause c = KiiClause.Or(
KiiClause.Equals("name", "kii"),
KiiClause.GreaterThan("score", 100)
);
Assert.AreEqual("{\"type\":\"or\",\"clauses\":[" +
"{\"type\":\"eq\",\"field\":\"name\",\"value\":\"kii\"}," +
"{\"type\":\"range\",\"field\":\"score\",\"lowerLimit\":100,\"lowerIncluded\":false}]}", c.ToJson().ToString());
}
public void Test_0102_Or_0()
{
KiiClause.Or();
}
