pg-blast-radius 0.3.0

Workload-aware blast radius forecaster for PostgreSQL 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

use pg_query::protobuf::{self, ObjectType};

use crate::parse::format_relation;
use crate::types::*;

use super::RuleContext;

pub fn analyse_rename(
    rename: &protobuf::RenameStmt,
    stmt_sql: &str,
    _ctx: &RuleContext,
) -> Vec<Finding> {
    let obj_type = ObjectType::try_from(rename.rename_type).unwrap_or(ObjectType::Undefined);

    let table = rename
        .relation
        .as_ref()
        .map(format_relation)
        .unwrap_or_else(|| "unknown".into());

    match obj_type {
        ObjectType::ObjectColumn => {
            vec![Finding {
                rule_id: "rename-column".into(),
                risk_level: RiskLevel::Medium,
                confidence: ConfidenceLedger::static_only(
                    vec!["ACCESS EXCLUSIVE lock for RENAME COLUMN (brief, catalog only)".into()],
                ),
                lock_mode: LockMode::AccessExclusive,
                rewrite: RewriteRisk::None,
                affected_table: Some(table.clone()),
                summary: format!(
                    "RENAME COLUMN \"{}\" to \"{}\" on \"{table}\"",
                    rename.subname, rename.newname
                ),
                explanation: "ACCESS EXCLUSIVE lock (brief, catalog update only). \
                    No table rewrite. The primary risk is application-level breakage \
                    if code still references the old column name."
                    .into(),
                recipe: None,
                pg_version_note: None,
                statement_sql: stmt_sql.into(),
                duration_forecast: None,
            }]
        }
        ObjectType::ObjectTable => {
            vec![Finding {
                rule_id: "rename-table".into(),
                risk_level: RiskLevel::Medium,
                confidence: ConfidenceLedger::static_only(
                    vec!["ACCESS EXCLUSIVE lock for RENAME TABLE (brief, catalog only)".into()],
                ),
                lock_mode: LockMode::AccessExclusive,
                rewrite: RewriteRisk::None,
                affected_table: Some(table.clone()),
                summary: format!(
                    "RENAME TABLE \"{table}\" to \"{}\"",
                    rename.newname
                ),
                explanation: "ACCESS EXCLUSIVE lock (brief, catalog update only). \
                    No table rewrite. The primary risk is application-level breakage \
                    if code still references the old table name."
                    .into(),
                recipe: None,
                pg_version_note: None,
                statement_sql: stmt_sql.into(),
                duration_forecast: None,
            }]
        }
        _ => vec![],
    }
}