use rusqlite::{Connection, params};
use super::read;
use crate::api;
#[derive(Debug, Clone, Default, PartialEq, Eq)]
pub struct RunJobs {
pub jobs: Vec<api::JobSummary>,
pub more: bool,
}
pub(super) fn run_jobs(
db: &Connection,
repository: &str,
run: u64,
except: u64,
limit: usize,
) -> rusqlite::Result<RunJobs> {
let mut statement = db.prepare_cached(
"SELECT id FROM jobs WHERE repository = ?1 AND run_id = ?2 AND id != ?3 \
ORDER BY run_attempt DESC, id LIMIT ?4",
)?;
let ids = statement
.query_map(
params![
repository,
run,
except,
i64::try_from(limit).unwrap_or(i64::MAX).saturating_add(1)
],
|row| row.get::<_, u64>(0),
)?
.collect::<rusqlite::Result<Vec<u64>>>()?;
let more = ids.len() > limit;
let mut jobs = Vec::new();
for id in ids.into_iter().take(limit) {
jobs.extend(read::summary(db, id)?);
}
Ok(RunJobs { jobs, more })
}