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 }