write_oliver_data: Get data from 'oliver_replica' write a single file

In pocdata/oliveR: A package for extracting data from the oliver sms replica and creating measurements

Description

This function is used to select all records from a view or a table within the specified schema within oliver_replica. For now, the files are written in a feather format in the Data directory of the package.

Usage

write_oliver_data(data_name, con, schema)

Arguments

data_name	A character string specifying the name of the table or view being accessed from the oliver replica.
con	An object of class src_postgres which specifies a connection to the oliver replica.
schema	A character string specifying the name of the schema holding the table or view from the oliver replica. The default value is static.

Details

#' The following dependencies are required in order to create a valid string:

#'

• The presence of an open SSH tunnel to the oliver replica as partially decribed in the create_ssh_command documentation.

• A valid username and password on the oliver replica database. Can be set by contacting [e-mail].

Value

A single feather file.

Author(s)

Joe Mienko, [e-mail]

See Also

create_ssh_command, create_flat_files

Examples

library(dplyr)
library(RPostgreSQL)
library(feather)

con <- src_postgres(
  dbname = 'oliver_replica',
  host = '127.0.0.1',
  user = 'mienkoja',
  password = 'mypassword'
)

write_oliver_data(data_name = 'report_businessmetrics_memberbreakdown', con = con)

pocdata/oliveR documentation built on May 25, 2019, 10:23 a.m.