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

UPDATE Text
FILTER
    .author.email = 'dana@tutorial.com'
    AND
    # Here we just use the post author and title to
    # get the post we want, but in real life we'd
    # probably use the "id".
    .title = 'Learning EdgeDB'
SET {
    # Concatenate an additional string to
    # existing body.
    body := .body ++ " Doing great so far!",
};

UPDATE Text
FILTER
    .author.email = 'dana@tutorial.com'
    AND
    # Here we just use the post author and title to
    # get the post we want, but in real life we'd
    # probably use the "id".
    .title = 'Learning EdgeDB'
SET {
    # Concatenate an additional string to
    # existing body.
    body := .body ++ " Doing great so far!",
};

Run

Output

Press the 'Run' button to evaluate the input

Let's select the updated post:

Input

SELECT Text {
    title,
    body,
    # Display the author's email as a sanity-check
    author_email := .author.email,
} FILTER
    # same FILTER as for UPDATE
    .author.email = 'dana@tutorial.com'
    AND
    .title = 'Learning EdgeDB';

SELECT Text {
    title,
    body,
    # Display the author's email as a sanity-check
    author_email := .author.email,
} FILTER
    # same FILTER as for UPDATE
    .author.email = 'dana@tutorial.com'
    AND
    .title = 'Learning EdgeDB';

Run

Output

Press the 'Run' button to evaluate the input

Prev Next