chore: commit TK-11086 held-set-2 IG delete tooling + audit, v0.0.2 (session close)

a6d11aab8f27643e28ec0383555955a34793e02d · 2026-09-01 17:57:38 -0700 · Steve
Files touched

M data/tk11086-ig-deleted-audit.jsonl
A data/tk11086-ig-heldset2-targets.jsonl
M package-lock.json
M package.json
A scripts/tk11086-ig-delete-heldset2.mjs
Diff

commit a6d11aab8f27643e28ec0383555955a34793e02d
Author: Steve <steve@designerwallcoverings.com>
Date:   Tue Sep 1 17:57:38 2026 -0700

    chore: commit TK-11086 held-set-2 IG delete tooling + audit, v0.0.2 (session close)
---
 data/tk11086-ig-deleted-audit.jsonl    |   7 +++
 data/tk11086-ig-heldset2-targets.jsonl |   7 +++
 package-lock.json                      |   4 +-
 package.json                           |   2 +-
 scripts/tk11086-ig-delete-heldset2.mjs | 104 +++++++++++++++++++++++++++++++++
 5 files changed, 121 insertions(+), 3 deletions(-)

diff --git a/data/tk11086-ig-deleted-audit.jsonl b/data/tk11086-ig-deleted-audit.jsonl
index 355c0dd..46d0dac 100644
--- a/data/tk11086-ig-deleted-audit.jsonl
+++ b/data/tk11086-ig-deleted-audit.jsonl
@@ -89,3 +89,10 @@
 {"ts":"2026-09-02T00:29:27.271Z","account":"wallpaperinstallers","ig_user_id":"17841414900195265","ig_media_id":"18023942297855291","posted_date":"2026-08-20T21:53:37+0000","media_type":"CAROUSEL_ALBUM","caption_snippet":"Novasuede™ Fabric & Wallcovering - Blank Slate Color: Blank Slate Model / SKU: DWCC-112040 Considered materials, faithful color, lasting quality. Designer Wallc","permalink":"https://www.instagram.com/p/DcRxhQKAV3l/","why_flagged":["caption:novasuede","caption:DWCC-sku"],"delete_result":"success","graph_response":{"success":true,"deleted_id":"18023942297855291"}}
 {"ts":"2026-09-02T00:29:31.025Z","account":"wallpaperinstallers","ig_user_id":"17841414900195265","ig_media_id":"18104442041270867","posted_date":"2026-08-20T18:14:53+0000","media_type":"CAROUSEL_ALBUM","caption_snippet":"Novasuede™ Fabric & Wallcovering - Opal Color: Gray Model / SKU: DWCC-112170 Designer-grade quality, ready to specify. Samples to your studio and dedicated serv","permalink":"https://www.instagram.com/p/DcRYfJeG6sg/","why_flagged":["caption:novasuede","caption:DWCC-sku"],"delete_result":"success","graph_response":{"success":true,"deleted_id":"18104442041270867"}}
 {"ts":"2026-09-02T00:29:34.999Z","account":"wallpaperinstallers","ig_user_id":"17841414900195265","ig_media_id":"18101041334260521","posted_date":"2026-08-20T02:54:56+0000","media_type":"CAROUSEL_ALBUM","caption_snippet":"Novasuede™ Fabric & Wallcovering - Shale Color: Gold Model / SKU: DWCC-112280 Crafted to an exacting standard and specified for the trade — Designer Wallcoverin","permalink":"https://www.instagram.com/p/DcPvNMTlH_C/","why_flagged":["caption:novasuede","caption:DWCC-sku"],"delete_result":"success","graph_response":{"success":true,"deleted_id":"18101041334260521"}}
+{"ts":"2026-09-02T00:38:36.742Z","account":"beverlyhillsvideos","ig_user_id":"17841408681887144","ig_media_id":"18128622871671291","posted_date":"2026-08-29T13:00:32+0000","media_type":"VIDEO","caption_snippet":"Jason of Beverly Hills — Jewelry on Rodeo Drive, Beverly Hills. Timeless elegance shines on Rodeo Drive. 📍 Rodeo Drive · Beverly Hills, CA 90210 🛍️ fine jewel","permalink":"https://www.instagram.com/reel/Dcn_oKSjoXA/","why_flagged":["caption:jewelry-terms"],"held_set":2,"delete_result":"success","get_verify":"confirmed-gone","graph_response":{"success":true,"deleted_id":"18128622871671291"}}
+{"ts":"2026-09-02T00:38:40.271Z","account":"beverlyhillsvideos","ig_user_id":"17841408681887144","ig_media_id":"17966082696158287","posted_date":"2026-08-26T13:00:34+0000","media_type":"VIDEO","caption_snippet":"Harry Winston — Jewelry on Rodeo Drive, Beverly Hills. A legacy of brilliance on Rodeo Drive. 📍 Rodeo Drive · Beverly Hills, CA 90210 🛍️ fine jewelry in Bever","permalink":"https://www.instagram.com/reel/DcgRQKYEVGo/","why_flagged":["caption:jewelry-terms"],"held_set":2,"delete_result":"success","get_verify":"confirmed-gone","graph_response":{"success":true,"deleted_id":"17966082696158287"}}
+{"ts":"2026-09-02T00:38:43.628Z","account":"beverlyhillsvideos","ig_user_id":"17841408681887144","ig_media_id":"17949490158036807","posted_date":"2026-08-20T13:00:32+0000","media_type":"VIDEO","caption_snippet":"David Yurman — Jewelry on Rodeo Drive, Beverly Hills. Timeless artistry shines on Rodeo Drive. 📍 Rodeo Drive · Beverly Hills, CA 90210 🛍️ fine jewelry in Beve","permalink":"https://www.instagram.com/reel/DcQ0eV5lwpN/","why_flagged":["caption:jewelry-terms"],"held_set":2,"delete_result":"success","get_verify":"confirmed-gone","graph_response":{"success":true,"deleted_id":"17949490158036807"}}
+{"ts":"2026-09-02T00:38:47.337Z","account":"beverlyhillsvideos","ig_user_id":"17841408681887144","ig_media_id":"17942944269291712","posted_date":"2026-08-20T01:00:35+0000","media_type":"VIDEO","caption_snippet":"David Webb — Jewelry on Rodeo Drive, Beverly Hills. Timeless artistry shines on Rodeo Drive. 📍 Rodeo Drive · Beverly Hills, CA 90210 🛍️ fine jewelry in Beverl","permalink":"https://www.instagram.com/reel/DcPiFKwk4Fh/","why_flagged":["caption:jewelry-terms"],"held_set":2,"delete_result":"success","get_verify":"confirmed-gone","graph_response":{"success":true,"deleted_id":"17942944269291712"}}
+{"ts":"2026-09-02T00:38:51.052Z","account":"beverlyhillsvideos","ig_user_id":"17841408681887144","ig_media_id":"18084353789257461","posted_date":"2026-08-19T01:00:43+0000","media_type":"VIDEO","caption_snippet":"Cartier — Jewelry / Watches on Rodeo Drive, Beverly Hills. Cartier: A legacy of exquisite craftsmanship on Rodeo Drive. 📍 Rodeo Drive · Beverly Hills, CA 90210","permalink":"https://www.instagram.com/reel/DcM9SF4CoJI/","why_flagged":["caption:jewelry-terms"],"held_set":2,"delete_result":"success","get_verify":"confirmed-gone","graph_response":{"success":true,"deleted_id":"18084353789257461"}}
+{"ts":"2026-09-02T00:38:54.992Z","account":"beverlyhillsvideos","ig_user_id":"17841408681887144","ig_media_id":"18109441034168181","posted_date":"2026-08-16T13:00:50+0000","media_type":"VIDEO","caption_snippet":"Bulgari — Jewelry / Watches on Rodeo Drive, Beverly Hills. Timeless elegance graces Rodeo Drive with the Roman artistry of Bulgari. 📍 Rodeo Drive · Beverly Hil","permalink":"https://www.instagram.com/reel/DcGhVl3DZAR/","why_flagged":["caption:jewelry-terms"],"held_set":2,"delete_result":"success","get_verify":"confirmed-gone","graph_response":{"success":true,"deleted_id":"18109441034168181"}}
+{"ts":"2026-09-02T00:38:58.297Z","account":"beverlyhillsvideos","ig_user_id":"17841408681887144","ig_media_id":"18116728696938845","posted_date":"2026-08-16T01:00:32+0000","media_type":"VIDEO","caption_snippet":"Buccellati — Jewelry on Rodeo Drive, Beverly Hills. Timeless artistry, an Italian legacy on Rodeo Drive. 📍 Rodeo Drive · Beverly Hills, CA 90210 🛍️ fine jewel","permalink":"https://www.instagram.com/reel/DcFO5YOAN0J/","why_flagged":["caption:jewelry-terms"],"held_set":2,"delete_result":"success","get_verify":"confirmed-gone","graph_response":{"success":true,"deleted_id":"18116728696938845"}}
diff --git a/data/tk11086-ig-heldset2-targets.jsonl b/data/tk11086-ig-heldset2-targets.jsonl
new file mode 100644
index 0000000..00ba014
--- /dev/null
+++ b/data/tk11086-ig-heldset2-targets.jsonl
@@ -0,0 +1,7 @@
+{"account": "beverlyhillsvideos", "ig_user_id": "17841408681887144", "ig_media_id": "18128622871671291", "posted_date": "2026-08-29T13:00:32+0000", "media_type": "VIDEO", "caption_snippet": "Jason of Beverly Hills \u2014 Jewelry on Rodeo Drive, Beverly Hills. Timeless elegance shines on Rodeo Drive. \ud83d\udccd Rodeo Drive \u00b7 Beverly Hills, CA 90210 \ud83d\udecd\ufe0f fine jewel", "permalink": "https://www.instagram.com/reel/Dcn_oKSjoXA/", "why_flagged": ["caption:jewelry-terms"]}
+{"account": "beverlyhillsvideos", "ig_user_id": "17841408681887144", "ig_media_id": "17966082696158287", "posted_date": "2026-08-26T13:00:34+0000", "media_type": "VIDEO", "caption_snippet": "Harry Winston \u2014 Jewelry on Rodeo Drive, Beverly Hills. A legacy of brilliance on Rodeo Drive. \ud83d\udccd Rodeo Drive \u00b7 Beverly Hills, CA 90210 \ud83d\udecd\ufe0f fine jewelry in Bever", "permalink": "https://www.instagram.com/reel/DcgRQKYEVGo/", "why_flagged": ["caption:jewelry-terms"]}
+{"account": "beverlyhillsvideos", "ig_user_id": "17841408681887144", "ig_media_id": "17949490158036807", "posted_date": "2026-08-20T13:00:32+0000", "media_type": "VIDEO", "caption_snippet": "David Yurman \u2014 Jewelry on Rodeo Drive, Beverly Hills. Timeless artistry shines on Rodeo Drive. \ud83d\udccd Rodeo Drive \u00b7 Beverly Hills, CA 90210 \ud83d\udecd\ufe0f fine jewelry in Beve", "permalink": "https://www.instagram.com/reel/DcQ0eV5lwpN/", "why_flagged": ["caption:jewelry-terms"]}
+{"account": "beverlyhillsvideos", "ig_user_id": "17841408681887144", "ig_media_id": "17942944269291712", "posted_date": "2026-08-20T01:00:35+0000", "media_type": "VIDEO", "caption_snippet": "David Webb \u2014 Jewelry on Rodeo Drive, Beverly Hills. Timeless artistry shines on Rodeo Drive. \ud83d\udccd Rodeo Drive \u00b7 Beverly Hills, CA 90210 \ud83d\udecd\ufe0f fine jewelry in Beverl", "permalink": "https://www.instagram.com/reel/DcPiFKwk4Fh/", "why_flagged": ["caption:jewelry-terms"]}
+{"account": "beverlyhillsvideos", "ig_user_id": "17841408681887144", "ig_media_id": "18084353789257461", "posted_date": "2026-08-19T01:00:43+0000", "media_type": "VIDEO", "caption_snippet": "Cartier \u2014 Jewelry / Watches on Rodeo Drive, Beverly Hills. Cartier: A legacy of exquisite craftsmanship on Rodeo Drive. \ud83d\udccd Rodeo Drive \u00b7 Beverly Hills, CA 90210", "permalink": "https://www.instagram.com/reel/DcM9SF4CoJI/", "why_flagged": ["caption:jewelry-terms"]}
+{"account": "beverlyhillsvideos", "ig_user_id": "17841408681887144", "ig_media_id": "18109441034168181", "posted_date": "2026-08-16T13:00:50+0000", "media_type": "VIDEO", "caption_snippet": "Bulgari \u2014 Jewelry / Watches on Rodeo Drive, Beverly Hills. Timeless elegance graces Rodeo Drive with the Roman artistry of Bulgari. \ud83d\udccd Rodeo Drive \u00b7 Beverly Hil", "permalink": "https://www.instagram.com/reel/DcGhVl3DZAR/", "why_flagged": ["caption:jewelry-terms"]}
+{"account": "beverlyhillsvideos", "ig_user_id": "17841408681887144", "ig_media_id": "18116728696938845", "posted_date": "2026-08-16T01:00:32+0000", "media_type": "VIDEO", "caption_snippet": "Buccellati \u2014 Jewelry on Rodeo Drive, Beverly Hills. Timeless artistry, an Italian legacy on Rodeo Drive. \ud83d\udccd Rodeo Drive \u00b7 Beverly Hills, CA 90210 \ud83d\udecd\ufe0f fine jewel", "permalink": "https://www.instagram.com/reel/DcFO5YOAN0J/", "why_flagged": ["caption:jewelry-terms"]}
diff --git a/package-lock.json b/package-lock.json
index 6e53dbf..21c2291 100644
--- a/package-lock.json
+++ b/package-lock.json
@@ -7,7 +7,7 @@
       "dependencies": {
         "playwright-core": "^1.62.1"
       },
-      "version": "0.0.1"
+      "version": "0.0.2"
     },
     "node_modules/playwright-core": {
       "version": "1.62.1",
@@ -22,5 +22,5 @@
       }
     }
   },
-  "version": "0.0.1"
+  "version": "0.0.2"
 }
diff --git a/package.json b/package.json
index 1061e67..35a8d4d 100644
--- a/package.json
+++ b/package.json
@@ -2,5 +2,5 @@
   "dependencies": {
     "playwright-core": "^1.62.1"
   },
-  "version": "0.0.1"
+  "version": "0.0.2"
 }
diff --git a/scripts/tk11086-ig-delete-heldset2.mjs b/scripts/tk11086-ig-delete-heldset2.mjs
new file mode 100644
index 0000000..023f2e9
--- /dev/null
+++ b/scripts/tk11086-ig-delete-heldset2.mjs
@@ -0,0 +1,104 @@
+#!/usr/bin/env node
+// TK-11086 HELD SET #2 — IRREVERSIBLE Instagram deletion of the 7 Rodeo Drive
+// jewelry-store reels on @beverlyhillsvideos that matched ONLY on the word
+// "jewelry" (why_flagged == ["caption:jewelry-terms"]).
+// Steve answered the final clarify gate: NO to keeping them -> DELETE.
+//
+// Deletes ONLY the exact 7 media IDs in data/tk11086-ig-heldset2-targets.jsonl.
+// DELETE graph.facebook.com/v21.0/{ig-media-id}; verifies each with a follow-up
+// GET (expects "Unsupported get request"). Every deletion logged to:
+//   - data/tk11086-ig-deleted-audit.jsonl (per-delete audit record)
+//   - ~/.claude/yolo-queue/executed-reversible/ledger.jsonl
+//       (undo = "IRREVERSIBLE — Steve-authorized IG deletion TK-11086 held-set-2")
+// SAFETY: DRY-RUN by default; real deletes require --apply. Hard-caps at 7 rows.
+import fs from 'node:fs';
+import path from 'node:path';
+import { fileURLToPath } from 'node:url';
+import { homedir } from 'node:os';
+
+const __dirname = path.dirname(fileURLToPath(import.meta.url));
+const ROOT = path.resolve(__dirname, '..');
+const V = 'https://graph.facebook.com/v21.0';
+const args = process.argv.slice(2);
+const APPLY = args.includes('--apply');
+
+function token() {
+  if (process.env.IG_ACCESS_TOKEN) return process.env.IG_ACCESS_TOKEN;
+  const p = path.join(homedir(), 'Projects/Norma/agents/instagram-agent/.env');
+  const m = fs.readFileSync(p, 'utf8').match(/^IG_ACCESS_TOKEN=(.+)$/m);
+  return m ? m[1].trim() : null;
+}
+const TOK = token();
+if (!TOK) { console.error('no IG_ACCESS_TOKEN'); process.exit(1); }
+
+const TARGETS = path.join(ROOT, 'data/tk11086-ig-heldset2-targets.jsonl');
+const AUDIT = path.join(ROOT, 'data/tk11086-ig-deleted-audit.jsonl');
+const LEDGER = path.join(homedir(), '.claude/yolo-queue/executed-reversible/ledger.jsonl');
+const rows = fs.readFileSync(TARGETS, 'utf8').trim().split('\n').map(l => JSON.parse(l));
+
+// RAIL: exact held set only — refuse to widen.
+if (rows.length !== 7) { console.error(`REFUSING: expected 7 targets, got ${rows.length}`); process.exit(1); }
+for (const r of rows) {
+  if (r.account !== 'beverlyhillsvideos' || JSON.stringify(r.why_flagged) !== JSON.stringify(['caption:jewelry-terms'])) {
+    console.error(`REFUSING: target ${r.ig_media_id} is not a held-set-2 jewelry reel`); process.exit(1);
+  }
+}
+
+const sleep = ms => new Promise(r => setTimeout(r, ms));
+console.log(`Held-set-2 targets: ${rows.length}  | mode: ${APPLY ? 'APPLY (LIVE IRREVERSIBLE DELETE)' : 'DRY-RUN (no deletes)'}`);
+
+let deleted = 0, gone = 0, err = 0;
+for (const r of rows) {
+  if (!APPLY) { console.log(`  + WOULD delete ${r.account} ${r.ig_media_id} — ${r.caption_snippet.slice(0,40)}`); continue; }
+  const url = `${V}/${r.ig_media_id}?access_token=${encodeURIComponent(TOK)}`;
+  let res, body;
+  try {
+    res = await fetch(url, { method: 'DELETE' });
+    body = await res.text();
+  } catch (e) { console.log(`  ! ${r.account} ${r.ig_media_id}: fetch error ${e.message}`); err++; await sleep(400); continue; }
+  let d; try { d = JSON.parse(body); } catch { d = { raw: body }; }
+  const success = d && d.success === true;
+  const alreadyGone = !success && /does not exist|Unsupported.*request|cannot be loaded/i.test(body);
+
+  // Follow-up GET verify (expects "Unsupported get request" once gone)
+  let verifyResult = 'skipped';
+  if (success || alreadyGone) {
+    await sleep(300);
+    try {
+      const gr = await fetch(`${V}/${r.ig_media_id}?fields=id&access_token=${encodeURIComponent(TOK)}`);
+      const gt = await gr.text();
+      verifyResult = /Unsupported get request|does not exist|cannot be loaded/i.test(gt) ? 'confirmed-gone' : `still-present:${gt.slice(0,80)}`;
+    } catch (e) { verifyResult = `verify-fetch-error:${e.message}`; }
+  }
+
+  const rec = {
+    ts: new Date().toISOString(),
+    account: r.account,
+    ig_user_id: r.ig_user_id,
+    ig_media_id: r.ig_media_id,
+    posted_date: r.posted_date,
+    media_type: r.media_type,
+    caption_snippet: r.caption_snippet,
+    permalink: r.permalink,
+    why_flagged: r.why_flagged,
+    held_set: 2,
+    delete_result: success ? 'success' : (alreadyGone ? 'already-gone' : 'error'),
+    get_verify: verifyResult,
+    graph_response: d,
+  };
+  fs.appendFileSync(AUDIT, JSON.stringify(rec) + '\n');
+  if (success) {
+    deleted++;
+    console.log(`  ✓ deleted ${r.account} ${r.ig_media_id} | GET-verify: ${verifyResult}`);
+    fs.appendFileSync(LEDGER, JSON.stringify({
+      ts: rec.ts, agent: 'vp-dw-marketing', ticket: 'TK-11086',
+      action: `IG DELETE ${r.account} media ${r.ig_media_id} (${r.posted_date}) — Rodeo Drive jewelry reel (held-set-2)`,
+      blast_radius: 1,
+      undo_cmd: 'IRREVERSIBLE — Steve-authorized IG deletion TK-11086 held-set-2',
+      verify: `GET ${V}/${r.ig_media_id} returns "Unsupported get request" (${verifyResult})`,
+    }) + '\n');
+  } else if (alreadyGone) { gone++; console.log(`  = ${r.account} ${r.ig_media_id}: already gone | GET-verify: ${verifyResult}`); }
+  else { err++; console.log(`  ! ${r.account} ${r.ig_media_id}: ${JSON.stringify(d).slice(0,140)}`); }
+  await sleep(400);
+}
+console.log(`\n=== HELD-SET-2 RESULT ===  deleted=${deleted}  already-gone=${gone}  errors=${err}  audit=${AUDIT}`);
← 66dba82 TK-11086: IG deletion of 91 Novasuede posts (last 20d, Steve · back to Majilite Jewelry Cases · (newest)