crash_orm 0.7.2

A simple, typed ORM for Postgres
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

use crate::prelude::{BoxedSql, Column, Entity, IntoSql, UntypedColumnValue, VirtualColumn};

/// Trait implementing string database functions to create [VirtualColumn]s for string columns
pub trait StringVirtualColumn<U: Entity> {
    /// Convert self to lowercase
    fn lowercase(&self) -> VirtualColumn<String, U>;

    /// Convert self to uppercase
    fn uppercase(&self) -> VirtualColumn<String, U>;

    /// Reverse self
    fn reverse(&self) -> VirtualColumn<String, U>;

    /// Get the length of self
    fn length(&self) -> VirtualColumn<i32, U>;

    /// Repeat self `repetition` times
    fn repeat(&self, repetition: impl IntoSql<i32>) -> VirtualColumn<String, U>;

    /// Concat self and other
    fn concat(&self, other: Vec<&(dyn UntypedColumnValue)>) -> VirtualColumn<String, U>;

    /// Creates the md5 hash of this string
    fn md5(&self) -> VirtualColumn<String, U>;
}

impl<U: Entity, R: Column<String, U>> StringVirtualColumn<U> for R {
    fn lowercase(&self) -> VirtualColumn<String, U> {
        let sql = self.get_sql();
        VirtualColumn::new(BoxedSql::new(
            format!("LOWER({})", sql.sql),
            sql.values,
        ))
    }

    fn uppercase(&self) -> VirtualColumn<String, U> {
        let sql = self.get_sql();
        VirtualColumn::new(BoxedSql::new(
            format!("UPPER({})", sql.sql),
            sql.values,
        ))
    }

    fn reverse(&self) -> VirtualColumn<String, U> {
        let sql = self.get_sql();
        VirtualColumn::new(BoxedSql::new(
            format!("REVERSE({})", sql.sql),
            sql.values,
        ))
    }

    fn length(&self) -> VirtualColumn<i32, U> {
        let sql = self.get_sql();
        VirtualColumn::new(BoxedSql::new(
            format!("LENGTH({})", sql.sql),
            sql.values,
        ))
    }

    fn repeat(&self, repetition: impl IntoSql<i32>) -> VirtualColumn<String, U> {
        let sql = self.get_sql();
        let repetition_sql = repetition.into_boxed_sql();
        let mut values = sql.values;
        values.extend(repetition_sql.values);
        VirtualColumn::new(BoxedSql::new(
            format!("REPEAT({},{})", sql.sql, repetition_sql.sql),
            values,
        ))
    }

    fn concat(&self, other: Vec<&(dyn UntypedColumnValue)>) -> VirtualColumn<String, U> {
        let mut sql = self.get_sql();
        for value in other {
            let value_sql = value.get_sql();
            sql.sql.push_str(" || ");
            sql.sql.push_str(&*value_sql.sql);
            sql.values.extend(value_sql.values);
        }

        VirtualColumn::new(sql)
    }

    fn md5(&self) -> VirtualColumn<String, U> {
        let sql = self.get_sql();
        VirtualColumn::new(BoxedSql::new(
            format!("MD5({})", sql.sql),
            sql.values,
        ))
    }
}