alopex-sql 0.6.0

SQL parser components for the Alopex DB dialect
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

use alopex_sql::{AlopexDialect, ExprKind, Parser, StatementKind};

#[cfg_attr(not(feature = "lane_ci"), ignore)]
#[test]
fn parses_multiple_statements() {
    let sql = "CREATE TABLE docs (id INT); INSERT INTO docs (id) VALUES (1); SELECT * FROM docs;";
    let stmts = Parser::parse_sql(&AlopexDialect, sql).unwrap();
    assert_eq!(stmts.len(), 3);
    assert!(matches!(stmts[0].kind, StatementKind::CreateTable(_)));
    assert!(matches!(stmts[1].kind, StatementKind::Insert(_)));
    assert!(matches!(stmts[2].kind, StatementKind::Select(_)));
}

#[cfg_attr(not(feature = "lane_ci"), ignore)]
#[test]
fn vector_literal_parses_via_dialect_prefix() {
    let sql = "INSERT INTO docs VALUES ([0.1, -0.2])";
    let stmts = Parser::parse_sql(&AlopexDialect, sql).unwrap();
    match &stmts[0].kind {
        StatementKind::Insert(ins) => {
            assert_eq!(ins.values.len(), 1);
            match ins.values[0][0].kind {
                ExprKind::VectorLiteral { values: ref v } => assert_eq!(v, &vec![0.1, -0.2]),
                ref other => panic!("expected vector literal, got {:?}", other),
            }
        }
        other => panic!("expected insert, got {:?}", other),
    }
}

#[cfg_attr(not(feature = "lane_ci"), ignore)]
#[test]
fn parses_select_without_from_single_literal() {
    let stmts = Parser::parse_sql(&AlopexDialect, "SELECT 1").unwrap();
    match &stmts[0].kind {
        StatementKind::Select(select) => {
            assert!(select.from.is_empty());
            assert_eq!(select.projection.len(), 1);
        }
        other => panic!("expected select, got {:?}", other),
    }
}

#[cfg_attr(not(feature = "lane_ci"), ignore)]
#[test]
fn parses_select_without_from_multiple_literals() {
    let stmts = Parser::parse_sql(&AlopexDialect, "SELECT 1, 'ok'").unwrap();
    match &stmts[0].kind {
        StatementKind::Select(select) => {
            assert!(select.from.is_empty());
            assert_eq!(select.projection.len(), 2);
        }
        other => panic!("expected select, got {:?}", other),
    }
}