Learn R Programming

sqlutils (version 1.2)

Utilities for working with SQL files.

Description

This package provides utilities for working with a library of SQL files.

Copy Link

Version

Install

install.packages('sqlutils')

Monthly Downloads

39

Version

1.2

License

GPL

Issues

6

Pull Requests

0

Stars

23

Forks

5

Maintainer

Jason Bryer

Last Published

November 19th, 2014

Functions in sqlutils (1.2)

sqlexec.RMySQL

Executes queries for RMySQL package.
getQueries

Returns a list of available queries in the current repository.
parse.introduction

Parse introduction: the premier part of a roxygen block containing description and option details separated by a blank roxygen line.
sqlexec.PostgreSQLConnection

Executes queries for RPostgreSQL
parse.element

Parse a raw string containing key and expressions.
sqlexec

Generic function for executing a query.
is.null.string

Does the string contain no matter, but very well [:space:]?
sqlutils.envir

The locations of SQL files
getCacheFilename

Returns the complete filepath to the cache file.
sqlFile

Returns the full path to the query or NULL if not found.
sqldoc

Parses the query and returns a list with all the elements of the comment.
cacheQuery

Function for working with cached queries.
sqlexec.JDBCConnection

Executes queries for RJDBC
getSQL

Returns the query as a string with the parameters set.
recodeColumns

Recodes factors with more than maxLevels to characters.
isql

Interactive SQL session.
getSQLRaw

Returns the SQL from the file without the parameters replaced.
getParameters

Returns the parameters that must be set for the given query.
sqlexec.SQLiteConnection

Executes queries for RSQLite package.
sqlexec.RODBC

Executes queries for RODBC package.
sqlutils-package

Utilities for working with SQL files.
print.sqldoc

Prints the SQL documentation.
sqlPaths

Search paths for SQL repositories.
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.