use super::Cache;
use super::models::ReviewCard;
use super::schemas::reviews::dsl::*;
use crate::err::Error;
use crate::srs::{Day, Grade, Schedule};
use diesel::prelude::*;
impl Cache {
pub fn review_card(&self, problem_fid: i32) -> Result<Option<ReviewCard>, Error> {
Ok(reviews
.filter(fid.eq(problem_fid))
.first::<ReviewCard>(&mut self.conn()?)
.optional()?)
}
pub fn review_cards(&self) -> Result<Vec<ReviewCard>, Error> {
Ok(reviews
.order(due_day.asc())
.load::<ReviewCard>(&mut self.conn()?)?)
}
pub fn due_review_cards(&self, day: Day) -> Result<Vec<ReviewCard>, Error> {
Ok(reviews
.filter(due_day.le(day))
.order(due_day.asc())
.load::<ReviewCard>(&mut self.conn()?)?)
}
pub fn due_review_fids(&self, day: Day) -> Result<Vec<i32>, Error> {
Ok(reviews
.filter(due_day.le(day))
.order(due_day.asc())
.select(fid)
.load::<i32>(&mut self.conn()?)?)
}
pub fn review_count(&self) -> Result<i64, Error> {
Ok(reviews.count().get_result(&mut self.conn()?)?)
}
pub fn enroll_review(&self, problem_fid: i32, today: Day) -> Result<(), Error> {
let card = ReviewCard::new(problem_fid, Schedule::default(), today);
diesel::insert_or_ignore_into(reviews)
.values(&card)
.execute(&mut self.conn()?)?;
Ok(())
}
pub fn grade_review(
&self,
problem_fid: i32,
grade: Grade,
today: Day,
) -> Result<ReviewCard, Error> {
let current = self
.review_card(problem_fid)?
.map(|card| card.schedule())
.unwrap_or_default();
self.write_schedule(problem_fid, current.next(grade), today)
}
pub fn grade_enrolled_review(
&self,
problem_fid: i32,
grade: Grade,
today: Day,
) -> Result<Option<ReviewCard>, Error> {
let Some(card) = self.review_card(problem_fid)? else {
return Ok(None);
};
self.write_schedule(problem_fid, card.schedule().next(grade), today)
.map(Some)
}
fn write_schedule(
&self,
problem_fid: i32,
schedule: Schedule,
today: Day,
) -> Result<ReviewCard, Error> {
let card = ReviewCard::new(problem_fid, schedule, today);
diesel::replace_into(reviews)
.values(&card)
.execute(&mut self.conn()?)?;
Ok(card)
}
pub fn drop_review(&self, problem_fid: i32) -> Result<bool, Error> {
let removed =
diesel::delete(reviews.filter(fid.eq(problem_fid))).execute(&mut self.conn()?)?;
Ok(removed > 0)
}
}