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

111 lines
4.6 KiB
Go

package store
import (
"context"
"database/sql"
"errors"
"time"
)
type PeriodicalProjection struct {
Source string
Prefix string
}
func (s *Store) ListPeriodicalProjections() (result map[string]PeriodicalProjection, resultErr error) {
defer func() { resultErr = s.sqlError("periodicals repository", resultErr) }()
rows, err := s.DB.Query(`SELECT domain_uuid,kind,source_uuid,prefix FROM periodical_projections`)
if err != nil {
return nil, err
}
defer rows.Close()
out := map[string]PeriodicalProjection{}
for rows.Next() {
var d, k string
var p PeriodicalProjection
if err = rows.Scan(&d, &k, &p.Source, &p.Prefix); err != nil {
return nil, err
}
out[d+"|"+k] = p
}
return out, rows.Err()
}
func (s *Store) PeriodicalProjection(ctx context.Context, domain, kind string) (result *PeriodicalProjection, resultErr error) {
defer func() { resultErr = s.sqlError("periodicals repository", resultErr) }()
var p PeriodicalProjection
err := s.DB.QueryRowContext(ctx, `SELECT source_uuid,prefix FROM periodical_projections WHERE domain_uuid=`+s.sqlParam(1)+` AND kind=`+s.sqlParam(2), domain, kind).Scan(&p.Source, &p.Prefix)
if errors.Is(err, sql.ErrNoRows) {
return nil, nil
}
if err != nil {
return nil, err
}
var valid bool
err = s.DB.QueryRowContext(ctx, `SELECT EXISTS(SELECT 1 FROM domains d JOIN domains src ON src.uuid=`+s.sqlParam(1)+` AND src.campus_uuid=d.campus_uuid JOIN campuses c ON c.uuid=d.campus_uuid WHERE d.uuid=`+s.sqlParam(2)+` AND d.enabled=1 AND src.enabled=1 AND c.enabled=1 AND d.placement='local' AND src.placement='local' AND d.uuid!=src.uuid AND NOT EXISTS(SELECT 1 FROM periodical_projections p WHERE p.domain_uuid=src.uuid AND p.kind=`+s.sqlParam(3)+`))`, p.Source, domain, kind).Scan(&valid)
if err != nil {
return nil, err
}
if !valid {
return nil, ErrAccessDenied
}
return &p, nil
}
func (s *Store) SetPeriodicalProjection(ctx context.Context, id int64, actor, kind, source, prefix string) (resultErr error) {
defer func() { resultErr = s.sqlError("periodicals repository", resultErr) }()
if !PeriodicalKind(kind) {
return ErrPeriodicalInvalid
}
if source != "" {
if _, err := PeriodicalPath(prefix, "2000-01-01", ""); err != nil {
return err
}
}
ctx, cancel := context.WithTimeout(ctx, 3*time.Second)
defer cancel()
tx, err := s.DB.BeginTx(ctx, nil)
if err != nil {
return err
}
defer tx.Rollback()
if err = s.lockTaskWriter(ctx, tx); err != nil {
return err
}
if _, err = tx.ExecContext(ctx, `UPDATE domains SET title=title WHERE id=`+s.sqlParam(1), id); err != nil {
return err
}
var domain, campus, mode, placement string
if err = tx.QueryRowContext(ctx, `SELECT d.uuid,d.campus_uuid,c.authority_mode,d.placement FROM domains d JOIN campuses c ON c.uuid=d.campus_uuid WHERE d.id=`+s.sqlParam(1)+` AND d.enabled=1 AND c.enabled=1`, id).Scan(&domain, &campus, &mode, &placement); err != nil {
return err
}
if mode == "managed" || placement != "local" {
return ErrAccessDenied
}
var allowed bool
err = tx.QueryRowContext(ctx, `SELECT EXISTS(SELECT 1 FROM groups g JOIN domains d ON d.uuid=g.domain_uuid AND d.enabled=1 JOIN group_members gm ON gm.group_uuid=g.uuid JOIN domain_memberships m ON m.uuid=gm.membership_uuid AND m.domain_uuid=g.domain_uuid JOIN principals p ON p.uuid=m.principal_uuid WHERE d.campus_uuid=`+s.sqlParam(1)+` AND g.builtin_key='campus_admin' AND g.state='active' AND m.principal_uuid=`+s.sqlParam(2)+` AND m.state='active' AND p.state='active' AND gm.member_role IN ('owner','manager'))`, campus, actor).Scan(&allowed)
if err != nil {
return err
}
if !allowed {
return ErrAccessDenied
}
if source == "" {
if _, err = tx.ExecContext(ctx, `DELETE FROM periodical_projections WHERE domain_uuid=`+s.sqlParam(1)+` AND kind=`+s.sqlParam(2), domain, kind); err != nil {
return err
}
return tx.Commit()
}
err = tx.QueryRowContext(ctx, `SELECT EXISTS(SELECT 1 FROM domains WHERE uuid=`+s.sqlParam(1)+` AND uuid!=`+s.sqlParam(2)+` AND campus_uuid=`+s.sqlParam(3)+` AND enabled=1 AND placement='local') AND NOT EXISTS(SELECT 1 FROM periodical_projections WHERE kind=`+s.sqlParam(4)+` AND (domain_uuid=`+s.sqlParam(5)+` OR source_uuid=`+s.sqlParam(6)+`))`, source, domain, campus, kind, source, domain).Scan(&allowed)
if err != nil {
return err
}
if !allowed {
return ErrPeriodicalInvalid
}
if _, err = tx.ExecContext(ctx, `INSERT INTO periodical_projections(domain_uuid,kind,source_uuid,prefix) VALUES(`+s.sqlParam(1)+`,`+s.sqlParam(2)+`,`+s.sqlParam(3)+`,`+s.sqlParam(4)+`) ON CONFLICT(domain_uuid,kind) DO UPDATE SET source_uuid=excluded.source_uuid,prefix=excluded.prefix`, domain, kind, source, prefix); err != nil {
return err
}
return tx.Commit()
}