Janady13/missionmatch / cmd/staffing-proactive-sync/main.go

Source identity

Field	Recorded value
Source type	GitHub source
Original record	Janady13/missionmatch / cmd/staffing-proactive-sync/main.go
Date	Not specified in source
Repository	Janady13/missionmatch
Revision	1e9249840a4302ec82e123b9c9cb6f75badea3e4
Branch	master
Path or archive member	cmd/staffing-proactive-sync/main.go
Original SHA-256	b3a4026ab0091ecdff7e93af0f62cd96ad878f9a51a1bffef51d89f6982149f5
Git blob SHA	03a390a78ddf51b30be698edad9a3e2ae55ed183
Reading-copy SHA-256	b3a4026ab0091ecdff7e93af0f62cd96ad878f9a51a1bffef51d89f6982149f5

Original source ↗

Every recorded occurrence

These 43 records contain identical original source bytes. Their paths and revisions remain part of the archive.

Original record	Branch or archive	Revision / identifier	Original location
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	master	1e9249840a4302ec82e123b9c9cb6f75badea3e4	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	feature/aioe-upgrade	2178e7298d0e5d9af83afa12402fd587f0ba6ed8	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	m5-price-to-win	41000ad30fff4129fdaf5ec84e15ba14c27d4890	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ws3-clearance	4b8e7ce594c068621867f9c9deed0ec64ae6c553	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	collision-deconfliction	4ee5a09972608ed89f8377c6665542d5f450f0a6	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ws7-federal-signal	6a9f6ce9cfb13345ffb47770d4960e7c2d9c17c2	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ws6-retrieval	6c56e29231ec05735927fa265c97d517499dfeaf	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	per-tenant-routing	9bde0f9a74b89d01980fa658e5253acda7528d0c	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ai-brain-live	aac32fc49c878cc5bca099459307611562d0bac1	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	graphrag-foundation	b0ddeb9f633fd138d09309d1a17b7d13bc3a67f7	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ws1-ontology-sync	b596f449a32a1016fbd403c36505cc00a1ac9ee6	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	time-to-fill-survival	b66e1e505863d4f17741a4b9ede73509e45bd6c6	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	mag-substrate	b82c7100a492dec67dfd1eda6b3f53def859be35	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	capture-readiness	bae6af7cb2997e819174a9e9cfff5e16067a1975	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	deploy-and-ops	bdacd9d0b4d5998d25fc74bf4007f4c3ec538c7a	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ws8-teaching-loop	c823f0fb6bb2aba0f39001eb6de96f4000d9321f	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	phase2-eval-fairness	d361af254701975fe239927656ababb56374655e	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	phase2-connectors	e038d4c687aec16f8bd9bc4d907eea14d91f8704	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ws2-alias-relationship	e4dada4601c6eb101830f9d223a9655dfa120616	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	presentation-readiness	eb574acaa29d71ce4d0f852572e87c275c79fdb7	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ws9-bench-ingestion	f585a9ef32fa554663ce1fba9a414a54b6e49cf0	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	vendor-intelligence	fe9796a19c261951d3f2565206c0c1b5ac294465	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	per-tenant-routing	9bde0f9a74b89d01980fa658e5253acda7528d0c	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	collision-deconfliction	4ee5a09972608ed89f8377c6665542d5f450f0a6	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ws6-retrieval	6c56e29231ec05735927fa265c97d517499dfeaf	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	m5-price-to-win	41000ad30fff4129fdaf5ec84e15ba14c27d4890	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ws1-ontology-sync	b596f449a32a1016fbd403c36505cc00a1ac9ee6	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	master	1e9249840a4302ec82e123b9c9cb6f75badea3e4	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ws8-teaching-loop	c823f0fb6bb2aba0f39001eb6de96f4000d9321f	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	mag-substrate	b82c7100a492dec67dfd1eda6b3f53def859be35	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ws3-clearance	4b8e7ce594c068621867f9c9deed0ec64ae6c553	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	phase2-eval-fairness	d361af254701975fe239927656ababb56374655e	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	time-to-fill-survival	b66e1e505863d4f17741a4b9ede73509e45bd6c6	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	graphrag-foundation	b0ddeb9f633fd138d09309d1a17b7d13bc3a67f7	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	deploy-and-ops	bdacd9d0b4d5998d25fc74bf4007f4c3ec538c7a	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ws9-bench-ingestion	f585a9ef32fa554663ce1fba9a414a54b6e49cf0	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ws2-alias-relationship	e4dada4601c6eb101830f9d223a9655dfa120616	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	presentation-readiness	eb574acaa29d71ce4d0f852572e87c275c79fdb7	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ws7-federal-signal	6a9f6ce9cfb13345ffb47770d4960e7c2d9c17c2	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	ai-brain-live	aac32fc49c878cc5bca099459307611562d0bac1	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	phase2-connectors	e038d4c687aec16f8bd9bc4d907eea14d91f8704	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	feature/aioe-upgrade	2178e7298d0e5d9af83afa12402fd587f0ba6ed8	Open original
Janady13/missionmatch / cmd/staffing-proactive-sync/main.go	capture-readiness	bae6af7cb2997e819174a9e9cfff5e16067a1975	Open original

Recovered source transcript

Download complete source text ↓127 lines · 4.4 KB

// Command staffing-proactive-sync runs the W3 proactive bench watch recompute. For each organization it
// refreshes the proactive staffing recommendations: which available candidate best fits which open
// requirement, superseding that candidate's prior pending proactive rows. It is the scheduled job behind
// the host timer (the same pattern as opp-sync), pure Go and FIPS clean, and safe to rerun: every recompute
// is idempotent and writes a fresh run.
//
// It lists organizations through the migrator role (which sees every org) and does the per org work through
// the NOBYPASSRLS app role under RLS, so one tenant's recompute can never read or write another's. Pass
// -org to limit the run to a single organization.
//
// Env: MM_DATABASE_URL (the app DSN), MM_MIGRATOR_DATABASE_URL (the migrator DSN, for listing orgs; falls
// back to MM_DATABASE_URL). The MEGAMIND plane is not used: proactive rationales are deterministic.
package main

import (
	"context"
	"flag"
	"log"
	"os"
	"strings"
	"time"

	"github.com/google/uuid"
	"github.com/jackc/pgx/v5/pgxpool"

	"github.com/missionworkforce/missionmatch/internal/modules/matching"
	"github.com/missionworkforce/missionmatch/internal/modules/staffing"
	"github.com/missionworkforce/missionmatch/internal/platform/audit"
	"github.com/missionworkforce/missionmatch/internal/platform/config"
	"github.com/missionworkforce/missionmatch/internal/platform/database"
	"github.com/missionworkforce/missionmatch/internal/platform/tenant"
)

func main() {
	orgFlag := flag.String("org", "", "limit the recompute to a single organization id (default: all orgs)")
	flag.Parse()

	cfg, err := config.Load()
	if err != nil {
		log.Fatalf("staffing-proactive-sync: config: %v", err)
	}
	if cfg.AppDatabaseURL == "" {
		log.Fatal("staffing-proactive-sync: MM_DATABASE_URL (the app DSN) is required")
	}
	migDSN := firstNonEmpty(os.Getenv("MM_MIGRATOR_DATABASE_URL"), cfg.AppDatabaseURL)

	ctx, cancel := context.WithTimeout(context.Background(), 30*time.Minute)
	defer cancel()

	appPool, err := database.NewPool(ctx, cfg.AppDatabaseURL)
	if err != nil {
		log.Fatalf("staffing-proactive-sync: app pool: %v", err)
	}
	defer appPool.Close()
	// Fail closed unless this is the NOBYPASSRLS app role, so the recompute can never bypass tenant RLS.
	if err := database.AssertRole(ctx, appPool, "missionmatch_app"); err != nil {
		log.Fatalf("staffing-proactive-sync: app pool role check: %v", err)
	}
	appDB := tenant.New(appPool)

	// The skill matcher reads the backfilled stored embeddings (the same live path as the API), not request
	// time name embedding. Deterministic rationales for the batch (no inference client), so the cron never
	// hammers the plane.
	svc := staffing.NewService(appDB, matching.NewStoredSkillMatcher(appDB), audit.New(appDB), nil, staffing.Load())

	orgIDs, err := listOrgs(ctx, migDSN, *orgFlag)
	if err != nil {
		log.Fatalf("staffing-proactive-sync: list orgs: %v", err)
	}
	if len(orgIDs) == 0 {
		log.Print("staffing-proactive-sync: no organizations to process")
		return
	}

	total := 0
	for _, orgID := range orgIDs {
		orgCtx := tenant.WithOrg(ctx, orgID.String())
		n, rerr := svc.RecomputeProactive(orgCtx)
		if rerr != nil {
			log.Fatalf("staffing-proactive-sync: org %s: %v", orgID, rerr)
		}
		log.Printf("staffing-proactive-sync: org %s processed %d candidates", orgID, n)
		total += n
	}
	log.Printf("staffing-proactive-sync: done, %d org(s), %d candidate watches refreshed", len(orgIDs), total)
}

// listOrgs returns the organization ids to process. It uses the migrator role, which sees every org, so a
// single recompute run can cover the cluster; the per org work then runs under the app role and RLS.
func listOrgs(ctx context.Context, migDSN, only string) ([]uuid.UUID, error) {
	if only != "" {
		id, err := uuid.Parse(strings.TrimSpace(only))
		if err != nil {
			return nil, err
		}
		return []uuid.UUID{id}, nil
	}
	pool, err := pgxpool.New(ctx, migDSN)
	if err != nil {
		return nil, err
	}
	defer pool.Close()
	rows, err := pool.Query(ctx, "SELECT id FROM organizations ORDER BY id")
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var out []uuid.UUID
	for rows.Next() {
		var id uuid.UUID
		if err := rows.Scan(&id); err != nil {
			return nil, err
		}
		out = append(out, id)
	}
	return out, rows.Err()
}

func firstNonEmpty(vals ...string) string {
	for _, v := range vals {
		if s := strings.TrimSpace(v); s != "" {
			return s
		}
	}
	return ""
}