pgmt 0.6.4

PostgreSQL migration tool that keeps your schema files as the source of truth
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

//! Table operations

use super::OperationKind;
use crate::catalog::collation::CollationRef;
use crate::catalog::table::{Column, IdentityKind, PrimaryKey};

#[derive(Debug, Clone)]
pub enum TableOperation {
    Create {
        schema: String,
        name: String,
        columns: Vec<Column>,
        primary_key: Option<PrimaryKey>,
    },
    Drop {
        schema: String,
        name: String,
    },
    Alter {
        schema: String,
        name: String,
        actions: Vec<ColumnAction>,
    },
}

impl TableOperation {
    pub fn operation_kind(&self) -> OperationKind {
        match self {
            Self::Create { .. } => OperationKind::Create,
            Self::Drop { .. } => OperationKind::Drop,
            Self::Alter { .. } => OperationKind::Alter,
        }
    }
}

/// Column-level actions within ALTER TABLE
#[derive(Debug, Clone)]
pub enum ColumnAction {
    Add {
        column: Column,
    },
    Drop {
        name: String,
    },
    SetNotNull {
        name: String,
    },
    DropNotNull {
        name: String,
    },
    SetDefault {
        name: String,
        default: String,
    },
    DropDefault {
        name: String,
    },
    DropGenerated {
        name: String,
    },
    AddIdentity {
        name: String,
        kind: IdentityKind,
    },
    SetIdentityKind {
        name: String,
        kind: IdentityKind,
    },
    DropIdentity {
        name: String,
    },
    /// `ALTER COLUMN ... TYPE ...`. Also carries the column's target collation:
    /// PostgreSQL recomputes a column's collation from the TYPE clause, so
    /// omitting COLLATE resets it to the type's default — which makes this the
    /// one action for type changes, collation changes, and collation removal.
    AlterType {
        name: String,
        new_type: String,
        new_collation: Option<CollationRef>,
    },
    AddPrimaryKey {
        constraint: PrimaryKey,
    },
    DropPrimaryKey {
        name: String,
    },
    EnableRls,
    DisableRls,
    ForceRls,
    NoForceRls,
}