gosh-database 0.2.1

database for gosh
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56

// [[file:../database.note::cc76e0ae][cc76e0ae]]
use gosh_core::*;

use crate::schema::*;
use crate::*;
use gut::prelude::*;

use gosh_model::ModelProperties;

#[derive(Identifiable, Queryable, Associations, PartialEq, Debug)]
#[table_name = "models"]
pub struct Model {
    pub id: i32,
    pub name: String,
}

#[derive(Identifiable, Queryable, Associations, PartialEq, Debug)]
#[table_name = "molecules"]
pub struct Molecule {
    pub id: i32,
    pub name: String,
    pub data: Vec<u8>,
}

#[derive(Identifiable, Queryable, Associations, PartialEq, Debug)]
#[belongs_to(Molecule, foreign_key = "molecule_id")]
#[belongs_to(Model, foreign_key = "model_id")]
#[table_name = "properties"]
#[primary_key(model_id, molecule_id)]
pub struct Properties {
    pub model_id: i32,
    pub molecule_id: i32,
    pub data: Vec<u8>,
}

pub fn save_model_results(mp: &ModelProperties, db: &DbConnection) -> Result<()> {
    let mol = mp.get_molecule().expect("model properties has no structure!");

    // save molecule record
    let conn = db.get();

    // insert a new properties record
    {
        use crate::schema::properties::dsl::*;

        let row = (
            model_id.eq(1),
            molecule_id.eq(1),
            data.eq(bincode::serialize(&mol).unwrap()),
        );
        diesel::insert_into(properties).values(&row).execute(&*conn)?;
    }

    Ok(())
}
// cc76e0ae ends here