CourseDataJobsRepository.java

package edu.ucsb.cs156.courses.repositories;

import java.util.Collection;
import java.util.Map;
import lombok.RequiredArgsConstructor;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.stereotype.Repository;

/** Queries the job library's existing table without adding another entity or schema migration. */
@Repository
@RequiredArgsConstructor
public class CourseDataJobsRepository {
  private final NamedParameterJdbcTemplate jdbc;

  public boolean existsByJobNameAndStatusIn(String jobName, Collection<String> statuses) {
    return Boolean.TRUE.equals(
        jdbc.queryForObject(
            "select exists (select 1 from jobs where job_name = :name and status in (:statuses))",
            Map.of("name", jobName, "statuses", statuses),
            Boolean.class));
  }

  public void failQueuedSubmission(String name) {
    jdbc.update(
        "update jobs set status = 'failed' where job_name = :name and status = 'queued'",
        Map.of("name", name));
  }
}