query_replace_string_with_values: Replace character in query string with values over n times...

In mcneilco/racas: R Package for ACAS

Replace character in query string with values over n times ceiling(values/limit) and return query results for each resulting query

Description

Function originally created to get around oracle in clause query (1000). Calls query after replacing a specified character with a subset of values

Usage

query_replace_string_with_values(qu, string, values, limit = 999, ...)

Arguments

qu	a sql query character string that contains the character given in string parameter
string	a character string to replace with values parameter
values	a list of values to replace in string parameter
...	expressions fed to query

Value

A list objects with results from query

Examples

query_replace_string_with_values(qu = "select * from analysis_group_value where id in (REPLACEME)", string = "REPLACEME", values = c(1:1001))

mcneilco/racas documentation built on April 19, 2024, 1:12 p.m.