tailwag_orm 0.1.0

An ORM for building Postgres schemas and data access with a Manager pattern, backed by sqlx.
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

use std::sync::Arc;

use crate::BuildSql;

use super::{
    Identifier, IndexParameters, ReferencesConstraintMatchType, ReferentialAction, TableColumn,
};

#[derive(Clone, PartialEq, Eq, Debug)]
pub struct TableConstraint {
    pub name: Option<Identifier>,
    pub detail: Arc<TableConstraintDetail>,
}

impl BuildSql for TableConstraint {
    fn build_sql(
        &self,
        sql: &mut sqlx::QueryBuilder<'_, sqlx::Postgres>,
    ) {
        if let Some(name) = &self.name {
            sql.push("CONSTRAINT ").push_bind(name.to_string()).push(" ");
        }
        self.detail.build_sql(sql);
    }
}

#[derive(PartialEq, Eq, Debug)]
pub enum TableConstraintDetail {
    Unique(UniqueConstraint),
    PrimaryKey(PrimaryKeyConstraint),
    ForeignKey(ForeignKeyConstraint),
}

impl BuildSql for TableConstraintDetail {
    fn build_sql(
        &self,
        sql: &mut sqlx::QueryBuilder<'_, sqlx::Postgres>,
    ) {
        match self {
            Self::ForeignKey(fk) => fk.build_sql(sql),
            Self::Unique(un) => un.build_sql(sql),
            Self::PrimaryKey(pk) => pk.build_sql(sql),
        };
    }
}

#[derive(PartialEq, Eq, Debug)]
pub struct UniqueConstraint {
    is_null_distinct: bool,
    index_parameters: Option<IndexParameters>,
    columns: Vec<TableColumn>,
}

impl BuildSql for UniqueConstraint {
    fn build_sql(
        &self,
        sql: &mut sqlx::QueryBuilder<'_, sqlx::Postgres>,
    ) {
        sql.push("UNIQUE ");
        if self.is_null_distinct {
            sql.push("NULLS DISTINCT ");
        }
        let columns = self.columns.iter().map(|col| col.column_name.clone()).collect::<Vec<_>>();
        columns.build_sql(sql);
    }
}

#[derive(PartialEq, Eq, Debug)]
pub struct PrimaryKeyConstraint {
    index_parameters: Option<IndexParameters>,
    pub columns: Vec<TableColumn>,
}

impl BuildSql for PrimaryKeyConstraint {
    fn build_sql(
        &self,
        sql: &mut sqlx::QueryBuilder<'_, sqlx::Postgres>,
    ) {
        sql.push("PRIMARY KEY ");
        let columns = self.columns.iter().map(|col| col.column_name.clone()).collect::<Vec<_>>();
        columns.build_sql(sql);

        // TODO: IndexParameters impl
    }
}

impl BuildSql for ForeignKeyConstraint {
    fn build_sql(
        &self,
        builder: &mut sqlx::QueryBuilder<'_, sqlx::Postgres>,
    ) {
        let Self {
            ref_table,
            ref_columns,
            columns,
            match_type,
            on_delete_action,
            on_update_action,
        } = self;
        builder.push("FOREIGN_KEY(");
        // TODO: Loop through columns
        columns
            .iter()
            .map(|col| col.column_name.clone())
            .collect::<Vec<_>>()
            .build_sql(builder);
        builder.push(") ").push("REFERENCES ").push(&**ref_table).push("(");
        ref_columns.build_sql(builder);
        builder.push(")");
    }
}

#[derive(PartialEq, Eq, Debug)]
pub struct ForeignKeyConstraint {
    pub ref_table: Identifier,
    pub ref_columns: Vec<Identifier>, // TODO: Yank this to a more definitive mapping from columns and ref_columns
    pub columns: Vec<TableColumn>,
    pub match_type: Option<ReferencesConstraintMatchType>,
    pub on_delete_action: Option<ReferentialAction>,
    pub on_update_action: Option<ReferentialAction>,
}