Update

Subtopics

EdgeQL Tutorial

Update

Let's take a closer look at the latest Dune:

Input

Run

select Movie {
    title,
    actors: {
      name,
      @character_name
    },
} filter
    .title = 'Dune' and .release_year = 2021;

select Movie {
    title,
    actors: {
      name,
      @character_name
    },
} filter
    .title = 'Dune' and .release_year = 2021;

Output Objects

Press the 'Run' button to evaluate the input

Let's add Dave Bautista (who is already in our database) to the actors:

Input

Run

update Movie
filter
    .title = 'Dune' and .release_year = 2021
set {
    actors += (
      select Person {
        @character_name := 'Glossu Rabban Harkonnen'
      } filter .name = 'Dave Bautista'
    ),
};

update Movie
filter
    .title = 'Dune' and .release_year = 2021
set {
    actors += (
      select Person {
        @character_name := 'Glossu Rabban Harkonnen'
      } filter .name = 'Dave Bautista'
    ),
};

Output Objects

Press the 'Run' button to evaluate the input

Let's see the updated movie now:

Input

Run

select Movie {
    title,
    actors: {
      name,
      @character_name
    },
} filter
    .title = 'Dune' and .release_year = 2021;

select Movie {
    title,
    actors: {
      name,
      @character_name
    },
} filter
    .title = 'Dune' and .release_year = 2021;

Output Objects

Press the 'Run' button to evaluate the input

Prev NextDelete

We use ChatGPT with additional context from our documentation to answer your questions. Not all answers will be accurate. Please join our Discord if you need more help.