fetch_db: Fetch data from db

In quartin/dbutils: A set of utility functions for dealing with databases in R

Description

Fetch data from db

Usage

fetch_db(conn = NULL, path = NULL, query = NULL, async = FALSE,
  dsn = NULL, ...)

Arguments

conn	A database connection. Only necessary if 'async = FALSE'.
path	A SQL file path. Optionally, use 'query'.
query	A SQL string. Optionally, use 'path'. If both are supplied, 'path“ is used.
async	A logical indicating whether to execute the query asynchronously or (default) not.
dsn	The Data Source Name.
...	Named values to interpolate into the query string.

Value

If processed in a synchronous manner (the default), a data frame with as many rows as records and as many columns as fields in the result set. If processed in an asynchronous manner, a Future. To get the value of a future, use future::value. In case of error, a print of the full SQL error is returned before execution of error action.

quartin/dbutils documentation built on May 8, 2019, 1:49 p.m.