get_query: Get query.
In dslaw/ryesql: Implementation of Yesql

Description Usage Arguments Details Value Examples

Create an anonymous query from a sql file. The query is returned as a named list with a description and SQL string suitable for passing to a DBIConnection method.

1	get_query(filename)

filename

Character string.

The file should contain only a single query to be loaded.

Named list.

cat("SELECT * FROM fruit",
    "WHERE color = 'green'",
    file = "query.sql",
    sep = "\n")
query <- get_query("query.sql")
unlink("query.sql")

query$sql
# [1] "SELECT * FROM fruit\nWHERE color = 'green'"