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