Utilities for working with SQL files.


[Up] [Top]

Documentation for package ‘sqlutils’ version 1.2

Help Pages

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