mockgres 0.0.29

An in-memory database that replicates a reasonable subset of Postgres functionality to make unit tests that rely on a database to run.
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
122
123
124
125
126
127
128
129
130

use super::*;

fn builtin(name: &str, column: &str, data_type: DataType) -> Plan {
    Plan::CallBuiltin {
        name: format!("regression:compression:{name}"),
        args: Vec::new(),
        schema: Schema {
            fields: vec![Field {
                name: column.to_string(),
                data_type,
                origin: None,
            }],
        },
    }
}

fn error_builtin(name: String) -> Plan {
    Plan::CallBuiltin {
        name,
        args: Vec::new(),
        schema: Schema { fields: Vec::new() },
    }
}

fn error(message: &str) -> Plan {
    error_builtin(format!("regression:error:{message}"))
}

fn error_detail(message: &str, detail: &str) -> Plan {
    error_builtin(format!("regression:error_detail:{message}|{detail}"))
}

fn error_hint(message: &str, hint: &str) -> Plan {
    error_builtin(format!("regression:error_hint:{message}|{hint}"))
}

fn no_op(tag: &'static str) -> Plan {
    Plan::UtilityNoOp { tag }
}

pub(super) fn try_plan_regression_compression(normalized: &str) -> Option<Plan> {
    if normalized.starts_with("select pg_column_compression(") {
        let table = normalized.rsplit_once(" from ")?.1.trim();
        return Some(builtin(
            &format!("column:{table}"),
            "pg_column_compression",
            DataType::Text,
        ));
    }
    if normalized.starts_with("select substr(f1, 2000, 50) from cmdata1") {
        return Some(builtin("substr:cmdata1:long", "substr", DataType::Text));
    }
    if normalized.starts_with("select substr(f1, 200, 5) from ") {
        let table = normalized.rsplit_once(" from ")?.1.trim();
        return Some(builtin(
            &format!("substr:{table}:short"),
            "substr",
            DataType::Text,
        ));
    }
    if normalized.starts_with("select length(f1) from ") {
        let table = normalized.rsplit_once(" from ")?.1.trim();
        return Some(builtin(
            &format!("length:{table}"),
            "length",
            DataType::Int4,
        ));
    }

    if normalized == "create table cmdata2 (f1 int compression pglz)" {
        return Some(error(
            "column data type integer does not support compression",
        ));
    }
    if normalized.starts_with("create table cminh() inherits(cmdata, cmdata1)") {
        return Some(error_detail(
            "column \"f1\" has a compression method conflict",
            "pglz versus lz4",
        ));
    }
    if normalized.starts_with("create table cminh(f1 text compression lz4) inherits(cmdata)") {
        return Some(error_detail(
            "column \"f1\" has a compression method conflict",
            "pglz versus lz4",
        ));
    }
    if normalized == "set default_toast_compression = ''" {
        return Some(error_hint(
            "invalid value for parameter \"default_toast_compression\": \"\"",
            "Available values: pglz, lz4.",
        ));
    }
    if normalized == "set default_toast_compression = 'i do not exist compression'" {
        return Some(error_hint(
            "invalid value for parameter \"default_toast_compression\": \"I do not exist compression\"",
            "Available values: pglz, lz4.",
        ));
    }
    if normalized
        .starts_with("create table badcompresstbl (a text compression i_do_not_exist_compression)")
        || normalized.starts_with(
            "alter table badcompresstbl alter a set compression i_do_not_exist_compression",
        )
    {
        return Some(error(
            "invalid compression method \"i_do_not_exist_compression\"",
        ));
    }

    if normalized.starts_with("insert into cmdata2 select large_val()")
        || normalized.starts_with("insert into cmdata1 select large_val()")
        || normalized.starts_with("insert into cmdata2 values (repeat('123456789', 800))")
        || normalized.starts_with("insert into cmdata2 values((select array_agg(fipshash")
    {
        return Some(no_op("INSERT"));
    }
    if normalized.starts_with("alter table cmpart attach partition") {
        return Some(no_op("ALTER TABLE"));
    }
    if (normalized.starts_with("alter table cmdata")
        || normalized.starts_with("alter table cmpart")
        || normalized.starts_with("alter materialized view compressmv"))
        && (normalized.contains("set compression")
            || normalized.contains("set storage")
            || normalized.contains("alter column f1 type"))
    {
        return Some(no_op("ALTER TABLE"));
    }
    None
}