public void NotPrefixTest()
{
KiiBucket bucket = KiiUser.CurrentUser.Bucket("my_bucket");
KiiObject obj1 = bucket.NewKiiObject();
obj1["name"] = "foo";
obj1.Save();
KiiObject obj2 = bucket.NewKiiObject();
obj2["name"] = "fool";
obj2.Save();
KiiObject obj3 = bucket.NewKiiObject();
obj3["name"] = "hoge";
obj3.Save();
KiiQuery query = new KiiQuery(KiiClause.Not(KiiClause.StartsWith("name", "foo")));
query.SortByAsc("name");
KiiQueryResult <KiiObject> results = bucket.Query(query);
Assert.AreEqual(1, results.Count);
Assert.AreEqual("hoge", results[0].GetString("name"));
}
public void NotHasFieldTest()
{
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.Save();
KiiQuery query = new KiiQuery(KiiClause.Not(KiiClause.HasField("age", FieldType.INTEGER)));
query.SortByAsc("name");
KiiQueryResult <KiiObject> results = bucket.Query(query);
Assert.AreEqual(1, results.Count);
Assert.AreEqual("hoge", results[0].GetString("name"));
}
public void Test_0100_SortByAsc()
{
KiiQuery query = new KiiQuery();
query.SortByAsc("score");
Assert.AreEqual("{\"bucketQuery\":{\"clause\":{\"type\":\"all\"},\"orderBy\":\"score\",\"descending\":false}}", query.ToString());
}
public void Test_0004_GeoDistanceQuery_sort_asc()
{
KiiBucket bucket = testUser.Bucket("aBucket");
KiiObject obj1 = bucket.NewKiiObject();
KiiGeoPoint point1 = new KiiGeoPoint(35.672568, 139.723606);
obj1.SetGeoPoint("myLoc", point1);
obj1.Save();
KiiObject obj2 = bucket.NewKiiObject();
KiiGeoPoint point2 = new KiiGeoPoint(35.667983, 139.739356);
obj2.SetGeoPoint("myLoc", point2);
obj2.Save();
// not in radius
KiiObject obj3 = bucket.NewKiiObject();
KiiGeoPoint point3 = new KiiGeoPoint();
obj3.SetGeoPoint("myLoc", point3);
obj3.Save();
KiiGeoPoint center = new KiiGeoPoint(35.677379, 139.702148);
KiiClause clause = KiiClause.GeoDistance("myloc", center, 4000, "distanceToMyLoc");
KiiQuery query = new KiiQuery(clause);
query.SortByAsc("_calculated.distanceToMyLoc");
KiiQueryResult <KiiObject> result = bucket.Query(query);
Assert.AreEqual(result.Count, 2);
KiiObject retObj1 = result [0];
KiiGeoPoint retPoint1 = retObj1.GetGeoPoint("myLoc");
Assert.AreEqual(point1.Latitude, retPoint1.Latitude);
Assert.AreEqual(point1.Longitude, retPoint1.Longitude);
JsonObject jObj1 = retObj1.GetJsonObject("_calculated");
KiiObject retObj2 = result [1];
KiiGeoPoint retPoint2 = retObj2.GetGeoPoint("myLoc");
Assert.AreEqual(point2.Latitude, retPoint2.Latitude);
Assert.AreEqual(point2.Longitude, retPoint2.Longitude);
JsonObject jObj2 = retObj2.GetJsonObject("_calculated");
double retDistance1 = jObj1.GetDouble("distanceToMyLoc");
double retDistance2 = jObj2.GetDouble("distanceToMyLoc");
double expectedDistance1 = distanceInMeter(point1, center);
double expectedDistance2 = distanceInMeter(point2, center);
Assert.IsTrue(approximateEqual(expectedDistance1, retDistance1, 0.00001));
Assert.IsTrue(approximateEqual(expectedDistance2, retDistance2, 0.00001));
}
public void NotAndTest()
{
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"] = "foo";
obj2["age"] = 33;
obj2.Save();
KiiQuery query = new KiiQuery(KiiClause.Not(KiiClause.And(KiiClause.Equals("name", "foo"), KiiClause.LessThan("age", 30))));
query.SortByAsc("name");
KiiQueryResult <KiiObject> results = bucket.Query(query);
Assert.AreEqual(1, results.Count);
Assert.AreEqual(33, results[0].GetInt("age"));
}
public void NotGeoBoxTest()
{
KiiBucket bucket = KiiUser.CurrentUser.Bucket("my_bucket");
KiiObject obj1 = bucket.NewKiiObject();
obj1["name"] = "kii";
obj1.SetGeoPoint("location", new KiiGeoPoint(35.668387, 139.739495));
obj1.Save();
KiiObject obj2 = bucket.NewKiiObject();
obj2["name"] = "TDL";
obj2.SetGeoPoint("location", new KiiGeoPoint(35.633114, 139.880405));
obj2.Save();
KiiQuery query = new KiiQuery(KiiClause.Not(KiiClause.GeoBox("location", new KiiGeoPoint(35.669494, 139.741727), new KiiGeoPoint(35.660934, 139.734957))));
query.SortByAsc("name");
KiiQueryResult <KiiObject> results = bucket.Query(query);
Assert.AreEqual(1, results.Count);
Assert.AreEqual("TDL", results[0].GetString("name"));
}
public void Test_0102_SortByAsc_empty()
{
KiiQuery query = new KiiQuery();
query.SortByAsc("");
}
public void Test_0101_SortByAsc_null()
{
KiiQuery query = new KiiQuery();
query.SortByAsc(null);
}