sqlGsub: internal function for SQL methods

In metricarts/metRictools: Data Science Tools

Description

It takes general queries and returns specific ones by replacing keywords in the first.

Usage

sqlGsub(query, param=c())

Arguments

query	character, it contain the query structure and the keywords between @'s.
param	character vector, it contain the keywords that would be replaced in query.

Details

param must be indexed by the keyword.

Value

It returns a character to be used in a SQL query.

Author(s)

Daniel Fischer

Examples

q="SELECt @col@ FROM @table@ WHERE @cond@"
p=c(col="year",table="FIFAWorldCup",cond="winner LIKE Brazil")
sqlGsub(q,p)

metricarts/metRictools documentation built on Nov. 12, 2019, 10 a.m.