Delete

Let's look at some posts of another user:

Input

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

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

Run

Output

Press the 'Run' button to evaluate the input

It looks like this user has a duplicate post. It should be possible to delete a post you don't like. The DELETE command uses the same mechanism as SELECT to find the items to be deleted. Also, just like INSERT and UPDATE, a DELETE command can be wrapped in "(...)" and used an an expression. Let's pretend that Cameron wants to delete the last text post:

Input

DELETE Text
FILTER
    .author.email = 'cameron@tutorial.com'
# To get the last post we can order them by post_date
# and then pick the first one.
ORDER BY .post_date DESC
LIMIT 1;

DELETE Text
FILTER
    .author.email = 'cameron@tutorial.com'
# To get the last post we can order them by post_date
# and then pick the first one.
ORDER BY .post_date DESC
LIMIT 1;

Run

Output

Press the 'Run' button to evaluate the input

Let's make sure that we've deleted the right post:

Input

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

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

Run

Output

Press the 'Run' button to evaluate the input

Prev NextUpsert