sqlutils-package |
Utilities for working with SQL files. |
cacheQuery |
Function for working with cached queries. |
execQuery |
Executes the specified query and returns a data frame. This function currently supports RODBC, RSQLite, and RMySQL. For other databases, use getQuery() and execute the SQL statement using the appropriate database connection. |
getCacheFilename |
Returns the complete filepath to the cache file. |
getParameters |
Returns the parameters that must be set for the given query. |
getQueries |
Returns a list of available queries in the current repository. |
getSQL |
Returns the query as a string with the parameters set. |
getSQLRaw |
Returns the SQL from the file without the parameters replaced. |
is.null.string |
Does the string contain no matter, but very well [:space:]? |
isql |
Interactive SQL session. |
parse.element |
Parse a raw string containing key and expressions. |
parse.introduction |
Parse introduction: the premier part of a roxygen block containing description and option details separated by a blank roxygen line. |
print.sqldoc |
Prints the SQL documentation. |
recodeColumns |
Recodes factors with more than 'maxLevels' to characters. |
sqldoc |
Parses the query and returns a list with all the elements of the comment. |
sqlexec |
Generic function for executing a query. |
sqlexec.JDBCConnection |
Executes queries for RJDBC |
sqlexec.PostgreSQLConnection |
Executes queries for RPostgreSQL |
sqlexec.RMySQL |
Executes queries for RMySQL package. |
sqlexec.RODBC |
Executes queries for RODBC package. |
sqlexec.SQLiteConnection |
Executes queries for RSQLite package. |
sqlFile |
Returns the full path to the query or NULL if not found. |
sqlPaths |
Search paths for SQL repositories. |
sqlutils |
Utilities for working with SQL files. |
sqlutils.envir |
The locations of SQL files |