// 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 }