Insert

Subtopics

EdgeQL Tutorial

Insert

Sometimes it's necessary to insert several objects at the same time because they make up a single nested structure. Since each insert can be treated as an expression, they can just be nested into each other. Consider, for example, adding a Show with just one Season:

Input

Run

# Wrap everything in a `select` to also display the
# entire inserted structure.
select (
  insert Season {
    number := 1,
    show := (
      insert Show {
        title := 'Firefly'
      }
    )
  }
) {
  number,
  show: {
    title,
  }
}

# Wrap everything in a `select` to also display the
# entire inserted structure.
select (
  insert Season {
    number := 1,
    show := (
      insert Show {
        title := 'Firefly'
      }
    )
  }
) {
  number,
  show: {
    title,
  }
}

Output Objects

Press the 'Run' button to evaluate the input

Prev NextUpdate

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.