Skip to content

Garry's Opinionated OpenClaw/Hermes Agent Brain

TypeScript
6.4 KB
Raw Blame
import { requireMaintainerPoliciesSql } from '../derived-state-maintainers.ts';

/** NULL marks a legacy snapshot whose deletion state was not recorded. */
export const PAGE_VERSION_DELETION_SCHEMA_SQL = `ALTER TABLE page_versions ADD COLUMN IF NOT EXISTS is_deleted BOOLEAN;`;

/** A tag write moves its page's revision; under RLS the writer needs the page (#7637, derived-state-maintainers.ts). */
export const TAG_REVISION_FUNCTION_SQL = `CREATE OR REPLACE FUNCTION gbrain_advance_tag_revision() RETURNS trigger LANGUAGE plpgsql SET search_path = pg_catalog, public, pg_temp AS $fn$
    BEGIN
      IF TG_OP = 'UPDATE' AND (NEW.page_id, NEW.tag) IS NOT DISTINCT FROM (OLD.page_id, OLD.tag) THEN
        RETURN NULL;
      END IF;
      ${requireMaintainerPoliciesSql('pages', ['SELECT', 'UPDATE'], '      ')}
      IF TG_OP <> 'INSERT' THEN
        UPDATE pages SET knowledge_revision = gen_random_uuid() WHERE id = OLD.page_id;
      END IF;
      IF TG_OP <> 'DELETE' AND (TG_OP = 'INSERT' OR (NEW.page_id, NEW.tag) IS DISTINCT FROM (OLD.page_id, OLD.tag)) THEN
        UPDATE pages SET knowledge_revision = gen_random_uuid() WHERE id = NEW.page_id;
      END IF;
      RETURN NULL;
    END $fn$`;

/**
 * Shared by migration 150 and both schema blobs, so Postgres also replays it
 * before pending migrations. Statements stay idempotent. #5216: a column with
 * a volatile default added NOT NULL rewrites the whole table (and reads every
 * TOAST value, failing on a torn one), so both UUID columns are added
 * nullable, get their default separately, and become NOT NULL only when no
 * row needs a value: `sources` is backfilled here (a handful of rows), an
 * empty `pages` (fresh install) is constrained here, and existing pages are
 * backfilled in committed batches by page-state/revision-backfill-schema.ts.
 * A segmented page (Wave B) has NULL body columns, so its body identity is
 * `body_generation`, read only when both sides are NULL: the column is
 * migration-only (v248), and before it the body columns are NOT NULL.
 */
export const PAGE_STATE_SCHEMA_STATEMENTS = [
  `DO $do$ BEGIN
    IF NOT EXISTS (SELECT 1 FROM pg_attribute WHERE attrelid = 'sources'::regclass AND attname = 'incarnation' AND NOT attisdropped) THEN
      ALTER TABLE sources ADD COLUMN IF NOT EXISTS incarnation UUID;
    END IF;
    IF NOT EXISTS (SELECT 1 FROM pg_attribute WHERE attrelid = 'sources'::regclass AND attname = 'incarnation' AND atthasdef) THEN
      ALTER TABLE sources ALTER COLUMN incarnation SET DEFAULT gen_random_uuid();
    END IF;
    IF EXISTS (SELECT 1 FROM pg_attribute WHERE attrelid = 'sources'::regclass AND attname = 'incarnation' AND NOT attnotnull) THEN
      UPDATE sources SET incarnation = gen_random_uuid() WHERE incarnation IS NULL;
      ALTER TABLE sources ALTER COLUMN incarnation SET NOT NULL;
    END IF;
  END $do$`,
  `CREATE UNIQUE INDEX IF NOT EXISTS sources_incarnation_key ON sources(incarnation)`,
  `DO $do$ BEGIN
    IF NOT EXISTS (SELECT 1 FROM pg_attribute WHERE attrelid = 'pages'::regclass AND attname = 'knowledge_revision' AND NOT attisdropped) THEN
      ALTER TABLE pages ADD COLUMN IF NOT EXISTS knowledge_revision UUID;
    END IF;
    IF NOT EXISTS (SELECT 1 FROM pg_attribute WHERE attrelid = 'pages'::regclass AND attname = 'knowledge_revision' AND atthasdef) THEN
      ALTER TABLE pages ALTER COLUMN knowledge_revision SET DEFAULT gen_random_uuid();
    END IF;
    IF EXISTS (SELECT 1 FROM pg_attribute WHERE attrelid = 'pages'::regclass AND attname = 'knowledge_revision' AND NOT attnotnull)
       AND NOT EXISTS (SELECT 1 FROM pages) THEN
      ALTER TABLE pages ALTER COLUMN knowledge_revision SET NOT NULL;
    END IF;
  END $do$`,
  `ALTER TABLE pages ADD COLUMN IF NOT EXISTS text_projection_revision UUID`,
  `ALTER TABLE page_versions ADD COLUMN IF NOT EXISTS knowledge_revision UUID`,
  `ALTER TABLE page_versions ADD COLUMN IF NOT EXISTS timeline TEXT`,
  `ALTER TABLE page_versions ADD COLUMN IF NOT EXISTS title TEXT`,
  `ALTER TABLE page_versions ADD COLUMN IF NOT EXISTS type TEXT`,
  `ALTER TABLE page_versions ADD COLUMN IF NOT EXISTS tags JSONB`,
  PAGE_VERSION_DELETION_SCHEMA_SQL,
  `CREATE TABLE IF NOT EXISTS page_write_guards (
    source_incarnation UUID NOT NULL REFERENCES sources(incarnation) ON DELETE CASCADE,
    slug TEXT NOT NULL,
    PRIMARY KEY (source_incarnation, slug)
  )`,
  `CREATE OR REPLACE FUNCTION gbrain_advance_page_revision() RETURNS trigger LANGUAGE plpgsql SET search_path = pg_catalog, public, pg_temp AS $fn$
    DECLARE body_moved boolean := false;
    BEGIN
      IF OLD.knowledge_revision IS NULL THEN
        NEW.knowledge_revision := COALESCE(NEW.knowledge_revision, gen_random_uuid());
        NEW.text_projection_revision := NULL;
        RETURN NEW;
      END IF;
      IF NEW.compiled_truth IS NULL AND OLD.compiled_truth IS NULL THEN
        body_moved := NEW.body_generation IS DISTINCT FROM OLD.body_generation;
      END IF;
      IF (NEW.source_id, NEW.slug, NEW.type, NEW.page_kind, NEW.title, NEW.compiled_truth,
          NEW.timeline, NEW.frontmatter, NEW.deleted_at)
         IS DISTINCT FROM
         (OLD.source_id, OLD.slug, OLD.type, OLD.page_kind, OLD.title, OLD.compiled_truth,
          OLD.timeline, OLD.frontmatter, OLD.deleted_at) OR body_moved THEN
        IF NEW.knowledge_revision = OLD.knowledge_revision AND NOT (
          COALESCE(current_setting('gbrain.materializing_revision', true), '') = OLD.knowledge_revision::text
          AND (NEW.source_id, NEW.slug, NEW.type, NEW.page_kind, NEW.title, NEW.frontmatter, NEW.deleted_at)
            IS NOT DISTINCT FROM
            (OLD.source_id, OLD.slug, OLD.type, OLD.page_kind, OLD.title, OLD.frontmatter, OLD.deleted_at)
        ) THEN
          NEW.knowledge_revision := gen_random_uuid();
        END IF;
      END IF;
      IF NEW.knowledge_revision IS DISTINCT FROM OLD.knowledge_revision THEN
        NEW.text_projection_revision := NULL;
      END IF;
      RETURN NEW;
    END $fn$`,
  `DROP TRIGGER IF EXISTS pages_knowledge_revision ON pages`,
  `CREATE TRIGGER pages_knowledge_revision BEFORE UPDATE ON pages
    FOR EACH ROW EXECUTE FUNCTION gbrain_advance_page_revision()`,
  TAG_REVISION_FUNCTION_SQL,
  `DROP TRIGGER IF EXISTS tags_knowledge_revision ON tags`,
  `CREATE TRIGGER tags_knowledge_revision AFTER INSERT OR DELETE OR UPDATE ON tags
    FOR EACH ROW EXECUTE FUNCTION gbrain_advance_tag_revision()`,
] as const;

export const PAGE_STATE_SCHEMA_SQL = PAGE_STATE_SCHEMA_STATEMENTS.join(';\n') + ';\n';