Retrieve data to a data.frame
This function sends SQL to the server, and returns the results.
querySql(
connection,
sql,
errorReportFile = file.path(getwd(), "errorReportSql.txt"),
snakeCaseToCamelCase = FALSE,
integer64AsNumeric = getOption("databaseConnectorInteger64AsNumeric", default = TRUE)
)connection |
The connection to the database server. |
sql |
The SQL to be send. |
errorReportFile |
The file where an error report will be written if an error occurs. Defaults to 'errorReportSql.txt' in the current working directory. |
snakeCaseToCamelCase |
If true, field names are assumed to use snake_case, and are converted to camelCase. |
integer64AsNumeric |
Logical: should 64-bit integers be converted to numeric (double) values? If FALSE
64-bit integers will be represented using |
This function sends the SQL to the server and retrieves the results. If an error occurs during SQL execution, this error is written to a file to facilitate debugging. Null values in the database are converted to NA values in R.
A data frame.
## Not run:
connectionDetails <- createConnectionDetails(dbms = "postgresql",
server = "localhost",
user = "root",
password = "blah",
schema = "cdm_v4")
conn <- connect(connectionDetails)
count <- querySql(conn, "SELECT COUNT(*) FROM person")
disconnect(conn)
## End(Not run)Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.