append_sql3: Function to create a new db table from dataframe or append...

In HJAllen/gfuns: My Global Functions

Description

Submit data to be appended to database table using RMariaDB. Output 0 or 1 based on success if verbose = TRUE May want to add secure credentials method.

Usage

append_sql3(
  dataF,
  tName,
  Append = TRUE,
  Group = "EPA_harshadb",
  defaultFile = file.path(gfuns::sg("ws"), ".my.cnf"),
  header_ = FALSE,
  rowNames = FALSE,
  verbose = FALSE,
  ...
)

Arguments

dataF	data frame to be appended
tName	table to appand data to
Append	boolean defaults to TRUE. If True, dataF is appended to existing table. If FALSE and tName does not exist, a new table is created using dataF.
Group	Group identifier found in .my.cnf
defaultFile	file where Group credentials are found
header_	logical whether first row is header
rowNames	boolean passed to dbWriteTable, defaults to FALSE. If True, row names are translated into column row_names.
verbose	provide feedback to user

HJAllen/gfuns documentation built on July 24, 2021, 8:47 a.m.