sql_chunk: Look up common SQL chunks from YAML definitions to be reused...

In daroczig/dbr: Convenient Database Connections and Queries

Description

For more details and examples, please see the package README.md.

Usage

sql_chunk(key, ..., indent_after_linebreak = 0)

Arguments

key	optional key defined in sql_chunk_files to filter for
...	passed to glue for string interpolation
indent_after_linebreak	integer for extra indent

Value

string

Examples

## Not run: 
sql_chunk_files(system.file('example_sql_chunks.yaml', package = 'dbr'))
sql_chunk('dbr.shinydemo.countries.count')

## pass it right away to a database
countries <- db_query(sql_chunk('dbr.shinydemo.countries.count'), 'shinydemo')

## example for a more complex query
cities <- db_query(sql_chunk('dbr.shinydemo.cities.europe'), 'shinydemo')

## End(Not run)

daroczig/dbr documentation built on June 12, 2020, 2:47 p.m.