pgx-tests 0.7.4

Test framework for 'pgx'-based Postgres extensions
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

/*
Portions Copyright 2019-2021 ZomboDB, LLC.
Portions Copyright 2021-2022 Technology Concepts & Design, Inc. <support@tcdi.com>

All rights reserved.

Use of this source code is governed by the MIT license that can be found in the LICENSE file.
*/

use pgx::prelude::*;

#[pg_extern]
fn negative_default_argument(i: default!(i32, -1)) -> i32 {
    i
}

#[pg_extern]
fn default_argument(a: default!(i32, 99)) -> i32 {
    a
}

#[pg_extern]
fn option_default_argument(a: default!(Option<&str>, "NULL")) -> &str {
    match a {
        Some(a) => a,
        None => "got default of null",
    }
}

#[cfg(any(test, feature = "pg_test"))]
#[pgx::pg_schema]
mod tests {
    #[allow(unused_imports)]
    use crate as pgx_tests;

    use pgx::prelude::*;

    #[test]
    fn make_idea_happy() {}

    #[pg_test]
    fn test_negative_default_argument() {
        let result = Spi::get_one::<i32>("SELECT negative_default_argument();");
        assert_eq!(result, Ok(Some(-1)));
    }

    #[pg_test]
    fn test_default_argument() {
        let result = Spi::get_one::<i32>("SELECT default_argument();");
        assert_eq!(result, Ok(Some(99)));
    }

    #[pg_test]
    fn test_default_argument_specified() {
        let result = Spi::get_one::<i32>("SELECT default_argument(2);");
        assert_eq!(result, Ok(Some(2)));
    }

    #[pg_test]
    fn test_option_default_argument() {
        let result = Spi::get_one::<&str>("SELECT option_default_argument();");
        assert_eq!(result, Ok(Some("got default of null")));
    }

    #[pg_test]
    fn test_option_default_argument_specified() {
        let result = Spi::get_one::<&str>("SELECT option_default_argument('test');");
        assert_eq!(result, Ok(Some("test")));
    }
}