lowLevelQuerySqlToAndromeda: Low level function for retrieving data to a local Andromeda...

Description Usage Arguments Details Value

View source: R/Andromeda.R

Description

This is the equivalent of the querySqlToAndromeda function, except no error report is written when an error occurs.

Usage

1
2
3
4
5
6
7
8
9
lowLevelQuerySqlToAndromeda(
  connection,
  query,
  andromeda,
  andromedaTableName,
  datesAsString = FALSE,
  integerAsNumeric = getOption("databaseConnectorIntegerAsNumeric", default = TRUE),
  integer64AsNumeric = getOption("databaseConnectorInteger64AsNumeric", default = TRUE)
)

Arguments

connection

The connection to the database server.

query

The SQL statement to retrieve the data

andromeda

An open connection to a Andromeda database, for example as created using andromeda.

andromedaTableName

The name of the table in the local Andromeda database where the results of the query will be stored.

datesAsString

Should dates be imported as character vectors, our should they be converted to R's date format?

integerAsNumeric

Logical: should 32-bit integers be converted to numeric (double) values? If FALSE 32-bit integers will be represented using R's native Integer class.

integer64AsNumeric

Logical: should 64-bit integers be converted to numeric (double) values? If FALSE 64-bit integers will be represented using bit64::integer64.

Details

Retrieves data from the database server and stores it in a local Andromeda database This allows very large data sets to be retrieved without running out of memory. Null values in the database are converted to NA values in R. If a table with the same name already exists in the local Andromeda database it is replaced.

Value

Invisibly returns the andromeda. The Andromeda database will have a table added with the query results.


DatabaseConnector documentation built on Nov. 18, 2021, 5:08 p.m.