get_sql3: Function to get data from sql statement

In duanxd1/gfuns: My Global Functions

Description

Submit sql and get results from database using RMariaDB. May want to add secure credentials method.

Usage

get_sql3(
  sql,
  Group = "EPA_harshadb",
  returnClass = "data.table",
  defaultFile = file.path(gfuns::sg("ws"), ".my.cnf"),
  verbose = FALSE,
  ...
)

Arguments

sql	sql statement
Group	Group identifier found in .my.cnf
returnClass	class of return object. Should be one of data.table, tibble, or data.frame.
defaultFile	file where Group credentials are found
verbose	provide feedback to user

duanxd1/gfuns documentation built on March 7, 2020, 12:46 a.m.