6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
# File 'app/models/logical/naf/job_statuses/queued.rb', line 6
def self.all(conditions)
<<-SQL
(
SELECT DISTINCT
j.*, jp."historical_job_id"
FROM
"#{::Naf.schema_name}"."historical_jobs" AS j
LEFT JOIN
"#{::Naf.schema_name}"."historical_job_prerequisites" AS jp
ON j."id" = jp."historical_job_id"
WHERE
j.finished_at IS NULL AND
j.request_to_terminate = false AND
jp.historical_job_id IS NULL AND
j.started_at IS NULL
#{conditions}
ORDER BY
created_at desc
)
SQL
end
|