Struct sudoku_backend::ops::SudokuSolution

pub struct SudokuSolution {
    pub id: Option<i32>,
    pub display_name: String,
    pub board_id: i32,
    pub skeleton: String,
    pub difficulty: i32,
    pub solution_duration_secs: i32,
    pub score: i32,
    pub solution_time: NaiveDateTime,
}

Refer to doc/sudoku.md for more details.

Fields

id: Option<i32>

Unique board ID.

Actually not optional, but this allows us to get an ID from the database.

display_name: String

Solver's display name

board_id: i32

The solved board ID

skeleton: String

The solved board skeleton

difficulty: i32

Board "difficulty", between one and three

solution_duration_secs: i32

Time in seconds taken to achieve the solution

score: i32

Score achieved for the solve

solution_time: NaiveDateTime

Time the solution occured at

Methods

impl SudokuSolution

pub fn new<Sn: Into<String>, Sk: Into<String>>(     solver_name: Sn,     skeleton: Sk,     solved_board: &SudokuBoard,     solution_duration: &Duration ) -> Option<SudokuSolution>

Create a ready-to-insert solution out of the specified data.

Does not validate.

pub fn leaders(     cfg: &LeaderboardConfig,     db: &SqliteConnection ) -> Result<Vec<SudokuSolution>, &'static str>

Retrieve the board with the specified ID.

Examples

Given:

INSERT INTO "sudoku_solutions"
    VALUES(1, 'benlo', 104,
           '.79.2.48...5..........3762.....4627....85......4.9....48....7..5......3.1.....9..',
           3, 26, 435, '2018-08-03 18:26:35');

INSERT INTO "sudoku_solutions"
    VALUES(2, 'EasyStudentBegonia', 104,
           '3.9..54..............937.2.9...4.27...6......21....56..8.56....5...1.8..1..3.....',
           3, 22, 498, '2018-08-03 18:42:56');

INSERT INTO "sudoku_solutions"
    VALUES(3, 'WithoutHighBirch', 104,
           '3.9..54.1.25.8.....4.9......581...7...68.....2....35...8....7.2.......3.1......54',
           3, 14, 732, '2018-08-03 18:44:06');

INSERT INTO "sudoku_solutions"
    VALUES(4, 'LateBrokenAppendix', 104,
           '.7...5..1...4.1...8....762.95......3..68.....21.............71....2......6.3..95.',
           3, 14, 732, '2018-08-03 18:44:25');

The following holds:

let solutions = SudokuSolution::leaders(&LeaderboardConfig {
    count: 3,
    ordering: SolutionOrdering::BestToWorst,
}, &db).unwrap();
assert_eq!(
    solutions,
    &[SudokuSolution {
          id: Some(3),
          display_name: "WithoutHighBirch".to_string(),
          board_id: 104,
          skeleton: "3.9..54.1.25.8.....4.9......581...7...68.....2....35...8....7.2.......3.1......54".to_string(),
          difficulty: 3,
          solution_duration_secs: 14,
          score: 732,
          solution_time: NaiveDate::from_ymd(2018, 8, 3).and_hms(18, 44, 06),
      },
      SudokuSolution {
          id: Some(4),
          display_name: "LateBrokenAppendix".to_string(),
          board_id: 104,
          skeleton: ".7...5..1...4.1...8....762.95......3..68.....21.............71....2......6.3..95.".to_string(),
          difficulty: 3,
          solution_duration_secs: 14,
          score: 732,
          solution_time: NaiveDate::from_ymd(2018, 8, 3).and_hms(18, 44, 25),
      },
      SudokuSolution {
          id: Some(2),
          display_name: "EasyStudentBegonia".to_string(),
          board_id: 104,
          skeleton: "3.9..54..............937.2.9...4.27...6......21....56..8.56....5...1.8..1..3.....".to_string(),
          difficulty: 3,
          solution_duration_secs: 22,
          score: 498,
          solution_time: NaiveDate::from_ymd(2018, 8, 3).and_hms(18, 42, 56),
      }]);

pub fn insert(&mut self, db: &SqliteConnection) -> Result<(), &'static str>

Insert this board into the specified DB, updating its id.

Examples

Assuming empty table:

let mut board =
    SudokuSolution::new(username, board_skeleton, &SudokuBoard::get(board_id, &db).unwrap(), Duration::seconds(25));
assert!(solution.id.is_none());

solution.insert(&db).unwrap();
assert_eq!(solution.id, Some(1));

Trait Implementations

impl PartialEq<SudokuSolution> for SudokuSolution

fn eq(&self, other: &SudokuSolution) -> bool

This method tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &SudokuSolution) -> bool

This method tests for !=.

impl Clone for SudokuSolution

fn clone(&self) -> SudokuSolution

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Ord for SudokuSolution

fn cmp(&self, other: &SudokuSolution) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

Compares and returns the minimum of two values.

impl Eq for SudokuSolution

impl PartialOrd<SudokuSolution> for SudokuSolution

fn partial_cmp(&self, other: &SudokuSolution) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

fn lt(&self, other: &SudokuSolution) -> bool

This method tests less than (for self and other) and is used by the < operator.

fn le(&self, other: &SudokuSolution) -> bool

This method tests less than or equal to (for self and other) and is used by the <= operator.

fn gt(&self, other: &SudokuSolution) -> bool

This method tests greater than (for self and other) and is used by the > operator.

fn ge(&self, other: &SudokuSolution) -> bool

This method tests greater than or equal to (for self and other) and is used by the >= operator.

impl Debug for SudokuSolution

fn fmt(&self, f: &mut Formatter) -> Result

Formats the value using the given formatter.

impl Hash for SudokuSolution

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given [Hasher].

fn hash_slice<H>(data: &[Self], state: &mut H) where     H: Hasher,

Feeds a slice of this type into the given [Hasher].

impl Serialize for SudokuSolution

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error> where     __S: Serializer,

Serialize this value into the given Serde serializer.

impl<'de> Deserialize<'de> for SudokuSolution

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error> where     __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl<'insert> Insertable<table> for SudokuSolution

type Values = <(Option<Eq<id, i32>>, Option<Eq<display_name, String>>, Option<Eq<board_id, i32>>, Option<Eq<skeleton, String>>, Option<Eq<difficulty, i32>>, Option<Eq<solution_duration_secs, i32>>, Option<Eq<score, i32>>, Option<Eq<solution_time, NaiveDateTime>>) as Insertable<table>>::Values

The VALUES clause to insert these records

fn values(self) -> Self::Values

Construct Self::Values

fn insert_into(     self,     table: T ) -> InsertStatement<T, Self::Values, Insert, NoReturningClause>

Insert self into a given table.

impl<'insert> Insertable<table> for &'insert SudokuSolution

type Values = <(Option<Eq<id, &'insert i32>>, Option<Eq<display_name, &'insert String>>, Option<Eq<board_id, &'insert i32>>, Option<Eq<skeleton, &'insert String>>, Option<Eq<difficulty, &'insert i32>>, Option<Eq<solution_duration_secs, &'insert i32>>, Option<Eq<score, &'insert i32>>, Option<Eq<solution_time, &'insert NaiveDateTime>>) as Insertable<table>>::Values

The VALUES clause to insert these records

fn values(self) -> Self::Values

Construct Self::Values

fn insert_into(     self,     table: T ) -> InsertStatement<T, Self::Values, Insert, NoReturningClause>

Insert self into a given table.

impl<__DB: Backend, __ST> Queryable<__ST, __DB> for SudokuSolution where     (Option<i32>, String, i32, String, i32, i32, i32, NaiveDateTime): Queryable<__ST, __DB>,

type Row = <(Option<i32>, String, i32, String, i32, i32, i32, NaiveDateTime) as Queryable<__ST, __DB>>::Row

The Rust type you'd like to map from.

fn build(row: Self::Row) -> Self

Construct an instance of this type

impl<'update> AsChangeset for &'update SudokuSolution

type Target = table

The table which Self::Changeset will be updating

type Changeset = <(Eq<display_name, &'update String>, Eq<board_id, &'update i32>, Eq<skeleton, &'update String>, Eq<difficulty, &'update i32>, Eq<solution_duration_secs, &'update i32>, Eq<score, &'update i32>, Eq<solution_time, &'update NaiveDateTime>) as AsChangeset>::Changeset

The update statement this type represents

fn as_changeset(self) -> Self::Changeset

Convert self into the actual update statement being executed

impl<'update> AsChangeset for SudokuSolution

type Target = table

The table which Self::Changeset will be updating

type Changeset = <(Eq<display_name, String>, Eq<board_id, i32>, Eq<skeleton, String>, Eq<difficulty, i32>, Eq<solution_duration_secs, i32>, Eq<score, i32>, Eq<solution_time, NaiveDateTime>) as AsChangeset>::Changeset

The update statement this type represents

fn as_changeset(self) -> Self::Changeset

Convert self into the actual update statement being executed

impl<'insert> UndecoratedInsertRecord<table> for SudokuSolution