Fork me on GitHub

sqlutils

An R package for managing a library of database queries

Data Dictionary

The sqlutils contains a data dictionary script as a vignette that can be recreated reflecting your own library of SQL files. You can view the source on Github and the results of running the Sweave file for the two included SQL scripts is provided below (and can also be downloaded here). The script will loop over each query returned by getQueries() and for each attempting to execute the query using the default values (see ?sqldoc). By executing the query the script can determine the structure of the data frame returned for the database. That information is included in the resulting PDF file.


= Github page; = RSS XML Feed; = External website; = Portable Document File (PDF)
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License. Creative Commons License
Formulas powered by MathJax