Bulk operations — jsn

Update thousands of records by query. Dry-run by default — preview before you commit.

CommandWhat it does
jsn records bulk --table incident --query "active=true" --set '{"state":"2"}'Dry-run: shows the count + sample first
jsn records bulk ... --executeCommit after reviewing
$ jsn records bulk
$ jsn records bulk \
    --table incident \
    --query "active=true" \
    --set '{"state":"2"}'

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
  ⚠  Default update set in scope [x_8821_test]
  Changes are contained to this scope, but a named
  update set is still recommended for tracking.
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Dry run: 40 record(s) in incident would be updated

Get started

Install, point it at your instance, then run this feature.

$ npm install -g @jacebenson/jsn
$ jsn setup
$ jsn records bulk --table incident --query "active=true" --set '{"state":"2"}'
Full setup guide & skill docs →

← All features