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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133

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

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

use super::{etymologies::Etymologies, utils::SQLBuilder};

#[derive(Iden)]
pub enum Pronunciations {
    Table,
    ID,
    Kind,
    Value,
    EtymologyID,
}

#[derive(Iden)]
pub enum PronunciationUrls {
    Table,
    ID,
    Source,
    MimeType,
    PronunciationID,
}

pub fn create_pronunciations(builder: &mut SQLBuilder) {
    // Create the pronunciations table
    builder.add_table(
        Table::create()
            .table(Pronunciations::Table)
            .if_not_exists()
            .col(
                ColumnDef::new(Pronunciations::ID)
                    .uuid()
                    .not_null()
                    .primary_key(),
            )
            .col(ColumnDef::new(Pronunciations::Kind).string())
            .col(ColumnDef::new(Pronunciations::Value).string().not_null())
            .col(
                ColumnDef::new(Pronunciations::EtymologyID)
                    .uuid()
                    .not_null(),
            )
            .foreign_key(
                ForeignKey::create()
                    .from(Pronunciations::Table, Pronunciations::EtymologyID)
                    .to(Etymologies::Table, Etymologies::ID)
                    .on_delete(ForeignKeyAction::Cascade)
                    .on_update(ForeignKeyAction::Cascade),
            ),
    );

    // Create the pronunciation_urls table
    builder.add_table(
        Table::create()
            .table(PronunciationUrls::Table)
            .if_not_exists()
            .col(
                ColumnDef::new(PronunciationUrls::ID)
                    .uuid()
                    .not_null()
                    .primary_key(),
            )
            .col(
                ColumnDef::new(PronunciationUrls::Source)
                    .string()
                    .not_null(),
            )
            .col(ColumnDef::new(PronunciationUrls::MimeType).string())
            .col(
                ColumnDef::new(PronunciationUrls::PronunciationID)
                    .uuid()
                    .not_null(),
            )
            .foreign_key(
                ForeignKey::create()
                    .from(PronunciationUrls::Table, PronunciationUrls::PronunciationID)
                    .to(Pronunciations::Table, Pronunciations::ID)
                    .on_delete(ForeignKeyAction::Cascade)
                    .on_update(ForeignKeyAction::Cascade),
            ),
    );
}

pub fn insert_pronunciation(
    builder: &mut SQLBuilder,
    etymology_id: &str,
    pronunciation: &Pronunciation,
) -> crate::Result<()> {
    let id = ID::default();

    // Insert the pronunciation
    builder.add_insert(
        Query::insert()
            .into_table(Pronunciations::Table)
            .columns([
                Pronunciations::ID,
                Pronunciations::Kind,
                Pronunciations::Value,
                Pronunciations::EtymologyID,
            ])
            .values([
                id.as_str().into(),
                pronunciation.kind.clone().map(|k| k.to_string()).into(),
                pronunciation.value.clone().into(),
                etymology_id.into(),
            ])?,
    );

    // Insert any URLs
    for url in &pronunciation.media {
        let url_id = ID::default();

        builder.add_insert(
            Query::insert()
                .into_table(PronunciationUrls::Table)
                .columns([
                    PronunciationUrls::ID,
                    PronunciationUrls::Source,
                    PronunciationUrls::MimeType,
                    PronunciationUrls::PronunciationID,
                ])
                .values([
                    url_id.as_str().into(),
                    url.src.clone().into(),
                    url.mime_type.clone().unwrap_or_default().into(),
                    id.as_str().into(),
                ])?,
        );
    }

    Ok(())
}