GEML 块图解 · table 与 view

=== table {#budget caption="Annual cost"}
| Plan  | Months | Rate |
|-------|-------:|-----:|
| Basic |      1 |   30 |
| Pro   |      2 |   30 |
===

=== table {#fy caption="FY revenue ($M)" format=csv header=1 delim=;}
Segment ; Q1    ; Q2
Cloud   ; 124.5 ; 131.2
Hardware; 88.1  ; 84.6
Services; 45.2  ; 47.8
===
=== view {#fy-report src=#fy \
          compute="FY [%.1f] = Q1 + Q2; Share [%.1f%%] = FY * 100 / 500" \
          summary="Segment = 'Total'; Q1 = sum(Q1); Q2 = sum(Q2); FY = sum(FY)"}
===                                    %% 表装事实；view 负责派生与汇总
See [[#fy]] and [[#budget]].

$ geml get t1-table.geml '#fy[2]'          第 2 个体行，表头不算
Hardware; 88.1; 84.6; 172.7; 34.5%
$ geml get t1-table.geml '#fy[2]["Q1"]'
88.1
$ geml get t1-table.geml '#fy["Q1"]'       一列，不含表头
124.5
88.1
45.2
$ geml get t1-table.geml '#fy[summary]["FY"]'
521.4
$ geml get t1-table.geml '#fy[summary]'
Total; 257.8; 263.6; 521.4;
$ geml get t1-table.geml '#borrowed[1]["Half"]'   借表自己算的列
127.85

=== table {#ext caption="From a file" format=csv src=rows.csv}
===
=== view {#borrowed caption="Borrowed rows" src=#fy-report compute="Half = FY / 2"}
===

%% rows.csv 在文档同目录：Segment,Q1,Q2 / Cloud,124.5,131.2 / Hardware,88.1,84.6
%% #borrowed 拿到 #fy-report 的元组和它算出的 FY，再算自己的 Half

=== table {#borrowed src=#fy-report compute="Half = FY / 2"}
===
%% error: table source `#fy-report` names another block's output; use `view`
%% 另有：warning: unknown attribute `compute` for block type `table`

=== table {#a format=csv src=rows.csv}
x,y                                   ← src 与正文同在
===
=== table {#b format=csv delim=;;}       ← 两个字符
a;b
===
=== table {#c delim=;}                  %% 没有 format，可视网格用不上 delim
| a | b |
===
=== table {#d format=weird}
| a | b |
===
%% compute=/summary= 是 view 的属性（§6.1），所以下面每个公式用例都是 view
=== view {#e src=#src compute="Z = Q9 + 1"}
===
=== table {#fsrc format=csv}
Q1,Q2
1,n/a                                %% 非数按 0，warning
===
=== view {#f src=#fsrc compute="S = Q1 + Q2"}
===
=== table {#gsrc format=csv}
Q1,Q2
1,0                                  %% 除零
===
=== view {#g src=#gsrc compute="R = Q1 / Q2"
          summary="Q1 = sum(Q1); Nope = 1; Q2 = Q2"}
===
=== table {#h src=#n}                   ← table 的 src= 不能指块
===
=== table {#i format=csv src=missing.csv}
===
=== view {#j src=#src compute="bad formula"}
===

error: table has both `src` and an inline body; provide one, not both (line 8)
error: `delim=";;"` must be exactly one character (for a tab use
  `format=tsv`); split on `,` instead (line 11)
warning: `delim` applies to a data body (`format=csv`/`tsv`); this body
  was parsed as a visual grid, so it is ignored (line 15)
warning: unknown table format `weird`; parsed as visual grid (line 20)
error: compute `Z`: unknown column `Q9` (line 25)
warning: column `Q2` row 1 is not a number (`n/a`); counted as 0 (line 29)
warning: compute `R` row 1: division by zero; the cell holds no value
  and shows `-` (line 33)
error: summary targets unknown column `Nope` (line 33)
error: summary `Q2`: column `Q2` must be reduced by an aggregate
  (e.g. sum(Q2)) (line 33)
error: bad compute formula `bad formula` (want `Name = expr`) (line 41)
error: cannot resolve table source `missing.csv` (line 39)
error: table source `#n` names another block's output; use `view`
  (line 37)

=== table {#tickets format=csv}
Area,Status,Days
Draft Mode,open,3
Turbopack,open,12
Draft Mode,closed,1
===
=== view {#open src=#tickets where="Status = 'open'" order="Days desc"
          limit=10 select="Area, Days"}
===
=== view {#by-area src=#tickets by="Area" aggregate="Open = count(Status)"}
===

warning: unknown block type `view`; body kept as raw (line 11)
warning: unknown block type `view`; body kept as raw (line 13)
0 error(s), 2 warning(s)   exit 0 —— 草案文档今天能过检查，只是什么都不算