ReplaceQueryParams: Replaces %s parameters in a query statement by the given...

In rvladimiro/dafR: Data Analysis Framework in R

Description

Replaces %s parameters in a query statement by the given arguments

Arguments

query	The query to be treated It can be a file with SQL or a character vector
...	a number of strings to be replaced in the query

Value

A character vector ready to be used on queries

Author(s)

João Monteiro

Examples

ReplaceQueryParams(
    query = "SELECT * FROM %s_session",
    "game_name"
)

ReplaceQueryParams(
    query = "SELECT *, '%1$s' AS game 
    FROM %1$s_session
    WHERE date = '%2$s'",
    "game_name",
    Sys.Date()
)

rvladimiro/dafR documentation built on June 26, 2019, 4:37 a.m.