blue-marble / gridpath / 26592690362
89%
main: 89%

LAST BUILD BRANCH: develop
DEFAULT BRANCH: main
Ran
Jobs 1
Files 775
Run time 2min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst
coverage: 88.682%. Remained the same
26592690362

push

github

web-flow 
Fixes to some cost queries (#1374)

* Minor SQL cost query fixes

1. in costs.py, `INSERT INTO results_project_costs_operations_agg`
   lists columns as `(... variable_om_cost, fuel_cost, ...)` but selects
   `SUM(fuel_cost) AS fuel_cost` first and
   `SUM(variable_om_cost) AS variable_om_cost` second. SQLite's INSERT
   is positional so the columns are stored swapped: the column named
   `variable_om_cost` actually holds period-aggregated fuel cost and
   vice versa. Reorder the SELECT to match the column list.
2. `results_project_costs_capacity_agg` writes
   `spinup_or_lookahead = 0` for non-spinup rows while
   `results_project_costs_operations_agg` (tx as well) write NULL,
   so the view's `a.spinup_or_lookahead = b.spinup_or_lookahead` join
   fails (NULL = 0 is UNKNOWN) and every operations / tx
   row is silently dropped. Wrap both sides in `COALESCE(..., 0)` so
   the condition is robust to either convention.
3. The 4th LEFT JOIN in  `results_project_costs_capacity_agg`
   aliases `results_transmission_hurdle_costs_by_timepoint_agg`
   as `e` but its ON clause references `d.scenario_id` etc., so the
   join is effectively against the previous table again rather than
   the aliased one. Switch the references to `e.`.

Issues found with help from Claude Opus 4.7.

* Remove merge on period from timepoint hurdle rate table

Views `results_costs_by_period_load_zone`
and `results_costs_by_period` aggregate by period and included
either joins or summation over
`results_transmission_hurdle_costs_by_timepoint_agg`.
However, this view does not include period.
This was silently ignored before and is now removed for clarity.

28303 of 31915 relevant lines covered (88.68%)

0.89 hits per line

Jobs
ID Job ID Ran Files Coverage
1 26592690362.1 775
88.68
 GitHub Action Run
Source Files on build 26592690362