How do I run the csas commands from the shell?
Table of Contents
This file documents the csas resource at the shell, one section per command. Every command is a subcommand of csas, 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:
csas list [--offset <n>] [--limit <n>] [--order <field>] [--desc]
It is addressed at refdata.v1.csas.list.
csas 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:
csas get <id>
It is addressed at refdata.v1.csas.get.
csas 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:
csas get-many <id>
It is addressed at refdata.v1.csas.get_many.
csas 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:
csas add <netting_set_id> <is_active> <bilateral> <csa_currency> <index_name> <threshold_pay> <threshold_receive> <minimum_transfer_amount_pay> <minimum_transfer_amount_receive> <independent_amount_held> <independent_amount_type> <call_frequency> <post_frequency> <margin_period_of_risk> <collateral_compounding_spread_receive> <collateral_compounding_spread_pay> <apply_initial_margin> <initial_margin_type> <calculate_im_amount> <calculate_vm_amount> <non_exempt_im_regulations> <reason> <commentary>
It is addressed at refdata.v1.csas.put.
csas add 00000000-0000-0000-0000-000000000000 false - - - - - - - - - - - - - - - - - - - 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:
csas set <id> <netting_set_id> <is_active> <bilateral> <csa_currency> <index_name> <threshold_pay> <threshold_receive> <minimum_transfer_amount_pay> <minimum_transfer_amount_receive> <independent_amount_held> <independent_amount_type> <call_frequency> <post_frequency> <margin_period_of_risk> <collateral_compounding_spread_receive> <collateral_compounding_spread_pay> <apply_initial_margin> <initial_margin_type> <calculate_im_amount> <calculate_vm_amount> <non_exempt_im_regulations> <reason> <commentary> [--version <n>]
It is addressed at refdata.v1.csas.put.
csas set 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 false - - - - - - - - - - - - - - - - - - - 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:
csas put-many --count <n> <id> <netting_set_id> <is_active> <bilateral> <csa_currency> <index_name> <threshold_pay> <threshold_receive> <minimum_transfer_amount_pay> <minimum_transfer_amount_receive> <independent_amount_held> <independent_amount_type> <call_frequency> <post_frequency> <margin_period_of_risk> <collateral_compounding_spread_receive> <collateral_compounding_spread_pay> <apply_initial_margin> <initial_margin_type> <calculate_im_amount> <calculate_vm_amount> <non_exempt_im_regulations> <reason> <commentary>
It is addressed at refdata.v1.csas.put_many.
csas put-many --count 1 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 false - - - - - - - - - - - - - - - - - - - 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:
csas delete <id> <reason> <commentary> [--version <n>]
It is addressed at refdata.v1.csas.delete.
csas 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:
csas delete-many <id> <reason> <commentary>
It is addressed at refdata.v1.csas.delete_many.
csas delete-many 00000000-0000-0000-0000-000000000000 system.new_record generated_script
1.9. by-netting-set-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:
csas by-netting-set-id <netting_set_id> [--offset <n>] [--limit <n>] [--order <field>] [--desc]
It is addressed at refdata.v1.csas.list_by_netting_set_id.
csas by-netting-set-id 00000000-0000-0000-0000-000000000000 --limit 1
1.10. versions
Reads the row's recorded history, newest first.
The command is shaped like this:
csas versions <id> [--offset <n>] [--limit <n>] [--order <field>] [--desc]
It is addressed at refdata.v1.csas_versions.list.
csas versions 00000000-0000-0000-0000-000000000000 --limit 1
1.11. version
Reads one recorded version of the row.
The command is shaped like this:
csas version <id> --version <n>
It is addressed at refdata.v1.csas_versions.get.
csas version 00000000-0000-0000-0000-000000000000 --version 1