RunSqlFile: A helper function that loads an SQL script, updates the...

In PSC-CoTC/AnnualReport: Writes the Annual Report using a pre and post season FRAM DB.

A helper function that loads an SQL script, updates the variables in the script to values provide and formats the resulting data by renames columns to common R style.

Usage

RunSqlFile(db.conn, file.name, variables = NA)

Arguments

db.conn	An ODBC connection to the ODBC database
file.name	A file name that the SQL script is saved to
variables	An R list of variables, variable names in the list are matched to ones with the same name in a format like

A data frame with query results A helper function that loads an SQL script, updates the variables in the script to values provide and formats the resulting data by renames columns to common R style.

PSC-CoTC/AnnualReport documentation built on March 26, 2022, 9:33 a.m.