Files
pages/internal/store/federation_postgres.go
2026-11-15 05:47:14 +09:00

59 lines
4.2 KiB
Go

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`,
}}})
}