docbox-database 0.11.1

Docbox database structures, logic, and migrations
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

use sqlx::error::DatabaseError;

use crate::DbErr;

/// Database error extension helper to determine common types of database
/// errors that can be safely caught
pub trait DatabaseErrorExt {
    fn is_error_code(&self, error_code: &str) -> bool;

    fn is_database_does_not_exist(&self) -> bool;

    fn is_database_exists(&self) -> bool;

    fn is_table_does_not_exist(&self) -> bool;

    fn is_duplicate_record(&self) -> bool;

    fn is_restrict(&self) -> bool;
}

impl DatabaseErrorExt for &dyn DatabaseError {
    fn is_error_code(&self, error_code: &str) -> bool {
        self.code()
            .is_some_and(|code| code.to_string().eq(error_code))
    }

    fn is_database_does_not_exist(&self) -> bool {
        self.is_error_code("3D000" /* Database does not exist */)
    }

    fn is_database_exists(&self) -> bool {
        self.is_error_code("42P04" /* Duplicate database */)
    }

    fn is_table_does_not_exist(&self) -> bool {
        self.is_error_code("42P01" /* Table does not exist */)
    }

    fn is_duplicate_record(&self) -> bool {
        self.is_unique_violation()
    }

    fn is_restrict(&self) -> bool {
        self.is_error_code("23001" /* Foreign key RESTRICT violation */)
    }
}

impl DatabaseErrorExt for DbErr {
    fn is_error_code(&self, error_code: &str) -> bool {
        self.as_database_error()
            .is_some_and(|error| error.is_error_code(error_code))
    }

    fn is_database_does_not_exist(&self) -> bool {
        self.as_database_error()
            .is_some_and(|error| error.is_database_does_not_exist())
    }

    fn is_database_exists(&self) -> bool {
        self.as_database_error()
            .is_some_and(|error| error.is_database_exists())
    }

    fn is_table_does_not_exist(&self) -> bool {
        self.as_database_error()
            .is_some_and(|error| error.is_table_does_not_exist())
    }

    fn is_duplicate_record(&self) -> bool {
        self.as_database_error()
            .is_some_and(|error| error.is_duplicate_record())
    }

    fn is_restrict(&self) -> bool {
        self.as_database_error()
            .is_some_and(|error| error.is_restrict())
    }
}

macro_rules! update_if_some {
    ($self:expr, $($field:ident),+ $(,)?) => {
        $(
            if let Some(value) = $field {
                $self.$field = value;
            }
        )+
    };
}

pub(crate) use update_if_some;