Source identity
| Field | Recorded value |
|---|---|
| Source type | GitHub source |
| Original record | Janady13/missionmatch / db/queries/opportunities.sql |
| Date | Not specified in source |
| Repository | Janady13/missionmatch |
| Revision | 1675031db74316e100782d063e9eda1a597fe3a1 |
| Branch | workstream-a-opportunity-intelligence |
| Path or archive member | db/queries/opportunities.sql |
| Original SHA-256 | 66ee6696e0009ceb1cc09620e6a99070b3d6b1ae3e0a9b666d336c4132d6f4e6 |
| Git blob SHA | ccb4c385cc356eb51f56efeee4a7e93a78409a1f |
| Reading-copy SHA-256 | 66ee6696e0009ceb1cc09620e6a99070b3d6b1ae3e0a9b666d336c4132d6f4e6 |
Every recorded occurrence
These 7 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/opportunities.sql | workstream-a-opportunity-intelligence | 1675031db74316e100782d063e9eda1a597fe3a1 | Open original |
| Janady13/missionmatch / db/queries/opportunities.sql | workstream-d-command-center | 255e7d1d420abf5e277d0cd8c9b14f6f72b6acb9 | Open original |
| Janady13/missionmatch / db/queries/opportunities.sql | workstream-e-commercial-stubs | 4437da660539284a400ee380b9b427a300c369ee | Open original |
| Janady13/missionmatch / db/queries/opportunities.sql | workstream-b-sam-contract-awards | d5101cceb98e70000cebb31d3e7ac73d747d3a6d | Open original |
| Janady13/missionmatch / db/queries/opportunities.sql | workstream-d-command-center | 255e7d1d420abf5e277d0cd8c9b14f6f72b6acb9 | Open original |
| Janady13/missionmatch / db/queries/opportunities.sql | workstream-a-opportunity-intelligence | 1675031db74316e100782d063e9eda1a597fe3a1 | Open original |
| Janady13/missionmatch / db/queries/opportunities.sql | workstream-e-commercial-stubs | 4437da660539284a400ee380b9b427a300c369ee | Open original |
Recovered source transcript
Download complete source text ↓25 lines · 1.0 KB
-- name: CreateOpportunity :one
INSERT INTO opportunities (organization_id, name, solicitation_number, customer_agency, due_date, status)
VALUES ($1,$2,$3,$4,$5,$6)
RETURNING *;
-- name: GetOpportunity :one
SELECT * FROM opportunities WHERE id = $1;
-- name: ListOpportunities :many
SELECT * FROM opportunities ORDER BY created_at DESC LIMIT $1 OFFSET $2;
-- name: ListRequirementsForOpportunity :many
SELECT * FROM requirements WHERE opportunity_id = $1 AND deleted_at IS NULL ORDER BY created_at DESC;
-- name: ProposalReadiness :many
-- Band/decision rollup across every slate member under one opportunity's requirements, the source
-- for GET /proposal-readiness [review COMPL-2]. RLS scopes all three tables to the caller's org.
SELECT sm.band, sm.decision, COUNT(*) AS n
FROM requirements r
JOIN slates s ON s.requirement_id = r.id
JOIN slate_members sm ON sm.slate_id = s.id
WHERE r.opportunity_id = $1
GROUP BY sm.band, sm.decision
ORDER BY sm.band, sm.decision;