Update

Subtopics

EdgeQL Tutorial

Update

Let's check out hashtags of some posts:

Input

SELECT Text {
    title,
    hashtags,
    # Display the author's email as a sanity-check
    author_email := .author.email,
} FILTER
    .author.email = 'dana@tutorial.com';

SELECT Text {
    title,
    hashtags,
    # Display the author's email as a sanity-check
    author_email := .author.email,
} FILTER
    .author.email = 'dana@tutorial.com';

Run

Output

Press the 'Run' button to evaluate the input

Let's add hashtags to all posts mentioning EdgeDB in the title:

Input

UPDATE Text
FILTER
    .author.email = 'dana@tutorial.com'
    AND .title ILIKE '%edgedb%'
SET {
    hashtags := .hashtags UNION 'edgedb',
};

UPDATE Text
FILTER
    .author.email = 'dana@tutorial.com'
    AND .title ILIKE '%edgedb%'
SET {
    hashtags := .hashtags UNION 'edgedb',
};

Run

Output

Press the 'Run' button to evaluate the input

Let's see the updated posts now:

Input

SELECT Text {
    title,
    hashtags,
    # Display the author's email as a sanity-check
    author_email := .author.email,
} FILTER
    .author.email = 'dana@tutorial.com';

SELECT Text {
    title,
    hashtags,
    # Display the author's email as a sanity-check
    author_email := .author.email,
} FILTER
    .author.email = 'dana@tutorial.com';

Run

Output

Press the 'Run' button to evaluate the input

Prev NextDelete