Create a testing script with SQL queries and functions to check report values

MargaretSiple-NOAA / goa-ai-data-reports

Automate data reports for GOA and AI surveys

1 stars 1 forks source link

Create a testing script with SQL queries and functions to check report values #21

Closed MargaretSiple-NOAA closed 1 year ago

MargaretSiple-NOAA commented 1 year ago

Per convo with Ned, we want to create a script that prints out all the values used in the report so someone can quickly check them. This should include a table that puts the value produced by the R script, and one produced by a SQL query, next to each other for easy comparison. E.g.,	Variable name	Description	Value in previous report year	Value this year (produced by R script)	Value this year (produced by SQL query
`nstations`	number of stations successfully sampled	398	417	398

MargaretSiple-NOAA commented 1 year ago

Closing this for now because the current script includes SQL and R and RODBC. Also the gapindex group has done a ton of the comparisons for the important things so I don't think we need them in this repo specifically.