Insert

Subtopics

EdgeQL Tutorial

Insert

Let's start with adding a new Account. We'll need a username and to make things more interesting we'll add all movies with Scarlett Johansson to our watchlist:

Input

Run

insert Account {
  username := 'tutorial',
  watchlist := (
    # Using a sub-query to fetch the existing movies.
    select Movie filter .actors.name = 'Scarlett Johansson'
  )
};

insert Account {
  username := 'tutorial',
  watchlist := (
    # Using a sub-query to fetch the existing movies.
    select Movie filter .actors.name = 'Scarlett Johansson'
  )
};

Output Objects

Press the 'Run' button to evaluate the input

Now let's select the post we just added:

Input

Run

select Account {
  username,
  watchlist: {
    title
  }
} filter .username = 'tutorial';

select Account {
  username,
  watchlist: {
    title
  }
} filter .username = 'tutorial';

Output Objects

Press the 'Run' button to evaluate the input

Prev Next

We use ChatGPT with additional context from our documentation to answer your questions. Not all answers will be accurate. Please join our Discord if you need more help.