-- Coverage reports from OxygenFlow jobs (oxygenhub#113): a job's artifact

-- named `coverage` (LCOV) is parsed when uploaded. The totals and each

-- file's counts are kept here; the per-line counts stay in the artifact's

-- blob and are read again for the file view.

CREATE TABLE coverage_reports (

    id               INTEGER PRIMARY KEY,

    repo_id          INTEGER NOT NULL REFERENCES repositories(id) ON DELETE CASCADE,

    run_id           INTEGER NOT NULL REFERENCES flow_runs(id) ON DELETE CASCADE,

    job_id           INTEGER NOT NULL UNIQUE,

    job              TEXT NOT NULL,

    run_number       INTEGER NOT NULL,

    bookmark         TEXT NOT NULL,

    state            TEXT NOT NULL,

    heads            TEXT NOT NULL,

    blob             TEXT NOT NULL,

    format           TEXT NOT NULL,

    lines_found      INTEGER NOT NULL,

    lines_hit        INTEGER NOT NULL,

    functions_found  INTEGER NOT NULL,

    functions_hit    INTEGER NOT NULL,

    branches_found   INTEGER NOT NULL,

    branches_hit     INTEGER NOT NULL,

    -- Every run of every instrumented line, added up: hits per line.

    hits             INTEGER NOT NULL DEFAULT 0,

    files            INTEGER NOT NULL,

    -- Files the report named that are not in the run's state.

    dropped          INTEGER NOT NULL,

    created_ms       INTEGER NOT NULL

);

CREATE INDEX coverage_reports_bookmark ON coverage_reports (repo_id, bookmark, created_ms);

CREATE TABLE coverage_files (

    report_id        INTEGER NOT NULL REFERENCES coverage_reports(id) ON DELETE CASCADE,

    path             TEXT NOT NULL,

    lines_found      INTEGER NOT NULL,

    lines_hit        INTEGER NOT NULL,

    functions_found  INTEGER NOT NULL,

    functions_hit    INTEGER NOT NULL,

    branches_found   INTEGER NOT NULL,

    branches_hit     INTEGER NOT NULL,

    PRIMARY KEY (report_id, path)

);