load

✅  add and commit data to a pool

Synopsis

load <pool>[@<branch>] [ ( [author <author>] [message <message>] [meta <meta>] ) ] 

Note

The load operator is exclusively for working with a database and is not available when running super detached from a database.

Description

The load operator populates the specified <pool> with the values it receives as input. Much like how super db load is used at the command line to populate a pool with data from files, streams, and URIs, the load operator is used to save query results from your SuperSQL query to a pool in the same database. <pool> is a string indicating the name or ID of the destination pool. If the optional @<branch> string is included then the data will be committed to an existing branch of that name, otherwise the main branch is assumed. The author, message, and meta strings may also be provided to further describe the committed data, similar to the same super db load options.

Input Data

Examples below assume the existence of a database created and populated by the following commands:

export SUPER_DB=example super db -q init super db -q create -orderby flip:asc coinflips super db branch -q -use coinflips onlytails echo '{flip:1,result:"heads"} {flip:2,result:"tails"}' | super db load -q -use coinflips - super db -q create -orderby flip:asc bigflips super db -f line -c ' from :branches | values pool.name || "@" || branch.name | sort' 

The database then contains the two pools:

bigflips@main coinflips@main coinflips@onlytails 

Examples

Modify some values, load them into the main branch of our empty bigflips pool, and see what was loaded

super db -db example -c ' from coinflips | result:=upper(result) | load bigflips ' > /dev/null super db -db example -s -c 'from bigflips' 

=>

{flip:1,result:"HEADS"} {flip:2,result:"TAILS"} 

Add a filtered subset of records to our onlytails branch, while also adding metadata

super db -db example -c ' from coinflips | result=="tails" | load coinflips@onlytails ( author "Steve" message "A subset" meta "\"Additional metadata\"" ) ' > /dev/null super db -db example -s -c 'from coinflips@onlytails' 

=>

{flip:2,result:"tails"}