EdgeQL Tutorial

Upsert

Subtopics

There are times when rather than an "upsert" you need to select an object or insert it, if it wasn't there. Consider, for example, the functionality to create a new account or retrieve an existing one:

Input
Run
Output Objects
Press the 'Run' button to evaluate the input

You can experiment with creating accounts with different usernames and see whether they seem to be fetching a pre-existing record or not by looking at the id or watchlist.

Input
Run
Output Objects
Press the 'Run' button to evaluate the input