sql.fill.template: Generic template filler (internal)

In cezden/rpostgrexplorer: Simplification of analysis in PostgreSQL and Redshift DBs

Description

Generic template filler (internal)

Usage

sql.fill.template(template.name, query.names, param.list)

Arguments

template.name	the name of the template
query.names	the vector of names of the generated queries (in the genereated query list)
param.list	the (named) list with names of parameters to be replaced and the values to be substituted

Examples

sql.fill.template(
   "dictionary_values",
   query.names="q1",
   list("%%DICTKEY%%" = "abd", "%%QUERY%%" = "bca")
   )

 sql.fill.template(
   "dictionary_values",
   query.names = c("q1","q2"),
   list("%%QUERY%%" = c("bca", "bcb"), "%%DICTKEY%%" = c("abd"))
   )

 sql.fill.template(
   "dictionary_values",
   query.names = c("q1", "q2"),
   list("%%QUERY%%" = c("bca", "bcb"), "%%DICTKEY%%"=c("abc", "abd"))
   )

cezden/rpostgrexplorer documentation built on May 13, 2019, 3:08 p.m.