Function iqps_backend::db::queries::get_edit_paper_query

source ·
pub fn get_edit_paper_query(approval: bool) -> String
Expand description

Returns a query that updates a paper’s details by id ($1) (course_code, course_name, year, semester, exam, approve_status, filelink). approved_by optionally included if the edit is also used for approval.

The query also returns all the admin dashboard qp fields of the edited paper

Query parameters:

  • $1: id
  • $2: course_code
  • $3: course_name
  • $4: year
  • $5: semester
  • $6: exam
  • $7: approve_status
  • $8: filelink
  • $9: approved_by