query: Query

In ndesmo/rquery:

Description

Query the database

Usage

query(sql, subs = NULL)

Arguments

sql	SQL query to run
subs	One row data frame whose column names are the substrings to replace, and whose values are the strings to replace them with.

Examples

sys.setenv(
  'db_dsn' = 'mydb',
  'db_username' = 'myuser',
  'db_password' = 'password'
)

sql <- "select 1 as a from dual where 1 = XnumberX"
subs <- data.frame('XnumberX' = 1)

query(sql, subs)

ndesmo/rquery documentation built on May 7, 2019, 9:43 p.m.