Description Usage Arguments Details Value See Also
Standard SQL database queries
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | TSgetSQL(serIDs, con, TSrepresentation=getOption("TSrepresentation"),
tf = NULL, start = tfstart(tf), end = tfend(tf), names=NULL,
TSdescription=FALSE, TSdoc=FALSE, TSlabel=FALSE, TSsource=TRUE,
vintage=getOption("TSvintage"), panel=getOption("TSpanel"))
TSdatesSQL(serIDs, con,
vintage=getOption("TSvintage"), panel=getOption("TSpanel"))
TSdeleteSQL(serIDs, con=getOption("TSconnection"),
vintage=getOption("TSvintage"), panel=getOption("TSpanel"))
TSdescriptionSQL(x=NULL, con=getOption("TSconnection"),
vintage=getOption("TSvintage"), panel=getOption("TSpanel"),
lang=getOption("TSlang"))
TSdocSQL(x=NULL, con=getOption("TSconnection"),
vintage=getOption("TSvintage"), panel=getOption("TSpanel"),
lang=getOption("TSlang"))
TSlabelSQL(x=NULL, con=getOption("TSconnection"),
vintage=getOption("TSvintage"), panel=getOption("TSpanel"),
lang=getOption("TSlang"))
TSsourceSQL(x=NULL, con=getOption("TSconnection"),
vintage=getOption("TSvintage"), panel=getOption("TSpanel"),
lang=getOption("TSlang"))
TSputSQL(x, serIDs=seriesNames(x), con, Table=NULL,
TSdescription.=TSdescription(x),
TSdoc.=TSdoc(x), TSlabel.=TSlabel(x), TSsource.=TSsource(x),
vintage=getOption("TSvintage"), panel=getOption("TSpanel"))
|
con |
A database connection. |
serIDs |
identifiers for series to extract. |
TSrepresentation |
time series representation to use for the result. |
x |
time series data, or serIDs. |
names |
Optional character vector to use for series names. |
tf |
Optional tframe to use for truncating data. (See |
start |
Optional start date to use for truncating data. (See |
end |
Optional end date to use for truncating data. (See |
TSdescription |
TRUE or FALSE indicating whether description should be extracted |
TSdescription. |
Description to put on the database. |
TSdoc |
TRUE or FALSE indicating whether documentation should be extracted. |
TSdoc. |
Documentation to put on the database. |
TSlabel |
TRUE or FALSE indicating whether documentation should be extracted. |
TSlabel. |
Documentation to put on the database. |
TSsource |
TRUE or FALSE indicating whether source indication should be extracted. |
TSsource. |
Source indication to put on the database. |
Table |
Database table indication (necessary if it cannot be determined automatically). |
vintage |
Vintage to be supplied (if supported by db). |
panel |
Panel to be supplied (if supported by db). |
These functions provide standard SQL queries that can be used by other packages such as TSMySQL and TSSQLite that provide connections. These functions would usually not be called directly by the user. Thus the package will typically be imported by other packages but need not be attached.
A time series matrix.
TSdbi-package
,
dbConnect
,
TSget
,
TSput
,
TSdelete
,
TSmeta
,
TSdates
tfwindow
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.