Update

Subtopics

Sometimes you may need to edit existing data. You can use update to do that. Using update begins the update process, filter narrows down the set of objects to edit (no need for filter if you want to update every object), and the set block determines the actual changes:

Input

Run

update Movie
filter
    # Here we use "title" and "release_year" 
    # to get the movie we want, but in real 
    # life we'd probably use the "id".
    .title = 'Dune'
    and
    .release_year = 2021
set {
    # Concatenate an additional string to existing title.
    title := .title ++ ": Part One"
};

update Movie
filter
    # Here we use "title" and "release_year" 
    # to get the movie we want, but in real 
    # life we'd probably use the "id".
    .title = 'Dune'
    and
    .release_year = 2021
set {
    # Concatenate an additional string to existing title.
    title := .title ++ ": Part One"
};

Output Objects

Press the 'Run' button to evaluate the input

Let's select the updated post:

Input

Run

select Movie {
    title,
    release_year
} filter
    # simialr to filter for update
    .title like 'Dune%'
    and
    .release_year = 2021;

select Movie {
    title,
    release_year
} filter
    # simialr to filter for update
    .title like 'Dune%'
    and
    .release_year = 2021;

Output Objects

Press the 'Run' button to evaluate the input

Prev Next