mockgres 0.0.27

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

use pgwire::api::Type;

use crate::compat::{
    POSTGRES_COMPAT_VERSION, POSTGRES_COMPAT_VERSION_NUM,
    server_version_string as compat_server_version_string,
};
use crate::engine::DataType;

pub fn map_pg_type_to_datatype(t: &Type) -> Option<DataType> {
    match *t {
        Type::INT2 => Some(DataType::Int2),
        Type::INT4 => Some(DataType::Int4),
        Type::INT8 => Some(DataType::Int8),
        Type::FLOAT8 => Some(DataType::Float8),
        Type::TEXT => Some(DataType::Text),
        Type::VARCHAR => Some(DataType::Varchar(None)),
        Type::NAME => Some(DataType::Name),
        Type::BPCHAR => Some(DataType::BpChar(None)),
        Type::CHAR => Some(DataType::PgChar),
        Type::POINT => Some(DataType::Point),
        Type::LSEG => Some(DataType::Lseg),
        Type::LINE => Some(DataType::Line),
        Type::CIRCLE => Some(DataType::Circle),
        Type::BOX => Some(DataType::Box),
        Type::TID => Some(DataType::Tid),
        Type::OID => Some(DataType::Oid),
        Type::PG_LSN => Some(DataType::PgLsn),
        Type::MACADDR => Some(DataType::MacAddr),
        Type::MACADDR8 => Some(DataType::MacAddr8),
        Type::PATH => Some(DataType::Path),
        Type::JSON => Some(DataType::Json),
        Type::JSONB => Some(DataType::Jsonb),
        Type::BOOL => Some(DataType::Bool),
        Type::DATE => Some(DataType::Date),
        Type::TIME => Some(DataType::Time(None)),
        Type::TIMESTAMP => Some(DataType::Timestamp),
        Type::TIMESTAMPTZ => Some(DataType::Timestamptz),
        Type::BYTEA => Some(DataType::Bytea),
        Type::INTERVAL => Some(DataType::Interval),
        Type::VOID => Some(DataType::Void),
        _ => None,
    }
}

pub fn map_datatype_to_pg_type(dt: &DataType) -> Type {
    match dt {
        DataType::Int2 => Type::INT2,
        DataType::Int4 => Type::INT4,
        DataType::Int8 => Type::INT8,
        DataType::Float8 => Type::FLOAT8,
        DataType::Text => Type::TEXT,
        DataType::Varchar(_) => Type::VARCHAR,
        DataType::Name => Type::NAME,
        DataType::BpChar(_) => Type::BPCHAR,
        DataType::PgChar => Type::CHAR,
        DataType::Point => Type::POINT,
        DataType::Lseg => Type::LSEG,
        DataType::Line => Type::LINE,
        DataType::Circle => Type::CIRCLE,
        DataType::Box => Type::BOX,
        DataType::Tid => Type::TID,
        DataType::Oid => Type::OID,
        DataType::PgLsn => Type::PG_LSN,
        DataType::MacAddr => Type::MACADDR,
        DataType::MacAddr8 => Type::MACADDR8,
        DataType::Path => Type::PATH,
        DataType::Json => Type::JSON,
        DataType::Jsonb => Type::JSONB,
        DataType::Bool => Type::BOOL,
        DataType::Date => Type::DATE,
        DataType::Time(_) => Type::TIME,
        DataType::Timestamp => Type::TIMESTAMP,
        DataType::Timestamptz => Type::TIMESTAMPTZ,
        DataType::Bytea => Type::BYTEA,
        DataType::Interval => Type::INTERVAL,
        DataType::Void => Type::VOID,
    }
}

pub fn lookup_show_value(name: &str) -> Option<String> {
    match name {
        "server_version" => Some(POSTGRES_COMPAT_VERSION.to_string()),
        "server_version_num" => Some(POSTGRES_COMPAT_VERSION_NUM.to_string()),
        "standard_conforming_strings" => Some("on".to_string()),
        _ => None,
    }
}

pub fn server_version_string() -> String {
    compat_server_version_string()
}