const commitId = db.vcs.logCommit({
  vcs_type: "git",
  commit_hash: "abc123def",
  change_id: "CABC123",
  message: "feat: Add user authentication",
  author: "claude",
  files_changed: ["src/auth.ts"],
  insertions: 150,
  deletions: 20,
  smithers_metadata: { phase: "implementation" },
});

const commits = db.vcs.getCommits(10);

const commit = db.vcs.getCommit("abc123def", "git");

const snapshotId = db.vcs.logSnapshot({
  change_id: "CXYZ789",
  description: "Before refactoring auth module",
  commit_hash: "abc123def",
  files_modified: ["src/auth.ts"],
  files_added: ["src/auth.test.ts"],
  files_deleted: [],
  has_conflicts: false,
});

const snapshots = db.vcs.getSnapshots(10);

const reviewId = db.vcs.logReview({
  target_type: "commit",
  target_ref: "abc123def",
  approved: false,
  summary: "Security issues found",
  issues: [
    {
      severity: "critical",
      file: "src/auth.ts",
      line: 42,
      message: "SQL injection vulnerability",
      suggestion: "Use parameterized queries",
    },
  ],
  reviewer_model: "sonnet",
  blocking: true,
});

db.vcs.updateReview(reviewId, {
  posted_to_github: true,
  posted_to_git_notes: true,
});

const reviews = db.vcs.getReviews(10);

const blocking = db.vcs.getBlockingReviews();
if (blocking.length > 0) {
  console.log("Cannot proceed - blocking reviews exist");
}

db.vcs.addReport({
  type: "progress",
  severity: "info",
  title: "Phase Complete",
  content: "Research phase completed successfully",
  data: { phase: "research", duration_ms: 5000 },
});

db.vcs.addReport({
  type: "finding",
  severity: "warning",
  title: "Potential Issue",
  content: "Found deprecated API usage",
  agent_id: agentId,
});

db.vcs.addReport({
  type: "error",
  severity: "critical",
  title: "Build Failed",
  content: "TypeScript compilation errors",
});

// All reports
const reports = db.vcs.getReports();

// By type
const errors = db.vcs.getReports("error", 10);

const critical = db.vcs.getCriticalReports();
if (critical.length > 0) {
  console.error("Critical issues detected!");
}

interface Commit {
  id: string;
  execution_id: string;
  agent_id?: string;
  vcs_type: "git" | "jj";
  commit_hash: string;
  change_id?: string;
  message: string;
  author?: string;
  files_changed?: string[];
  insertions?: number;
  deletions?: number;
  smithers_metadata?: Record<string, any>;
  created_at: Date;
}

interface Snapshot {
  id: string;
  execution_id: string;
  change_id: string;
  commit_hash?: string;
  description?: string;
  files_modified?: string[];
  files_added?: string[];
  files_deleted?: string[];
  has_conflicts: boolean;
  created_at: Date;
}

interface Review {
  id: string;
  execution_id: string;
  agent_id?: string;
  target_type: "commit" | "diff" | "pr" | "files";
  target_ref?: string;
  approved: boolean;
  summary: string;
  issues: ReviewIssue[];
  approvals?: ReviewApproval[];
  reviewer_model?: string;
  blocking: boolean;
  posted_to_github: boolean;
  posted_to_git_notes: boolean;
  created_at: Date;
}

interface ReviewIssue {
  severity: "critical" | "major" | "minor" | "suggestion";
  file?: string;
  line?: number;
  message: string;
  suggestion?: string;
}

interface ReviewApproval {
  aspect: string;
  reason: string;
}

interface Report {
  id: string;
  execution_id: string;
  agent_id?: string;
  type: "progress" | "finding" | "warning" | "error" | "metric" | "decision";
  title: string;
  content: string;
  data?: Record<string, any>;
  severity: "info" | "warning" | "critical";
  created_at: Date;
}