TSdbiMethods: TSdbi ODBC Methods

In TSodbc: 'TSdbi' Extensions for ODBC

Description

Methods for TSdbi ODBC time series dtabase connection.

Usage

    odbc(...)
    ## S4 method for signature 'odbcConnection,missing'
TSconnect(q, dbname, ...)
    ## S4 method for signature 'character,TSodbcConnection'
TSget(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"),   ...)
    ## S4 method for signature 'ANY,character,TSodbcConnection'
TSput(x, serIDs, con, Table=NULL, 
       TSdescription.=TSdescription(x), TSdoc.=TSdoc(x), TSlabel.=TSlabel(x),
        TSsource.=TSsource(x),  
       vintage=getOption("TSvintage"), panel=getOption("TSpanel"),  ...)
    ## S4 method for signature 'character,TSodbcConnection'
TSdates(serIDs, con,  
       vintage=getOption("TSvintage"), panel=getOption("TSpanel"), ...)
    ## S4 method for signature 'character,TSodbcConnection'
TSdelete(serIDs, con,  
   vintage=getOption("TSvintage"), panel=getOption("TSpanel"), ...)
    ## S4 method for signature 'character,TSodbcConnection'
TSdescription(x, con, ...)
    ## S4 method for signature 'character,TSodbcConnection'
TSdoc(x, con, ...)
    ## S4 method for signature 'character,TSodbcConnection'
TSlabel(x, con, ...)
    ## S4 method for signature 'character,TSodbcConnection'
TSsource(x, con, ...)
    ## S4 method for signature 'TSodbcConnection'
TSvintages(con)

Arguments

q	A character string indicating the query interface to use, or a database connection object.
dbname	The name of the database to which the connection should be established, omitted if q is a database connection object.
con	A database connection.
serIDs	identifiers for series to extract.
x	data series to put on the database, or a series identifier for TSdescription and TSdoc.
TSrepresentation	time series representation to use for the result.
names	Optional character vector to use for series names.
tf	Optional tframe to use for truncating data. (See tfwindow.)
start	Optional start date to use for truncating data. (See tfwindow.)
end	Optional end date to use for truncating data. (See tfwindow.)
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 series label should be extracted.
TSlabel.	Short series label 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	Character string indicating database table. (In TSput this is 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).
...	Arguments passed to other methods.

Details

These are ODBC methods for TSdbi. See the TSdbi for details and see the vignette distributed with the package TSdata for more complete examples. Package TSsql is required for functions createTSdbTables() and removeTSdbTables(). Typically createTSdbTables() will only be done once, and the tables will not be removed. These steps are done in the example below.

Value

depends.

See Also

TSdbi-package, dbConnect, TSput sqlQuery

Examples

    require("tfplot")
    ## Not run: 
      require("RODBC")
      setup <- RODBC::odbcConnect(dsn="test")
      TSsql::createTSdbTables(setup, index=FALSE)
      con <- TSconnect("odbc", dbname="test")
      z <- ts(rnorm(100), start=c(1975,1), frequency=12)
      seriesNames(z) <- "random1"
      if(TSexists("random1", con)) TSreplace(z, con) else
      TSput(z, con)
      z1 <- TSget("random1", con)
      tfplot(z1)
      z <- ts(matrix(rnorm(100),50,2), start=c(1975,1), frequency=4)
      seriesNames(z) <- c("random2","random3")
      if(TSexists("random2", con) |
         TSexists("random3", con) ) TSreplace(z, con) else
      TSput(z, con)
      z2 <- TSget("random2", con)
      tfplot(z2)
      TSdates("D1", con)
      TSdates("random2", con)
      TSdates(c("random1","random2","random3"), con)
      TSmeta("random2", con)
      options(TSconnection=con)
      z2 <- TSget(c("random2","random3"))
      z <- TSdates(c("D1","random2","random3"))
      print(z)
      TSmeta("random2")
      TSdelete("random1", con)
      TSdelete("random2")
      TSsql::removeTSdbTables(con, yesIknowWhatIamDoing=TRUE)
      dbDisconnect(con)
      
## End(Not run)

TSodbc documentation built on Sept. 23, 2019, 3 a.m.