public void NotRangeTest()
{
KiiBucket bucket = KiiUser.CurrentUser.Bucket("my_bucket");
KiiObject obj1 = bucket.NewKiiObject();
obj1["name"] = "foo";
obj1["age"] = 20;
obj1.Save();
KiiObject obj2 = bucket.NewKiiObject();
obj2["name"] = "bar";
obj2["age"] = 33;
obj2.Save();
KiiObject obj3 = bucket.NewKiiObject();
obj3["name"] = "hoge";
obj3["age"] = 38;
obj3.Save();
KiiQuery query = new KiiQuery(KiiClause.Not(KiiClause.GreaterThan("age", 30)));
query.SortByAsc("name");
KiiQueryResult <KiiObject> results = bucket.Query(query);
Assert.AreEqual(1, results.Count);
Assert.AreEqual("foo", results[0].GetString("name"));
}
public void Test_0011_And_null()
{
KiiClause.And(
KiiClause.Equals("name", "kii"),
null,
KiiClause.GreaterThan("score", 100),
null
);
}
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_0010_And_array()
{
KiiClause[] arr = new KiiClause[] {
KiiClause.Equals("name", "kii"),
KiiClause.GreaterThan("score", 100)
};
KiiClause c = KiiClause.And(arr);
Assert.AreEqual("{\"type\":\"and\",\"clauses\":[" +
"{\"type\":\"eq\",\"field\":\"name\",\"value\":\"kii\"}," +
"{\"type\":\"range\",\"field\":\"score\",\"lowerLimit\":100,\"lowerIncluded\":false}]}", c.ToJson().ToString());
}
public void Test_0251_GreaterThan_value_null()
{
KiiClause c = KiiClause.GreaterThan("name", null);
Assert.AreEqual("{\"type\":\"range\",\"field\":\"name\",\"lowerIncluded\":false}", c.ToJson().ToString());
}
public void Test_0250_GreaterThan_key_empty()
{
KiiClause.GreaterThan("", "kii");
}
public void Test_0250_GreaterThan_key_null()
{
KiiClause.GreaterThan(null, "kii");
}
public void Test_0240_GreaterThan_string()
{
KiiClause c = KiiClause.GreaterThan("name", "kii");
Assert.AreEqual("{\"type\":\"range\",\"field\":\"name\",\"lowerLimit\":\"kii\",\"lowerIncluded\":false}", c.ToJson().ToString());
}
public void Test_0230_GreaterThan_bool_true()
{
KiiClause.GreaterThan("enable", true);
}
public void Test_0220_GreaterThan_double()
{
KiiClause c = KiiClause.GreaterThan("score", 1.234);
Assert.AreEqual("{\"type\":\"range\",\"field\":\"score\",\"lowerLimit\":1.234,\"lowerIncluded\":false}", c.ToJson().ToString());
}
public void Test_0210_GreaterThan_long()
{
KiiClause c = KiiClause.GreaterThan("score", (long)1234567890123);
Assert.AreEqual("{\"type\":\"range\",\"field\":\"score\",\"lowerLimit\":1234567890123,\"lowerIncluded\":false}", c.ToJson().ToString());
}
