load_query: Load query into an environment.

In dslaw/ryesql: Implementation of Yesql

Description

Create a query function inside an environment. The query is added to the specified environment as the given name.

Usage

load_query(name, filename, env = parent.frame())

Arguments

name	Character string. Name to be given to the query.
filename	Character string.
env	Environment to load the queries into. Default is the calling environment.

See Also

get_query

Examples

# A package implementing DBI methods must be available. 
require(RSQLite)
cat("SELECT * FROM fruit",
    "WHERE name LIKE '%berry'",
    file = "query.sql",
    sep = "\n")

# Load into global environment.
load_query("get_berries", "query.sql")
unlink("query.sql")

conn <- dbConnect(SQLite(), ":memory:")
tbl <- data.frame(name = c("apple", "strawberry", "blackberry", "mango"),
                  color = c("green", "red", "black", "orange"))
success <- dbWriteTable(conn, "fruit", tbl)

get_berries(conn)
#         name color
# 1 strawberry   red
# 2 blackberry black

dbDisconnect(conn)

dslaw/ryesql documentation built on May 15, 2019, 4:22 p.m.