fetchData: Fetch data from the input database

In LREN-CHUV/r-mip-adaptor: DBI connection manager for HBP MIP platform

Description

Environment variables:

Usage

fetchData(query, inFormat, conn)

Arguments

query	The SQL query to execute on the input database, defaults to the value of environment parameter PARAM_query
inFormat	Hint for the exact shape of the data stored in the database. Possible values are PARTIAL_RESULTS, OTHER. Defaults to the value of environment parameter IN_FORMAT
conn	The connection to the database, default to global variable in_conn

Details

- Input Parameters: PARAM_query : SQL query producing the dataframe to analyse - Execution context: IN_FORMAT : Hint for the exact shape of the data stored in the database. Possible values are PARTIAL_RESULTS, OTHER IN_JDBC_DRIVER : class name of the JDBC driver for input data IN_JDBC_JAR_PATH : path to the JDBC driver jar for input data IN_JDBC_URL : JDBC connection URL for input data IN_JDBC_USER : User for the database connection for input data IN_JDBC_PASSWORD : Password for the database connection for input data IN_JDBC_SCHEMA : Optional schema by default for the database connection for input data

LREN-CHUV/r-mip-adaptor documentation built on May 20, 2019, 5:45 p.m.