qrc_query: qrc_query

In kimjam/qrcutils: Contains utility functions for data pipeline project.

Description

Function to query qrc_raw Postgresql database.

Usage

qrc_query(db, query, dbhost = Sys.getenv("QRC_DB_HOST"), port = 5432,
  uid = Sys.getenv("QRC_DB_USER"), pwd = Sys.getenv("QRC_DB_PWD"))

Arguments

db	Database name.
query	Query to send to database.
dbhost	Host IP address. Set to QRC_DB_HOST in .Renviron.
port	Port that server is listening on. Defaults to 5432.
uid	User ID. Set as QRC_DB_USER in .Renviron file.
pwd	Password. Set as QRC_DB_PWD in .Renviron file.

Value

Returns query results in dataframe.

kimjam/qrcutils documentation built on May 20, 2019, 10:21 p.m.