mirror of
https://github.com/hanzoai/insights.git
synced 2026-10-30 16:15:31 +00:00
zeekay
1b367e2b62
The tree was a debranded snapshot of upstream taken around 2026-02-20, and upstream has moved about five months since. This replaces it with upstream master, mechanically re-derived: bin/debrand does the rename, and the pipeline and squashed migrations are restored from the shipped tree. Not a merge. The previous import replaced the tree wholesale in a single commit, so there is no shared content history to merge against. Reproducing the rename on the new tree is what actually converges. What survives: .hanzo/workflows, the Dockerfiles and bin/docker* entrypoints, compose files, LLM.md, and insights/migrations. The squashed initial migration is load-bearing — the live database records it by name, so upstream's ~918 individual migrations cannot come back. Nine products are dropped as unreferenced. Twenty-one more that we do not run are kept anyway because the core app still imports them; unpicking those is a refactor and does not belong in a rebase. This base does not build yet, and the reasons are not in the rename: upstream now wants Python 3.13.13 against our 3.12.12 and Django 5.2 against our 4.2, and the dependency manifests still name upstream packages that we republish under our own names. Those are decisions, not renames.
44 lines
1.3 KiB
SQL
44 lines
1.3 KiB
SQL
CREATE TYPE CyclotronJobStatus AS ENUM(
|
|
'available',
|
|
'running',
|
|
'completed',
|
|
'failed',
|
|
'canceled'
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS cyclotron_jobs (
|
|
id UUID PRIMARY KEY,
|
|
team_id INT NOT NULL,
|
|
function_id UUID,
|
|
queue_name TEXT NOT NULL,
|
|
status CyclotronJobStatus NOT NULL,
|
|
priority SMALLINT NOT NULL,
|
|
scheduled TIMESTAMPTZ NOT NULL,
|
|
created TIMESTAMPTZ NOT NULL,
|
|
lock_id UUID,
|
|
last_heartbeat TIMESTAMPTZ,
|
|
janitor_touch_count SMALLINT NOT NULL DEFAULT 0,
|
|
transition_count SMALLINT NOT NULL DEFAULT 0,
|
|
last_transition TIMESTAMPTZ NOT NULL,
|
|
parent_run_id TEXT,
|
|
state BYTEA
|
|
);
|
|
|
|
-- Dequeue: workers SELECT available jobs ordered by priority then scheduled time
|
|
CREATE INDEX idx_cyclotron_jobs_dequeue
|
|
ON cyclotron_jobs (queue_name, priority, scheduled)
|
|
WHERE status = 'available';
|
|
|
|
-- Janitor: find running jobs with stale heartbeats
|
|
CREATE INDEX idx_cyclotron_jobs_stalled
|
|
ON cyclotron_jobs (last_heartbeat)
|
|
WHERE status = 'running';
|
|
|
|
-- Janitor: find terminal jobs to clean up
|
|
CREATE INDEX idx_cyclotron_jobs_terminal
|
|
ON cyclotron_jobs (last_transition)
|
|
WHERE status IN ('completed', 'failed', 'canceled');
|
|
|
|
CREATE INDEX idx_cyclotron_jobs_team_id ON cyclotron_jobs(team_id);
|
|
CREATE INDEX idx_cyclotron_jobs_function_id ON cyclotron_jobs(function_id);
|