Mercurial > gemma

comparison report-templates/data-quality-report.yaml @ 5644:f432f578d7e7 DQR adjustments

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
WIP
author Thomas Junk <thomas.junk@intevation.de>
date Wed, 14 Jun 2023 10:14:43 +0200
parents b4ee50490592
children 88fdf143daf1
comparison
equal deleted inserted replaced
5643:b4ee50490592 5644:f432f578d7e7
15 - type: copy 15 - type: copy
16 location: [A1, A5] 16 location: [A1, A5]
17 # BN names 17 # BN names
18 - type: select 18 - type: select
19 statement: > 19 statement: >
20 SELECT DISTINCT objnam AS bnnam, hm 20 SELECT DISTINCT bottleneck_id, objnam AS bnnam, hm
21 FROM waterway.dqr_bottleneck_stats 21 FROM waterway.dqr_bottleneck_stats
22 WHERE cc = {{ cc }} ORDER BY hm, objnam; 22 WHERE cc = {{ cc }} ORDER BY hm, bottleneck_id, objnam;
23 actions: 23 actions:
24 - type: assign 24 - type: assign
25 name: last_row 25 name: last_row
26 expr: (row_number ?? 0) + 6 26 expr: (row_number ?? 0) + 6
27 - type: copy 27 - type: copy
47 location: [B4, C5] 47 location: [B4, C5]
48 destination: "{{ coord2cell(column_number, 4) }}" 48 destination: "{{ coord2cell(column_number, 4) }}"
49 # BN SR-Count 49 # BN SR-Count
50 - type: select 50 - type: select
51 statement: > 51 statement: >
52 SELECT objnam, srcnt, fwacnt 52 SELECT concat(bottleneck_id, ' ', objnam), srcnt, fwacnt
53 FROM waterway.dqr_bottleneck_stats 53 FROM waterway.dqr_bottleneck_stats
54 WHERE cc = {{ cc }} AND month = {{ d }} 54 WHERE cc = {{ cc }} AND month = {{ d }}
55 ORDER BY hm, objnam; 55 ORDER BY hm, bottleneck_id;
56 actions: 56 actions:
57 - type: assign 57 - type: assign
58 name: last_row 58 name: last_row
59 expr: (row_number ?? 0) + 6 59 expr: (row_number ?? 0) + 6
60 - type: copy 60 - type: copy