Insert

Subtopics

One way to insert multiple pieces of data in a single command is to use the for query. Basically, this construct allows you to iterate over some input set and perform some operation on each element. It's somewhat like invoking a function element-wise on the input set, without having to define the function.

Consider the following example that uses JSON as its input (which could come from some external source or even be passed as a parameter):

Input

Run

with
  input_data := to_json('{
    "title": "Star Trek: Voyager",
    "seasons": [1, 2, 3, 4, 5, 6, 7]
  }'),
  title := <str>input_data['title'],
  seasons := <array<int64>>input_data['seasons'],
  voyager := (insert Show { title := <str>title })
# Unpack the seasons array as a set. Then insert the 
# corresponding number of seasons for the show.
for num in array_unpack(seasons)
union (
  insert Season {
    number := num,
    show := voyager
  }
);

with
  input_data := to_json('{
    "title": "Star Trek: Voyager",
    "seasons": [1, 2, 3, 4, 5, 6, 7]
  }'),
  title := <str>input_data['title'],
  seasons := <array<int64>>input_data['seasons'],
  voyager := (insert Show { title := <str>title })
# Unpack the seasons array as a set. Then insert the 
# corresponding number of seasons for the show.
for num in array_unpack(seasons)
union (
  insert Season {
    number := num,
    show := voyager
  }
);

Output Objects

Press the 'Run' button to evaluate the input

Let's see what we've just inserted:

Input

Run

select Show {
  title,
  num_seasons,
  seasons := .<show[is Season] {
      number
  }
} filter .title like '%Voyager';

select Show {
  title,
  num_seasons,
  seasons := .<show[is Season] {
      number
  }
} filter .title like '%Voyager';

Output Objects

Press the 'Run' button to evaluate the input

Prev Next