sqlutils: Utilities for working with SQL files.

Share:

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

Author
Jason Bryer
Date of publication
2014-11-19 17:49:01
Maintainer
Jason Bryer <jason@bryer.org>
License
GPL
Version
1.2
URLs

View on CRAN

Man pages

cacheQuery
Function for working with cached queries.
execQuery
Executes the specified query and returns a data frame. This...
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...
getSQL
Returns the query as a string with the parameters set.
getSQLRaw
Returns the SQL from the file without the parameters...
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...
print
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...
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.envir
The locations of SQL files
sqlutils-package
Utilities for working with SQL files.

Files in this package

sqlutils
sqlutils/inst
sqlutils/inst/sql
sqlutils/inst/sql/StudentsInRange.sql
sqlutils/inst/sql/StudentSummary.sql
sqlutils/inst/db
sqlutils/inst/db/students.db
sqlutils/inst/doc
sqlutils/inst/doc/DataDictionary.pdf
sqlutils/inst/doc/DataDictionary.R
sqlutils/inst/doc/DataDictionary.Rnw
sqlutils/NAMESPACE
sqlutils/demo
sqlutils/demo/isql.r
sqlutils/demo/00Index
sqlutils/demo/sqlutils.r
sqlutils/NEWS
sqlutils/R
sqlutils/R/sqlPaths.r
sqlutils/R/sqlFile.r
sqlutils/R/recodeColumns.r
sqlutils/R/getCacheFilename.r
sqlutils/R/sqldoc.r
sqlutils/R/getQueries.r
sqlutils/R/interactiveSQL.r
sqlutils/R/sqlexec.R
sqlutils/R/cacheQuery.r
sqlutils/R/getSQL.r
sqlutils/R/getParameters.r
sqlutils/R/execQuery.r
sqlutils/R/sqlutils-package.r
sqlutils/R/getSQLRaw.r
sqlutils/vignettes
sqlutils/vignettes/DataDictionary.Rnw
sqlutils/MD5
sqlutils/build
sqlutils/build/vignette.rds
sqlutils/DESCRIPTION
sqlutils/man
sqlutils/man/getSQLRaw.Rd
sqlutils/man/sqlutils-package.Rd
sqlutils/man/isql.Rd
sqlutils/man/parse.introduction.Rd
sqlutils/man/sqlexec.PostgreSQLConnection.Rd
sqlutils/man/sqlexec.SQLiteConnection.Rd
sqlutils/man/cacheQuery.Rd
sqlutils/man/getQueries.Rd
sqlutils/man/is.null.string.Rd
sqlutils/man/sqlexec.RMySQL.Rd
sqlutils/man/sqlexec.RODBC.Rd
sqlutils/man/sqlFile.Rd
sqlutils/man/sqlexec.JDBCConnection.Rd
sqlutils/man/sqldoc.Rd
sqlutils/man/parse.element.Rd
sqlutils/man/sqlPaths.Rd
sqlutils/man/getSQL.Rd
sqlutils/man/getParameters.Rd
sqlutils/man/execQuery.Rd
sqlutils/man/sqlexec.Rd
sqlutils/man/print.Rd
sqlutils/man/sqlutils.envir.Rd
sqlutils/man/getCacheFilename.Rd
sqlutils/man/recodeColumns.Rd