query: query - SQL ODBC

In 07engineer/HVACControlAnalysis:

Description

After setting up an open database connection (ODBC), this function calls the Transformative Wave server. Uses the ROBDC package.

Usage

query(site, start_date, end_date, variables, password)

Arguments

site	Site name string like "Altoona". Must have id entry inside function.
start_date	start date string like "09-01-2017"
end_date	end date string like "09-01-2017"
variables	comma separated string like str_c("eq_id", "Timestamp", "UnitKw", "OATemp", sep = ", ")
password	the database password

Value

A dataframe resulting from the SQL query

Examples

vars <- str_c("eq_id", "Timestamp", "UnitKw", "OATemp", sep = ", ")
data <- query("Altoona", "09-01-2017", "09-02-2017", vars) 

07engineer/HVACControlAnalysis documentation built on May 18, 2019, 10:13 a.m.