read_scripts: Read SQL scripts from a directory
In brascoball/hattyr: Red Hat Specific Functions

Description Usage Arguments Details Value

Read SQL scripts from a directory into R for use against a database.

1	read_scripts(base_path, sqlvars, prefix, pattern)

`base_path`	the directory holding the sql files
`sqlvars`	a list containing all variables you wish to set within your queries
`prefix`	a prefix from your SQL filenames if you want to remove before creating the data frames
`pattern`	a suffix to include in the data frame names

Just place all scripts in the same directory with a .sql extension, and provide the directory path. It's also possible to set any variables in your query with the format of $variable.

sql.list returns a list of SQL queries with the future filename as the name

brascoball/hattyr documentation built on May 13, 2019, 2:30 a.m.