public void TestCollectionGetPage() { var getPageEntities = new List<GetPageEntity>(); for( int i = 10; i < 30; i++ ) { var entity = new GetPageEntity {Name = "name#" + i, Age = 20 + i}; Backendless.Persistence.Save( entity ); if( i > 19 && i < 30 ) getPageEntities.Add( entity ); Thread.Sleep( 1000 ); } var dataQuery = new BackendlessDataQuery( new QueryOptions( 10, 0, "Age" ) ); var collection = Backendless.Persistence.Of<GetPageEntity>().Find( dataQuery ).GetPage( 10, 10 ); Assert.IsNotNull( collection, "Next page returned a null object" ); Assert.IsNotNull( collection.GetCurrentPage(), "Next page contained a wrong data size" ); Assert.AreEqual( getPageEntities.Count, collection.GetCurrentPage().Count, "Next page returned a wrong size" ); foreach( GetPageEntity entity in getPageEntities ) Assert.IsTrue( collection.GetCurrentPage().Contains( entity ), "Server result didn't contain expected entity" ); }
public BackendlessDataQuery Build() { BackendlessDataQuery dataQuery = pagedQueryBuilder.Build(); dataQuery.QueryOptions = queryOptionsBuilder.Build(); dataQuery.Properties = properties; dataQuery.WhereClause = whereClause; return(dataQuery); }
internal BackendlessDataQuery Build() { ValidateOffset(offset); ValidatePageSize(pageSize); BackendlessDataQuery dataQuery = new BackendlessDataQuery(); dataQuery.PageSize = pageSize; dataQuery.Offset = offset; return(dataQuery); }
public BackendlessDataQuery Build() { BackendlessDataQuery dataQuery = pagedQueryBuilder.Build(); dataQuery.QueryOptions = queryOptionsBuilder.Build(); dataQuery.Properties = properties; dataQuery.ExcludeProperties = excludeProperties; dataQuery.WhereClause = whereClause; dataQuery.GroupBy = groupBy; dataQuery.HavingClause = havingClause; return(dataQuery); }
public void TestCollectionGetPage() { RunAndAwait( () => { var getPageEntities = new List<GetPageEntityAsync>(); var latch = new CountdownEvent( 20 ); for( int i = 10; i < 30; i++ ) { var entity = new GetPageEntityAsync {Name = "name#" + i, Age = 20 + i}; Backendless.Persistence.Save( entity, new AsyncCallback<GetPageEntityAsync>( response => latch.Signal(), fault => { for( int j = 0; j < latch.CurrentCount; j++ ) latch.Signal(); } ) ); if( i > 19 && i < 30 ) getPageEntities.Add( entity ); } latch.Wait(); var dataQuery = new BackendlessDataQuery( new QueryOptions( 10, 0, "Age" ) ); Backendless.Persistence.Of<GetPageEntityAsync>() .Find( dataQuery, new ResponseCallback<BackendlessCollection<GetPageEntityAsync>>( this ) { ResponseHandler = response => response.GetPage( 10, 10, new ResponseCallback<BackendlessCollection<GetPageEntityAsync>>( this ) { ResponseHandler = collection => { Assert.IsNotNull( collection, "Next page returned a null object" ); Assert.IsNotNull( collection.GetCurrentPage(), "Next page contained a wrong data size" ); Assert.AreEqual( getPageEntities.Count, collection.GetCurrentPage().Count, "Next page returned a wrong size" ); foreach( GetPageEntityAsync entity in getPageEntities ) Assert.IsTrue( collection.GetCurrentPage().Contains( entity ), "Server result didn't contain expected entity" ); CountDown(); } } ) } ); } ); }
public BackendlessDataQuery Build() { if (string.IsNullOrEmpty(relationName)) { throw new System.Exception("Unable to build a query for LoadRelations. Relation name is not set"); } BackendlessDataQuery dataQuery = pagedQueryBuilder.Build(); QueryOptions queryOptions = new QueryOptions(); queryOptions.Related = new List <String>(new[] { relationName }); dataQuery.QueryOptions = queryOptions; return(dataQuery); }
public void TestFindWithWhereEntities() { var entities = new List<FindWithWhereEntity>(); for( int i = 0; i < 10; i++ ) { var findWithWhereEntity = new FindWithWhereEntity(); findWithWhereEntity.Name = "bot_#" + i; findWithWhereEntity.Age = 20 + i; Backendless.Persistence.Save( findWithWhereEntity ); if( i < 5 ) entities.Add( findWithWhereEntity ); } BackendlessDataQuery dataQuery = new BackendlessDataQuery( "Age < 25" ); BackendlessCollection<FindWithWhereEntity> backendlessCollection = Backendless.Persistence.Of<FindWithWhereEntity>().Find( dataQuery ); AssertArgumentAndResultCollections( entities, backendlessCollection ); }
public void TestFindWithNullPropertiesQuery() { var findWithPropertiesEntity = new FindWithPropertiesEntity {Name = "bot_#foobar", Age = 20}; Backendless.Persistence.Save( findWithPropertiesEntity ); List<String> properties = null; var dataQuery = new BackendlessDataQuery( properties ); BackendlessCollection<FindWithPropertiesEntity> backendlessCollection = Backendless.Persistence.Of<FindWithPropertiesEntity>().Find( dataQuery ); Assert.IsTrue( backendlessCollection.TotalObjects > 0, "Server found wrong number of objects" ); Assert.IsTrue( backendlessCollection.GetCurrentPage().Count > 0, "Server returned wrong number of objects" ); foreach( FindWithPropertiesEntity entity in backendlessCollection.GetCurrentPage() ) { Assert.IsTrue( entity.Age > 0, "Server result contained wrong age field value" ); Assert.IsNotNull( entity.Name, "Server result contained non null field" ); Assert.IsNotNull( entity.ObjectId, "Server result contained non null field" ); Assert.IsNotNull( entity.Created, "Server result contained non null field" ); } }
public void TestFindWithMissingProperties() { var findWithPropertiesEntity = new FindWithPropertiesEntity {Name = "bot_#foobar", Age = 20}; Backendless.Persistence.Save( findWithPropertiesEntity ); var properties = new List<string> {"foobar"}; var dataQuery = new BackendlessDataQuery( properties ); try { Backendless.Persistence.Of<FindWithPropertiesEntity>().Find( dataQuery ); Assert.Fail( "Server didn't throw an exception" ); } catch( System.Exception e ) { CheckErrorCode( 1006, e ); } }
public void TestFindWithWhereEntities() { RunAndAwait( () => { var entities = new List<FindWithWhereEntityAsync>(); var latch = new CountdownEvent( 10 ); for( int i = 0; i < 10; i++ ) { var findWithWhereEntity = new FindWithWhereEntityAsync(); findWithWhereEntity.Name = "bot_#" + i; findWithWhereEntity.Age = 20 + i; Backendless.Persistence.Save( findWithWhereEntity, new AsyncCallback<FindWithWhereEntityAsync>( response => latch.Signal(), fault => { for( int j = 0; j < latch.CurrentCount; j++ ) latch.Signal(); FailCountDownWith( fault ); } ) ); if (i < 5) entities.Add(findWithWhereEntity); } latch.Wait(); BackendlessDataQuery dataQuery = new BackendlessDataQuery( "Age < 25" ); Backendless.Persistence.Of<FindWithWhereEntityAsync>() .Find( dataQuery, new ResponseCallback<BackendlessCollection<FindWithWhereEntityAsync>>( this ) { ResponseHandler = backendlessCollection => AssertArgumentAndResultCollections( entities, backendlessCollection ) } ); } ); }
public void TestFindWithNullPropertiesQuery() { RunAndAwait( () => { var findWithPropertiesEntity = new FindWithPropertiesEntityAsync {Name = "bot_#foobar", Age = 20}; Backendless.Persistence.Save( findWithPropertiesEntity, new ResponseCallback<FindWithPropertiesEntityAsync>( this ) { ResponseHandler = response => { List<String> properties = null; var dataQuery = new BackendlessDataQuery( properties ); Backendless.Persistence.Of<FindWithPropertiesEntityAsync>() .Find( dataQuery, new ResponseCallback <BackendlessCollection<FindWithPropertiesEntityAsync>> ( this ) { ResponseHandler = backendlessCollection => { Assert.IsTrue( backendlessCollection.TotalObjects > 0, "Server found wrong number of objects" ); Assert.IsTrue( backendlessCollection.GetCurrentPage().Count > 0, "Server returned wrong number of objects" ); foreach( FindWithPropertiesEntityAsync entity in backendlessCollection.GetCurrentPage() ) { Assert.IsTrue( entity.Age > 0, "Server result contained wrong age field value" ); Assert.IsNotNull( entity.Name, "Server result contained non null field" ); Assert.IsNotNull( entity.ObjectId, "Server result contained non null field" ); Assert.IsNotNull( entity.Created, "Server result contained non null field" ); } CountDown(); } } ); } } ); } ); }
public void TestFindWithMissingProperties() { RunAndAwait( () => { var findWithPropertiesEntity = new FindWithPropertiesEntityAsync {Name = "bot_#foobar", Age = 20}; Backendless.Persistence.Save( findWithPropertiesEntity, new ResponseCallback<FindWithPropertiesEntityAsync>( this ) { ResponseHandler = response => { var properties = new List<string> {"foobar"}; var dataQuery = new BackendlessDataQuery( properties ); Backendless.Persistence.Of<FindWithPropertiesEntityAsync>() .Find( dataQuery, new AsyncCallback <BackendlessCollection<FindWithPropertiesEntityAsync>> ( collection => Assert.Fail( "Server didn't throw an exception" ), fault => CheckErrorCode( 1006, fault ) ) ); } } ); } ); }
public TaskModel GetObjectFromTable(string query) { BackendlessDataQuery dataQuery = new BackendlessDataQuery(query) { QueryOptions = new QueryOptions() }; return Backendless.Data.Find<TaskModel>(dataQuery).Data[0]; }
public int GetNumberOfObjectsFromTable(string query) { BackendlessDataQuery dataQuery = new BackendlessDataQuery(query) { QueryOptions = new QueryOptions() }; return Backendless.Data.Of<TaskModel>().Find(dataQuery).TotalObjects; }
public List<TaskModel> GetListOfObjectsFromTable(string query) { BackendlessDataQuery dataQuery = new BackendlessDataQuery(query) { QueryOptions = new QueryOptions() }; return Backendless.Persistence.Of<TaskModel>().Find(dataQuery).Data; }
public IEnumerable<Users> GetListOfAllUsers() { BackendlessDataQuery dataQuery = new BackendlessDataQuery("name LIKE '%'") { QueryOptions = new QueryOptions() }; return Backendless.Persistence.Of<Users>().Find(dataQuery).Data; }