#' Classe para manipulação de String SQL para a função UPDATE
#'
#' @aliases UpdateQueryBuilder
#' @importFrom methods setRefClass
#' @export UpdateQueryBuilder UpdateQueryBuilder
#' @exportClass UpdateQueryBuilder
#'
UpdateQueryBuilder <- setRefClass(
"UpdateQueryBuilder",
contains = c("DefaultQueryBuilder"),
methods = list(
toString = function() {
tryCatch({
sSql <- paste0("UPDATE ", getFromClause())
sSql <- paste0(sSql, " SET ", getSetClause())
if (length(whereList) > 0) {
sSql <- paste0(sSql, " WHERE ", getWhereClause())
}
return (gsub("\r\n", "", paste(sSql, collapse = " ")))
}, error = function(ex) {
stop (ex$message)
})
}
)
)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.