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

use {
    crate::*,
    bigdecimal::BigDecimal,
    gluesql_core::{
        ast::DataType,
        data::Literal,
        error::{TranslateError, ValueError},
        prelude::{Payload, Value::*},
    },
    std::borrow::Cow,
};

test_case!(point, {
    let g = get_tester!();

    let test_cases = [
        (
            "CREATE TABLE POINT (point_field POINT)",
            Ok(Payload::Create),
        ),
        (
            r#"INSERT INTO POINT VALUES (POINT(0.3134, 0.156))"#,
            Ok(Payload::Insert(1)),
        ),
        (
            r#"SELECT point_field AS point_field FROM POINT;"#,
            Ok(select!(
                point_field
                Point;
                gluesql_core::data::Point::new(0.3134, 0.156)
            )),
        ),
        (
            r#"UPDATE POINT SET point_field=POINT(2.0, 1.0) WHERE point_field=POINT(0.3134, 0.156)"#,
            Ok(Payload::Update(1)),
        ),
        (
            r#"SELECT point_field AS point_field FROM POINT"#,
            Ok(select!(
                point_field
                Point;
                gluesql_core::data::Point::new(2.0, 1.0)
            )),
        ),
        (
            r#"DELETE FROM POINT WHERE point_field=POINT(2.0, 1.0)"#,
            Ok(Payload::Delete(1)),
        ),
        (
            r#"INSERT INTO POINT VALUES (0)"#,
            Err(ValueError::IncompatibleLiteralForDataType {
                data_type: DataType::Point,
                literal: format!("{:?}", Literal::Number(Cow::Owned(BigDecimal::from(0)))),
            }
            .into()),
        ),
        (
            r#"INSERT INTO POINT VALUES (POINT(0.3134))"#,
            Err(TranslateError::FunctionArgsLengthNotMatching {
                name: "POINT".to_owned(),
                expected: 2,
                found: 1,
            }
            .into()),
        ),
        (
            r#"SELECT CAST('POINT(-71.064544 42.28787)' AS POINT) AS pt"#,
            Ok(select!(
                pt
                Point;
                gluesql_core::data::Point::new(-71.064544, 42.28787)

            )),
        ),
        (
            r#"SELECT CAST('POINT(-71.06454t4 42.28787)' AS POINT) AS pt"#,
            Err(ValueError::FailedToParsePoint(
                Str("POINT(-71.06454t4 42.28787)".to_owned()).into(),
            )
            .into()),
        ),
    ];

    for (sql, expected) in test_cases {
        g.test(sql, expected).await;
    }
});