Update

Subtopics

EdgeQL Tutorial

Update

Sometimes you may need to edit existing data. You can use update to do that. The command first uses a filter to narrow down the set of objects that need to be edited and the set block determines the actual changes:

Input

Run

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

update Movie
filter
    .title = 'Dune'
    and
    # Here we just use the title and release_year to get
    # the movie we want, but in real life we'd probably
    # use the "id".
    .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