get_queries: Get queries.

In dslaw/ryesql: Implementation of Yesql

Description

Create named-queries from a sql file. Each query is returned as a named list with a name, description and SQL string suitable for passing to a DBIConnection method.

Usage

get_queries(filename)

Arguments

filename

Character string.

Value

List of named-queries.

Examples

cat("-- name: get-fruits",
    "-- Get all fruits.",
    "SELECT * FROM fruit",
    "",
    "-- name: green-fruits",
    "-- Get green fruits.",
    "SELECT * FROM fruit",
    "WHERE color = 'green'",
    file = "queries.sql",
    sep = "\n")
queries <- get_queries("queries.sql")
unlink("queries.sql")

names(queries)
# [1] "get-fruits"   "green-fruits"
queries$`green-fruits`$sql
# [1] "SELECT * FROM fruit\nWHERE color = 'green'"

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