Struct iqps_backend::db::Database

pub struct Database {
    connection: PgPool,
}

The database

Fields

connection: PgPool

Implementations

impl Database

pub async fn new(env_vars: &EnvVars) -> Result<Self, Error>

Creates a new database connection given the environment variables.

pub async fn get_unapproved_papers( &self, ) -> Result<Vec<AdminDashboardQP>, Error>

Fetches the list of all unapproved papers

pub async fn search_papers( &self, query: &str, exam_filter: ExamFilter, exam_filter_str: String, ) -> Result<Vec<SearchQP>, Error>

Searches for papers from a given query. Uses some voodoo black magic by @rajivharlalka

pub async fn get_paper_by_id(&self, id: i32) -> Result<AdminDashboardQP, Error>

pub async fn edit_paper<'c>( &self, edit_req: EditReq, username: &str, env_vars: &EnvVars, ) -> Result<(Transaction<'c, Postgres>, String, AdminDashboardQP), Error>

Edit’s a paper’s details.

• Sets the approved_by field to the username if approved.
• Sets the filelink to:
  • For library papers, remains unchanged
  • For uploaded papers, approved papers are moved to the approved directory and renamed id_coursecode_coursename_year_semester_exam.pdf and unapproved papers are moved to the unapproved directory and named id.pdf

Returns the database transaction, the old filelink and the new paper details (crate::qp::AdminDashboardQP)

pub async fn soft_delete(&self, id: i32) -> Result<bool, Error>

Adds a new upload paper’s details to the database. Sets the from_library field to false.

Returns the database transaction and the id of the uploaded paper Sets the is_deleted field to true and approve_status to false. Only deletes uploaded papers.

Returns a boolean that represents whether a db entry was affected or not. If more than one entry was affected, an error will be thrown and the transaction will be rolled back.

pub async fn get_similar_papers( &self, course_code: &str, year: Option<i32>, semester: Option<&String>, exam: Option<&String>, ) -> Result<Vec<AdminDashboardQP>, Error>

Returns all papers that match one or more of the specified properties exactly. course_name is required, other properties are optional.

pub async fn insert_new_uploaded_qp<'c>( &self, file_details: &FileDetails, ) -> Result<(Transaction<'c, Postgres>, i32), Error>

Inserts a new uploaded question paper into the database. Uses a placeholder for the filelink which should be replaced once the id is known using the crate::db::Database::update_uploaded_filelink function.

Returns a tuple with the transaction and the id of the inserted paper.

pub async fn update_uploaded_filelink<'c>( &self, tx: &mut Transaction<'c, Postgres>, id: i32, file_link: &str, ) -> Result<(), Error>

Trait Implementations

impl Clone for Database

fn clone(&self) -> Database

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.