Update

Subtopics

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