TSsql: Generic SQL Helper Functions for 'TSdbi' SQL Plugins

Share:

Standard SQL query functions used by SQL plugins packages for the 'TSdbi' interface to time series databases. It will mainly be used by other packages rather than directly by end users. The one exception is the function 'TSquery' which can be used to construct a time series from a database containing observations over time (e.g. balance statements for multiple years), but where the database is not specifically designed to store time series (as with other 'TSdbi' SQL plugin packages). Comprehensive examples of all the 'TS*' packages is provided in the vignette Guide.pdf with the 'TSdata' package.

Author
Paul Gilbert <pgilbert.ttv9z@ncf.ca>
Date of publication
2015-07-05 14:37:09
Maintainer
Paul Gilbert <pgilbert.ttv9z@ncf.ca>
License
GPL-2
Version
2015.7-1
URLs

View on R-Forge

Man pages

createTSdbTables
Create and Remove Time Series Database Tables
internal
set Where
standardSQL
Standard SQL Database Queries
TSquery
Construct Time Series Data From a Database

Files in this package

TSsql/DESCRIPTION
TSsql/NAMESPACE
TSsql/NEWS
TSsql/R
TSsql/R/TSquery.R
TSsql/R/TSsql.R
TSsql/inst
TSsql/inst/TSsql
TSsql/inst/TSsql/CreateTables.TSsql
TSsql/inst/TSsql/HistQuote.TSsql
TSsql/inst/TSsql/Populate.TSsql
TSsql/inst/TSsql/TSdbi.TSsql
TSsql/inst/TSsql/dbGetQuery.TSsql
TSsql/inst/TSsql/vintages.TSsql
TSsql/man
TSsql/man/TSquery.Rd
TSsql/man/createTSdbTables.Rd
TSsql/man/internal.Rd
TSsql/man/standardSQL.Rd
TSsql/tests
TSsql/tests/dbconnect.R