Mercurial > gemma

changeset 5392:014dc3219bdb extented-report

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Made DQR template more bullet-proof for missing data.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Sat, 03 Jul 2021 01:04:37 +0200
parents 1dd63a2405bc
children fe3f651bb03d
files report-templates/data-quality-report.yaml
diffstat 1 files changed, 7 insertions(+), 7 deletions(-) [+]
line wrap: on
line diff
--- a/report-templates/data-quality-report.yaml	Sat Jul 03 00:43:25 2021 +0200
+++ b/report-templates/data-quality-report.yaml	Sat Jul 03 01:04:37 2021 +0200
@@ -29,7 +29,7 @@
         destination: A{{ last_row }}
     - type: copy
       location: [A7]
-      destination: A{{ last_row + 1 }}
+      destination: A{{ (last_row ?? 6) + 1 }}
     # Gen Months
     - type: select
       statement: >
@@ -53,17 +53,17 @@
             ORDER BY objnam;
         actions:
         - type: assign
-          name: last_row 
+          name: last_row
           expr: (row_number ?? 0) + 6
         - type: copy
           location: [B6,C6]
           destination: '{{ coord2cell(column_number, last_row) }}'
       - type: copy
         location: [B7,C7]
-        destination: '{{ coord2cell(column_number, last_row + 1) }}'
+        destination: '{{ coord2cell(column_number, (last_row ?? 0) + 1) }}'
     - type: assign
       name: offset
-      expr: last_row + 3
+      expr: (last_row ?? 0) + 3
     #--------------------------------------------------------------------------
     # GAUGES
     # Header:
@@ -84,7 +84,7 @@
         destination: A{{ last_row }}
     - type: copy
       location: [A11]
-      destination: A{{ last_row + 1 }}
+      destination: A{{ (last_row ?? 10) + 1 }}
     # Gen Months
     - type: select
       statement: >
@@ -108,12 +108,12 @@
             ORDER BY objname;
         actions:
         - type: assign
-          name: last_row 
+          name: last_row
           expr: (row_number ?? 0) + offset + 1
         - type: copy
           location: [B10]
           destination: '{{ coord2cell(column_number, last_row) }}'
       - type: copy
         location: [B11]
-        destination: '{{ coord2cell(column_number, last_row + 1) }}'
+        destination: '{{ coord2cell(column_number, (last_row ?? 10) + 1) }}'