Warnings in summary system

[rburghol]

@COBrogan

• Examples:
  • waterSupplyElement.R
    • See also: PR for code diff Warn #620
• Data Model:
  • runid_XX
    • warnings - this is a single property container that is set on the scenario container at the beggining of the summary script, that then holds all the warnings during that model run
      • [propname] - corresponds to the run metric that triggered the warning
        • [propcode] - the warning message

model	model_pid	featureid	runid	varname	message
Loudoun Water: Potomac River	5392994	401262	runid_13	unmet_demand_mgd	unmet_demand_mgd is NA/NULL in simulation 13
Loudoun Water: Potomac River	5392994	401262	runid_13	wd_mgd	wd_mgd is NA/NULL in simulation 13
Loudoun Water: Potomac River	5392994	401262	runid_13	gw_demand_mgd	gw_demand_mgd is NA/NULL in simulation 13

SQL 1: Retrieve all warnings for any model (riverseg, facility, runoff OK).

sqldf(
  "select m.propname as model, m.pid as model_pid, a.propname as runid, 
      c.propname as varname, c.propcode as message 
    from dh_properties as a 
    left outer join dh_properties as m 
    on (
      a.featureid = m.pid 
      and a.entity_type = 'dh_properties'
    ) 
    left outer join dh_properties as b 
    on (
      b.featureid = a.pid 
      and b.propname = 'warnings'
    ) 
    left outer join dh_properties as c 
    on (
      c.featureid = b.pid 
      and c.entity_type = 'dh_properties'
    ) 
    where a.propname = 'runid_201' 
      and b.pid is not null 
      and c.pid is not null
    ",
  connection = ds$connection
)