Description Usage Arguments Details Value See Also Examples
Methods for TSdbi fame time series database connection.
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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 | fameLocal(...)
fameServer(...)
## S4 method for signature 'TSfameLocalConnection,missing'
TSconnect(q, dbname,
accessMode = if (file.exists(dbname)) "shared" else "create",
current = NA, ...)
## S4 method for signature 'TSfameServerConnection,missing'
TSconnect(q, dbname,
service = "", host = "", user = "", password = "", current = NA, ...)
## S4 method for signature 'character,TSfameLocalConnection'
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"), ...)
## S4 method for signature 'character,TSfameServerConnection'
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"), ...)
## S4 method for signature 'ANY,character,TSfameLocalConnection'
TSput(x, serIDs=seriesNames(x),
con, TSdescription.=TSdescription(x),
TSdoc.=TSdoc(x), TSlabel.=NULL, TSsource.=NULL, warn = TRUE, ...)
## S4 method for signature 'ANY,character,TSfameServerConnection'
TSput(x, serIDs=seriesNames(x),
con, TSdescription.=TSdescription(x),
TSdoc.=TSdoc(x), TSlabel.=NULL, TSsource.=NULL, warn = TRUE, ...)
## S4 method for signature 'character,TSfameLocalConnection'
TSdates(serIDs, con,
vintage=getOption("TSvintage"), panel=NULL, ...)
## S4 method for signature 'character,TSfameServerConnection'
TSdates(serIDs, con,
vintage=getOption("TSvintage"), panel=NULL, ...)
## S4 method for signature 'character,TSfameLocalConnection'
TSexists(
serIDs, con, vintage=NULL, panel=NULL, ...)
## S4 method for signature 'character,TSfameServerConnection'
TSexists(
serIDs, con, vintage=NULL, panel=NULL, ...)
## S4 method for signature 'character,TSfameLocalConnection'
TSdelete(serIDs, con,
vintage=getOption("TSvintage"), panel=getOption("TSpanel"), ...)
## S4 method for signature 'character,TSfameServerConnection'
TSdelete(serIDs, con,
vintage=getOption("TSvintage"), panel=getOption("TSpanel"), ...)
## S4 method for signature 'character,TSfameLocalConnection'
TSdescription(x, con, ...)
## S4 method for signature 'character,TSfameServerConnection'
TSdescription(x, con, ...)
## S4 method for signature 'character,TSfameLocalConnection'
TSdoc(x, con, ...)
## S4 method for signature 'character,TSfameServerConnection'
TSdoc(x, con, ...)
## S4 method for signature 'character,TSfameLocalConnection'
TSlabel(x, con, ...)
## S4 method for signature 'character,TSfameServerConnection'
TSlabel(x, con, ...)
## S4 method for signature 'character,TSfameLocalConnection'
TSsource(x, con, ...)
## S4 method for signature 'character,TSfameServerConnection'
TSsource(x, con, ...)
## S4 method for signature 'TSfameLocalConnection'
TSvintages(con)
## S4 method for signature 'TSfameServerConnection'
TSvintages(con)
|
q |
A character string indicating the query interface to use, or a database connection object. |
dbname |
The name of the [server and] database to which the
connection should be
established, omitted if |
con |
A database connection. |
serIDs |
identifiers for series to extract. |
vintage |
character string indicating vintage of the series on the databases. |
panel |
character string indicating panel of the series on the database (not supported by this database). |
x |
data series to put on the database, or a series identifier for TSdescription and TSdoc or, for print, a database connection as returned by TSconnect. |
TSrepresentation |
time series representation to use for the result. |
names |
Optional character vector to use for series names. Defaults to serIDs unless vintage is a vector, in which case it defaults to vintage. |
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 |
For compatibility with other TS packages. Not supported in Fame |
TSlabel. |
For compatibility with other TS packages. Not supported in Fame |
TSsource |
For compatibility with other TS packages. Not supported in Fame |
TSsource. |
For compatibility with other TS packages. Not supported in Fame |
warn |
Logical indicating if warning messages should be suppressed. |
accessMode |
Optional character indicating the mode to use when opening the Fame database when establishing the first connection. After the first connection, "read" will be used for reading and "update" for writing. |
host |
A character string indicating a server. |
service |
A character string indicating a server port number. |
user |
A character string indicating a user id (if needed). |
password |
A character string indicating a password (if needed). |
current |
A character string indicating a vintage that should be considered the current vintage (see details). |
... |
Arguments passed to other methods. |
These are fame methods for TSdbi. See the package TSdbi for details and see the vignette distributed with this package for more complete examples.
This package provides a wrapper to the fame package to provide a
TSdbi API for users. The TSfameLocalConnection
establishes a connection
using the locally fame which can access local databases or databases on a remote
server, specified by the server name followed by a space and the database name.
The TSfameServerConnection
establishes a connection to a remote server
using one of Fame's remote server protocols. See package fame for more
specific details.
There is a simplistic mechanism for accessing vintages of data stored in
different Fame databases. To use this, the dbname
argument to
TSconnect
should be a vector of character strings indicating the
databases, with names of the elements indicating the vintages. The
vintage
argument to TSget
is then a character vector used to
select a subset of dbname
. The dbname
argument to
TSconnect
can also be specified to indicate the version that should be
considered current. (That is, the user needs to know that information and specify it,
rather than having it supplied by the database.) In other respects the vintages
support is then similar to other TSdbi packages such as TSMySQL, and
examples in those packages may be useful. Some examples are also provided in
the TSfame Guide vingette.
depends.
TSdbi-package
,
dbConnect
,
TSput
getfame
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 27 28 29 | require("tfplot")
con <- try(TSconnect(dbDriver("fame"), dbname="test.db"))
if(! inherits(con, "try-error")) {
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")
dbDisconnect(con)
}
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.