R/gta_sql_update_table.R

In global-trade-alert/gtasql:

# Roxygen documentation

#' Update a specific portion of an existing table in your SQL database
#'
#' Just a wrapper to make the connection easier. You have to type out the query in SQL, no help here.
#'
#' @param query A string with the SQL query you want to execute.
#' @param db.connection Specify the database connection you want to use. Default is 'pool'.
#'
#' @references www.globaltradealert.org
#' @author Global Trade Alert

gta_sql_update_table <- function(query=NULL,
                                 db.connection="pool") {
  
  eval(parse(text=paste0("conn.update=poolCheckout(",db.connection,")"))) 

  res = dbFetch(dbSendQuery(conn.update, query))
  poolReturn(conn.update)
  rm(conn.update)
  
  if(nrow(res)>0) return(res);

}