public async Task Find()
{
var obj = new CB.CloudObject("Custom1");
obj.Set("newColumn", "sample");
obj.Set("description", "sample2");
await obj.SaveAsync();
var query = new CB.CloudQuery("Custom1");
query.EqualTo("id", obj.ID);
query.SelectColumn("newColumn");
var response = await query.FindAsync();
if (response.Count > 0)
{
if (((CB.CloudObject)response[0]).Get("description") == null)
{
Assert.IsTrue(true);
}
else
{
Assert.IsFalse(true);
}
}
else
{
Assert.IsFalse(true);
}
}
public async Task ascendingOrder()
{
var query = new CB.CloudQuery("student4");
query.OrderByAsc("age");
var response = (List <CB.CloudObject>) await query.FindAsync();
if (response.Count > 0)
{
int age = (int)response[0].Get("age");
for (int i = 1; i < response.Count; i++)
{
int data = (int)response[i].Get("age");
if (age > data)
{
Assert.Fail("received value greater than the required value");
}
age = data;
}
Assert.IsTrue(true);
}
else
{
Assert.IsFalse(false);
}
}
public async Task RetrieveList()
{
var obj = new CB.CloudObject("student1");
string[] list = { "java", "python" };
obj.Set("subject", list);
await obj.SaveAsync();
var query = new CB.CloudQuery("student1");
query.ContainsAll("subject", list);
var response = await query.FindAsync();
if (response.Count > 0)
{
for (int i = 0; i < response.Count; i++)
{
ArrayList subject = (ArrayList)((CB.CloudObject)response[i]).Get("subject");
for (int j = 0; j < subject.Count; j++)
{
if (subject[j].ToString() != "java" && subject[j].ToString() != "python")
{
Assert.Fail("should retrieve saved data with particular value");
}
}
}
Assert.IsTrue(true);
}
else
{
Assert.IsFalse(false);
}
}
public async Task RelationQueryTest()
{
var obj1 = new CB.CloudObject("Hostel");
obj1.Set("room", 123);
await obj1.SaveAsync();
var obj = new CB.CloudObject("student1");
obj.Set("newColumn", obj1);
await obj.SaveAsync();
var query = new CB.CloudQuery("student1");
query.NotEqualTo("newColumn", obj1);
var response = await query.FindAsync();
for (int i = 0; i < response.Count; i++)
{
if (((CB.CloudObject)response[i]).Get("newColumn") != null)
{
CB.CloudObject relObj = (CB.CloudObject)((CB.CloudObject)response[i]).Get("newColumn");
if (relObj.ID == obj1.ID)
{
Assert.Fail("Should not get the id in not equal to");
}
Assert.IsTrue(true);
}
}
}
public async Task GetEncryptedPassword()
{
string username = Util.Methods.MakeEmail();
var obj = new CB.CloudObject("User");
obj.Set("username", username);
obj.Set("password", "password");
obj.Set("email", Util.Methods.MakeEmail());
await obj.SaveAsync();
if (obj.Get("password").ToString() != "password")
{
var query = new CB.CloudQuery("User");
query.EqualTo("password", "password");
query.EqualTo("username", username);
var response = await query.FindAsync();
if (response.Count > 0)
{
Assert.IsTrue(true);
}
else
{
Assert.Fail("Cannot get items");
}
}
else
{
Assert.IsFalse(true);
}
}
[TestMethod] //273
public async Task RetrieveDataWithValue()
{
var obj = new CB.CloudObject("student1");
obj.Set("name", "sampleName");
await obj.SaveAsync();
var query = new CB.CloudQuery("student1");
query.EqualTo("name", "sampleName");
var response = (ArrayList)await query.FindAsync();
if (response.Count > 0)
{
for (int i = 0; i < response.Count; i++)
{
if (((CB.CloudObject)response[i]).Get("name").ToString() != "sampleName")
{
Assert.Fail("should retrieve saved data with particular value");
}
}
Assert.IsTrue(true);
}
else
{
Assert.IsFalse(false);
}
}
public async Task ColumnNameNotEqualTo()
{
var obj = new CB.CloudObject("student1");
obj.Set("name", "sampleName");
await obj.SaveAsync();
var query = new CB.CloudQuery("student1");
query.NotEqualTo("name", null);
var response = await query.FindAsync();
for (int i = 0; i < response.Count; i++)
{
if (((CB.CloudObject)response[i]).Get("name") == null)
{
Assert.Fail("Name does not exists");
}
}
if (response.Count > 0)
{
Assert.IsTrue(true);
}
else
{
Assert.Fail("object could not queried properly");
}
}
public async Task GetEncryptedPasswordOverORQuery()
{
var username = Util.Methods.MakeEmail();
var obj = new CB.CloudObject("User");
obj.Set("username", username);
obj.Set("password", "password");
obj.Set("email", username);
await obj.SaveAsync();
string pass = obj.Get("password").ToString();
if (!pass.Equals("password"))
{
var query1 = new CB.CloudQuery("User");
query1.EqualTo("password", "password");
var query2 = new CB.CloudQuery("User");
query2.EqualTo("password", "password1");
var query = CB.CloudQuery.Or(query1, query2);
query.EqualTo("username", username);
ArrayList response = await query.FindAsync();
if (response.Count > 0)
{
Assert.IsTrue(true);
}
else
{
Assert.IsFalse(true);
}
}
}
public async Task ContainedInWithId()
{
var obj1 = new CB.CloudObject("Custom1");
obj1.Set("newColumn", "sample");
obj1.Set("description", "sample2");
await obj1.SaveAsync();
var obj2 = new CB.CloudObject("Custom1");
obj2.Set("newColumn", "sample");
obj2.Set("description", "sample2");
await obj2.SaveAsync();
var obj3 = new CB.CloudObject("Custom1");
obj3.Set("newColumn", "sample");
obj3.Set("description", "sample2");
await obj3.SaveAsync();
var query = new CB.CloudQuery("Custom1");
ArrayList list = new ArrayList();
list.Add(obj1.ID);
list.Add(obj2.ID);
list.Add(obj3.ID);
query.ContainedIn("id", list);
var response = (ArrayList)await query.FindAsync();
Assert.IsTrue(true);
}
public async Task saveFileAndGetRelation()
{
var obj1 = new CB.CloudObject("Employee");
var obj2 = new CB.CloudObject("Company");
obj1.Set("Name", "abcd");
obj1.Set("Name", "pqrs");
byte[] data = System.Text.Encoding.UTF8.GetBytes(".net cloudfile testing!");
string name = "sample.txt";
string type = "txt";
var file = new CB.CloudFile(data, name, type);
await file.SaveAsync();
var obj = new CB.CloudObject("Sample");
obj2.Set("File", file);
obj1.Set("Company", obj2);
await obj1.SaveAsync();
var query = new CB.CloudQuery("Employee");
query.Include("Company.File");
query.EqualTo("id", obj1.ID);
var response = (List <CB.CloudObject>) await query.FindAsync();
Assert.IsTrue(true);
}
public async Task distinctTest()
{
var query = new CB.CloudQuery("student4");
var response = (List <CB.CloudObject>) await query.DistinctAsync("age");
List <int> age = new List <int>();
if (response.Count > 0)
{
for (int i = 1; i < response.Count; i++)
{
int data = (int)response[i].Get("age");
if (age.Contains(data) == true)
{
Assert.Fail("received item with duplicate age");
}
age.Add(data);
}
Assert.IsTrue(true);
}
else
{
Assert.IsFalse(false);
}
}
public async Task DescendingOrder()
{
var query = new CB.CloudQuery("student1");
query.OrderByDesc("age");
var response = await query.FindAsync();
if (response.Count > 0)
{
int age = Int32.Parse(((CB.CloudObject)response[0]).Get("age").ToString());
for (int i = 1; i < response.Count; i++)
{
int data = Int32.Parse(((CB.CloudObject)response[i]).Get("age").ToString());
if (age < data)
{
Assert.Fail("received value greater than the required value");
}
age = data;
}
Assert.IsTrue(true);
}
else
{
Assert.IsFalse(false);
}
}
public async Task find()
{
CB.Test.Util.Keys.InitWithClientKey();
var obj = new CB.CloudObject("Custom1");
obj.Set("newColumn", "sample");
obj.Set("description", "sample2");
await obj.SaveAsync();
var query = new CB.CloudQuery("Custom1");
query.EqualTo("id", obj.ID);
query.SelectColumn("newColumn");
var response = (List <CB.CloudObject>) await query.FindAsync();
if (response.Count > 0)
{
if (response[0].Get("description") == null)
{
Assert.IsTrue(true);
}
Assert.IsFalse(true);
}
Assert.IsFalse(true);
}
public async Task <Dictionary <string, Object> > PaginateAsync(int pageNo, int totalItemsInPage)
{
if (pageNo > 0)
{
if (totalItemsInPage > 0)
{
int skip = (pageNo * totalItemsInPage) - totalItemsInPage;
this.Skip = skip;
this.Limit = totalItemsInPage;
}
}
if (totalItemsInPage > 0)
{
this.Limit = totalItemsInPage;
}
var findTask = Util.CloudRequest.Send <List <Dictionary <string, Object> > >(Util.CloudRequest.Method.POST, "/ " + this.dictionary["tableName"] + "/find", this.dictionary);
var countObj = new CB.CloudQuery(this.dictionary["tableName"].ToString());
countObj.dictionary = this.dictionary;
var countTask = Util.CloudRequest.Send <object> (Util.CloudRequest.Method.POST, CloudApp.ApiUrl + "/" + this.dictionary["tableName"] + "/count", countObj.dictionary);
await Task.WhenAll(findTask, countTask);
var findResult = await findTask;
List <CloudObject> list = CB.PrivateMethods.ToCloudObjectList(findResult);
var countResult = await countTask;
int count = (int)countResult;
int totalPages = 0;
if (countResult != null)
{
count = 0;
}
else
{
totalPages = (int)(count / this.Limit);
}
if (totalPages < 0)
{
totalPages = 0;
}
var resultObject = new Dictionary <string, Object>();
resultObject.Add("objectsList", findResult);
resultObject.Add("count", count);
resultObject.Add("totalPages", totalPages);
return(resultObject);
}
public async Task AscendingOrder()
{
var query = new CB.CloudQuery("student1");
query.OrderByAsc("age");
var response = await query.FindAsync();
if (response.Count > 0)
{
Assert.IsTrue(true);
}
else
{
Assert.IsFalse(false);
}
}
public async Task DistinctTest()
{
var query = new CB.CloudQuery("student1");
var response = await query.DistinctAsync("age");
List <int> age = new List <int>();
if (response.Count > 0)
{
Assert.IsTrue(true);
}
else
{
Assert.IsFalse(false);
}
}
public async Task nearTest()
{
var query = new CB.CloudQuery("Custom5");
var loc = new CB.CloudGeoPoint(17.7, 78.9);
query.Near("location", loc, 400000);
var response = (List <CB.CloudObject>) await query.FindAsync();
if (response.Count > 0)
{
Assert.IsTrue(true);
}
else
{
Assert.Fail("should retrieve saved data with particular value");
}
}
public async Task NearTest()
{
var query = new CB.CloudQuery("Custom5");
var loc = new CB.CloudGeoPoint((decimal)17.7, (decimal)78.9);
query.Near("geopoint", loc, 400000);
var response = await query.FindAsync();
if (response.Count > 0)
{
Assert.IsTrue(true);
}
else
{
Assert.Fail("should retrieve saved data with particular value");
}
}
public async Task geoWithinTestCircle()
{
var query = new CB.CloudQuery("Custom5");
var loc = new CB.CloudGeoPoint(17.3, 78.3);
query.Limit = 4;
query.GeoWithin("location", loc, 1000);
var response = (List <CB.CloudObject>) await query.FindAsync();
if (response.Count > 0)
{
Assert.IsTrue(true);
}
else
{
Assert.Fail("should retrieve saved data with particular value");
}
}
public async Task RetrieveDataWithParticularValue()
{
var obj1 = new CB.CloudQuery("student1");
string[] list = { "java", "python" };
obj1.EqualTo("subject", list);
var obj2 = new CB.CloudQuery("student1");
obj2.EqualTo("age", 12);
var obj = CB.CloudQuery.Or(obj1, obj2);
var response = await obj.FindAsync();
if (response.Count > 0)
{
for (int i = 0; i < response.Count; i++)
{
int data = (int)((CB.CloudObject)response[i]).Get("age");
if (data == 12)
{
continue;
}
else
{
string[] subject = (string[])((CB.CloudObject)response[i]).Get("subject");
for (int j = 0; j < subject.Length; j++)
{
if (subject[j] == "java" || subject[j] == "python")
{
continue;
}
else
{
Assert.Fail("should retrieve saved data with particular value");
}
}
}
}
Assert.IsTrue(true);
}
else
{
Assert.IsFalse(false);
}
}
public async Task FindByIdTest()
{
var obj = new CB.CloudObject("student1");
obj.Set("name", "abcd");
await obj.SaveAsync();
var query = new CB.CloudQuery("student1");
var response = await query.GetAsync <CB.CloudObject>(obj.ID);
if (((CB.CloudObject)response).Get("name").ToString() == "abcd")
{
Assert.IsTrue(true);
}
else
{
Assert.IsFalse(false);
}
}
public async Task DoNotEncryptAlreadyEncryptedPassword()
{
string username = Util.Methods.MakeEmail();
var obj = new CB.CloudObject("User");
obj.Set("username", username);
obj.Set("password", "password");
obj.Set("email", Util.Methods.MakeEmail());
await obj.SaveAsync();
var query = new CB.CloudQuery("User");
var response = await query.GetAsync <CB.CloudUser>(obj.ID);
var obj1 = await response.SaveAsync();
Assert.IsTrue(true);
}
public async Task existsTest()
{
var query = new CB.CloudQuery("student4");
query.Exists("age");
var response = (List <CB.CloudObject>) await query.FindAsync();
if (response.Count > 0)
{
for (int i = 0; i < response.Count; i++)
{
if (response[i].Get("age") == null)
{
Assert.Fail("received wrong data");
}
}
Assert.IsTrue(true);
}
Assert.IsFalse(false);
}
public async Task DoesNotExists()
{
var query = new CB.CloudQuery("student1");
query.DoesNotExist("age");
var response = await query.FindAsync();
if (response.Count > 0)
{
for (int i = 0; i < response.Count; i++)
{
if (((CB.CloudObject)response[i]).Get("age") != null)
{
Assert.Fail("received wrong data");
}
}
Assert.IsTrue(true);
}
Assert.IsFalse(false);
}
public async Task geoWithinTestLimit()
{
var query = new CB.CloudQuery("Custom5");
var loc1 = new CB.CloudGeoPoint(18.4, 78.9);
var loc2 = new CB.CloudGeoPoint(17.4, 78.4);
var loc3 = new CB.CloudGeoPoint(17.7, 80.4);
CB.CloudGeoPoint[] loc = { loc1, loc2, loc3 };
query.Limit = 4;
query.GeoWithin("location", loc);
var response = (List <CB.CloudObject>) await query.FindAsync();
if (response.Count > 0)
{
Assert.IsTrue(true);
}
else
{
Assert.Fail("should retrieve saved data with particular value");
}
}
public async Task RetrieveRole()
{
var roleName = Util.Methods.MakeString();
var role = new CB.CloudRole(roleName);
var response = await role.SaveAsync();
if (response.ID == null)
{
Assert.IsTrue(true);
}
var query = new CB.CloudQuery("Role");
query.EqualTo("id", response.ID);
var result = await query.FindAsync();
if (result == null)
{
Assert.Fail("Should retrieve the cloud role");
}
Assert.IsTrue(true);
}
public async Task createNewUserSave()
{
var obj = new CB.CloudUser();
obj.Set("username", username);
obj.Set("password", password);
obj.Set("email", Util.Methods._makeEmail());
await obj.SaveAsync();
var query = new CB.CloudQuery("User");
var response = await query.GetAsync(obj.ID);
if (response != null)
{
Assert.IsTrue(true);
}
else
{
Assert.Fail("Unable to retrieve User");
}
}
public async Task FindItemWithId()
{
var obj = new CB.CloudObject("student1");
obj.Set("name", "sampleName");
await obj.SaveAsync();
var query = new CB.CloudQuery("student1");
query.EqualTo("id", obj.ID);
var response = (ArrayList)await query.FindAsync();
if (response.Count > 0)
{
Assert.IsTrue(true);
}
else
{
Assert.IsFalse(false);
}
}
public async Task FindOneQuery()
{
var obj = new CB.CloudObject("student1");
obj.Set("name", "sampleName");
await obj.SaveAsync();
var query = new CB.CloudQuery("student1");
query.EqualTo("name", "sampleName");
CB.CloudObject response = await query.FindOneAsync <CB.CloudObject>();
if (((CB.CloudObject)response).Get("name").ToString() == "sampleName")
{
Assert.IsTrue(true);
}
else
{
Assert.IsFalse(false);
}
}
public async Task QueryOverBooleanDataType()
{
var obj1 = new CB.CloudObject("Custom1");
obj1.Set("newColumn", false);
await obj1.SaveAsync();
var query = new CB.CloudQuery("Custom1");
query.EqualTo("newColumn", false);
var response = await query.FindAsync();
if (response.Count > 0)
{
Assert.IsTrue(true);
}
else
{
Assert.IsFalse(true);
}
}
