Write Data to a Data Connection

Share:

Description

Write data to a server.

Usage

 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
    TSput(x, serIDs=seriesNames(x), con=getOption("TSconnection"), ...)

    TSdelete(serIDs, con=getOption("TSconnection"), 
	vintage=getOption("TSvintage"), panel=getOption("TSpanel"), ...)

    TSreplace(x, serIDs=seriesNames(x), con=getOption("TSconnection"), 
	vintage=getOption("TSvintage"), panel=getOption("TSpanel"), ...)

    ## S4 method for signature 'ANY,missing,missing'
TSput(
	x, serIDs=seriesNames(x), con=getOption("TSconnection"), ...)
    ## S4 method for signature 'ANY,DBIConnection,missing'
TSput(
	x, serIDs=seriesNames(x), con=getOption("TSconnection"), ...)
    ## S4 method for signature 'ANY,character,ANY'
TSput(
	x, serIDs=seriesNames(x), con=getOption("TSconnection"), ...)

    ## S4 method for signature 'character,missing'
TSdelete(
	serIDs, con=getOption("TSconnection"), 
	vintage=getOption("TSvintage"), panel=getOption("TSpanel"), ...)
    ## S4 method for signature 'character,ANY'
TSdelete(
	serIDs, con=getOption("TSconnection"), 
	vintage=getOption("TSvintage"), panel=getOption("TSpanel"), ...)
    ## S4 method for signature 'character,missing,ANY,ANY'
TSdelete(
	serIDs, con=getOption("TSconnection"), 
	vintage=getOption("TSvintage"), panel=getOption("TSpanel"), ...)
    ## S4 method for signature 'character,ANY,ANY,ANY'
TSdelete(
	serIDs, con=getOption("TSconnection"), 
	vintage=getOption("TSvintage"), panel=getOption("TSpanel"), ...)

    ## S4 method for signature 'default'
TSreplace(
	x, serIDs=seriesNames(x), con=getOption("TSconnection"), 
	vintage=getOption("TSvintage"), panel=getOption("TSpanel"), ...)

Arguments

con

A database connection.

x

time series data.

serIDs

identifiers for series on the database.

vintage

character string indicating vintage of the series on the database (if supported by the database).

panel

character string indicating panel of the series on the database (if supported by the database).

...

Arguments passed to other methods.

Details

Class logicalId is a logical indicating if the operation succeeded, and also contains meta data indicating how to retrieve the data. (Except in the case of TSdelete the data cannot be retrieved.)

These functions write data to a database connection. TSreplace removes any existing object first. TSput will fail if a series with the same identifier already exists.

TSput and TSreplace provide ways to query a regularly used single database. The connection can be set in options using options(TSconnection=con) and then only the series identifiers need to be specified in calls to TSput and TSreplace.

TSdescription and TSdoccan also be set. (Passed in ...).

If an appropriate table cannot be determined from the series it will be necessary to pass the Table argument (in ...). The DBI/SQL interface uses the following tables:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
A     for annual data
Q     for quarterly data
M     for monthly data
S     for semiannual data
W     for weekly data
D     for daily data
B     for business data
U     for minutely data
I     for irregular data with a date
T     for irregular data with a date and time
Meta  for meta data

Value

An object of class logicalId.

See Also

TSdbi-package, TSdates, TSget, dbConnect