wrap_sql_query: combines strings and vectors in a sensible way for select...

Description Usage Arguments Details Examples

View source: R/utils.R

Description

This function is a variant of the sprintf function. In the query, can be placed identifier tags which are a hash character followed by a number e.g. #1 The number in the tag reflects the position of the arguments after the query The resut of evaluating that argument will then be inserted in place of the tag. If the result of evaluating the argument is a vector of length 1, it is inserted as is. If it is a vector of length > 1, it is wrapped in parentheses and comma separated.

Usage

1

Arguments

query

a character string with identifier tags (#[number]) for selecting the argument in ...

...

optional arguments selected by the identifier tags

Details

Note that this function is for help in constructing raw SQL queries and should not be used as an input to the where argument in select_event calls. This is because these calls use translate_sql_q to translate from R code to SQL

Examples

1
2
3
4
medcodes1 <- 1:5
practice <- 255
wrap_sql_query("eventdate >= STARTDATE & eventdate <= ENDDATE & medcode %in% #1 &
   practice == #2", medcodes1, practice)

rOpenHealth/rEHR documentation built on March 19, 2018, 7:58 a.m.