dbQuery: Query Database and Return Results

In Tsunamical28/mdpr: Municipal Data and Pricing

Description

Wrapper for RODBC odbcDriverConnect with default values for cetain parameters. The connection defaults to the production server and the Muni DB. The result is returned as a tbl_df with strings represented as characters instead of factors, unless it is only one column, in which case it is returned as a vector.

Usage

dbQuery(query, stringsAsFactors = FALSE, server = c_server,
  database = c_database, uid = c_uid, pwd = c_pwd)

Arguments

query	Character string database query in MS SQL SERVER T-SQL format.
stringsAsFactors	Boolean value as in base R
server	Server name as a character string
database	Database name as a character string
uid	User ID as a character string
pwd	Password as a character string

Value

tbl_df or vector containing the results of the query

Examples

qry <- paste("R_LoadMuniDeskPositions '",
           as.character(c_close_date),"','", as.character(c_as_of_datetime),"','",
           paste(c_exempt_accounts, c_taxable_accounts,
           c_tsy_accounts,sep = ",",collapse=","),"'")
dbQuery(qry)

Tsunamical28/mdpr documentation built on May 9, 2019, 5:15 p.m.