faucet-cli 1.13.1

Config-driven CLI runner for faucet-stream pipelines (YAML / JSON, Meltano-style)
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

# Fixture-based offline tests for the `tree_flatten` transform (#530) — run with:
#
#   faucet test cli/examples/tests/tree_flatten_tests.yaml
#
# `tree_flatten` walks a recursive report tree (accounting-report-style nested
# `Rows`) and emits one flat row per leaf, carrying the section labels and the
# period columns. The input is one report record; the output is N leaf rows.
version: 1
tests:
  - name: nested-Rows P&L report flattens to leaf rows
    pipeline:
      transforms:
        - type: tree_flatten
          config:
            root: "Rows.Row"
            children: "Rows.Row"
            columns:
              from: "ColData"
              header: "Columns.Column"
              header_label: "ColTitle"
              value: "value"
            ancestors:
              field: "Header.ColData[0].value"
              as: ["section"]
            path_as: "group_path"
    input:
      - Columns:
          Column:
            - { ColTitle: "" }
            - { ColTitle: "Jan 2024" }
            - { ColTitle: "Feb 2024" }
        Rows:
          Row:
            - Header:
                ColData: [ { value: "Income" } ]
              Rows:
                Row:
                  - ColData: [ { value: "Sales" },    { value: "100" }, { value: "120" } ]
                  - ColData: [ { value: "Services" }, { value: "50" },  { value: "60" } ]
    expect:
      records:
        - { section: "Income", group_path: "Income", col_0: "Sales",    "Jan 2024": "100", "Feb 2024": "120" }
        - { section: "Income", group_path: "Income", col_0: "Services", "Jan 2024": "50",  "Feb 2024": "60" }

  # #746: each leaf carries two positional cell arrays, each named by its own
  # header list; the groups merge into one row per leaf.
  - name: column groups merge per leaf
    pipeline:
      transforms:
        - type: tree_flatten
          config:
            root: rows
            children: rows
            groups:
              - { from: dims, header: dimHeaders, header_label: name }
              - { from: mets, header: metHeaders, header_label: name }
            ancestors: { field: label, as: [section] }
    input:
      - dimHeaders: [ { name: date }, { name: country } ]
        metHeaders: [ { name: sessions } ]
        rows:
          - label: Web
            rows:
              - { dims: [ { value: "20260901" }, { value: DE } ], mets: [ { value: "12" } ] }
              - { dims: [ { value: "20260902" }, { value: FR } ], mets: [ { value: "7" } ] }
    expect:
      records:
        - { section: Web, date: "20260901", country: DE, sessions: "12" }
        - { section: Web, date: "20260902", country: FR, sessions: "7" }

  - name: a group narrower than its headers fails the page
    pipeline:
      transforms:
        - type: tree_flatten
          config:
            children: rows
            groups:
              - { from: mets, header: metHeaders, header_label: name }
    input:
      - metHeaders: [ { name: sessions }, { name: users } ]
        mets: [ { value: "1" } ]
    expect:
      error: "group 'mets': 1 cell(s) but 2 header(s)"