public void TestPersistenceServiceFindById_Dictionary()
{
List <Dictionary <String, Object> > listPerson = new List <Dictionary <String, Object> >();
Dictionary <String, Object> person = new Dictionary <String, Object>();
person["age"] = 15;
person["name"] = "Alexandra";
List <String> listId = new List <String>();
listPerson.Add(person);
listId = (List <String>)Backendless.Data.Of("Person").Create(listPerson);
person["objectId"] = listId[0];
DataQueryBuilder queryBuilder = DataQueryBuilder.Create();
queryBuilder.AddProperties("age");
Dictionary <String, Object> result = Backendless.Data.Of("Person").FindById(person, queryBuilder);
Assert.IsNotNull(result);
Assert.AreEqual(result["objectId"], listId[0], "Object id were not equivalent");
Assert.IsFalse(result.ContainsKey("name"));
Assert.IsTrue(result.ContainsKey("age"));
Backendless.Data.Of("Person").Remove("age = '15'");
}
public void TestPersistenceServiceFindById_StringId_Async()
{
List <Dictionary <String, Object> > listPerson = new List <Dictionary <String, Object> >();
Dictionary <String, Object> person = new Dictionary <String, Object>();
person["age"] = 15;
person["name"] = "Alexandra";
List <String> listId = new List <String>();
listPerson.Add(person);
listId = (List <String>)Backendless.Data.Of("Person").Create(listPerson);
DataQueryBuilder queryBuilder = DataQueryBuilder.Create();
queryBuilder.AddProperties("age");
Backendless.Data.Of("Person").FindById(listId[0], queryBuilder, new AsyncCallback <Dictionary <String, Object> >(
callback =>
{
Assert.IsNotNull(callback);
Assert.AreEqual(callback["objectId"], listId[0], "Object id were not equivalent");
Assert.IsFalse(callback.ContainsKey("name"));
Assert.IsTrue(callback.ContainsKey("age"));
},
fault =>
{
throw new ArgumentException("Error");
}));
Backendless.Data.Of("Person").Remove("age = '15'");
}
public void TestRelatedField()
{
DataQueryBuilder queryBuilder = DataQueryBuilder.Create();
queryBuilder.AddProperties("*", "Location.adress");
IList <Dictionary <String, Object> > res = Backendless.Data.Of("Person").Find(queryBuilder);
Assert.IsTrue(res[0].ContainsKey("adress"), "First object does not contain 'adress' field");
Assert.IsTrue(res[1].ContainsKey("adress"), "Second object does not contain 'adress' field");
}
public void TestCreateFieldTIME()
{
DataQueryBuilder queryBuilder = DataQueryBuilder.Create();
queryBuilder.AddProperties("*", "TIME(created) as myTime");
IList <Dictionary <String, Object> > res = Backendless.Data.Of("Person").Find(queryBuilder);
Assert.IsTrue(res[0].ContainsKey("myTime"), "First object does not contain 'myTime' key");
Assert.IsTrue(res[1].ContainsKey("myTime"), "Second object does not contain 'myTime' key");
}
public void TestExcludeTwoFields()
{
DataQueryBuilder queryBuilder = DataQueryBuilder.Create();
queryBuilder.AddProperties("*");
queryBuilder.ExcludeProperties("name", "age");
IList <Dictionary <String, Object> > res = Backendless.Data.Of("Person").Find(queryBuilder);
Assert.IsFalse(res[0].ContainsKey("name"), "First object is contains key 'name'");
Assert.IsFalse(res[0].ContainsKey("age"), "First object is contains key 'age'");
Assert.IsFalse(res[1].ContainsKey("name"), "First object is contains key 'name'");
Assert.IsFalse(res[1].ContainsKey("age"), "First object is contains key 'age'");
}
public void JN4()
{
Dictionary <String, Object> map = CreateDefaultJson();
DataQueryBuilder queryBuilder = DataQueryBuilder.Create();
queryBuilder.AddProperties("json->'$.timeMarks.time' as time");
var newMap = Backendless.Data.Of("Table1").Find(queryBuilder)[0];
Assert.IsTrue(newMap != null && newMap != new Dictionary <String, Object>());
Assert.IsTrue(newMap.Keys.Count == 3);
Assert.IsTrue(newMap.Keys.Contains("objectId"));
Assert.IsTrue(newMap.Keys.Contains("___class"));
Assert.IsTrue(newMap.Keys.Contains("time"));
Assert.IsTrue(newMap["time"] != null);
Backendless.Data.Of("Table1").Remove(newMap);
}