Method: Naf::QueuedJob.prerequisites_finished

Defined in:
app/models/naf/queued_job.rb

.prerequisites_finished ⇒ Object 



102
103
104
105
106
107
108
109
110
111
112
113
114
115
 
# File 'app/models/naf/queued_job.rb', line 102

def self.prerequisites_finished
  where("NOT EXISTS (
    SELECT 1
    FROM #{::Naf.schema_name}.historical_job_prerequisites AS p
    WHERE p.historical_job_id = #{::Naf.schema_name}.queued_jobs.id AND
      EXISTS (
        SELECT 1
        FROM #{::Naf.schema_name}.historical_jobs AS j
        WHERE p.prerequisite_historical_job_id = j.id AND
          j.finished_at IS NULL
      )
    )"
  )
end