send_sql3: Function to send sql statement

In duanxd1/gfuns: My Global Functions

Description

Submit sql statement using RMariaDB. If dataF given, a the SQL statement will be parameterized. May want to add secure credentials method.

Usage

send_sql3(
  dataF = NULL,
  tName = NULL,
  returnClass = "data.table",
  sql = "SELECT * FROM ",
  Group = "EPA_harshadb",
  defaultFile = file.path(gfuns::sg("ws"), ".my.cnf"),
  verbose = FALSE,
  CLIENT_MULTI_STATEMENTS_ = TRUE,
  ...
)

Arguments

dataF	If given, data frame of key values to be used in parameterized statement.
tName	table name
returnClass	class of return object. Should be one of data.table, tibble, or data.frame.
sql	sql statement. defaults to select
Group	Group identifier found in .my.cnf
defaultFile	file where Group credentials are found
verbose	provide feedback to user
CLIENT_MULTI_STATEMENTS_	logical to use CLIENT_MULTI_STATEMENTS

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