Module: Henitai::MutantHistoryStore::Sql

Defined in:: lib/henitai/mutant_history_store/sql.rb,
sig/henitai.rbs

Overview

SQL statements used by Henitai::MutantHistoryStore to create the schema and persist run/mutant rows in the SQLite history database.

Constant Summary collapse

RUNS_TABLE = Returns: (String)

<<~SQL
  CREATE TABLE IF NOT EXISTS runs (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    version TEXT NOT NULL,
    recorded_at TEXT NOT NULL,
    mutation_score REAL,
    mutation_score_indicator REAL,
    equivalence_uncertainty TEXT,
    total_mutants INTEGER NOT NULL,
    killed_mutants INTEGER NOT NULL,
    survived_mutants INTEGER NOT NULL,
    timeout_mutants INTEGER NOT NULL,
    equivalent_mutants INTEGER NOT NULL
  );
SQL

MUTANTS_TABLE = Returns: (String)

<<~SQL
  CREATE TABLE IF NOT EXISTS mutants (
    mutant_id TEXT PRIMARY KEY,
    first_seen_version TEXT NOT NULL,
    first_seen_at TEXT NOT NULL,
    last_seen_version TEXT NOT NULL,
    last_seen_at TEXT NOT NULL,
    current_status TEXT NOT NULL,
    status_history TEXT NOT NULL,
    days_alive INTEGER NOT NULL
  );
SQL

INSERT_RUN = Returns: (String)

<<~SQL
  INSERT INTO runs (
    version,
    recorded_at,
    mutation_score,
    mutation_score_indicator,
    equivalence_uncertainty,
    total_mutants,
    killed_mutants,
    survived_mutants,
    timeout_mutants,
    equivalent_mutants
  ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SQL

MIGRATION_COLUMNS = Nullable verdict-cache columns added after the initial release; see MIGRATION_COLUMNS. Old rows keep NULL there, which the incremental filter treats as never-reusable — the correct conservative behavior. Returns: (Hash[String, String])

{
  "subject_source_hash" => "TEXT",
  "covered_tests_fingerprint" => "TEXT"
}.freeze

UPSERT_MUTANT = Returns: (String)

<<~SQL
  INSERT INTO mutants (
    mutant_id,
    first_seen_version,
    first_seen_at,
    last_seen_version,
    last_seen_at,
    current_status,
    status_history,
    days_alive,
    subject_source_hash,
    covered_tests_fingerprint
  ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  ON CONFLICT(mutant_id) DO UPDATE SET
    last_seen_version = excluded.last_seen_version,
    last_seen_at = excluded.last_seen_at,
    current_status = excluded.current_status,
    status_history = excluded.status_history,
    days_alive = excluded.days_alive,
    subject_source_hash = excluded.subject_source_hash,
    covered_tests_fingerprint = excluded.covered_tests_fingerprint
SQL

VERDICT_LOOKUP = Returns: (String)

<<~SQL
  SELECT current_status, subject_source_hash, covered_tests_fingerprint
  FROM mutants
  WHERE mutant_id = ?
SQL