Insert

You may have noticed that when you run an INSERT command, some data is returned as the result. Every INSERT is also a query that returns the object that was just inserted along with its "id". It is possible to get more than that by applying a shape to the INSERT as a whole:

Input

# Wrap the entire INSERT into a (...) to treat it as
# an expression which can then be selected.
SELECT (
    INSERT Text {
        title := 'EdgeQL',
        body := "INSERT commands can become expressions.",
        author := (
            # Using a sub-query to fetch the
            # existing user so that we can
            # assign them as the author.
            SELECT User
            FILTER .email = 'dana@tutorial.com'
        )
    }
) {
    title,
    body,
    post_date,
    author: {
        name,
        email
    }
};

# Wrap the entire INSERT into a (...) to treat it as
# an expression which can then be selected.
SELECT (
    INSERT Text {
        title := 'EdgeQL',
        body := "INSERT commands can become expressions.",
        author := (
            # Using a sub-query to fetch the
            # existing user so that we can
            # assign them as the author.
            SELECT User
            FILTER .email = 'dana@tutorial.com'
        )
    }
) {
    title,
    body,
    post_date,
    author: {
        name,
        email
    }
};

Previous Next