Insert

Subtopics

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 just the id by using select and applying a shape to the returned insert as a whole:

Input

Run

# Wrap the entire insert with parentheses to treat it as
# an expression which can then be selected.
select (
  insert Account {
    username := 'evans_fan',
    watchlist := (
      # Using a sub-query to fetch the existing movies.
      select Movie filter .actors.name = 'Chris Evans'
    )
  }
) {
  username,
  watchlist: {
    title
  }
};

# Wrap the entire insert with parentheses to treat it as
# an expression which can then be selected.
select (
  insert Account {
    username := 'evans_fan',
    watchlist := (
      # Using a sub-query to fetch the existing movies.
      select Movie filter .actors.name = 'Chris Evans'
    )
  }
) {
  username,
  watchlist: {
    title
  }
};

Output Objects

Press the 'Run' button to evaluate the input

Prev Next