formatSql: Retreives Sql Statement text from a file, binds parameters to...

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

Retreives Sql Statement text from a file, binds parameters to the text, and do basic format cleanup

Description

Retreives Sql Statement text from a file, binds parameters to the text, and do basic format cleanup

Usage

formatSql(
  sql_file_name,
  params = NULL,
  sql_dir = "sql",
  clean_sql = TRUE,
  package_name = packageName(parent.frame())
)

Arguments

sql_file_name	The name of of the file with sql to load
params	List of named parameters to bind to the sql text
sql_dir	The directory that stores all the sql statements (defaults to "sql")
clean_sql	A boolean that identifies if the format of the final sql should be cleaned (e.g. strip newlines)
package_name	The package name to load sql file from, defaults to the current package name

Value

An Sql text statement

PSC-CoTC/AnnualReport documentation built on Feb. 15, 2025, 8:34 p.m.