Function dbPatch

packages/core/src/scripts/db/patch.ts:694–803

(args: string[])

// ─── Entry point ────────────────────────────────────────────────────────────

export default async function dbPatch(args: string[]): Promise<void> {
  const parsed = parseArgs(args);

  if (parsed.help === "true") {
    console.log(`Usage: pnpm action db-patch --table <t> --column <c> --where "<clause>" [edit flags]

Surgical search-and-replace on a text column. Avoids re-sending the full
column value — ideal for large strings (documents, slides, dashboards, JSON).

Required:
  --table <name>        Target table (identifier; no quoting)
  --column <name>       Target text column (identifier; no quoting)
  --where "<clause>"    SQL WHERE clause that matches exactly one row

Edit mode (pick one):
  --find <text>         Text to find (single edit; default replace = "")
  --replace <text>      Replacement text (used with --find)
  --edits <json>        Batch: JSON array of {find, replace} objects
  --json-ops <json>     Structural JSON edits on a JSON column — array of ops:
                          { op: "set",     path, value }    → set/replace at path
                          { op: "remove",  path }           → delete at path
                          { op: "insert",  path, value }    → insert into array
                          { op: "move",    from, path }     → move node
                          { op: "move-before", from, path } → move, stable indexing
                        Paths use JSON Pointer ("/panels/3/title").
                        Much safer than string patches for JSON columns
                        (dashboards, forms, slide decks).

Options:
  --all                 Replace every occurrence of each 'find' (default: first only)
  --format json         Output as JSON
  --help                Show this help

Examples:
  # Fix a typo in one document
  pnpm action db-patch --table documents --column content \\
    --where "id='abc'" --find "teh" --replace "the"

  # Batch edits on a deck's JSON blob
  pnpm action db-patch --table decks --column data --where "id='d1'" \\
    --edits '[{"find":"\\"Q3\\"","replace":"\\"Q4\\""},{"find":"$1M","replace":"$1.2M"}]'

When to use db-patch vs other tools:
  Large text field, small edit                → db-patch (this)
  Short field or multi-column set             → db-exec UPDATE
  Domain action exists (edit-document, ...)   → use that action (syncs live
                                                to open collaborative editors)
`);
    return;
  }

  const table = parsed.table;
  const column = parsed.column;
  const where = parsed.where;

  if (!table) fail("--table is required");
  if (!column) fail("--column is required");
  if (!where) fail("--where is required");