Module: Henitai::MutantHistoryStore::Sql

Defined in:

lib/henitai/mutant_history_store/sql.rb

Overview

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

Constant Summary

RUNS_TABLE =

<<~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 =

<<~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 =

<<~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

UPSERT_MUTANT =

<<~SQL
  INSERT INTO mutants (
    mutant_id,
    first_seen_version,
    first_seen_at,
    last_seen_version,
    last_seen_at,
    current_status,
    status_history,
    days_alive
  ) 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
SQL