package store import ( "context" "database/sql" "errors" "pageswiki/internal/db" "pageswiki/internal/documentrefs" ) func (s *Store) ensurePostgreSQLPeriodicals(ctx context.Context) error { if err := s.ensurePostgreSQLDomainEntry(ctx); err != nil { return err } return db.ApplyPostgreSQLMigrations(ctx, s.DB, "store-periodicals", []db.PostgreSQLMigration{{Version: 1, Name: "blog diary entries and projections", Statements: []string{ `CREATE TABLE periodical_entries(domain_uuid TEXT COLLATE "C" NOT NULL,kind TEXT COLLATE "C" NOT NULL CHECK(kind IN ('diary','blog')),page_uuid TEXT COLLATE "C" NOT NULL,owner_uuid TEXT COLLATE "C" NOT NULL,local_date TEXT COLLATE "C" NOT NULL,title TEXT NOT NULL,category TEXT NOT NULL DEFAULT '',timezone TEXT NOT NULL,version BIGINT NOT NULL DEFAULT 1,PRIMARY KEY(domain_uuid,kind,page_uuid))`, `CREATE INDEX idx_periodical_date ON periodical_entries(domain_uuid,kind,local_date DESC,page_uuid)`, `CREATE TABLE periodical_events(id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,domain_uuid TEXT COLLATE "C" NOT NULL,kind TEXT COLLATE "C" NOT NULL,page_uuid TEXT COLLATE "C" NOT NULL,actor_uuid TEXT COLLATE "C" NOT NULL,operation TEXT NOT NULL,version BIGINT NOT NULL,created_at_ms BIGINT NOT NULL)`, `CREATE INDEX idx_periodical_event_page ON periodical_events(domain_uuid,kind,page_uuid,version DESC)`, `CREATE TABLE periodical_posts(domain_uuid TEXT COLLATE "C" NOT NULL,kind TEXT COLLATE "C" NOT NULL,actor_uuid TEXT COLLATE "C" NOT NULL,request_id TEXT COLLATE "C" NOT NULL,digest TEXT NOT NULL,page_uuid TEXT COLLATE "C" NOT NULL,PRIMARY KEY(domain_uuid,kind,actor_uuid,request_id))`, `CREATE TABLE periodical_projections(domain_uuid TEXT COLLATE "C" NOT NULL,kind TEXT COLLATE "C" NOT NULL,source_uuid TEXT COLLATE "C" NOT NULL,prefix TEXT NOT NULL,PRIMARY KEY(domain_uuid,kind))`, }, Assertions: []string{ `SELECT domain_uuid,kind,page_uuid,owner_uuid,local_date,title,category,timezone,version FROM periodical_entries WHERE 1=0`, `SELECT id,domain_uuid,kind,page_uuid,actor_uuid,operation,version,created_at_ms FROM periodical_events WHERE 1=0`, `SELECT domain_uuid,kind,actor_uuid,request_id,digest,page_uuid FROM periodical_posts WHERE 1=0`, `SELECT domain_uuid,kind,source_uuid,prefix FROM periodical_projections WHERE 1=0`, }}}) } // The caller owns the namespace lock and has authorized the exact Path. // Asset names resolve only inside this Domain; immutable references are pinned // to this Revision, not silently followed to a future Asset HEAD. func (s *Store) createPeriodicalPageTx(ctx context.Context, tx *sql.Tx, domain, actor, object, path, html string) error { if s.DocumentRoot == "" { return ErrDocumentStoreRequired } body, hashes, err := documentrefs.Freeze(ctx, []byte(html), "text/html; charset=utf-8", func(ctx context.Context, address string) (string, error) { var hash string e := tx.QueryRowContext(ctx, `SELECT head_document_hash FROM assets WHERE domain_uuid=$1 AND address=$2`, domain, address).Scan(&hash) if errors.Is(e, sql.ErrNoRows) { return "", ErrEmbeddedAssetUnavailable } return hash, e }) if err != nil { return err } docs, err := s.documentStorage() if err != nil { return err } for _, hash := range hashes { if err = docs.Verify(ctx, hash); err != nil { return err } } return s.createTaskWikiPageTx(ctx, tx, domain, actor, object, path, string(body), "Create periodical article", hashes...) }