Struct Database

pub struct Database { /* private fields */ }

The database

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 get_unapproved_papers_count(&self) -> Result<i64, Error>

Returns the number of unapproved papers

pub async fn search_papers( &self, query: &str, exam_filter: Vec<Exam>, ) -> Result<Vec<BaseQP>, 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
• Deletes replace papers from the database.

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>

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_soft_deleted_papers( &self, ) -> Result<Vec<AdminDashboardQP>, Error>

Gets all soft-deleted papers from the database

pub async fn hard_delete( &self, id: i32, ) -> Result<Transaction<'_, Postgres>, Error>

Permanently deletes a paper from the database

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_filelink function.

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

pub async fn insert_new_library_qp<'c>( &self, paper: &LibraryQP, ) -> Result<(Transaction<'c, Postgres>, i32), Error>

Inserts a new library 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_filelink function.

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

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

Updates filelink for an uploaded question paper uploaded using the crate::db::Database::insert_new_uploaded_qp or crate::db::Database::insert_new_library_qp function. Takes the same transaction that the previous function used.

Trait Implementations

impl Clone for Database

fn clone(&self) -> Database

Returns a duplicate of the value.

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

Performs copy-assignment from source.