Function deleteProjectRow

notfair-cmo/src/server/db/projects.ts:260–291

(slug: string)

 * shipped a regression test for).
 */
export function deleteProjectRow(slug: string): void {
  const db = getDb();
  const childTables = [
    // tasks must come before scheduled_jobs / sessions because both have
    // optional FK references back to tasks(id) on delete-set-null. Order
    // within the loop otherwise doesn't matter — we just need every
    // child row gone before the parent project row.
    "tasks",
    // approval_comments cascades from approvals.
    "approvals",
    "approval_policies",
    "questions",
    "cost_events",
    "oauth_tokens",
    "mcp_tokens",
    // scheduled_job_runs cascades from scheduled_jobs.
    "scheduled_jobs",
    // transcript_events cascades from sessions.
    "sessions",
    "agent_actions",
    "sequence_runs",
  ];
  for (const table of childTables) {
    try {
      db.prepare(`DELETE FROM ${table} WHERE project_slug = ?`).run(slug);
    } catch {
      // table missing on this install (e.g., older DB pre-migration).
      // Per-table try/catch so one missing table doesn't block the rest.
    }
  }
  db.prepare("DELETE FROM projects WHERE slug = ?").run(slug);
}

/**
 * Per-project hide-list for preset MCP catalog entries. See migration