dbExecuteEM: Executes in the database

In AndreMikulec/econModel: Meaningful Social and Economic Data from ALFRED and elsewhere

Description

Disconnects the R object passed "conn". Alternately, can disconnect and remove the DBI connection object connName (default is "connEM") from the environment "env". The function will just do one or the other, but not both. Does NOT remove the passed R object "conn".

Usage

dbExecuteEM(
  connName,
  Statement,
  time_zone = "UTC",
  client_encoding = "UTF8",
  env,
  display = TRUE,
  exec = TRUE
)

Arguments

connName	String. Default is "connEM". Contains the name of the variable that contains the name of the "connection" in the environment "env".
Statement	String. Required. DML/DDL/DCL to execute
time_zone	Execution time zone. Default is "UTC".
client_encoding	Execution encoding. Default is "UTF8".
env	Environment. Default is the .Global environment. This is the environment to return the connection object "connEM".
display	Logical. Whether to display the query (defaults to TRUE).
exec	Logical. Whether to execute the query (defaults to TRUE).

Value

Execution of "conn" from the database or disconnects "connName" from the database and removes it from the environment "env".

Examples

## Not run: 
dbExecuteEM(Statement = "CREATE TEMP TABLE xyz();")

## End(Not run)

AndreMikulec/econModel documentation built on June 30, 2021, 9:48 a.m.