public void testQuery() { mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).equalTo("id", 1); executeQuery("author is cedric"); mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).notEqualTo("author", "cedric"); executeQuery("author is not cedric"); mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).greaterThan("price", 11.0); executeQuery("price > 11.0"); mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).greaterThanOrEqualTo("price", 11.0); executeQuery("price >= 11.0"); mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).lessThan("publishTime", new Date((long)1607500800)); executeQuery("publishTime < 1607500800"); mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).lessThanOrEqualTo("price", 24.0); executeQuery("price <= 24.0"); mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).@in("author", new string[] { "cedric" }); executeQuery("cedric in author"); mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).beginsWith("author", "ce"); executeQuery("author beginsWith ce"); mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).endsWith("author", "ic"); executeQuery("author endsWith ic"); mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).contains("author", "dr"); executeQuery("author contains dr"); mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).isNull("author"); executeQuery("author isNull"); mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).isNotNull("author"); executeQuery("author isNotNull"); mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).orderByAsc("author"); executeQuery("author by asc"); mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).orderByDesc("author"); executeQuery("author by desc"); mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).limit(1, 0); executeQuery("limit 1 by 0"); }
public void deleteBookInfo() { if (mCloudDBZone == null) { TestTip.Inst.ShowText("CloudDBZone is null, try re-open it"); return; } mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)); Task queryTask = mCloudDBZone.executeQuery(mQuery, CloudDBZoneQuery.CloudDBZoneQueryPolicy.POLICY_QUERY_FROM_CLOUD_ONLY); queryTask.addOnSuccessListener(new HmsSuccessListener <CloudDBZoneSnapshot <BookInfo> > ((snapshot) => { mObjectList = snapshot.getSnapshotObjects(); BookInfo bookInfo = mObjectList.get(3); Task deleteTask = mCloudDBZone.executeDelete(bookInfo); deleteTask.addOnSuccessListener(new HmsSuccessListener <int> ((cloudDBZoneResult) => { TestTip.Inst.ShowText("delete " + cloudDBZoneResult + " records"); })).addOnFailureListener(new HmsFailureListener((exception) => { TestTip.Inst.ShowText("delete bookinfo failed: " + exception.toString()); })); List <BookInfo> list = new List <BookInfo> (); list.add(mObjectList.get(4)); list.add(mObjectList.get(5)); Task deleteTask2 = mCloudDBZone.executeDelete(list); deleteTask2.addOnSuccessListener(new HmsSuccessListener <int> ((cloudDBZoneResult) => { TestTip.Inst.ShowText("delete " + cloudDBZoneResult + " records"); })).addOnFailureListener(new HmsFailureListener((exception) => { TestTip.Inst.ShowText("delete bookinfo failed: " + exception.toString()); })); })).addOnFailureListener(new HmsFailureListener((exception) => { TestTip.Inst.ShowText("Query book list from cloud failed: " + exception.toString()); })); }
public void executeAverageQuery() { if (mCloudDBZone == null) { TestTip.Inst.ShowText("CloudDBZone is null, try re-open it"); return; } mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)); Task queryTask = mCloudDBZone.executeAverageQuery(mQuery, "price", CloudDBZoneQuery.CloudDBZoneQueryPolicy.POLICY_QUERY_FROM_CLOUD_ONLY); queryTask.addOnSuccessListener(new HmsSuccessListener <double> ((result) => { TestTip.Inst.ShowText("query average price: " + result); })).addOnFailureListener(new HmsFailureListener((exception) => { TestTip.Inst.ShowText("query average price failed: " + exception.toString()); })); }
public void addSubscription() { if (mCloudDBZone == null) { TestTip.Inst.ShowText("CloudDBZone is null, try re-open it"); return; } try { CloudDBZoneQuery snapshotQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)) .equalTo("shadowFlag", true); mRegister = mCloudDBZone.subscribeSnapshot(snapshotQuery, CloudDBZoneQuery.CloudDBZoneQueryPolicy.POLICY_QUERY_FROM_CLOUD_ONLY, mSnapshotListener); TestTip.Inst.ShowText("Add subscription success"); } catch (System.Exception e) { TestTip.Inst.ShowText("subscribeSnapshot: " + e.Message); } }
public void executeUnsyncQuery() { if (mCloudDBZone == null) { TestTip.Inst.ShowText("CloudDBZone is null, try re-open it"); return; } var tag = "Unsync"; mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)); Task queryTask = mCloudDBZone.executeQueryUnsynced(mQuery); queryTask.addOnSuccessListener(new HmsSuccessListener <CloudDBZoneSnapshot <BookInfo> > ((snapshot) => { TestTip.Inst.ShowText("ExecuteQueryUnsynced."); processQueryResult(snapshot, tag); })).addOnFailureListener(new HmsFailureListener((exception) => { TestTip.Inst.ShowText("ExecuteQueryUnsynced failed: " + exception.toString()); })); }
public void testTransaction() { Transaction.Function f = new Transaction.Function((t) => { try { mQuery = CloudDBZoneQuery.where (new AndroidJavaClass(bookInfoClass)).equalTo("bookName", "testTransaction"); var queryList = t.executeQuery(mQuery); TestTip.Inst.ShowText("Transaction success: " + queryList.toArray().Length); t = t.executeDelete(queryList); TestTip.Inst.ShowText("Transaction success: " + queryList.toArray().Length); } catch (System.Exception e) { TestTip.Inst.ShowText("Transaction fail: " + e.Message); return(false); } return(true); }); TestTip.Inst.ShowText("Run Transaction."); mCloudDBZone.runTransaction(f); }