Update Parent and Child

The example below demonstrates how the Deep Save API can be used to update both the parent and the child objects in the database. The sample retrieves a Product and the related Manufacturer objects then it changes property values in both objects and saves the changes with a single Deep Save API call. The objects before the code runs are:

The Product object:

The Manufacturer object:

The example uses blocking API for code brevity. When using in an Android application, keep in mind the blocking API cannot be used on the mail UI thread. Either run it in a separate thread or use the non-blocking API.

Using Java MapCustom Class

DataQueryBuilder queryBuilder = DataQueryBuilder.create();
// load the related manufacturer object
queryBuilder.addRelated( "manufacturer" );
// get the specific product
queryBuilder.setWhereClause( "name = 'iPhone X'" );

// use get( 0 ) to get the first object from the response
Map<String, Object> iPhone = Backendless.Data.of( "Product" ).find( queryBuilder ).get( 0 );

// update values in both parent (Order) and child (Manufacturer) objects
iPhone.put( "price", 1300 );
Map<String, Object> manufacturer = (Map<String, Object>) iPhone.get( "manufacturer" );
manufacturer.put( "industry", "Computer Hardware, Software and Consumer Electronics" );

// save both objects back in the database
Backendless.Data.of( "Product" ).deepSave( iPhone );

DataQueryBuilder queryBuilder = DataQueryBuilder.create();
// load the related manufacturer object
queryBuilder.addRelated( "manufacturer" );
// get the specific product
queryBuilder.setWhereClause( "name = 'iPhone X'" );

// use get( 0 ) to get the first object from the response
Product iPhone = Backendless.Data.of( Product.class ).find( queryBuilder ).get( 0 );

// update values in both parent (Order) and child (Manufacturer) objects
iPhone.price = 1300;
iPhone.manufacturer.industry = "Computer Hardware, Software and Consumer Electronics";

// save both objects back in the database
Backendless.Data.of( Product.class ).deepSave( iPhone );

Product class. Public fields are used for brevity - JavaBean get/set methods are supported and recommended.

public class Product
{
  public String objectId;
  public String name;
  public double price;
  public Manufacturer manufacturer;
}

Manufacturer class. Public fields are used for brevity - JavaBean get/set methods are supported and recommended.

public class Manufacturer
{
  public String objectId;
  public String name;
  public String industry;
}

After the sample code runs, the objects in the database will appear as shown below:

The Product object:

The Manufacturer object:

Codeless Reference

where:

Argument	Description
table name	Specify the name of the data table where you want to update an existing record.
object	An object to update in the database. Object properties must match the names of the table columns.
return result	Optional parameter. When this box is checked, the operation returns the updated object.

The Deep Save API can be used to update both the parent and the child objects in the database.

Returns the updated object.

Consider the structure of the data table called Product. This table contains three columns: manufacturer, name and price. Values in the first column are associated with the Manufacturer data table where the manufacturer object with the corresponding information is stored, values in the second column represent the name of the product, while the third column stores the price of the product.

Below you can find the structure of the Manufacturer data table where the manufacturer information is stored.

The example below sets the new value 1300 in the "price" column of the parent object which is stored in the "Product" data table, and also it updates the value in the "industry" column of the related child object which is stored in the "Manufacturer" data table. The updated value for the "industry" column is: "Computer Hardware, Software and Consumer Electronics".

After the Codeless logic runs, the value in the price column of the parent object gets updated to 1300.

The value stored in the industry column of the related child object also gets updated.

The result of this operation will look as shown below after the Codeless logic runs: