Insert

Subtopics

EdgeQL Tutorial

Insert

Let's start with adding a simple post. We'll need the actual content and some way to identify the author. We could use the "id" property, but instead we'll use the "email" property because it has an "exclusive" constraint, which means that every email is associated with only one user exclusively:

Input

INSERT Text {
    title := 'EdgeDB',
    body := "I'm doing the INSERT tutorial.",
    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'
    )
};

INSERT Text {
    title := 'EdgeDB',
    body := "I'm doing the INSERT tutorial.",
    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'
    )
};

Run

Output

Press the 'Run' button to evaluate the input

Now let's select the post we just added:

Input

SELECT Text {
    title,
    body,
    post_date,
    author: {
        name,
        email
    }
}
# We can just select the last post based on post_date
ORDER BY .post_date DESC
LIMIT 1;

SELECT Text {
    title,
    body,
    post_date,
    author: {
        name,
        email
    }
}
# We can just select the last post based on post_date
ORDER BY .post_date DESC
LIMIT 1;

Run

Output

Press the 'Run' button to evaluate the input

Prev Next