Learn R
TSdbi (version 2017.4-1)

TSconnect: Connect to a Time Series Database

Description

Return a connection to a time series database

Usage

TSconnect(q, dbname, ...)
    # S4 method for character,character
TSconnect(q, dbname, ...)
    # S4 method for logicalId
show(object)
    # S4 method for TSdb
show(object)
    # S4 method for TSmeta
show(object)
    # S4 method for TSdb
print(x, ...)

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.
x
A database connection as returned by TSconnect.
object
an object to display.
...
Additional arguments passed to other methods. For TSconnect these will be passed to the database driver.

Value

A database connection.

Details

This function establishes a connection using a driver from one of the driver packages (e.g. TSMySQL or TSSQLite). If q is a character string (e.g. "MySQL") then the method attempts to get a connection using the character string.

"TSconnect" uses dbConnect but checks the database has expected tables and also establishes information about additional features that may be available (vintiges and/or panels).

Options can be set to simplify access to a commonly used database (see TSput).

See Also

TSdbi-package, dbConnect, TSget, TSput, TSdates