TSsql: Generic SQL Helper Functions for 'TSdbi' SQL Plugins
Version 2017.4-1

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.

Browse man pages Browse package API and functions Browse package files

AuthorPaul Gilbert <pgilbert.ttv9z@ncf.ca>
Date of publication2017-05-15 01:30:05
MaintainerPaul Gilbert <pgilbert.ttv9z@ncf.ca>
LicenseGPL-2
Version2017.4-1
URL http://tsdbi.r-forge.r-project.org/
Package repositoryView on R-Forge
InstallationInstall the latest version of this package by entering the following in R:
install.packages("TSsql", repos="http://R-Forge.R-project.org")

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

Functions

TSdatesSQL Man page Source code
TSdeleteSQL Man page Source code
TSdescriptionSQL Man page Source code
TSdocSQL Man page Source code
TSgetSQL Man page Source code
TSlabelSQL Man page Source code
TSputSQL Man page Source code
TSquery Man page Source code
TSsourceSQL Man page Source code
createTSdbTables Man page Source code
realPanel Man page Source code
realVintage Man page Source code
removeTSdbTables Man page Source code
setWhere Man page Source code
tbNm Source code

Files

DESCRIPTION
NAMESPACE
NEWS
R
R/TSquery.R
R/TSsql.R
inst
inst/TSsql
inst/TSsql/CreateTables.TSsql
inst/TSsql/HistQuote.TSsql
inst/TSsql/Populate.TSsql
inst/TSsql/TSdbi.TSsql
inst/TSsql/dbGetQuery.TSsql
inst/TSsql/vintages.TSsql
man
man/TSquery.Rd
man/createTSdbTables.Rd
man/internal.Rd
man/standardSQL.Rd
tests
tests/dbconnect.R
TSsql documentation built on May 21, 2017, 1:14 a.m.