Janady13/missionmatch / db/queries/wages.sql

Source identity

Field	Recorded value
Source type	GitHub source
Original record	Janady13/missionmatch / db/queries/wages.sql
Date	Not specified in source
Repository	Janady13/missionmatch
Revision	720d47fae476b0d38477ae4401697d372b1ea2bc
Branch	feature/opportunity-to-outcome
Path or archive member	db/queries/wages.sql
Original SHA-256	76280b685b7f1391d15b52f093e20ce0f9bbadc3dee90b52b251b593c17ea1a8
Git blob SHA	a4bddac7f3f47fa5855ea97a65ccd78d8ee97efa
Reading-copy SHA-256	76280b685b7f1391d15b52f093e20ce0f9bbadc3dee90b52b251b593c17ea1a8

Original source ↗

Every recorded occurrence

These 11 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 / db/queries/wages.sql	feature/opportunity-to-outcome	720d47fae476b0d38477ae4401697d372b1ea2bc	Open original
Janady13/missionmatch / db/queries/wages.sql	collision-deconfliction	4ee5a09972608ed89f8377c6665542d5f450f0a6	Open original
Janady13/missionmatch / db/queries/wages.sql	m5-price-to-win	41000ad30fff4129fdaf5ec84e15ba14c27d4890	Open original
Janady13/missionmatch / db/queries/wages.sql	master	1e9249840a4302ec82e123b9c9cb6f75badea3e4	Open original
Janady13/missionmatch / db/queries/wages.sql	mag-substrate	b82c7100a492dec67dfd1eda6b3f53def859be35	Open original
Janady13/missionmatch / db/queries/wages.sql	time-to-fill-survival	b66e1e505863d4f17741a4b9ede73509e45bd6c6	Open original
Janady13/missionmatch / db/queries/wages.sql	presentation-readiness	eb574acaa29d71ce4d0f852572e87c275c79fdb7	Open original
Janady13/missionmatch / db/queries/wages.sql	vendor-intelligence	fe9796a19c261951d3f2565206c0c1b5ac294465	Open original
Janady13/missionmatch / db/queries/wages.sql	phase2-connectors	e038d4c687aec16f8bd9bc4d907eea14d91f8704	Open original
Janady13/missionmatch / db/queries/wages.sql	feature/aioe-upgrade	2178e7298d0e5d9af83afa12402fd587f0ba6ed8	Open original
Janady13/missionmatch / db/queries/wages.sql	capture-readiness	bae6af7cb2997e819174a9e9cfff5e16067a1975	Open original

Recovered source transcript

Download complete source text ↓46 lines · 1.9 KB

-- BLS OEWS wage baseline cache. Global public catalog (no organization_id, outside RLS): reads run
-- off the pool, writes come from the weekly rates sync (cmd/rates-sync) as the migrator role.

-- name: UpsertBlsWage :exec
INSERT INTO bls_wages (
    series_id, occupation_code, occupation_title, role, area, area_name, metric, period_year, value, raw, synced_at
) VALUES (
    $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, now()
)
ON CONFLICT (series_id) DO UPDATE SET
    occupation_code  = EXCLUDED.occupation_code,
    occupation_title = EXCLUDED.occupation_title,
    role             = EXCLUDED.role,
    area             = EXCLUDED.area,
    area_name        = EXCLUDED.area_name,
    metric           = EXCLUDED.metric,
    period_year      = EXCLUDED.period_year,
    value            = EXCLUDED.value,
    raw              = EXCLUDED.raw,
    synced_at        = now();

-- name: UpsertBlsWageByOcc :exec
-- National OEWS wage expansion upsert, keyed on the natural key (occupation_code, area, metric), the
-- UNIQUE added in migration 0035. Used by cmd/oews-national-sync for the area='US' national rows: a
-- second run updates the value in place and inserts nothing new. Idempotent.
INSERT INTO bls_wages (
    series_id, occupation_code, occupation_title, role, area, area_name, metric, period_year, value, raw, synced_at
) VALUES (
    $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, now()
)
ON CONFLICT (occupation_code, area, metric) DO UPDATE SET
    series_id        = EXCLUDED.series_id,
    occupation_title = EXCLUDED.occupation_title,
    role             = EXCLUDED.role,
    area_name        = EXCLUDED.area_name,
    period_year      = EXCLUDED.period_year,
    value            = EXCLUDED.value,
    raw              = EXCLUDED.raw,
    synced_at        = now();

-- name: ListBlsWages :many
SELECT * FROM bls_wages ORDER BY occupation_code, area, metric;

-- name: WagesSyncMeta :one
SELECT COUNT(*)::bigint AS total, MAX(synced_at) AS last_synced FROM bls_wages;