nu-command 0.112.1

Nushell's built-in commands
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

use nu_test_support::nu;

#[cfg(feature = "sqlite")]
#[test]
fn can_query_single_table() {
    let actual = nu!(cwd: "tests/fixtures/formats", r#"
        open sample.db
        | query db "select * from strings"
        | where x =~ ell
        | length
    "#);

    assert_eq!(actual.out, "4");
}

#[cfg(feature = "sqlite")]
#[test]
fn invalid_sql_fails() {
    let actual = nu!(cwd: "tests/fixtures/formats", r#"
        open sample.db
        | query db "select *asdfasdf"
    "#);

    assert!(actual.err.contains("syntax error"));
}

#[cfg(feature = "sqlite")]
#[test]
fn invalid_input_fails() {
    let actual = nu!(cwd: "tests/fixtures/formats", r#"
        "foo" | query db "select * from asdf"
    "#);

    assert!(actual.err.contains("can't convert string"));
}