getDataframeFromDatabase: Function to pull data from database using paramterized DBI...

In cusom/CUSOM.ShinyHelpers: CU School of Medicine Helper Functions for Shiny Applications

Function to pull data from database using paramterized DBI odbc query

Description

Function to pull data from database using paramterized DBI odbc query

Usage

getDataframeFromDatabase(
  queryString,
  parameters,
  convertFactorsToStrings = TRUE,
  ...
)

Arguments

queryString	string paramterized sql query where parameters are indicated by "?"
parameters	tibble of parameter values
convertFactorsToStrings	boolean whether to convert all factor variables to character strings default = TRUE
...	conn_args list of database connection arguments: driver, server, database name, userid, password, port

Value

returns sql query result as a dataframe

cusom/CUSOM.ShinyHelpers documentation built on Oct. 23, 2023, 6:50 a.m.