update_sql3: Function to update db table

In duanxd1/gfuns: My Global Functions

Description

Update database table. Records with extant keys will be updated those without will not be inserted using RMariaDB. Output 0 or 1 based on success if verbose = TRUE May want to add secure credentials method.

Usage

update_sql3(
  dataF,
  tName,
  key = NULL,
  Group = "EPA_harshadb",
  defaultFile = file.path(gfuns::sg("ws"), ".my.cnf"),
  verbose = FALSE,
  ...
)

Arguments

dataF	data frame to be appended
tName	table to appand data to
Group	Group identifier found in .my.cnf
defaultFile	file where Group credentials are found
verbose	provide feedback to user

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