Skip to content

Instantly share code, notes, and snippets.

@devth

devth/update-chidori-qa.fish

Created May 11, 2026 21:30
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save devth/8855dfb1c01f75b13427bdb567b8f92e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save devth/8855dfb1c01f75b13427bdb567b8f92e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
update-chidori-qa.fish
cd ~/anduril/forge
pwd
read -s chidori_pat
set -gx CHIDORI_PAT "$chidori_pat"
# Pull the QA DATABASE_URL directly from 1Password with the op CLI.
set -gx QA_DATABASE_URL_ITEM_URL "https://start.1password.com/open/i?a=FFKOXCXTT5ADRCX2CIABM7VJEQ&v=fedf73cignfpybpmqoefuztyb4&i=35nyjmnpr2mbhyt6bjladdgcbm&h=anduril.1password.com"
set -gx DATABASE_URL (op item get "$QA_DATABASE_URL_ITEM_URL" --account anduril.1password.com --fields label=DATABASE_URL --reveal)
set -gx READER_DATABASE_URL "$DATABASE_URL"
# Quick connection check. psql/libpq does not understand Prisma's `?schema=...` query param.
set -gx PSQL_DATABASE_URL (string replace -r '\?.*$' '' "$DATABASE_URL")
psql "$PSQL_DATABASE_URL" -c 'select current_database(), current_user, version();'
npx tsx apps/web/scripts/prisma-scripts/backfill-service-account-tokens.ts
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment