mirror of
https://github.com/hanzoai/insights.git
synced 2026-11-03 00:52:32 +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.
31 lines
1.1 KiB
SQL
31 lines
1.1 KiB
SQL
-- Backup table for person property reconciliation job
|
|
-- Stores original person state before updates for audit/rollback
|
|
|
|
CREATE TABLE IF NOT EXISTS insights_person_reconciliation_backup (
|
|
job_id TEXT NOT NULL,
|
|
team_id INTEGER NOT NULL,
|
|
person_id BIGINT NOT NULL,
|
|
-- Full row backup of insights_person columns (BEFORE state)
|
|
uuid UUID NOT NULL,
|
|
properties JSONB NOT NULL,
|
|
properties_last_updated_at JSONB,
|
|
properties_last_operation JSONB,
|
|
version BIGINT,
|
|
is_identified BOOLEAN NOT NULL,
|
|
created_at TIMESTAMP WITH TIME ZONE NOT NULL,
|
|
is_user_id INTEGER,
|
|
-- Operations to be applied (from Datastore query)
|
|
pending_operations JSONB NOT NULL,
|
|
-- AFTER state (computed before update)
|
|
properties_after JSONB,
|
|
properties_last_updated_at_after JSONB,
|
|
properties_last_operation_after JSONB,
|
|
version_after BIGINT,
|
|
-- Metadata
|
|
backed_up_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
|
|
PRIMARY KEY (job_id, team_id, person_id)
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS person_reconciliation_backup_team_person
|
|
ON insights_person_reconciliation_backup (team_id, person_id);
|