odict 3.3.0

A blazingly-fast dictionary file format for human languages
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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96

use sea_query::{ColumnDef, Expr, ForeignKey, ForeignKeyAction, Iden, Query, Table};

use crate::schema::{Example, ID};

use super::{definitions::Definitions, notes::Notes, utils::SQLBuilder};

#[derive(Iden)]
pub enum Examples {
    Table,
    ID,
    Value,
    Index,
    DefinitionID,
    NoteID,
}

pub fn create_examples(builder: &mut SQLBuilder) {
    builder.add_table(
        Table::create()
            .table(Examples::Table)
            .if_not_exists()
            .col(ColumnDef::new(Examples::ID).uuid().not_null().primary_key())
            .col(ColumnDef::new(Examples::Value).string())
            .col(ColumnDef::new(Examples::Index).integer().not_null())
            .col(ColumnDef::new(Examples::DefinitionID).uuid())
            .col(ColumnDef::new(Examples::NoteID).uuid())
            .foreign_key(
                ForeignKey::create()
                    .from(Examples::Table, Examples::DefinitionID)
                    .to(Definitions::Table, Definitions::ID)
                    .on_delete(ForeignKeyAction::Cascade)
                    .on_update(ForeignKeyAction::Cascade),
            )
            .foreign_key(
                ForeignKey::create()
                    .from(Examples::Table, Examples::DefinitionID)
                    .to(Notes::Table, Notes::ID)
                    .on_delete(ForeignKeyAction::Cascade)
                    .on_update(ForeignKeyAction::Cascade),
            ),
    )
}

pub fn insert_example(
    builder: &mut SQLBuilder,
    definition_id: Option<&str>,
    note_id: Option<&str>,
    index: u32,
    example: &Example,
) -> crate::Result<()> {
    builder.add_insert(
        Query::insert()
            .into_table(Examples::Table)
            .columns([
                Examples::ID,
                Examples::Value,
                Examples::Index,
                Examples::DefinitionID,
                Examples::NoteID,
            ])
            .values([
                ID::default().as_str().into(),
                example.value.as_str().into(),
                index.into(),
                definition_id.map_or(Expr::cust("NULL"), |id| id.into()),
                note_id.map_or(Expr::cust("NULL"), |id| id.into()),
            ])?,
    );

    Ok(())
}

#[cfg(test)]
mod test {

    use super::*;

    #[test]
    fn test_null() {
        let builder = &mut SQLBuilder::new(crate::format::sql::SQLDialect::Postgres);

        let example = Example {
            pronunciations: vec![],
            value: String::from("test"),
            translations: vec![],
        };

        let result = insert_example(builder, None, None, 0, &example);

        assert!(result.is_ok());

        let built = builder.build().unwrap();

        assert!(built.ends_with("'test', 0, NULL, NULL)"));
    }
}