formatSql | R Documentation |
Retreives Sql Statement text from a file, binds parameters to the text, and do basic format cleanup
formatSql( sql_file_name, params = NULL, sql_dir = "sql", clean_sql = TRUE, package_name = packageName(parent.frame()) )
sql_file_name |
The name of of the file with sql to load |
params |
List of named parameters to bind to the sql text |
sql_dir |
The directory that stores all the sql statements (defaults to "sql") |
clean_sql |
A boolean that identifies if the format of the final sql should be cleaned (e.g. strip newlines) |
package_name |
The package name to load sql file from, defaults to the current package name |
An Sql text statement
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.