Skip to contents

Program-Area composite-score delta between two version databases

Source: R/validate.R
pra_score_delta.Rd

Reads the Program-Area composite score from two SDM DuckDB connections (e.g. v7 on the cell grid and v8 on the hex grid) and returns the per-Program-Area score_delta(). Centralizes the query previously inlined in workflows/dev/build_v7.R so build_v8.R and validate_versions.qmd share it.

Usage

pra_score_delta(
  con_a,
  con_b,
  metric_key = METRIC_SCORE_DEFAULT,
  labels = c("v7", "v8")
)

Arguments

con_a, con_b

DBI connections to the two versions' sdm.duckdb

metric_key

composite metric key (default METRIC_SCORE_DEFAULT)

labels

length-2 version labels (default c("v7","v8"))

Value

a tibble from score_delta() keyed by programarea_key

Details

Schema-adaptive: the score/key column is value in v7 and val in v8 (the reserved-word rename), so the column name is resolved per connection via .value_col() rather than hard-coded — otherwise a v7↔v8 (or v8↔v8) comparison errors with "Table z does not have a column named value".