Files
mtusi2026lab6/internal/database/sqlc/outbox.sql.go

129 lines
3.8 KiB
Go

// Code generated by sqlc. DO NOT EDIT.
// versions:
// sqlc v1.31.1
// source: outbox.sql
package sqlc
import (
"context"
"github.com/jackc/pgx/v5/pgtype"
)
const createInitialOutboxEvent = `-- name: CreateInitialOutboxEvent :exec
INSERT INTO outbox (job_id, payload, available_at, dedup_key)
SELECT id, attachment_job_payload(id, attachment_id, pipeline_version, 1, created_at)
|| jsonb_strip_nulls(jsonb_build_object(
'traceparent', NULLIF($1::text, ''),
'tracestate', NULLIF($2::text, '')
)),
next_attempt_at, 'initial/' || id
FROM attachment_jobs WHERE id = $3::uuid
`
type CreateInitialOutboxEventParams struct {
Traceparent string
Tracestate string
JobID pgtype.UUID
}
func (q *Queries) CreateInitialOutboxEvent(ctx context.Context, arg CreateInitialOutboxEventParams) error {
_, err := q.db.Exec(ctx, createInitialOutboxEvent, arg.Traceparent, arg.Tracestate, arg.JobID)
return err
}
const enqueueExpiredLeases = `-- name: EnqueueExpiredLeases :many
WITH expired AS (
SELECT j.id, j.attachment_id, j.pipeline_version, j.attempts_started, j.max_attempts, j.next_attempt_at, j.lease_generation, j.lease_until, j.created_at, j.updated_at, j.published_original_key, 'recovery/' || j.id || '/' || j.lease_generation AS recovery_key
FROM attachment_jobs AS j
JOIN attachments AS a ON a.id = j.attachment_id AND a.pipeline_version = j.pipeline_version
WHERE a.status = 'processing' AND j.lease_until <= clock_timestamp()
AND NOT EXISTS (
SELECT 1 FROM outbox AS o WHERE o.dedup_key = 'recovery/' || j.id || '/' || j.lease_generation
)
ORDER BY j.lease_until, j.id
LIMIT $1
FOR UPDATE OF j SKIP LOCKED
)
INSERT INTO outbox (job_id, payload, dedup_key)
SELECT e.id, attachment_job_payload(e.id, e.attachment_id, e.pipeline_version,
LEAST(e.attempts_started + 1, e.max_attempts), clock_timestamp())
|| COALESCE((
SELECT jsonb_strip_nulls(jsonb_build_object(
'traceparent', o.payload->>'traceparent', 'tracestate', o.payload->>'tracestate'
))
FROM outbox AS o WHERE o.job_id = e.id
ORDER BY o.created_at DESC, o.id DESC LIMIT 1
), '{}'::jsonb),
e.recovery_key
FROM expired AS e
ON CONFLICT (dedup_key) DO NOTHING
RETURNING id, job_id, payload, available_at, sent_at, created_at, dedup_key
`
func (q *Queries) EnqueueExpiredLeases(ctx context.Context, batchSize int32) ([]Outbox, error) {
rows, err := q.db.Query(ctx, enqueueExpiredLeases, batchSize)
if err != nil {
return nil, err
}
defer rows.Close()
var items []Outbox
for rows.Next() {
var i Outbox
if err := rows.Scan(
&i.ID,
&i.JobID,
&i.Payload,
&i.AvailableAt,
&i.SentAt,
&i.CreatedAt,
&i.DedupKey,
); err != nil {
return nil, err
}
items = append(items, i)
}
if err := rows.Err(); err != nil {
return nil, err
}
return items, nil
}
const markOutboxEventSent = `-- name: MarkOutboxEventSent :execrows
UPDATE outbox SET sent_at = clock_timestamp()
WHERE id = $1 AND sent_at IS NULL
`
func (q *Queries) MarkOutboxEventSent(ctx context.Context, id pgtype.UUID) (int64, error) {
result, err := q.db.Exec(ctx, markOutboxEventSent, id)
if err != nil {
return 0, err
}
return result.RowsAffected(), nil
}
const nextPendingOutboxEvent = `-- name: NextPendingOutboxEvent :one
SELECT id, job_id, payload, available_at, sent_at, created_at, dedup_key
FROM outbox
WHERE sent_at IS NULL AND available_at <= statement_timestamp()
ORDER BY available_at, id
LIMIT 1
FOR UPDATE SKIP LOCKED
`
func (q *Queries) NextPendingOutboxEvent(ctx context.Context) (Outbox, error) {
row := q.db.QueryRow(ctx, nextPendingOutboxEvent)
var i Outbox
err := row.Scan(
&i.ID,
&i.JobID,
&i.Payload,
&i.AvailableAt,
&i.SentAt,
&i.CreatedAt,
&i.DedupKey,
)
return i, err
}