How do I run the sandbox_members commands from the shell?
Table of Contents
This file documents the sandbox_members resource at the shell, one section per command. Every command is a subcommand of sandbox_members, and every section exports its own script into projects/ores.shell/scripts/library/. Loading a script runs that one command, so a failure names the command it came from.
1. Commands
1.1. list
Reads one page of the collection. Nothing addresses it but the caller's tenant, so it is the read that shows what exists.
The command is shaped like this:
sandbox_members list [--offset <n>] [--limit <n>] [--order <field>] [--desc]
It is addressed at refdata.v1.sandbox_members.list.
sandbox_members list --limit 1
1.2. get
Reads the one row its key addresses. A key states every identifying column, so a partial key is refused rather than answered with an arbitrary row.
The command is shaped like this:
sandbox_members get <id>
It is addressed at refdata.v1.sandbox_members.get.
sandbox_members get 00000000-0000-0000-0000-000000000000
1.3. get-many
Reads several rows in one request, one key group per row.
The command is shaped like this:
sandbox_members get-many <id>
It is addressed at refdata.v1.sandbox_members.get_many.
sandbox_members get-many 00000000-0000-0000-0000-000000000000
1.4. add
Writes a row. The change states that the row must not exist, so a create that collides with an existing row is refused rather than replacing it. The change carries a reason and a commentary, which the server records on it so the row's history says why it moved.
The command is shaped like this:
sandbox_members add <sandbox_id> <account_id> <reason> <commentary>
It is addressed at refdata.v1.sandbox_members.put.
sandbox_members add 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 system.new_record generated_script
1.5. set
Writes a row. The change states no precondition, so it replaces whatever row the key already addresses. The change carries a reason and a commentary, which the server records on it so the row's history says why it moved. Passing –version makes the write conditional on the version the caller last read.
The command is shaped like this:
sandbox_members set <id> <sandbox_id> <account_id> <reason> <commentary> [--version <n>]
It is addressed at refdata.v1.sandbox_members.put.
sandbox_members set 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 system.new_record generated_script
1.6. put-many
Writes several rows in one request. The count states how many field groups follow. The change carries a reason and a commentary, which the server records on it so the row's history says why it moved.
The command is shaped like this:
sandbox_members put-many --count <n> <id> <sandbox_id> <account_id> <reason> <commentary>
It is addressed at refdata.v1.sandbox_members.put_many.
sandbox_members put-many --count 1 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 system.new_record generated_script
1.7. delete
Removes a row. The change carries a reason and a commentary, which the server records on it so the row's history says why it moved. Passing –version makes the write conditional on the version the caller last read.
The command is shaped like this:
sandbox_members delete <id> <reason> <commentary> [--version <n>]
It is addressed at refdata.v1.sandbox_members.delete.
sandbox_members delete 00000000-0000-0000-0000-000000000000 system.new_record generated_script
1.8. delete-many
Removes several rows in one request. The change carries a reason and a commentary, which the server records on it so the row's history says why it moved.
The command is shaped like this:
sandbox_members delete-many <id> <reason> <commentary>
It is addressed at refdata.v1.sandbox_members.delete_many.
sandbox_members delete-many 00000000-0000-0000-0000-000000000000 system.new_record generated_script
1.9. by-sandbox-id
Reads one page of the rows that share a relation value. The relation is part of the address rather than a filter applied after the read.
The command is shaped like this:
sandbox_members by-sandbox-id <sandbox_id> [--offset <n>] [--limit <n>] [--order <field>] [--desc]
It is addressed at refdata.v1.sandbox_members.list_by_sandbox_id.
sandbox_members by-sandbox-id 00000000-0000-0000-0000-000000000000 --limit 1
1.10. by-account-id
Reads one page of the rows that share a relation value. The relation is part of the address rather than a filter applied after the read.
The command is shaped like this:
sandbox_members by-account-id <account_id> [--offset <n>] [--limit <n>] [--order <field>] [--desc]
It is addressed at refdata.v1.sandbox_members.list_by_account_id.
sandbox_members by-account-id 00000000-0000-0000-0000-000000000000 --limit 1
1.11. versions
Reads the row's recorded history, newest first.
The command is shaped like this:
sandbox_members versions <id> [--offset <n>] [--limit <n>] [--order <field>] [--desc]
It is addressed at refdata.v1.sandbox_members_versions.list.
sandbox_members versions 00000000-0000-0000-0000-000000000000 --limit 1
1.12. version
Reads one recorded version of the row.
The command is shaped like this:
sandbox_members version <id> --version <n>
It is addressed at refdata.v1.sandbox_members_versions.get.
sandbox_members version 00000000-0000-0000-0000-000000000000 --version 1