toasty-sql 0.4.0

SQL serialization layer for Toasty database drivers
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

use super::Statement;

use toasty_core::{
    schema::db::{Index, IndexId, IndexOp, TableId},
    stmt,
};

/// A `CREATE INDEX` statement.
#[derive(Debug, Clone)]
pub struct CreateIndex {
    /// Name of the index
    pub index: IndexId,

    /// Which table to index
    pub on: TableId,

    /// The columns to index
    pub columns: Vec<stmt::OrderByExpr>,

    /// When true, the index is unique
    pub unique: bool,
}

impl Statement {
    /// Creates a `CREATE INDEX` statement from a schema [`Index`].
    pub fn create_index(index: &Index) -> Self {
        CreateIndex {
            index: index.id,
            on: index.on,
            columns: index
                .columns
                .iter()
                .map(|index_column| stmt::OrderByExpr {
                    expr: stmt::Expr::column(index_column.column),
                    order: match index_column.op {
                        IndexOp::Eq => None,
                        IndexOp::Sort(direction) => Some(direction),
                    },
                })
                .collect(),
            unique: index.unique,
        }
        .into()
    }
}

impl From<CreateIndex> for Statement {
    fn from(value: CreateIndex) -> Self {
        Self::CreateIndex(value)
    }
}