headless_lms_models/
rejected_exercise_slide_submissions.rs

1use crate::{
2    exercise_task_submissions::AnswerKind,
3    library::grading::{
4        StudentExerciseSlideSubmission, StudentExerciseTaskSubmission, SubmittedAnswer,
5    },
6    prelude::*,
7};
8
9#[derive(Clone, PartialEq, Deserialize, Serialize)]
10pub struct RejectedExerciseSlideSubmission {
11    pub id: Uuid,
12    pub created_at: DateTime<Utc>,
13    pub updated_at: DateTime<Utc>,
14    pub deleted_at: Option<DateTime<Utc>>,
15    pub user_id: Uuid,
16    pub exercise_slide_id: Uuid,
17    pub http_status_code: Option<i32>,
18    pub error_message: Option<String>,
19    pub response_body: Option<String>,
20}
21
22pub async fn insert_rejected_exercise_slide_submission(
23    conn: &mut PgConnection,
24    rejected_submission: &StudentExerciseSlideSubmission,
25    user_id: Uuid,
26    http_status_code: Option<i32>,
27    error_message: Option<String>,
28    response_body: Option<String>,
29) -> ModelResult<Uuid> {
30    let mut tx = conn.begin().await?;
31    let res = sqlx::query!(
32        "
33INSERT INTO rejected_exercise_slide_submissions (
34    user_id,
35    exercise_slide_id,
36    http_status_code,
37    error_message,
38    response_body
39  )
40VALUES ($1, $2, $3, $4, $5)
41RETURNING id
42        ",
43        user_id,
44        rejected_submission.exercise_slide_id,
45        http_status_code,
46        error_message,
47        response_body,
48    )
49    .fetch_one(&mut *tx)
50    .await?;
51
52    for task in &rejected_submission.exercise_task_submissions {
53        insert_rejected_exercise_task_submission(&mut tx, task, res.id).await?;
54    }
55
56    tx.commit().await?;
57    Ok(res.id)
58}
59
60/// Used internally only by the `insert_rejected_exercise_slide_submission` function.
61async fn insert_rejected_exercise_task_submission(
62    conn: &mut PgConnection,
63    rejected_submission: &StudentExerciseTaskSubmission,
64    exercise_slide_submission_id: Uuid,
65) -> ModelResult<Uuid> {
66    let answer = rejected_submission.to_submitted_answer()?;
67    let (answer_kind, answer_json, file_upload_ids) = match &answer {
68        SubmittedAnswer::Json { data } => (AnswerKind::Json, Some(data), None),
69        SubmittedAnswer::File {
70            metadata,
71            file_upload_ids,
72        } => (AnswerKind::File, metadata.as_ref(), Some(file_upload_ids)),
73    };
74    let res = sqlx::query!(
75        "
76INSERT INTO rejected_exercise_task_submissions (
77    rejected_exercise_slide_submission_id,
78    data_json,
79    answer_kind
80  )
81VALUES ($1, $2, $3)
82RETURNING id
83        ",
84        exercise_slide_submission_id,
85        answer_json,
86        answer_kind,
87    )
88    .fetch_one(&mut *conn)
89    .await?;
90    if let Some(file_upload_ids) = file_upload_ids {
91        insert_rejected_exercise_task_submission_files(conn, res.id, file_upload_ids).await?;
92    }
93    Ok(res.id)
94}
95
96/// Records which files a rejected file answer named.
97///
98/// The files themselves are not spared from the exercise_answer_uploads reaper, so this is what a
99/// later diagnosis has to work from: the ids still resolve to soft-deleted file_uploads rows
100/// carrying each file's name, type and size.
101///
102/// `order_number` must stay encoded exactly as
103/// [`exercise_task_submission_files::insert_many`](crate::exercise_task_submission_files::insert_many)
104/// encodes it, so a rejection can be compared against an accepted answer.
105async fn insert_rejected_exercise_task_submission_files(
106    conn: &mut PgConnection,
107    rejected_exercise_task_submission_id: Uuid,
108    file_upload_ids: &[Uuid],
109) -> ModelResult<()> {
110    sqlx::query!(
111        "
112INSERT INTO rejected_exercise_task_submission_files (
113    rejected_exercise_task_submission_id,
114    file_upload_id,
115    order_number
116  )
117SELECT $1,
118  file_upload_id,
119  (ordinality - 1)::integer
120FROM UNNEST($2::uuid []) WITH ORDINALITY AS t(file_upload_id, ordinality)
121",
122        rejected_exercise_task_submission_id,
123        file_upload_ids
124    )
125    .execute(conn)
126    .await?;
127    Ok(())
128}
129
130/// How many live rejections a user has collected on a slide.
131pub async fn count_with_slide_and_user_ids(
132    conn: &mut PgConnection,
133    exercise_slide_id: Uuid,
134    user_id: Uuid,
135) -> ModelResult<u32> {
136    let count = sqlx::query_scalar!(
137        r#"
138SELECT count(*) AS "count!"
139FROM rejected_exercise_slide_submissions
140WHERE exercise_slide_id = $1
141  AND user_id = $2
142  AND deleted_at IS NULL
143"#,
144        exercise_slide_id,
145        user_id
146    )
147    .fetch_one(conn)
148    .await?;
149    Ok(count.try_into()?)
150}
headless_lms_models/rejected_exercise_slide_submissions.rs

headless_lms_models/
rejected_exercise_slide_submissions.rs
