How to Update a Nested Object in EdgeDB

Learn how to efficiently update nested objects in EdgeDB, specifically focusing on updating properties of a `Baz` object linked to a `Foo` object.
---

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: How to update a nested object in EdgeDB?

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Update a Nested Object in EdgeDB

Updating nested objects in databases can sometimes pose a challenge for developers, especially when working with complex schemas. In this guide, we will address how to update a property of a nested object in EdgeDB, providing you with a step-by-step guide and clear examples.

Understanding the Schema

Before diving into the solution, let's take a look at the schema we are working with:

[[See Video to Reveal this Text or Code Snippet]]

In this schema:

Foo has a required link to Bar.

Bar holds a property baz, which is of type boolean.

The task at hand is to update the baz property of a Bar object associated with a specific Foo object, using the Foo object's ID.

The Problem

Suppose we have the ID of a Foo object. The challenge is to update the baz value of the Bar object that is linked to this Foo. For instance, if we know the ID of the Foo object is df492862-80aa-11ed-832e-e72d12452736, how can we proceed?

The Solution

Step 1: Filtering the Bar Object

First, we need to filter the Bar object associated with the Foo object. This can be done using the following query:

[[See Video to Reveal this Text or Code Snippet]]

In this query:

select Bar retrieves instances of Bar.

Step 2: Updating the baz Property

Once we have filtered the Bar object, we can perform the update operation to set the baz property to a new value. Here's how the update query looks:

[[See Video to Reveal this Text or Code Snippet]]

This query:

Uses update Bar to specify that we want to update the Bar object.

Again, we filter based on the Foo ID.

The set clause changes the baz property to false.

Conclusion

Updating a nested object in EdgeDB requires a clear understanding of the relationship between your types and the correct use of filtering and updating syntax. In this post, we've shown how to efficiently update the baz property of a Bar object linked to a Foo object by using the unique ID of the Foo.

By following this structured approach, you should feel confident in handling similar updates in your own EdgeDB schema. If you have any questions or further scenarios you'd like to explore, feel free to share in the comments!