runnerd_core/store/
run.rs1use rusqlite::{Connection, params};
6
7use super::read;
8use crate::api;
9
10#[derive(Debug, Clone, Default, PartialEq, Eq)]
12pub struct RunJobs {
13 pub jobs: Vec<api::JobSummary>,
15 pub more: bool,
17}
18
19pub(super) fn run_jobs(
21 db: &Connection,
22 repository: &str,
23 run: u64,
24 except: u64,
25 limit: usize,
26) -> rusqlite::Result<RunJobs> {
27 let mut statement = db.prepare_cached(
28 "SELECT id FROM jobs WHERE repository = ?1 AND run_id = ?2 AND id != ?3 \
29 ORDER BY run_attempt DESC, id LIMIT ?4",
30 )?;
31 let ids = statement
32 .query_map(
33 params![
34 repository,
35 run,
36 except,
37 i64::try_from(limit).unwrap_or(i64::MAX).saturating_add(1)
38 ],
39 |row| row.get::<_, u64>(0),
40 )?
41 .collect::<rusqlite::Result<Vec<u64>>>()?;
42 let more = ids.len() > limit;
43 let mut jobs = Vec::new();
44 for id in ids.into_iter().take(limit) {
45 jobs.extend(read::summary(db, id)?);
46 }
47 Ok(RunJobs { jobs, more })
48}
49
50#[derive(Debug, Clone, PartialEq, Eq)]
52pub struct RunnerFault {
53 pub job: u64,
55 pub repository: String,
57 pub run: u64,
59 pub attempt: u32,
61}
62
63#[derive(Debug, Clone, Copy, PartialEq, Eq)]
65pub enum Claim {
66 Claimed,
68 Taken,
70 Unstored,
72}
73
74#[derive(Debug)]
76pub(super) struct ClaimKey {
77 pub(super) repository: String,
79 pub(super) run: u64,
81 pub(super) attempt: u32,
83}
84
85pub(super) const CLAIM_KEPT_MS: u64 = 24 * 60 * 60 * 1000;
87
88const FAULTS_MAX: u32 = 500;
90
91pub(super) fn runner_faults(db: &Connection, since: u64) -> rusqlite::Result<Vec<RunnerFault>> {
94 db.prepare_cached(
95 "SELECT id, repository, run_id, run_attempt FROM jobs WHERE runner_fault = 1 AND state = 'completed' \
96 AND rerun_at IS NULL AND run_id != 0 AND coalesce(finished_at, queued_at) >= ?1 AND NOT EXISTS \
97 (SELECT 1 FROM rerun_claims c WHERE c.repository = jobs.repository AND c.run_id = jobs.run_id \
98 AND c.attempt = jobs.run_attempt) ORDER BY id LIMIT ?2",
99 )?
100 .query_map(params![since, FAULTS_MAX], |row| {
101 Ok(RunnerFault {
102 job: row.get(0)?,
103 repository: row.get(1)?,
104 run: row.get(2)?,
105 attempt: row.get(3)?,
106 })
107 })?
108 .collect()
109}