AkurAI-Build

Latest change ce4b48cfe1decc20a4f7243fa2b30fb78a3e0f12 - worker: hourly stale-workspace pruning; writable-home sandbox docs by Ólafur Búi Ólafsson

ALTER TABLE runs ADD COLUMN issue_identifier TEXT CHECK (issue_identifier IS NULL OR length(issue_identifier) BETWEEN 1 AND 256);
ALTER TABLE runs ADD COLUMN workload_window_id TEXT CHECK (workload_window_id IS NULL OR length(workload_window_id) BETWEEN 1 AND 256);
ALTER TABLE jobs ADD COLUMN issue_identifier TEXT CHECK (issue_identifier IS NULL OR length(issue_identifier) BETWEEN 1 AND 256);
ALTER TABLE jobs ADD COLUMN workload_window_id TEXT CHECK (workload_window_id IS NULL OR length(workload_window_id) BETWEEN 1 AND 256);
ALTER TABLE artifacts ADD COLUMN issue_identifier TEXT CHECK (issue_identifier IS NULL OR length(issue_identifier) BETWEEN 1 AND 256);
ALTER TABLE artifacts ADD COLUMN workload_window_id TEXT CHECK (workload_window_id IS NULL OR length(workload_window_id) BETWEEN 1 AND 256);
ALTER TABLE artifacts ADD COLUMN peak_rss_bytes INTEGER CHECK (peak_rss_bytes IS NULL OR peak_rss_bytes >= 0);
ALTER TABLE artifacts ADD COLUMN cpu_time_ms REAL CHECK (cpu_time_ms IS NULL OR cpu_time_ms >= 0);
ALTER TABLE artifacts ADD COLUMN binary_size_bytes INTEGER CHECK (binary_size_bytes IS NULL OR binary_size_bytes >= 0);
ALTER TABLE artifacts ADD COLUMN throughput REAL CHECK (throughput IS NULL OR throughput >= 0);
ALTER TABLE artifacts ADD COLUMN latency_p50_ms REAL CHECK (latency_p50_ms IS NULL OR latency_p50_ms >= 0);
ALTER TABLE artifacts ADD COLUMN latency_p95_ms REAL CHECK (latency_p95_ms IS NULL OR latency_p95_ms >= 0);
ALTER TABLE artifacts ADD COLUMN latency_p99_ms REAL CHECK (latency_p99_ms IS NULL OR latency_p99_ms >= 0);
CREATE TABLE profile_baselines (
    id INTEGER PRIMARY KEY,
    repository_id INTEGER NOT NULL REFERENCES repositories(id) ON DELETE CASCADE,
    run_id INTEGER NOT NULL REFERENCES runs(id) ON DELETE CASCADE,
    job_id INTEGER NOT NULL REFERENCES jobs(id) ON DELETE CASCADE,
    commit_sha TEXT NOT NULL CHECK (length(commit_sha) IN (40, 64)),
    branch TEXT NOT NULL,
    median_latency_ms REAL NOT NULL CHECK (median_latency_ms >= 0),
    cpu_time_ms REAL NOT NULL CHECK (cpu_time_ms >= 0),
    peak_rss_bytes INTEGER NOT NULL CHECK (peak_rss_bytes >= 0),
    accepted INTEGER NOT NULL CHECK (accepted IN (0,1)),
    regression_reason TEXT,
    created_at INTEGER NOT NULL DEFAULT (unixepoch()),
    UNIQUE(run_id, job_id)
) STRICT;
CREATE INDEX profile_baselines_lookup ON profile_baselines(repository_id, branch, accepted, created_at DESC);
PRAGMA user_version = 6;