CourseDataLoadService.java
package edu.ucsb.cs156.courses.services;
import edu.ucsb.cs156.courses.jobs.MissingCourseDataJob;
import edu.ucsb.cs156.courses.jobs.UpdateCourseDataJobFactory;
import edu.ucsb.cs156.courses.repositories.CourseDataJobsRepository;
import edu.ucsb.cs156.courses.repositories.UCSBSubjectRepository;
import edu.ucsb.cs156.jobs.services.JobService;
import java.util.List;
import lombok.RequiredArgsConstructor;
import org.springframework.security.core.context.SecurityContextHolder;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Isolation;
import org.springframework.transaction.annotation.Transactional;
@Service
@RequiredArgsConstructor
public class CourseDataLoadService {
private final UCSBSubjectRepository subjects;
private final UpdateService updates;
private final CourseDataJobsRepository jobs;
private final UpdateCourseDataJobFactory factory;
private final JobService jobService;
/**
* Serialize the short check/submit step across app instances using the existing subject row.
* JobService commits its queued row in a separate transaction before returning. READ_COMMITTED
* ensures the next lock holder sees that job. No course retrieval happens in this transaction.
* Terminal jobs do not suppress retries, and an old update still counts as loaded data.
*/
@Transactional(isolation = Isolation.READ_COMMITTED, noRollbackFor = Exception.class)
public boolean ensureLoaded(String subject, String quarter) throws Exception {
subjects
.lockSubject(subject)
.orElseThrow(() -> new IllegalArgumentException("Unknown subject"));
if (updates.getLastUpdate(subject, quarter).isPresent()) {
return true;
}
var job =
new MissingCourseDataJob(
subject, quarter, factory.createForSubjectAndQuarterAndIfStale(subject, quarter, true));
if (!jobs.existsByJobNameAndStatusIn(
job.getJobName(), List.of("queued", "running", "cancelling"))) {
var originalContext = SecurityContextHolder.getContext();
try {
// Shared cache fills are system jobs; user attribution must not require an OAuth lookup.
SecurityContextHolder.setContext(SecurityContextHolder.createEmptyContext());
jobService.runAsJob(job);
} catch (RuntimeException e) {
// The library commits the queued row before dispatching to its executor. If dispatch
// fails, do not leave a queued row that would suppress every future retry.
jobs.failQueuedSubmission(job.getJobName());
throw e;
} finally {
SecurityContextHolder.setContext(originalContext);
}
}
return false;
}
}