Files

33 lines
939 B
Go

package postgres
import (
"context"
"fmt"
"time"
"gitea.privcloud.tech/dizi/mtusi2026lab7/internal/model"
)
func (s *Store) RenewAttachmentJobLease(
ctx context.Context,
lease model.AttachmentJobLease,
duration time.Duration,
) (bool, error) {
if duration <= 0 || lease.Job.ID == "" || lease.Job.LeaseToken == "" || lease.Job.LeaseOwner == "" {
return false, model.ErrInvalidInput
}
const query = `
UPDATE attachment_jobs
SET lease_until = clock_timestamp() + ($4::bigint * interval '1 microsecond'),
updated_at = clock_timestamp()
WHERE id = $1 AND lease_token = $2 AND lease_owner = $3
AND status = 'processing' AND lease_until > clock_timestamp()`
result, err := s.pool.Exec(
ctx, query, lease.Job.ID, lease.Job.LeaseToken, lease.Job.LeaseOwner, duration.Microseconds(),
)
if err != nil {
return false, fmt.Errorf("renew attachment job lease: %w", err)
}
return result.RowsAffected() == 1, nil
}