nu-command 0.112.2

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
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
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114

use nu_test_support::nu;

#[test]
fn headers_uses_first_row_as_header() {
    let actual = nu!(cwd: "tests/fixtures/formats", "
        open sample_headers.xlsx
        | get Sheet1
        | headers
        | get header0
        | to json --raw");

    assert_eq!(actual.out, r#"["r1c0","r2c0"]"#)
}

#[test]
fn headers_adds_missing_column_name() {
    let actual = nu!(cwd: "tests/fixtures/formats", "
        open sample_headers.xlsx
        | get Sheet1
        | headers
        | get column1
        | to json --raw");

    assert_eq!(actual.out, r#"["r1c1","r2c1"]"#)
}

#[test]
fn headers_handles_missing_values() {
    let actual = nu!("
        [{x: a, y: b}, {x: 1, y: 2}, {x: 1, z: 3}]
        | headers
        | to nuon
    ");

    assert_eq!(actual.out, "[{a: 1, b: 2}, {a: 1}]")
}

#[test]
fn headers_invalid_column_type_empty_record() {
    let actual = nu!("
        [[a b]; [{}, 2], [3,4] ]
        | headers");

    assert!(
        actual
            .err
            .contains("needs compatible type: Null, String, Bool, Float, Int")
    );
}

#[test]
fn headers_invalid_column_type_record() {
    let actual = nu!("
        [[a b]; [1 (scope aliases)] [2 2]]
        | headers");

    assert!(
        actual
            .err
            .contains("needs compatible type: Null, String, Bool, Float, Int")
    );
}

#[test]
fn headers_invalid_column_type_array() {
    let actual = nu!("
        [[a b]; [[f,g], 2], [3,4] ]
        | headers");

    assert!(
        actual
            .err
            .contains("needs compatible type: Null, String, Bool, Float, Int")
    );
}

#[test]
fn headers_invalid_column_type_range() {
    let actual = nu!("
        [[a b]; [(1..5), 2], [3,4] ]
        | headers");

    assert!(
        actual
            .err
            .contains("needs compatible type: Null, String, Bool, Float, Int")
    );
}

#[test]
fn headers_invalid_column_type_duration() {
    let actual = nu!("
        [[a b]; [((date now) - (date now)), 2], [3,4] ]
        | headers");

    assert!(
        actual
            .err
            .contains("needs compatible type: Null, String, Bool, Float, Int")
    );
}

#[test]
fn headers_invalid_column_type_binary() {
    let actual = nu!(r#"
        [[a b]; [("aa" | into binary), 2], [3,4] ]
        | headers"#);

    assert!(
        actual
            .err
            .contains("needs compatible type: Null, String, Bool, Float, Int")
    );
}