rulemorph 0.3.4

YAML-based declarative data transformation engine for CSV/JSON to JSON
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

#[test]
fn html_attr_value_requires_attr_name() {
    let yaml = r#"
version: 2
input:
  format: html
  html:
    records_selector: ".item"
    fields:
      url:
        selector: "a"
        value: attr
mappings:
  - target: "url"
    source: "url"
"#;
    let rule = parse_rule_file(yaml).expect("parse rule");
    let errors = validate_rule_file(&rule).expect_err("missing attr should fail");
    assert!(
        errors
            .iter()
            .any(|err| err.path.as_deref() == Some("input.html.fields.url.attr"))
    );
}

#[test]
fn excel_without_headers_requires_columns() {
    let yaml = r#"
version: 2
input:
  format: excel
  excel:
    has_header: false
mappings:
  - target: "id"
    source: "id"
"#;
    let rule = parse_rule_file(yaml).expect("parse rule");
    let errors = validate_rule_file(&rule).expect_err("missing columns should fail");
    assert!(
        errors
            .iter()
            .any(|err| err.code.as_str() == "MissingExcelColumns"
                && err.path.as_deref() == Some("input.excel.columns"))
    );
}

#[test]
fn excel_rejects_invalid_range_syntax_during_validation() {
    let yaml = r#"
version: 2
input:
  format: excel
  excel:
    range: "B3"
mappings:
  - target: "id"
    source: "id"
"#;
    let rule = parse_rule_file(yaml).expect("parse rule");
    let errors = validate_rule_file(&rule).expect_err("invalid range should fail validation");
    assert!(errors.iter().any(|err| {
        err.code == ErrorCode::InvalidInputOption
            && err.path.as_deref() == Some("input.excel.range")
            && err.message.contains("A:D or A1:D100")
    }));
}

#[test]
fn excel_rejects_numeric_column_reference_during_validation() {
    let yaml = r#"
version: 2
input:
  format: excel
  excel:
    has_header: false
    columns:
      - { name: id, column: "1" }
mappings:
  - target: "id"
    source: "id"
"#;
    let rule = parse_rule_file(yaml).expect("parse rule");
    let errors = validate_rule_file(&rule).expect_err("numeric column should fail validation");
    assert!(errors.iter().any(|err| {
        err.code == ErrorCode::InvalidInputOption
            && err.path.as_deref() == Some("input.excel.columns[0].column")
            && err.message.contains("Excel column reference is invalid")
    }));
}

#[test]
fn excel_rejects_header_row_before_selected_range_during_validation() {
    let yaml = r#"
version: 2
input:
  format: excel
  excel:
    range: "B3:F100"
    header_row: 1
mappings:
  - target: "id"
    source: "id"
"#;
    let rule = parse_rule_file(yaml).expect("parse rule");
    let errors = validate_rule_file(&rule).expect_err("header before range should fail validation");
    assert!(errors.iter().any(|err| {
        err.code == ErrorCode::InvalidInputOption
            && err.path.as_deref() == Some("input.excel.header_row")
            && err.message.contains("before selected range")
    }));
}