forked from mtusi2026/mtusi2026lab7
33 lines
939 B
Go
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
|
|
}
|