package store import ( "context" "database/sql" "pageswiki/internal/db" ) func (s *Store) lockFederationWrite(ctx context.Context, tx *sql.Tx) error { if s.sqlBackend == storePostgreSQL { return s.lockPolicyWrite(ctx, tx) } _, err := tx.ExecContext(ctx, `UPDATE federation_manifest_state SET applied_at=applied_at WHERE 0`) return err } func (s *Store) deleteFederationCampusTx(ctx context.Context, tx *sql.Tx, campus string) error { if _, err := tx.ExecContext(ctx, `DELETE FROM federation_instance_capabilities WHERE instance_uuid IN (SELECT uuid FROM federation_instances WHERE campus_uuid=`+s.sqlParam(1)+`)`, campus); err != nil { return err } for _, table := range []string{"federation_instances", "campus_tokens", "federation_manifest_versions", "federation_manifest_state"} { if _, err := tx.ExecContext(ctx, `DELETE FROM `+table+` WHERE campus_uuid=`+s.sqlParam(1), campus); err != nil { return err } } return nil } func (s *Store) ensurePostgreSQLFederation(ctx context.Context) error { return db.ApplyPostgreSQLMigrations(ctx, s.DB, "store-federation", []db.PostgreSQLMigration{{Version: 1, Name: "federation identities and signed manifest checkpoints", Statements: []string{ `CREATE TABLE campus_tokens(id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,campus_uuid TEXT COLLATE "C" NOT NULL,token_hash TEXT COLLATE "C" NOT NULL UNIQUE,label TEXT NOT NULL DEFAULT '',revoked INTEGER NOT NULL DEFAULT 0,created_at BIGINT NOT NULL,last_used_at BIGINT NOT NULL DEFAULT 0)`, `CREATE TABLE federation_instances(id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,uuid TEXT COLLATE "C" NOT NULL UNIQUE,campus_uuid TEXT COLLATE "C" NOT NULL,fqdn TEXT COLLATE "C" NOT NULL,fingerprint TEXT COLLATE "C" NOT NULL,status TEXT NOT NULL DEFAULT 'pending',last_seen_at BIGINT NOT NULL,created_at BIGINT NOT NULL,UNIQUE(campus_uuid,fqdn,fingerprint))`, `CREATE INDEX idx_federation_instances_campus ON federation_instances(campus_uuid,status,fqdn)`, `CREATE TABLE federation_instance_capabilities(instance_uuid TEXT COLLATE "C" PRIMARY KEY,manifest_version INTEGER NOT NULL)`, `CREATE TABLE federation_manifest_versions(campus_uuid TEXT COLLATE "C" PRIMARY KEY,revision BIGINT NOT NULL,manifest_hash TEXT NOT NULL,updated_at BIGINT NOT NULL)`, `CREATE TABLE federation_manifest_state(campus_uuid TEXT COLLATE "C" PRIMARY KEY,controller_public_key TEXT NOT NULL,controller_fingerprint TEXT NOT NULL,applied_revision BIGINT NOT NULL,manifest_json TEXT NOT NULL,applied_at BIGINT NOT NULL)`, }, Assertions: []string{ `SELECT id,campus_uuid,token_hash,label,revoked,created_at,last_used_at FROM campus_tokens WHERE 1=0`, `SELECT id,uuid,campus_uuid,fqdn,fingerprint,status,last_seen_at,created_at FROM federation_instances WHERE 1=0`, `SELECT instance_uuid,manifest_version FROM federation_instance_capabilities WHERE 1=0`, `SELECT campus_uuid,revision,manifest_hash,updated_at FROM federation_manifest_versions WHERE 1=0`, `SELECT campus_uuid,controller_public_key,controller_fingerprint,applied_revision,manifest_json,applied_at FROM federation_manifest_state WHERE 1=0`, }}}) } // Settings needed by signed manifests; the full periodical repository remains // a separate component and must not recreate these tables. func (s *Store) ensurePostgreSQLDomainEntry(ctx context.Context) error { return db.ApplyPostgreSQLMigrations(ctx, s.DB, "store-domain-entry", []db.PostgreSQLMigration{{Version: 1, Name: "federated entry settings", Statements: []string{ `CREATE TABLE domain_entry_settings(domain_uuid TEXT COLLATE "C" PRIMARY KEY,settings_json TEXT NOT NULL)`, `CREATE TABLE periodical_settings(domain_uuid TEXT COLLATE "C" NOT NULL,kind TEXT COLLATE "C" NOT NULL CHECK(kind IN ('diary','blog')),enabled INTEGER NOT NULL DEFAULT 0,PRIMARY KEY(domain_uuid,kind))`, `CREATE TABLE periodical_prefixes(domain_uuid TEXT COLLATE "C" NOT NULL,kind TEXT COLLATE "C" NOT NULL CHECK(kind IN ('diary','blog')),prefix TEXT NOT NULL,PRIMARY KEY(domain_uuid,kind))`, }, Assertions: []string{ `SELECT domain_uuid,settings_json FROM domain_entry_settings WHERE 1=0`, `SELECT domain_uuid,kind,enabled FROM periodical_settings WHERE 1=0`, `SELECT domain_uuid,kind,prefix FROM periodical_prefixes WHERE 1=0`, }}}) }